Add Not Found Writing Test

3 files changed, 18 insertions, 0 deletions

diff --git a/RhSolutions.Tests/CanWriteProducts.cs b/RhSolutions.Tests/CanWriteProducts.cs
index accb639..9280d5f 100644
--- a/RhSolutions.Tests/CanWriteProducts.cs
+++ b/RhSolutions.Tests/CanWriteProducts.cs
@@ -51,6 +51,24 @@ public class CanWriteProducts : IDisposable
         Assert.True(Enumerable.SequenceEqual(products.First().Item2, targetProducts.First().Item2));
     }
 
+
+    [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationNotFound.xlsx")]
+    public void CanWriteNotFound()
+    {
+        Worksheet sourceSheet = Util.Workbook.Worksheets[1];
+        RhSolutionsAddIn.Configuration.SetPriceListPath(Path.GetFullPath(@"..\..\..\TestWorkbooks\TargetSpecificationNotFound.xlsx"));
+        var products = _reader.ReadProducts(new[] { sourceSheet });
+        var _writer = new ExcelWriter(Util.Application, RhSolutionsAddIn.Configuration);
+        _writer.WriteProducts(products);
+        Worksheet targetSheet = Util.Application.ActiveWindow.ActiveSheet;
+
+        Assert.Equal("???", targetSheet.Range["B4"].Value2);
+        Assert.Contains("Молот Тора", targetSheet.Range["C4"].Value2);
+        Assert.Contains("15555551555", targetSheet.Range["C4"].Value2);
+    }
+
+
+
     public void Dispose()
     {
         _addIn.AutoClose();
diff --git a/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx
new file mode 100644
index 0000000..e26fe55
--- /dev/null
+++ b/RhSolutions.Tests/TestWorkbooks/TargetSpecificationNotFound.xlsx
diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx
new file mode 100644
index 0000000..de111f3
--- /dev/null
+++ b/RhSolutions.Tests/TestWorkbooks/TestSpecificationNotFound.xlsx