public DataTable RunTransformation(string userName, int setId)
{
const string TRANSFORMED_DATA_FILE = "{0:yyyyMMdd_HHmm}_Transformed_Data_Set_{1:0000}.csv";
DataTable result = _DemiContext.LoadTransformedDataTable(setId, userName);
result.TableName = String.Format(TRANSFORMED_DATA_FILE, DateTime.Now, setId);
return(result);
}
private DataTable ProcessDestinationFile(string file, int setId)
{
DataTable result = _ExcelService.GetDataTableFromExcel(file, FileType.Destination);
_DemiContext.CreateTransformedDataTable(result, USER_NAME);
if (setId > 0)
{
_DemiContext.LoadTransformedDataTable(setId, USER_NAME);
}
return(result);
}