1 files changed, 60 insertions, 0 deletions
diff --git a/src/PriceListTools/AbstractPriceListTool.cs b/src/PriceListTools/AbstractPriceListTool.cs
new file mode 100644
index 0000000..04d11af
--- /dev/null
+++ b/src/PriceListTools/AbstractPriceListTool.cs
@@ -0,0 +1,60 @@
+using ExcelDna.Integration;
+using Microsoft.Office.Interop.Excel;
+using System;
+using System.Collections.Generic;
+
+namespace RehauSku.PriceListTools
+{
+    internal abstract class AbstractPriceListTool
+    {
+        protected private Application ExcelApp;
+        protected private PriceList NewPriceList;
+        protected private List<PriceList> sourcePriceLists;
+
+        public AbstractPriceListTool()
+        {
+            ExcelApp = (Application)ExcelDnaUtil.Application;
+            sourcePriceLists = new List<PriceList>();
+        }
+
+        public void OpenNewPrice(string path)
+        {
+            Workbook wb = ExcelApp.Workbooks.Open(path);
+
+            try
+            {
+                NewPriceList = new PriceList(wb);
+
+                if (NewPriceList.Sheets.Count == 0)
+                    throw new ArgumentException($"Не найдены листы с артикулами в {wb.Name}");
+
+                if (NewPriceList.OfferSheet == null)
+                    throw new ArgumentException($"Нет листа для коммерческого предложения в {wb.Name}");
+            }
+
+            catch (Exception ex)
+            {
+                wb.Close();
+                throw ex;
+            }
+        }
+
+        public virtual void GetSource(string[] files)
+        {
+            ExcelApp.ScreenUpdating = false;
+            foreach (string file in files)
+            {
+                Workbook wb = ExcelApp.Workbooks.Open(file);
+                PriceList priceList = new PriceList(wb);
+                sourcePriceLists.Add(priceList);
+                wb.Close();
+            }
+            ExcelApp.ScreenUpdating = true;
+        }
+
+        public virtual void FillPriceList()
+        {
+            throw new NotImplementedException();
+        }
+    }
+}
+\ No newline at end of file