From 02d0b21a5896ea3323511240652ba8c5fd9671c5 Mon Sep 17 00:00:00 2001 From: Serghei Cebotari Date: Sun, 12 Nov 2023 14:57:43 +0300 Subject: Add couplings calculator test --- RhSolutions.Tests/CanFillCouplings.cs | 41 +++++++++++++++++++++ .../TestWorkbooks/TestSpecificationCouplings.xlsx | Bin 0 -> 358588 bytes 2 files changed, 41 insertions(+) create mode 100644 RhSolutions.Tests/CanFillCouplings.cs create mode 100644 RhSolutions.Tests/TestWorkbooks/TestSpecificationCouplings.xlsx (limited to 'RhSolutions.Tests') diff --git a/RhSolutions.Tests/CanFillCouplings.cs b/RhSolutions.Tests/CanFillCouplings.cs new file mode 100644 index 0000000..48e4ee8 --- /dev/null +++ b/RhSolutions.Tests/CanFillCouplings.cs @@ -0,0 +1,41 @@ +using RhSolutions.AddIn; + +namespace RhSolutions.Tests; + +[ExcelTestSettings(OutOfProcess = true)] +public class CanFillCouplings : IDisposable +{ + private RhSolutionsAddIn _addIn; + private IFittingsCalculator _calculator; + private IReader _reader; + private IWriter _writer; + private Worksheet _worksheet; + + public CanFillCouplings() + { + _addIn = new(); + _addIn.AutoOpen(); + _calculator = new CouplingsCalculator(); + _reader = new ExcelReader(Util.Application, RhSolutionsAddIn.Configuration); + _writer = new CurrentPriceWriter(Util.Application, RhSolutionsAddIn.Configuration); + _worksheet = Util.Workbook.Worksheets[1]; + } + + [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationCouplings.xlsx")] + public void CanCalculateSleeves() + { + var products = _reader.ReadProducts(new[] { _worksheet }); + var couplings = _calculator.Calculate(products.First().Item2); + _writer.WriteProducts(couplings); + + Assert.Equal(7, _worksheet.Range["E2"].Value); + Assert.Equal(1, _worksheet.Range["E3"].Value); + Assert.Equal(1, _worksheet.Range["E5"].Value); + Assert.Equal(1, _worksheet.Range["E7"].Value); + } + + public void Dispose() + { + _addIn.AutoClose(); + } +} diff --git a/RhSolutions.Tests/TestWorkbooks/TestSpecificationCouplings.xlsx b/RhSolutions.Tests/TestWorkbooks/TestSpecificationCouplings.xlsx new file mode 100644 index 0000000..0acdf22 Binary files /dev/null and b/RhSolutions.Tests/TestWorkbooks/TestSpecificationCouplings.xlsx differ -- cgit v1.2.3