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/Target.cs | 46 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 46 insertions(+)
 create mode 100644 src/PriceListTools/Target.cs

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

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 =
+            //}
+        }
+    }
+}
+
-- 
cgit v1.2.3


From 935d48fc5fe264218b39b335e1fc5232af5dae61 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Thu, 27 Jan 2022 17:34:03 +0300
Subject: Complete tools refactoring

---
 src/PriceListTools/Target.cs | 26 ++------------------------
 1 file changed, 2 insertions(+), 24 deletions(-)

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

diff --git a/src/PriceListTools/Target.cs b/src/PriceListTools/Target.cs
index b9eb856..7abe9e2 100644
--- a/src/PriceListTools/Target.cs
+++ b/src/PriceListTools/Target.cs
@@ -1,17 +1,14 @@
 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;
+            Name = workbook.FullName;
 
             amountCell = Sheet.Cells.Find(amountHeader);
             skuCell = Sheet.Cells.Find(skuHeader);
@@ -19,27 +16,8 @@ namespace RehauSku.PriceListTools
 
             if (amountCell == null || skuCell == null || groupCell == null)
             {
-                throw new ArgumentException($"Лист { Name } не распознан");
+                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 =
-            //}
         }
     }
 }
-- 
cgit v1.2.3


From 60006126b97131e383a8fee137cf89a13672f042 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Fri, 28 Jan 2022 18:15:13 +0300
Subject: Add not found positions to target file

---
 src/PriceListTools/Target.cs | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

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

diff --git a/src/PriceListTools/Target.cs b/src/PriceListTools/Target.cs
index 7abe9e2..a7e87ec 100644
--- a/src/PriceListTools/Target.cs
+++ b/src/PriceListTools/Target.cs
@@ -13,8 +13,9 @@ namespace RehauSku.PriceListTools
             amountCell = Sheet.Cells.Find(amountHeader);
             skuCell = Sheet.Cells.Find(skuHeader);
             groupCell = Sheet.Cells.Find(groupHeader);
+            nameCell = Sheet.Cells.Find(nameHeader);
 
-            if (amountCell == null || skuCell == null || groupCell == null)
+            if (amountCell == null || skuCell == null || groupCell == null || nameCell == null)
             {
                 throw new ArgumentException($"Шаблон { Name } не является прайс-листом");
             }
-- 
cgit v1.2.3