public void ImportPublishingHouseList_EmptyExcel_ShouldReturnEmptyPublishingHouseList()
{
// 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 publishingHouses = dataImport.ImportPublishingHousesList();
// Assert
publishingHouses.Should().BeEmpty();
package.File.Delete();
}
public void ImportPublishingHousesList_Duplicates_ShouldReturnPublishingHouseListWithoutDuplicates()
{
// 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 publishingHouses = dataImport.ImportPublishingHousesList();
// Assert
publishingHouses.Should().HaveCount(data.CatalogTestsDataList.Count - 1);
publishingHouses.Should().OnlyHaveUniqueItems();
package.File.Delete();
}
public void ImportPublishingHousesList_ShouldReturnPublishingHousesList()
{
// Arrange
using var package = new ExcelPackage();
var data = new TestExcelData();
package.CreateTestsExcel(data);
using var dataImport = new SpreadsheetDataImport(data.FileName);
// Act
var publishingHouses = dataImport.ImportPublishingHousesList();
// Assert
publishingHouses.Should().HaveSameCount(data.CatalogTestsDataList);
for (int i = 0; i < publishingHouses.Count; i++)
{
var publishingHouse = publishingHouses[i];
var catalogData = data.CatalogTestsDataList[i];
publishingHouse.Id.Should().NotBeEmpty();
publishingHouse.PublisherName.Should().Be(catalogData.PublishingHouse);
}
package.File.Delete();
}
