From 72ac236b15603e84f18ec346749186b6cb2c2bdf Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Thu, 27 Jan 2022 10:22:30 +0300
Subject: Refactoring tolls classes

---
 src/PriceListTools/Source.cs | 52 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 52 insertions(+)
 create mode 100644 src/PriceListTools/Source.cs

(limited to 'src/PriceListTools/Source.cs')

diff --git a/src/PriceListTools/Source.cs b/src/PriceListTools/Source.cs
new file mode 100644
index 0000000..40ac257
--- /dev/null
+++ b/src/PriceListTools/Source.cs
@@ -0,0 +1,52 @@
+using Microsoft.Office.Interop.Excel;
+using System;
+using System.Collections.Generic;
+
+namespace RehauSku.PriceListTools
+{
+    internal class Source : PriceList
+    {
+        public Dictionary<string, double> SkuAmount { get; private set; }
+
+        public Source(Workbook workbook)
+        {
+            Sheet = workbook.ActiveSheet;
+            Name = workbook.Name;
+
+            amountCell = Sheet.Cells.Find(amountHeader);
+            skuCell = Sheet.Cells.Find(skuHeader);
+            groupCell = Sheet.Cells.Find(groupHeader);
+
+            if (amountCell == null || skuCell == null || groupCell == null)
+            {
+                throw new ArgumentException($"Лист { Name } не распознан");
+            }
+
+            CreateAmountDict();
+        }
+
+        private void CreateAmountDict()
+        {
+            SkuAmount = new Dictionary<string, double>();
+
+            object[,] amountColumn = Sheet.Columns[amountCell.Column].Value2;
+            object[,] skuColumn = Sheet.Columns[skuCell.Column].Value2;
+
+            for (int row = amountCell.Row + 1; row < amountColumn.GetLength(0); row++)
+            {
+                object amount = amountColumn[row, 1];
+                object sku = skuColumn[row, 1];
+
+                if (amount != null && (double)amount != 0)
+                {
+                    if (SkuAmount.ContainsKey(sku.ToString()))
+                        SkuAmount[sku.ToString()] += (double)amount;
+
+                    else
+                        SkuAmount.Add(sku.ToString(), (double)amount);
+                }
+            }
+        }
+    }
+}
+
-- 
cgit v1.2.3