private void PrepareConvertedTableForDatabaseUpdate(SchedulingDataSet.SchedulingImportsDataTable convertedTable)
{
foreach (SchedulingDataSet.SchedulingImportsRow row in convertedTable.Rows)
{
row.AdminClientID = _AdminClientId;
row.CustClientID = _CustClientId;
row.ImportDate = DateTime.Now;
}
}
private SchedulingDataSet.SchedulingImportsDataTable ConvertUploadedDataTable()
{
SchedulingDataSet.SchedulingImportsDataTable result = null;
foreach (DataSheet supportedDataSheet in _SupportedSheetCollection)
{
result = AttemptToConvertFormat(supportedDataSheet);
if (result != null && result.Rows.Count > 0)
{
return(result);
}
}
return(null);
}
private SchedulingDataSet.SchedulingImportsDataTable AttemptToConvertFormat(DataSheet supportedDataSheet)
{
SchedulingDataSet.SchedulingImportsDataTable result = new SchedulingDataSet.SchedulingImportsDataTable();
try
{
if (!supportedDataSheet.PopulateRowsFromData(result, _UploadedSheetTable))
{
return(null);
}
}
catch (Exception exception)
{
throw new Exception(exception.ToString());
}
return(result);
}
public bool Process(string fileName, int adminClientId, int schedulingId, int custClientId)
{
_FileName = fileName;
_SchedulingId = schedulingId;
_AdminClientId = adminClientId;
_CustClientId = custClientId;
_SupportedSheetCollection = SchedulingTemplateLoader.GetSchedulingDataSheetCollection(_SchedulingId);
LoadFileIntoDataTable();
SchedulingDataSet.SchedulingImportsDataTable convertedTable = ConvertUploadedDataTable();
if (convertedTable == null)
{
return(false);
}
PrepareConvertedTableForDatabaseUpdate(convertedTable);
UploadDatabaseRecords(convertedTable);
if (convertedTable.Rows.Count == 0)
{
return(false);
}
return(true);
}
