From 24024b5729c1c44bb01cb29813868743d1753e31 Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Fri, 24 Dec 2021 16:22:03 +0300
Subject: MergeTool, MemoryUtil anf stuff

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

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

diff --git a/Source/PriceListTools/PriceListUtil.cs b/Source/PriceListTools/PriceListUtil.cs
new file mode 100644
index 0000000..14797d9
--- /dev/null
+++ b/Source/PriceListTools/PriceListUtil.cs
@@ -0,0 +1,41 @@
+using System.Collections.Generic;
+using System.IO;
+
+namespace RehauSku.PriceListTools
+{
+    static class PriceListUtil
+    {
+        public static string CreateNewExportFile()
+        {
+            string fileExtension = Path.GetExtension(RegistryUtil.PriceListPath);
+            string path = Path.GetTempFileName() + fileExtension;
+
+            File.Copy(RegistryUtil.PriceListPath, path);
+            return path;
+        }
+
+        public static void AddValues(this Dictionary<string, double> SkuAmount, PriceList priceList)
+        {
+            object[,] amountCells = priceList.ActiveSheet.amountCells;
+            object[,] skuCells = priceList.ActiveSheet.skuCells;
+
+            for (int row = priceList.ActiveSheet.headerRow.Value + 1; row < amountCells.GetLength(0); row++)
+            {
+                object amount = amountCells[row, 1];
+                object sku = skuCells[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