public void ImportStoragePlacesList_Null_ShouldReturnStoragePlacesListWithoutOneElement() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); var emptyStorageElement = data.CatalogTestsDataList[0]; emptyStorageElement.StoragePlace = null; data.CatalogTestsDataList.Add(emptyStorageElement); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var storagePlaces = dataImport.ImportStoragePlacesList(); // Assert storagePlaces.Should().HaveCount(data.StoragePlaceTestsDataList.Count + data.CatalogTestsDataList.Count - 2); var catalogData = data.CatalogTestsDataList; var storagePlaceData = data.StoragePlaceTestsDataList; foreach (var storagePlace in storagePlaces) { storagePlace.Id.Should().NotBeEmpty(); } storagePlaces.Should().OnlyContain(a => catalogData.Any(b => b.StoragePlace == a.StoragePlaceName) || storagePlaceData.Any(b => b.StoragePlaceName == a.StoragePlaceName)); package.File.Delete(); }
public void ImportStoragePlacesList_EmptyStoragePlaceExcel_ShouldReturnStoragePlacesListFromCatalogExcel() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); data.StoragePlaceTestsDataList.Clear(); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var storagePlaces = dataImport.ImportStoragePlacesList(); // Assert storagePlaces.Should().HaveCount(data.CatalogTestsDataList.Count); for (int i = 0; i < storagePlaces.Count; i++) { var storagePlace = storagePlaces[i]; var storagePlaceData = data.CatalogTestsDataList[i]; storagePlace.Id.Should().NotBeEmpty(); storagePlace.StoragePlaceName.Should().Be(storagePlaceData.StoragePlace); storagePlace.Comment.Should().BeNull(); } package.File.Delete(); }
public void ImportStoragePlacesList_BothEmptyExcel_ShouldReturnEmptyStoragePlacesList() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); data.CatalogTestsDataList.Clear(); data.StoragePlaceTestsDataList.Clear(); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var storagePlaces = dataImport.ImportStoragePlacesList(); // Assert storagePlaces.Should().BeEmpty(); package.File.Delete(); }
public void ImportStoragePlacesList_Duplicates_ShouldReturnStoragePlacesListWithoutDuplicates() { // 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 storagePlaces = dataImport.ImportStoragePlacesList(); // Assert storagePlaces.Should().HaveCount(data.CatalogTestsDataList.Count + data.StoragePlaceTestsDataList.Count - 1); storagePlaces.Should().OnlyHaveUniqueItems(); package.File.Delete(); }
public void ImportStoragePlacesList_DuplicatesWithEmptyDescription_ShouldReturnStoragePlacesListWithoutDuplicatesWithElementWithDescription() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); var catalogDataToDouble = data.CatalogTestsDataList[0]; var doubleData = new CatalogExcelTestData() { Title = catalogDataToDouble.Title, AuthorFirstName = catalogDataToDouble.AuthorFirstName, AuthorLastName = catalogDataToDouble.AuthorLastName, Series = catalogDataToDouble.Series, SeriesName = catalogDataToDouble.SeriesName, VolumeNumber = catalogDataToDouble.VolumeNumber, PublishingHouse = catalogDataToDouble.PublishingHouse, Town = catalogDataToDouble.Town, StoragePlace = data.StoragePlaceTestsDataList[0].StoragePlaceName, Year = catalogDataToDouble.Year, ISBN = catalogDataToDouble.ISBN, Language = catalogDataToDouble.Language, Comment = catalogDataToDouble.Comment }; data.CatalogTestsDataList.Add(doubleData); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var storagePlaces = dataImport.ImportStoragePlacesList(); // Assert storagePlaces.Should().HaveCount(data.CatalogTestsDataList.Count + data.StoragePlaceTestsDataList.Count - 1); storagePlaces.Should().OnlyHaveUniqueItems(); storagePlaces.Should().Contain(a => a.Comment == data.StoragePlaceTestsDataList[0].Description); package.File.Delete(); }