From 58f5c5ba4a9fde68e8b758cf715d8b97e900039b Mon Sep 17 00:00:00 2001 From: Sergey Chebotar Date: Sun, 21 May 2023 15:21:20 +0300 Subject: Add new variant writing test --- RhSolutions.Tests/CanWriteProducts.cs | 20 +++++++++++++++++++- .../TargetSpecificationNewVariant.xlsx | Bin 0 -> 9347 bytes .../TestWorkbooks/TestSpecificationNewVariant.xlsx | Bin 0 -> 9175 bytes 3 files changed, 19 insertions(+), 1 deletion(-) create mode 100644 RhSolutions.Tests/TestWorkbooks/TargetSpecificationNewVariant.xlsx create mode 100644 RhSolutions.Tests/TestWorkbooks/TestSpecificationNewVariant.xlsx (limited to 'RhSolutions.Tests') diff --git a/RhSolutions.Tests/CanWriteProducts.cs b/RhSolutions.Tests/CanWriteProducts.cs index c89bb71..33df1f8 100644 --- a/RhSolutions.Tests/CanWriteProducts.cs +++ b/RhSolutions.Tests/CanWriteProducts.cs @@ -51,7 +51,6 @@ public class CanWriteProducts : IDisposable Assert.True(Enumerable.SequenceEqual(products.First().Item2, targetProducts.First().Item2)); } - [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationNotFound.xlsx")] public void CanWriteNotFound() { @@ -86,6 +85,25 @@ public class CanWriteProducts : IDisposable Assert.Contains("15555551555", product.Name); } + [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationNewVariant.xlsx")] + public void CanWriteNewVariant() + { + Worksheet sourceSheet = Util.Workbook.Worksheets[1]; + RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationNewVariant.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("TestSpecificationNewVariant", products.First().Item1); + Assert.Equal("TargetSpecificationNewVariant", targetProducts.First().Item1); + Assert.Single(targetProducts.First().Item2); + var product = targetProducts.First().Item2.First().Key; + Assert.Contains("Молот Тора", product.Name); + Assert.Contains("15555551555", product.Name); + } + public void Dispose() { _addIn.AutoClose(); diff --git a/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNewVariant.xlsx b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNewVariant.xlsx new file mode 100644 index 0000000..56d1cdc Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNewVariant.xlsx differ diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationNewVariant.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNewVariant.xlsx new file mode 100644 index 0000000..f6c3d96 Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNewVariant.xlsx differ -- cgit v1.2.3