From 3ea18ae25e98527aa85835c9221ea01b36560b33 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Mon, 29 Nov 2021 21:24:44 +0300 Subject: Add Uri Converter --- src/Assistant/IProduct.cs | 9 --------- src/Assistant/Product.cs | 21 --------------------- src/Assistant/SkuAssist.cs | 45 --------------------------------------------- src/ExcelDNA/AddIn.cs | 24 ------------------------ src/ExcelDNA/Functions.cs | 21 --------------------- 5 files changed, 120 deletions(-) delete mode 100644 src/Assistant/IProduct.cs delete mode 100644 src/Assistant/Product.cs delete mode 100644 src/Assistant/SkuAssist.cs delete mode 100644 src/ExcelDNA/AddIn.cs delete mode 100644 src/ExcelDNA/Functions.cs (limited to 'src') diff --git a/src/Assistant/IProduct.cs b/src/Assistant/IProduct.cs deleted file mode 100644 index aca3ff5..0000000 --- a/src/Assistant/IProduct.cs +++ /dev/null @@ -1,9 +0,0 @@ -namespace Rehau.Sku.Assist -{ - interface IProduct - { - string Sku { get; } - string Name { get; } - string Uri { get; } - } -} diff --git a/src/Assistant/Product.cs b/src/Assistant/Product.cs deleted file mode 100644 index 17a7065..0000000 --- a/src/Assistant/Product.cs +++ /dev/null @@ -1,21 +0,0 @@ -namespace Rehau.Sku.Assist -{ - public class Product : IProduct - { - public string Sku { get; } - public string Name { get; } - - public string Uri => throw new System.NotImplementedException(); - - public Product(string sku, string name) - { - Sku = sku; - Name = name; - } - - public override string ToString() - { - return $"{this.Name} ({this.Sku})"; - } - } -} \ No newline at end of file diff --git a/src/Assistant/SkuAssist.cs b/src/Assistant/SkuAssist.cs deleted file mode 100644 index dc36dc0..0000000 --- a/src/Assistant/SkuAssist.cs +++ /dev/null @@ -1,45 +0,0 @@ -using AngleSharp; -using AngleSharp.Dom; -using System.Linq; -using System.Net; -using System.Net.Http; -using System.Text.RegularExpressions; -using System.Threading.Tasks; - -namespace Rehau.Sku.Assist -{ - static class SkuAssist - { - public async static Task GetContent(string request, HttpClient httpClient) - { - string uri = "https://shop-rehau.ru/catalogsearch/result/?q=" + request._CleanRequest(); - ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12 | SecurityProtocolType.Tls11 | SecurityProtocolType.Tls; - - return await httpClient.GetStringAsync(uri); - } - - public async static Task GetDocument(Task source) - { - IConfiguration config = Configuration.Default; - IBrowsingContext context = BrowsingContext.New(config); - - return await context.OpenAsync(req => req.Content(source.Result)); - } - - public static IProduct GetProductFromDocument(IDocument document) - { - return document - .All - .Where(e => e.ClassName == "product-item__desc-top") - .Select(e => new Product(e.Children[0].TextContent, e.Children[1].TextContent.Trim(new[] { '\n', ' ' }))) - .FirstOrDefault(); - } - - private static string _CleanRequest(this string input) - { - return input.Replace("+", " plus "); - } - } -} - - diff --git a/src/ExcelDNA/AddIn.cs b/src/ExcelDNA/AddIn.cs deleted file mode 100644 index dd99667..0000000 --- a/src/ExcelDNA/AddIn.cs +++ /dev/null @@ -1,24 +0,0 @@ -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/src/ExcelDNA/Functions.cs b/src/ExcelDNA/Functions.cs deleted file mode 100644 index ec9c607..0000000 --- a/src/ExcelDNA/Functions.cs +++ /dev/null @@ -1,21 +0,0 @@ -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