public void FormatExcelSheetBasedOnErrors_WhenValidationErrorsExists_ShouldColorWorksheet()
{
// Arrange;
FieldDefinition anyFieldDefinition = new FieldDefinition();
HashSet <Tuple <int, int> > fieldsInvalidated = new HashSet <Tuple <int, int> >()
{
new Tuple <int, int>(1, 1),
new Tuple <int, int>(2, 20),
new Tuple <int, int>(3, 5),
new Tuple <int, int>(4, 9),
};
string anyString = string.Empty;
List <FieldValidationResult> fieldValidationResults =
fieldsInvalidated
.Select(t => new FieldValidationResult(CreateField(t.Item1, t.Item2, anyString, anyFieldDefinition),
FieldValidationResult.ReasonForFailure.ProviderIdMismatchWithServiceProvider))
.ToList();
DatasetUploadValidationResult datasetUploadValidationResult = new DatasetUploadValidationResult()
{
FieldValidationFailures = fieldValidationResults
};
// Act
File.Copy(@"TestItems/1718HNStudNumbers.xlsx", testXlsxLocation, true);
FileInfo testFile = new FileInfo(testXlsxLocation);
using (var excelPackage = new ExcelPackage(testFile))
{
ExcelFieldErrorFormatter excelFieldErrorFormatter = new ExcelFieldErrorFormatter(excelPackage);
excelFieldErrorFormatter.FormatExcelSheetBasedOnErrors(datasetUploadValidationResult);
}
//Assert
using (var excelPackage = new ExcelPackage(testFile))
{
CheckThatAllExpectedCellsAreColored(excelPackage, fieldsInvalidated);
}
}
public void FormatExcelSheetBasedOnErrors_WhenGivenEmptyValidation_ShouldNotDoAnything()
{
// Arrange;
DatasetUploadValidationResult datasetUploadValidationResult = new DatasetUploadValidationResult()
{
FieldValidationFailures = new List <FieldValidationResult>()
};
// Act
File.Copy(@"TestItems/1718HNStudNumbers.xlsx", testXlsxLocation, true);
FileInfo testFile = new FileInfo(testXlsxLocation);
using (var excelPackage = new ExcelPackage(testFile))
{
ExcelFieldErrorFormatter excelFieldErrorFormatter = new ExcelFieldErrorFormatter(excelPackage);
excelFieldErrorFormatter.FormatExcelSheetBasedOnErrors(datasetUploadValidationResult);
}
//Assert
using (var excelPackage = new ExcelPackage(testFile))
{
CheckThatAllExpectedCellsAreColored(excelPackage, new HashSet <Tuple <int, int> >());
}
}
