1 files changed, 10 insertions, 42 deletions

diff --git a/Functions.cs b/Functions.cs
index 9d3eb28..9112822 100644
--- a/Functions.cs
+++ b/Functions.cs
@@ -1,53 +1,21 @@
-using ExcelDna.Integration;
-using System.Runtime.Caching;
+using AngleSharp.Dom;
+using ExcelDna.Integration;
 using System.Net.Http;
+using System.Threading.Tasks;
 
 namespace Rehau.Sku.Assist
 {
-    public class Functions : IExcelAddIn
+    public class Functions
     {
-        private static HttpClient _httpClient;
-        private static ObjectCache _resultCache = MemoryCache.Default;
-
-        public void AutoClose()
-        {
-        }
-        public void AutoOpen()
-        {
-            _httpClient = new HttpClient();
-        }
+        private static HttpClient httpClient = new HttpClient();
 
         [ExcelFunction]
-        public static object RAUNAME(string request)
+        public static async Task<string> RAUNAME(string request)
         {
-            string cachedResult = _resultCache[request] as string;
-
-            if (cachedResult != null)
-            {
-                return cachedResult;
-            }
-
-            else
-            {
-                object result = ExcelAsyncUtil.Run("RAUNAME", null,
-                    delegate
-                {
-                    var document = SkuAssist.GetDocumentAsync(request, _httpClient).Result;
-                    var product = SkuAssist.GetProductFromDocument(document);
-                    return product.ToString();
-                });
-
-                if (result.Equals(ExcelError.ExcelErrorNA))
-                {
-                    return "Загрузка...";
-                }
-
-                else
-                {
-                    _resultCache.Add(request, result, System.DateTime.Now.AddMinutes(20));
-                    return result.ToString();
-                }
-            }
+            Task<string> contentTask = Task.Run(() => SkuAssist.GetContent(request, httpClient));
+            Task<IDocument> documentTask = await contentTask.ContinueWith(content => SkuAssist.GetDocument(content));
+            IProduct product = await documentTask.ContinueWith(doc => SkuAssist.GetProductFromDocument(doc.Result));
+            return product.ToString();
         }
     }
 }
\ No newline at end of file