1 files changed, 41 insertions, 0 deletions
diff --git a/src/Models/WorksheetExtensions.cs b/src/Models/WorksheetExtensions.cs
new file mode 100644
index 0000000..6b5fc3e
--- /dev/null
+++ b/src/Models/WorksheetExtensions.cs
@@ -0,0 +1,41 @@
+using Microsoft.Office.Interop.Excel;
+using RhSolutions.Models;
+using System.Linq;
+
+namespace RhSolutions.Services
+{
+    public static class WorksheetExtensions
+    {
+        public static bool IsRehauSource(this Worksheet worksheet)
+        {
+            Range amountCell;
+            Range skuCell;
+            Range groupCell;
+            Range nameCell;
+
+            Range[] cells = new[]
+            {
+                amountCell = worksheet.Cells.Find(PriceListHeaders.Amount),
+                skuCell = worksheet.Cells.Find(PriceListHeaders.Sku),
+                groupCell = worksheet.Cells.Find(PriceListHeaders.Group),
+                nameCell = worksheet.Cells.Find(PriceListHeaders.Name)
+            };
+
+            return cells.All(x => x != null);
+        }
+
+        public static void AddValue(this Range range, double value)
+        {
+            if (range.Value2 == null)
+            {
+                range.Value2 = value;
+            }
+
+            else
+            {
+                range.Value2 += value;
+            }
+        }
+    }
+}
+