public void ImportCategoriesList_EmptyExcel_ShouldReturnEmptyCategoriesList() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); data.CategoryTestsDataList.Clear(); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var categories = dataImport.ImportCategoriesList(); // Assert categories.Should().BeEmpty(); package.File.Delete(); }
public void ImportCategoriesList_ShouldReturnCategories() { // Arrange using var package = new ExcelPackage(); var data = new TestExcelData(); package.CreateTestsExcel(data); using var dataImport = new SpreadsheetDataImport(data.FileName); // Act var categories = dataImport.ImportCategoriesList(); // Assert categories.Should().HaveSameCount(data.CategoryTestsDataList); for (int i = 0; i < categories.Count; i++) { var category = categories[i]; var categoryData = data.CategoryTestsDataList[i]; category.Should().BeEquivalentTo(categoryData.CategoryName); } package.File.Delete(); }