From 8a869e73fb1873b1f85203b7a4a18dc8a2325a11 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Wed, 8 Dec 2021 14:38:23 +0300 Subject: Rename dir ExcelDNA -> AddIn --- Source/AddIn/AddIn.cs | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 53 insertions(+) create mode 100644 Source/AddIn/AddIn.cs (limited to 'Source/AddIn/AddIn.cs') diff --git a/Source/AddIn/AddIn.cs b/Source/AddIn/AddIn.cs new file mode 100644 index 0000000..3c82406 --- /dev/null +++ b/Source/AddIn/AddIn.cs @@ -0,0 +1,53 @@ +using ExcelDna.Integration; +using ExcelDna.Registration; +using Microsoft.Win32; +using System.Net.Http; + +namespace RehauSku.Assist +{ + public enum ResponseOrder + { + Default, + Relevance, + Name, + Price, + Series + } + + public class AddIn : IExcelAddIn + { + public static readonly HttpClient httpClient = new HttpClient(); + public static ResponseOrder responseOrder; + public static string priceListPath; + + public void AutoOpen() + { + RegisterFunctions(); + GetRegistryKeys(); + } + + public void AutoClose() + { + + } + + void RegisterFunctions() + { + ExcelRegistration.GetExcelFunctions() + .ProcessAsyncRegistrations(nativeAsyncIfAvailable: false) + .RegisterFunctions(); + } + + void GetRegistryKeys() + { + RegistryKey addInKeys = Registry + .CurrentUser + .OpenSubKey("SOFTWARE") + .OpenSubKey("REHAU") + .OpenSubKey("SkuAssist"); + + responseOrder = (ResponseOrder)addInKeys.GetValue("ResponseOrder"); + priceListPath = (string)addInKeys.GetValue("PriceListPath"); + } + } +} -- cgit v1.2.3