From 73569a43644309d0342817580bcfd86c1face5b8 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Tue, 20 Dec 2022 12:27:47 +0300
Subject: Namespace refactoring

---
 src/Models/SourcePriceList.cs | 114 ++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 114 insertions(+)
 create mode 100644 src/Models/SourcePriceList.cs

(limited to 'src/Models/SourcePriceList.cs')

diff --git a/src/Models/SourcePriceList.cs b/src/Models/SourcePriceList.cs
new file mode 100644
index 0000000..d210c10
--- /dev/null
+++ b/src/Models/SourcePriceList.cs
@@ -0,0 +1,114 @@
+using ExcelDna.Integration;
+using Microsoft.Office.Interop.Excel;
+using System;
+using System.Collections.Generic;
+using System.Linq;
+
+namespace RhSolutions.Models
+{
+    internal class SourcePriceList : PriceListBase
+    {
+        public Dictionary<Product, double> PositionAmount { get; private set; }
+
+        public SourcePriceList(Workbook workbook)
+        {
+            if (workbook == null)
+            {
+                throw new ArgumentException($"Нет рабочего файла");
+            }
+
+            Sheet = workbook.ActiveSheet;
+            Name = workbook.Name;
+
+            Range[] cells = new[]
+            {
+                AmountCell = Sheet.Cells.Find(PriceListHeaders.Amount),
+                SkuCell = Sheet.Cells.Find(PriceListHeaders.Sku),
+                GroupCell = Sheet.Cells.Find(PriceListHeaders.Group),
+                NameCell = Sheet.Cells.Find(PriceListHeaders.Name)
+            };
+
+            if (cells.Any(x => x == null))
+            {
+                throw new ArgumentException($"Файл {Name} не распознан");
+            }
+
+            CreatePositionsDict();
+        }
+
+        public static List<SourcePriceList> GetSourceLists(string[] files)
+        {
+            var ExcelApp = (Application)ExcelDnaUtil.Application;
+            ProgressBar bar = new ProgressBar("Открываю исходные файлы...", files.Length);
+
+            List<SourcePriceList> sourceFiles = new List<SourcePriceList>();
+
+            foreach (string file in files)
+            {
+                ExcelApp.ScreenUpdating = false;
+                Workbook wb = ExcelApp.Workbooks.Open(file);
+                try
+                {
+                    SourcePriceList priceList = new SourcePriceList(wb);
+                    sourceFiles.Add(priceList);
+                    wb.Close();
+                    bar.Update();
+                }
+                catch (Exception ex)
+                {
+                    System.Windows.Forms.MessageBox.Show
+                        (ex.Message,
+                        "Ошибка открытия исходного прайс-листа",
+                        System.Windows.Forms.MessageBoxButtons.OK,
+                        System.Windows.Forms.MessageBoxIcon.Information);
+                    wb.Close();
+                    bar.Update();
+                }
+                ExcelApp.ScreenUpdating = true;
+            }
+
+            return sourceFiles;
+        }
+
+        private void CreatePositionsDict()
+        {
+            PositionAmount = new Dictionary<Product, double>();
+
+            for (int row = AmountCell.Row + 1; row <= Sheet.Cells[Sheet.Rows.Count, AmountCell.Column].End[XlDirection.xlUp].Row; row++)
+            {
+                double? amount = Sheet.Cells[row, AmountCell.Column].Value2 as double?;
+
+                if (amount != null && amount.Value != 0)
+                {
+                    object group = Sheet.Cells[row, GroupCell.Column].Value2;
+                    object name = Sheet.Cells[row, NameCell.Column].Value2;
+                    object sku = Sheet.Cells[row, SkuCell.Column].Value2;
+
+                    if (group == null || name == null || sku == null)
+                        continue;
+
+                    if (!sku.ToString().IsRehauSku())
+                        continue;
+
+                    Product p = new Product
+                    {
+                        ProductSku = sku.ToString(),
+                        ProductLine = group.ToString(),
+                        Name = name.ToString()
+                    };
+
+                    if (PositionAmount.ContainsKey(p))
+                    {
+                        PositionAmount[p] += amount.Value;
+                    }
+
+                    else
+                    {
+                        PositionAmount.Add(p, amount.Value);
+                    }
+                }
+            }
+        }
+    }
+}
+
-- 
cgit v1.2.3