diff options
author | Sergey Chebotar <s.chebotar@gmail.com> | 2022-12-20 12:03:05 +0300 |
---|---|---|
committer | Sergey Chebotar <s.chebotar@gmail.com> | 2022-12-20 12:03:05 +0300 |
commit | bfada8d605619e80702391c7f8fb326f021df18b (patch) | |
tree | e87bb02b44e8fe3893d41e05819e040809c300e0 /src/AddIn/Functions.cs | |
parent | e427d63e7735dd266ff5eb1309b9878585b83db6 (diff) |
RhDatabase Client extract class
Diffstat (limited to 'src/AddIn/Functions.cs')
-rw-r--r-- | src/AddIn/Functions.cs | 53 |
1 files changed, 0 insertions, 53 deletions
diff --git a/src/AddIn/Functions.cs b/src/AddIn/Functions.cs index 804e1c9..5bcfd45 100644 --- a/src/AddIn/Functions.cs +++ b/src/AddIn/Functions.cs @@ -1,27 +1,10 @@ using ExcelDna.Integration; -using Newtonsoft.Json; using System; -using System.Collections.Generic; -using System.Linq; -using System.Net; -using System.Net.Http; -using System.Threading.Tasks; namespace RhSolutions { public class Functions { - [ExcelFunction(Description = "Получение корректного артикула из строки")] - public static object GETRAUSKU([ExcelArgument(Name = "\"Строка\"", Description = "строка, содержащая актикул")] string line) - { - if (RauSku.TryParse(line, out RauSku rausku)) - { - return rausku.ToString(); - } - - else return ExcelError.ExcelErrorNA; - } - [ExcelFunction(Description = "Запрос в удаленную базу данных")] public static object RHSOLUTIONS([ExcelArgument(Name = "Запрос")] string line) { @@ -45,40 +28,4 @@ namespace RhSolutions return result; } } - - public static class RhDatabaseClient - { - private static HttpClient httpClient = AddIn.httpClient; - - public static async Task<object> GetProduct(string line) - { - string request = @"https://rh.cebotari.ru/api/search?query=" + line; - - ServicePointManager.SecurityProtocol = - SecurityProtocolType.Tls12 | - SecurityProtocolType.Tls11 | - SecurityProtocolType.Tls; - - string response = await httpClient.GetStringAsync(request); - - var products = JsonConvert.DeserializeObject<IEnumerable<DbProduct>>(response); - - var product = products.FirstOrDefault(); - - if (product == null) - { - return null; - } - else - { - return $"{product.productSku} {product.name}"; - } - } - - private class DbProduct - { - public string productSku { get; set; } - public string name { get; set; } - } - } }
\ No newline at end of file |