Refactoring

1 files changed, 31 insertions, 0 deletions

diff --git a/src/AddIn/Functions.cs b/src/AddIn/Functions.cs
new file mode 100644
index 0000000..2be19fa
--- /dev/null
+++ b/src/AddIn/Functions.cs
@@ -0,0 +1,31 @@
+using ExcelDna.Integration;
+using RhSolutions.Services;
+
+namespace RhSolutions.AddIn
+{
+    public class Functions
+    {
+        [ExcelFunction(Description = "Запрос в удаленную базу данных")]
+        public static object RHSOLUTIONS([ExcelArgument(Name = "Запрос")] string line)
+        {
+            object result;
+
+            result = ExcelAsyncUtil.Run("Database request", line, delegate
+            {
+                return RhDatabaseClient.GetProduct(line).GetAwaiter().GetResult();
+            });
+
+            if (result == null)
+            {
+                return ExcelError.ExcelErrorNA;
+            }
+
+            if (result.Equals(ExcelError.ExcelErrorNA))
+            {
+                return "Загрузка...";
+            }
+
+            return result;
+        }
+    }
+}
\ No newline at end of file