From 4f448f203471a19a1444555a895f503515ad2fda Mon Sep 17 00:00:00 2001
From: Sergey Chebotar <s.chebotar@gmail.com>
Date: Wed, 22 Mar 2023 08:36:13 +0300
Subject: Add basic test

---
 src/Controllers/CombineTool.cs      |  57 -----------
 src/Controllers/ConvertTool.cs      |  30 ------
 src/Controllers/ExportTool.cs       | 101 -------------------
 src/Controllers/MergeTool.cs        |  46 ---------
 src/Controllers/RibbonController.cs | 139 --------------------------
 src/Controllers/ToolBase.cs         | 190 ------------------------------------
 6 files changed, 563 deletions(-)
 delete mode 100644 src/Controllers/CombineTool.cs
 delete mode 100644 src/Controllers/ConvertTool.cs
 delete mode 100644 src/Controllers/ExportTool.cs
 delete mode 100644 src/Controllers/MergeTool.cs
 delete mode 100644 src/Controllers/RibbonController.cs
 delete mode 100644 src/Controllers/ToolBase.cs

(limited to 'src/Controllers')

diff --git a/src/Controllers/CombineTool.cs b/src/Controllers/CombineTool.cs
deleted file mode 100644
index 4d84d44..0000000
--- a/src/Controllers/CombineTool.cs
+++ /dev/null
@@ -1,57 +0,0 @@
-using Microsoft.Office.Interop.Excel;
-using RhSolutions.Models;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using Dialog = RhSolutions.Models.Dialog;
-using Range = Microsoft.Office.Interop.Excel.Range;
-
-namespace RhSolutions.Controllers
-{
-    internal class CombineTool : ToolBase
-    {
-        private List<SourcePriceList> SourceFiles { get; set; }
-
-        public CombineTool()
-        {
-            string[] files = Dialog.GetMultiplyFiles();
-
-            if (files != null)
-            {
-                SourceFiles = SourcePriceList.GetSourceLists(files);
-            }
-
-            else
-            {
-                throw new Exception("Не выбраны файлы");
-            }
-        }
-
-        public override void FillTarget()
-        {
-            using (ProgressBar = new ProgressBar("Заполняю строки...", SourceFiles.Sum(file => file.PositionAmount.Count)))
-            using (ResultBar = new ResultBar())
-            {
-                foreach (SourcePriceList source in SourceFiles)
-                {
-                    TargetFile.Sheet.Columns[TargetFile.AmountCell.Column]
-                        .EntireColumn
-                        .Insert(XlInsertShiftDirection.xlShiftToRight, XlInsertFormatOrigin.xlFormatFromRightOrBelow);
-
-                    Range newColumnHeader = TargetFile.Sheet.Cells[TargetFile.AmountCell.Row, TargetFile.AmountCell.Column - 1];
-                    newColumnHeader.Value2 = $"{source.Name}";
-                    newColumnHeader.WrapText = true;
-
-                    foreach (var kvp in source.PositionAmount)
-                    {
-                        FillPositionAmountToColumns(kvp, TargetFile.AmountCell.Column - 1, TargetFile.AmountCell.Column);
-                        ProgressBar.Update();
-                    }
-                }
-
-                FilterByAmount();
-                ResultBar.Update();
-            }
-        }
-    }
-}
diff --git a/src/Controllers/ConvertTool.cs b/src/Controllers/ConvertTool.cs
deleted file mode 100644
index 5b2cd4d..0000000
--- a/src/Controllers/ConvertTool.cs
+++ /dev/null
@@ -1,30 +0,0 @@
-using RhSolutions.Models;
-
-namespace RhSolutions.Controllers
-{
-    internal class ConvertTool : ToolBase
-    {
-        private SourcePriceList Current { get; set; }
-
-        public ConvertTool()
-        {
-            Current = new SourcePriceList(ExcelApp.ActiveWorkbook);
-        }
-
-        public override void FillTarget()
-        {
-            using (ProgressBar = new ProgressBar("Заполняю строки...", Current.PositionAmount.Count))
-            using (ResultBar = new ResultBar())
-            {
-                foreach (var kvp in Current.PositionAmount)
-                {
-                    FillPositionAmountToColumns(kvp, TargetFile.AmountCell.Column);
-                    ProgressBar.Update();
-                }
-
-                FilterByAmount();
-                ResultBar.Update();
-            }
-        }
-    }
-}
\ No newline at end of file
diff --git a/src/Controllers/ExportTool.cs b/src/Controllers/ExportTool.cs
deleted file mode 100644
index e2bbde4..0000000
--- a/src/Controllers/ExportTool.cs
+++ /dev/null
@@ -1,101 +0,0 @@
-using Microsoft.Office.Interop.Excel;
-using System;
-using System.Collections.Generic;
-using RhSolutions.Models;
-using System.Linq;
-using Range = Microsoft.Office.Interop.Excel.Range;
-
-namespace RhSolutions.Controllers
-{
-    internal class ExportTool : ToolBase
-    {
-        private Dictionary<Product, double> PositionAmount;
-        private readonly Range Selection;
-
-        public ExportTool()
-        {
-            Selection = ExcelApp.Selection;
-            GetSelected();
-
-            if (PositionAmount.Count == 0)
-            {
-                throw new Exception("В выделенном диапазоне не найдены позиции для экспорта");
-            }
-        }
-
-        public override void FillTarget()
-        {
-            using (ProgressBar = new ProgressBar("Заполняю строки...", PositionAmount.Count))
-            using (ResultBar = new ResultBar())
-            {
-                foreach (var kvp in PositionAmount)
-                {
-                    FillPositionAmountToColumns(kvp, TargetFile.AmountCell.Column);
-                    ProgressBar.Update();
-                }
-
-                FilterByAmount();
-                ResultBar.Update();
-            }
-        }
-
-        private void GetSelected()
-        {
-            object[,] cells = Selection.Value2;
-            PositionAmount = new Dictionary<Product, double>();
-
-            int rowsCount = Selection.Rows.Count;
-
-            for (int row = 1; row <= rowsCount; row++)
-            {
-                if (cells[row, 1] == null || cells[row, 2] == null)
-                    continue;
-
-                string sku = null;
-                double? amount = null;
-
-                for (int column = 1; column <= 2; column++)
-                {
-                    object current = cells[row, column];
-
-                    if (Sku.TryParse(current.ToString(), out var rauSku))
-                    {
-                        sku = rauSku.FirstOrDefault().ToString() ?? null;
-                    }
-
-                    else if (current.GetType() == typeof(string)
-                        && double.TryParse(current.ToString(), out _))
-                    {
-                        amount = double.Parse((string)current);
-                    }
-
-                    else if (current.GetType() == typeof(double))
-                    {
-                        amount = (double)current;
-                    }
-                }
-
-                if (sku == null || amount == null)
-                {
-                    continue;
-                }
-
-                Product position = new Product
-                {
-                    ProductSku = sku
-                };
-
-                if (PositionAmount.ContainsKey(position))
-                {
-                    PositionAmount[position] += amount.Value;
-                }
-
-                else
-                {
-                    PositionAmount.Add(position, amount.Value);
-                }
-            }
-        }
-    }
-}
-
diff --git a/src/Controllers/MergeTool.cs b/src/Controllers/MergeTool.cs
deleted file mode 100644
index dec8ff7..0000000
--- a/src/Controllers/MergeTool.cs
+++ /dev/null
@@ -1,46 +0,0 @@
-using RhSolutions.Models;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-
-namespace RhSolutions.Controllers
-{
-    internal class MergeTool : ToolBase
-    {
-        private List<SourcePriceList> SourceFiles { get; set; }
-
-        public MergeTool()
-        {
-            string[] files = Dialog.GetMultiplyFiles();
-
-            if (files != null)
-            {
-                SourceFiles = SourcePriceList.GetSourceLists(files);
-            }
-
-            else
-            {
-                throw new Exception("Не выбраны файлы");
-            }
-        }
-
-        public override void FillTarget()
-        {
-            using (ProgressBar = new ProgressBar("Заполняю строки...", SourceFiles.Sum(x => x.PositionAmount.Count)))
-            using (ResultBar = new ResultBar())
-            {
-                foreach (SourcePriceList source in SourceFiles)
-                {
-                    foreach (var kvp in source.PositionAmount)
-                    {
-                        FillPositionAmountToColumns(kvp, TargetFile.AmountCell.Column);
-                        ProgressBar.Update();
-                    }
-                }
-
-                FilterByAmount();
-                ResultBar.Update();
-            }
-        }
-    }
-}
diff --git a/src/Controllers/RibbonController.cs b/src/Controllers/RibbonController.cs
deleted file mode 100644
index 148daca..0000000
--- a/src/Controllers/RibbonController.cs
+++ /dev/null
@@ -1,139 +0,0 @@
-using ExcelDna.Integration.CustomUI;
-using Microsoft.Office.Interop.Excel;
-using RhSolutions.AddIn;
-using RhSolutions.Services;
-using System;
-using System.IO;
-using System.Reflection;
-using System.Runtime.InteropServices;
-using System.Windows.Forms;
-using Range = Microsoft.Office.Interop.Excel.Range;
-
-namespace RhSolutions.Controllers
-{
-    [ComVisible(true)]
-    public class RibbonController : ExcelRibbon
-    {
-        private static IRibbonUI ribbonUi;
-
-        public override string GetCustomUI(string RibbonID)
-        {
-            return @"
-      <customUI onLoad='RibbonLoad' xmlns='http://schemas.microsoft.com/office/2006/01/customui'>
-      <ribbon>
-        <tabs>
-          <tab id='rau' label='RhSolutions'>
-            <group id='priceList' label='Прайс-лист'>
-                <button id='export' getEnabled='GetExportEnabled' label='Экспорт в новый файл' size='normal' imageMso='PivotExportToExcel' onAction='OnToolPressed'/> 
-                <button id='convert' getEnabled='GetConvertEnabled' label='Актуализировать' size='normal' imageMso='FileUpdate' onAction='OnToolPressed'/> 
-                <menu id='conjoinMenu' label='Объединить' imageMso='Copy'>
-                    <button id='merge' label='Сложить' onAction='OnToolPressed'/>    
-                    <button id='combine' label='По колонкам' onAction='OnToolPressed'/>   
-                </menu>
-            </group>
-            <group id='rausettings' getLabel='GetVersionLabel'>
-                <button id='setPriceList' getLabel='GetPriceListPathLabel' size='large' imageMso='TableExcelSpreadsheetInsert' onAction='OnSetPricePressed'/>
-            </group>
-          </tab>
-        </tabs>
-      </ribbon>
-    </customUI>";
-        }
-
-        public void RibbonLoad(IRibbonUI sender)
-        {
-            ribbonUi = sender;
-        }
-
-        public static void RefreshControl(string id)
-        {
-            if (ribbonUi != null)
-            {
-                ribbonUi.InvalidateControl(id);
-            }
-        }
-        public void OnSetPricePressed(IRibbonControl control)
-        {
-            string path = Models.Dialog.GetFilePath();
-
-            if (!string.IsNullOrEmpty(path))
-            {
-                RegistryUtil.PriceListPath = path;
-            }
-        }
-
-        public void OnToolPressed(IRibbonControl control)
-        {
-            try
-            {
-                ToolBase tool;
-                switch (control.Id)
-                {
-                    case "export":
-                        tool = new ExportTool();
-                        break;
-                    case "convert":
-                        tool = new ConvertTool();
-                        break;
-                    case "merge":
-                        tool = new MergeTool();
-                        break;
-                    case "combine":
-                        tool = new CombineTool();
-                        break;
-                    default:
-                        throw new Exception("Неизвестный инструмент");
-                }
-
-                tool.OpenNewPrice();
-                tool.FillTarget();
-            }
-
-            catch (Exception exception)
-            {
-                MessageBox.Show(exception.Message,
-                    "Ошибка",
-                    MessageBoxButtons.OK,
-                    MessageBoxIcon.Information);
-                RhSolutionsAddIn.Excel.StatusBar = false;
-                return;
-            }
-        }
-
-        public bool GetConvertEnabled(IRibbonControl control)
-        {
-            if (RhSolutionsAddIn.Excel.ActiveWorkbook == null)
-                return false;
-
-            else
-            {
-                Worksheet worksheet = RhSolutionsAddIn.Excel.ActiveWorkbook.ActiveSheet;
-                return worksheet.IsRehauSource();
-            }
-        }
-
-        public bool GetExportEnabled(IRibbonControl control)
-        {
-            if (RhSolutionsAddIn.Excel.ActiveWorkbook == null)
-                return false;
-
-            else
-            {
-                Range selection = RhSolutionsAddIn.Excel.Selection;
-                return selection.Columns.Count == 2;
-            }
-        }
-
-        public string GetVersionLabel(IRibbonControl control)
-        {
-            string version = Assembly.GetExecutingAssembly().GetName().Version.ToString();
-            return $"v{version}";
-        }
-
-        public string GetPriceListPathLabel(IRibbonControl control)
-        {
-            string name = RegistryUtil.GetPriceListName();
-            return string.IsNullOrEmpty(name) ? "Нет файла шаблона!" : name;
-        }
-    }
-}
diff --git a/src/Controllers/ToolBase.cs b/src/Controllers/ToolBase.cs
deleted file mode 100644
index 08493d4..0000000
--- a/src/Controllers/ToolBase.cs
+++ /dev/null
@@ -1,190 +0,0 @@
-using Microsoft.Office.Interop.Excel;
-using RhSolutions.AddIn;
-using RhSolutions.Models;
-using RhSolutions.Services;
-using System;
-using System.Collections.Generic;
-using System.Linq;
-using Range = Microsoft.Office.Interop.Excel.Range;
-
-namespace RhSolutions.Controllers
-{
-    internal abstract class ToolBase
-    {
-        protected Application ExcelApp = RhSolutionsAddIn.Excel;
-        protected TargetPriceList TargetFile { get; set; }
-        protected ResultBar ResultBar { get; set; }
-        protected ProgressBar ProgressBar { get; set; }
-
-        public abstract void FillTarget();
-
-        public void OpenNewPrice()
-        {
-            if (ExcelApp.Workbooks
-                .Cast<Workbook>()
-                .FirstOrDefault(w => w.FullName == RegistryUtil.PriceListPath) != null)
-            {
-                throw new ArgumentException("Шаблонный файл редактируется в другом месте");
-            }
-
-            Workbook wb = ExcelApp.Workbooks.Open(RegistryUtil.PriceListPath, null, true);
-
-            try
-            {
-                TargetFile = new TargetPriceList(wb);
-            }
-
-            catch (Exception exception)
-            {
-                if (wb != null)
-                {
-                    wb.Close();
-                }
-
-                throw exception;
-            }
-        }
-
-        protected void FillPositionAmountToColumns(KeyValuePair<Product, double> positionAmount, params int[] columns)
-        {
-            Range worksheetCells = TargetFile.Sheet.Cells;
-            Range skuColumn = TargetFile.SkuCell.EntireColumn;
-
-            int? row = GetPositionRow(skuColumn, positionAmount.Key.ProductSku, positionAmount.Key.ProductLine);
-
-            if (row != null)
-            {
-                foreach (int column in columns)
-                {
-                    Range cell = worksheetCells[row, column];
-                    cell.AddValue(positionAmount.Value);
-                }
-
-                ResultBar.IncrementSuccess();
-                return;
-            }
-
-            if (TargetFile.OldSkuCell != null)
-            {
-                row = GetPositionRow(TargetFile.OldSkuCell.EntireColumn, positionAmount.Key.ProductSku, positionAmount.Key.ProductLine);
-
-                if (row != null)
-                {
-                    foreach (int column in columns)
-                    {
-                        Range cell = worksheetCells[row, column];
-                        cell.AddValue(positionAmount.Value);
-                    }
-
-                    ResultBar.IncrementReplaced();
-                    return;
-                }
-            }
-
-            string sku = positionAmount.Key.ProductSku.Substring(1, 6);
-            row = GetPositionRow(skuColumn, sku, positionAmount.Key.ProductLine);
-
-            if (row != null)
-            {
-                foreach (int column in columns)
-                {
-                    Range cell = worksheetCells[row, column];
-                    cell.AddValue(positionAmount.Value);
-                }
-
-                ResultBar.IncrementReplaced();
-                return;
-            }
-
-            FillMissing(positionAmount, columns);
-            ResultBar.IncrementNotFound();
-        }
-
-        protected void FillMissing(KeyValuePair<Product, double> positionAmount, params int[] columns)
-        {
-            Range worksheetCells = TargetFile.Sheet.Cells;
-            Range worksheetRows = TargetFile.Sheet.Rows;
-            int skuColumn = TargetFile.SkuCell.Column;
-            int groupColumn = TargetFile.GroupCell.Column;
-            int nameColumn = TargetFile.NameCell.Column;
-
-            int row = worksheetCells[worksheetRows.Count, skuColumn]
-                .End[XlDirection.xlUp]
-                .Row + 1;
-
-            worksheetRows[row]
-                .EntireRow
-                .Insert(XlInsertShiftDirection.xlShiftDown, XlInsertFormatOrigin.xlFormatFromLeftOrAbove);
-
-            Range previous = worksheetRows[row - 1];
-            Range current = worksheetRows[row];
-
-            previous.Copy(current);
-            current.ClearContents();
-
-            worksheetCells[row, groupColumn].Value2 = positionAmount.Key.ProductLine;
-            worksheetCells[row, nameColumn].Value2 = positionAmount.Key.Name;
-
-            if (TargetFile.OldSkuCell != null)
-            {
-                worksheetCells[row, skuColumn].Value2 = "Не найден";
-                worksheetCells[row, TargetFile.OldSkuCell.Column].Value2 = positionAmount.Key.ProductSku;
-            }
-
-            else
-            {
-                worksheetCells[row, skuColumn].Value2 = positionAmount.Key.ProductSku;
-            }
-
-            foreach (int column in columns)
-            {
-                Range cell = worksheetCells[row, column];
-                cell.AddValue(positionAmount.Value);
-            }
-        }
-
-        protected int? GetPositionRow(Range range, string sku, string group)
-        {
-            Range found = range.Find(sku);
-            string foundGroupValue;
-
-            if (found == null)
-            {
-                return null;
-            }
-
-            int firstFoundRow = found.Row;
-
-            if (string.IsNullOrEmpty(group))
-            {
-                return found.Row;
-            }
-
-            while (true)
-            {
-                foundGroupValue = TargetFile.Sheet.Cells[found.Row, TargetFile.GroupCell.Column].Value2.ToString();
-
-                if (group.Equals(foundGroupValue))
-                {
-                    return found.Row;
-                }
-
-                found = range.FindNext(found);
-
-                if (found.Row == firstFoundRow)
-                {
-                    return null;
-                }
-            }
-        }
-
-        protected void FilterByAmount()
-        {
-            AutoFilter filter = TargetFile.Sheet.AutoFilter;
-            int startColumn = filter.Range.Column;
-
-            filter.Range.AutoFilter(TargetFile.AmountCell.Column - startColumn + 1, "<>0", XlAutoFilterOperator.xlAnd, "<>");
-            TargetFile.Sheet.Range["A1"].Activate();
-        }
-    }
-}
\ No newline at end of file
-- 
cgit v1.2.3