Refactoring tolls classes

1 files changed, 46 insertions, 0 deletions

diff --git a/src/PriceListTools/Target.cs b/src/PriceListTools/Target.cs
new file mode 100644
index 0000000..b9eb856
--- /dev/null
+++ b/src/PriceListTools/Target.cs
@@ -0,0 +1,46 @@
+using Microsoft.Office.Interop.Excel;
+using System;
+using System.Collections.Generic;
+
+namespace RehauSku.PriceListTools
+{
+    internal class Target : PriceList
+    {
+        public Dictionary<PriceListPosition, Range> Map { get; private set; }
+
+        public Target(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 } не распознан");
+            }
+
+            CreateMap();
+        }
+
+        private void CreateMap()
+        {
+            Range amountCell = Sheet.Cells.Find(amountHeader);
+            Range skuCell = Sheet.Cells.Find(skuHeader);
+            Range groupCell = Sheet.Cells.Find(groupHeader);
+
+            //headerRowNumber = amountCell.Row;
+            //skuColumnNumber = skuCell.Column;
+            //amountColumnNumber = amountCell.Column;
+            //groupColumnNumber = groupCell.Column;
+
+            //for (int row = headerRowNumber + 1; row < skuCell.Rows.Count; row++)
+            //{
+            //    string sku =
+            //}
+        }
+    }
+}
+