public BusinessExcelValidationRecord(string sheetName, string columnName, int row, BusinessExcelValidationResultType excelValidationErrorType)
{
ExcelSheet = sheetName;
ExcelColumn = columnName;
ExcelRow = row;
ExcelValidationResultType = excelValidationErrorType;
}
public BusinessExcelValidationRecord(string sheetName, string columnName, int row, Type dataType, BusinessExcelValidationResultType excelValidationErrorType)
{
ExcelSheet = sheetName;
ExcelColumn = columnName;
ExcelRow = row;
ExcelValidationResultType = excelValidationErrorType;
if (dataType == typeof(DateTime))
{
ExcelValidationDataType = BusinessExcelValidationDataType.Date;
}
else if (dataType == typeof(bool))
{
ExcelValidationDataType = BusinessExcelValidationDataType.Boolean;
}
else if (dataType == typeof(DateTimeOffset))
{
ExcelValidationDataType = BusinessExcelValidationDataType.DateTimeOffset;
}
else if ((dataType == typeof(decimal)) || (dataType == typeof(double)))
{
ExcelValidationDataType = BusinessExcelValidationDataType.Decimal;
}
else if ((dataType == typeof(short)) || (dataType == typeof(int)) || (dataType == typeof(long)))
{
ExcelValidationDataType = BusinessExcelValidationDataType.WholeNumber;
}
else if (dataType == typeof(TimeSpan))
{
ExcelValidationDataType = BusinessExcelValidationDataType.WholeNumber;
}
else if (dataType == typeof(Guid))
{
ExcelValidationDataType = BusinessExcelValidationDataType.Guid;
}
}
public BusinessExcelValidationRecord(string systemException)
{
Message = systemException;
ExcelValidationResultType = BusinessExcelValidationResultType.SystemException;
}
