aboutsummaryrefslogtreecommitdiff
path: root/src/AddIn/Functions.cs
diff options
context:
space:
mode:
authorSergey Chebotar <s.chebotar@gmail.com>2022-12-20 12:03:05 +0300
committerSergey Chebotar <s.chebotar@gmail.com>2022-12-20 12:03:05 +0300
commitbfada8d605619e80702391c7f8fb326f021df18b (patch)
treee87bb02b44e8fe3893d41e05819e040809c300e0 /src/AddIn/Functions.cs
parente427d63e7735dd266ff5eb1309b9878585b83db6 (diff)
RhDatabase Client extract class
Diffstat (limited to 'src/AddIn/Functions.cs')
-rw-r--r--src/AddIn/Functions.cs53
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