public void ImportSeriesList_EmptyExcel_ShouldReturnEmptySeriesList() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); data.CatalogTestsDataList.Clear(); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var seriesList = dataImport.ImportSeriesListInfo(); // Assert seriesList.Should().BeEmpty(); package.File.Delete(); }
public void ImportSeriesList_Duplicates_ShouldReturnSeriesListWithoutDuplicates() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); data.CatalogTestsDataList.Add(data.CatalogTestsDataList[0]); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var seriesList = dataImport.ImportSeriesListInfo(); // Assert seriesList.Should().HaveCount(data.CatalogTestsDataList.Count - 1); seriesList.Should().OnlyHaveUniqueItems(); package.File.Delete(); }
public void ImportSeriesList_ShouldReturnSeriesList() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var seriesList = dataImport.ImportSeriesListInfo(); // Assert seriesList.Should().HaveSameCount(data.CatalogTestsDataList); for (int i = 0; i < seriesList.Count; i++) { var series = seriesList[i]; var catalogData = data.CatalogTestsDataList[i]; series.Id.Should().NotBeEmpty(); series.SeriesName.Should().Be(catalogData.SeriesName); series.VolumeNumber.Should().Be(catalogData.VolumeNumber); } package.File.Delete(); }