diff options
Diffstat (limited to 'RhSolutions.Tests/CanFillCouplings.cs')
-rw-r--r-- | RhSolutions.Tests/CanFillCouplings.cs | 61 |
1 files changed, 30 insertions, 31 deletions
diff --git a/RhSolutions.Tests/CanFillCouplings.cs b/RhSolutions.Tests/CanFillCouplings.cs index 5a57c32..2c6c0bb 100644 --- a/RhSolutions.Tests/CanFillCouplings.cs +++ b/RhSolutions.Tests/CanFillCouplings.cs @@ -5,38 +5,37 @@ 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; + private RhSolutionsAddIn _addIn; + private IFittingsCalculator _calculator; + private IReader _reader; + private IWriter _writer; + private Worksheet _worksheet; - public CanFillCouplings() - { - Environment.SetEnvironmentVariable("ISTESTING", "true"); - _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]; - } + public CanFillCouplings() + { + Environment.SetEnvironmentVariable("ISTESTING", "true"); + _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); + [ExcelFact(Workbook = @"..\..\..\TestWorkbooks\TestSpecificationCouplings.xlsx")] + public void CanCalculateSleeves() + { + var products = _reader.ReadProducts(new[] { _worksheet }); + var couplings = _calculator.Calculate(products.First().Item2); + _writer.WriteProducts(couplings); + for (int i = 2; i < 14; i++) + { + Assert.Equal(_worksheet.Range[$"F{i}"].Value, _worksheet.Range[$"E{i}"].Value); + } + } - 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(); - } + public void Dispose() + { + _addIn.AutoClose(); + } } |