Add Uri Converter

2 files changed, 43 insertions, 0 deletions

diff --git a/Source/ExcelDNA/AddIn.cs b/Source/ExcelDNA/AddIn.cs
new file mode 100644
index 0000000..dd99667
--- /dev/null
+++ b/Source/ExcelDNA/AddIn.cs
@@ -0,0 +1,24 @@
+using ExcelDna.Integration;
+using ExcelDna.Registration;
+
+namespace Rehau.Sku.Assist
+{
+    public class AddIn : IExcelAddIn
+    {
+        public void AutoOpen()
+        {
+            RegisterFunctions();
+        }
+
+        public void AutoClose()
+        {
+        }
+
+        void RegisterFunctions()
+        {
+            ExcelRegistration.GetExcelFunctions()
+                             .ProcessAsyncRegistrations(nativeAsyncIfAvailable: false)
+                             .RegisterFunctions();
+        }
+    }
+}
diff --git a/Source/ExcelDNA/Functions.cs b/Source/ExcelDNA/Functions.cs
new file mode 100644
index 0000000..a282e3e
--- /dev/null
+++ b/Source/ExcelDNA/Functions.cs
@@ -0,0 +1,19 @@
+using AngleSharp.Dom;
+using ExcelDna.Integration;
+using System.Net.Http;
+using System.Threading.Tasks;
+
+namespace Rehau.Sku.Assist
+{
+    public class Functions
+    {
+        [ExcelFunction]
+        public static async Task<string> RAUNAME(string request)
+        {
+            Task<string> contentTask = Task.Run(() => SkuAssist.GetContent(request));
+            Task<IDocument> documentTask = await contentTask.ContinueWith(content => SkuAssist.GetDocument(content));
+            IProduct product = await documentTask.ContinueWith(doc => SkuAssist.GetProductFromDocument(doc.Result));
+            return product != null ? product.ToString() : "Не найдено";
+        }
+    }
+}
\ No newline at end of file