From 9d2f386a7491a3ceb31e908f1070e42ee616d3b7 Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Tue, 23 May 2023 14:39:49 +0300 Subject: Add one row guess test --- RhSolutions.Tests/CanDoGuess.cs | 19 ++++++++++++++++++- .../TargetSpecificationGuessOneRow.xlsx | Bin 0 -> 11602 bytes .../TestWorkbooks/TestSpecificationGuessOneRow.xlsx | Bin 0 -> 9069 bytes 3 files changed, 18 insertions(+), 1 deletion(-) create mode 100644 RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuessOneRow.xlsx create mode 100644 RhSolutions.Tests/TestWorkbooks/TestSpecificationGuessOneRow.xlsx (limited to 'RhSolutions.Tests') diff --git a/RhSolutions.Tests/CanDoGuess.cs b/RhSolutions.Tests/CanDoGuess.cs index c801af7..8e2d71c 100644 --- a/RhSolutions.Tests/CanDoGuess.cs +++ b/RhSolutions.Tests/CanDoGuess.cs @@ -18,7 +18,7 @@ public class CanDoGuess : IDisposable } [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationGuess.xlsx")] - public void CanWrite() + public void CanWriteMultiplyRows() { Worksheet sourceSheet = Util.Workbook.Worksheets[1]; RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationGuess.xlsx")); @@ -34,6 +34,23 @@ public class CanDoGuess : IDisposable Assert.Equal(products.First().Item2.Values.Sum(), targetProducts.First().Item2.Values.Sum()); } + [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationGuessOneRow.xlsx")] + public void CanWriteOneRow() + { + Worksheet sourceSheet = Util.Workbook.Worksheets[1]; + RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationGuessOneRow.xlsx")); + var products = _reader.ReadProducts(new[] { sourceSheet }); + var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration); + _writer.WriteProducts(products); + Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet; + var targetProducts = _reader.ReadProducts(new[] { targetSheet }); + + Assert.Equal("TestSpecificationGuessOneRow", products.First().Item1); + Assert.Equal("TargetSpecificationGuessOneRow", targetProducts.First().Item1); + Assert.Equal(products.First().Item2.Count(), targetProducts.First().Item2.Count()); + Assert.Equal(products.First().Item2.Values.Sum(), targetProducts.First().Item2.Values.Sum()); + } + public void Dispose() { _addIn.AutoClose(); diff --git a/RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuessOneRow.xlsx b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuessOneRow.xlsx new file mode 100644 index 0000000..4501c1e Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationGuessOneRow.xlsx differ diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationGuessOneRow.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationGuessOneRow.xlsx new file mode 100644 index 0000000..723789f Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TestSpecificationGuessOneRow.xlsx differ -- cgit v1.2.3