From 2afcbbf08c21aa7368361269f24240147aa79a00 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Mon, 29 Nov 2021 17:12:56 +0300 Subject: =?UTF-8?q?=D0=9E=D1=80=D0=B3=D0=B0=D0=BD=D0=B8=D0=B7=D0=B0=D1=86?= =?UTF-8?q?=D0=B8=D1=8F=20=D0=B4=D0=B8=D1=80=D0=B5=D0=BA=D1=82=D0=BE=D1=80?= =?UTF-8?q?=D0=B8=D0=B9=20=D0=BF=D1=80=D0=BE=D0=B5=D0=BA=D1=82=D0=B0?= MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- src/ExcelDNA/Functions.cs | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 src/ExcelDNA/Functions.cs (limited to 'src/ExcelDNA/Functions.cs') diff --git a/src/ExcelDNA/Functions.cs b/src/ExcelDNA/Functions.cs new file mode 100644 index 0000000..6792195 --- /dev/null +++ b/src/ExcelDNA/Functions.cs @@ -0,0 +1,21 @@ +using AngleSharp.Dom; +using ExcelDna.Integration; +using System.Net.Http; +using System.Threading.Tasks; + +namespace Rehau.Sku.Assist +{ + public class Functions + { + private static HttpClient httpClient = new HttpClient(); + + [ExcelFunction] + public static async Task RAUNAME(string request) + { + Task contentTask = Task.Run(() => SkuAssist.GetContent(request, httpClient)); + Task documentTask = await contentTask.ContinueWith(content => SkuAssist.GetDocument(content)); + IProduct product = await documentTask.ContinueWith(doc => SkuAssist.GetProductFromDocument(doc.Result)); + return product == null ? ExcelError.ExcelErrorNull.ToString() : product.ToString(); + } + } +} \ No newline at end of file -- cgit v1.2.3 From e67b5b24fd4a02df8516c43adf316bbcc04f7682 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Mon, 29 Nov 2021 17:13:36 +0300 Subject: Private field name fix --- src/ExcelDNA/Functions.cs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/ExcelDNA/Functions.cs') diff --git a/src/ExcelDNA/Functions.cs b/src/ExcelDNA/Functions.cs index 6792195..ec9c607 100644 --- a/src/ExcelDNA/Functions.cs +++ b/src/ExcelDNA/Functions.cs @@ -7,12 +7,12 @@ namespace Rehau.Sku.Assist { public class Functions { - private static HttpClient httpClient = new HttpClient(); + private static HttpClient _httpClient = new HttpClient(); [ExcelFunction] public static async Task RAUNAME(string request) { - Task contentTask = Task.Run(() => SkuAssist.GetContent(request, httpClient)); + Task contentTask = Task.Run(() => SkuAssist.GetContent(request, _httpClient)); Task documentTask = await contentTask.ContinueWith(content => SkuAssist.GetDocument(content)); IProduct product = await documentTask.ContinueWith(doc => SkuAssist.GetProductFromDocument(doc.Result)); return product == null ? ExcelError.ExcelErrorNull.ToString() : product.ToString(); -- cgit v1.2.3