private DataTable ProcessSourceFile(string file)
{
DataTable result = _ExcelService.GetDataTableFromExcel(file, FileType.Source);
_DemiContext.CreateSourceDataTable(result, USER_NAME);
_DemiContext.LoadSourceDataTable(result, USER_NAME);
return(result);
}
private void SaveTableData(DataTable sourceTable, string userName, FileType fileType)
{
if (fileType == FileType.Source)
{
_DemiContext.CreateSourceDataTable(sourceTable, userName);
_DemiContext.LoadSourceDataTable(sourceTable, userName);
}
else
{
_DemiContext.CreateTransformedDataTable(sourceTable, userName);
}
}