public override DbImportResult Import(bool canCreateProperties = false)
{
DbImportResult = new DbImportResult();
if (MetaData.ImportType != CommonUtils.ImportType.Cji3)
{
DbImportResult.ErrorMessages.Add(IMPORT_TYPE_NOT_COMPATIBLE);
return DbImportResult;
}
CanCreateProperties = false;
IList<Cji3DataAdapter> importData = new List<Cji3DataAdapter>();
string connString = BuildConnectionString(MetaData.FullFileName);
using (var excelConn = new OleDbConnection(connString))
{
try
{
using (var cmd = new OleDbCommand())
{
cmd.CommandTimeout = 600;
cmd.Connection = excelConn;
excelConn.Open();
DataTable dbSchema = excelConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
if (dbSchema == null || dbSchema.Rows.Count < 1)
{
throw new Exception("Error: Could not determine the name of the first worksheet.");
}
string firstSheetName = dbSchema.Rows[0]["TABLE_NAME"].ToString();
cmd.CommandText = string.Format(@"SELECT * FROM [{0}] where [Period] IS NOT NULL", firstSheetName);
if (!WorkSheetCheckColumnNamesAreValid<Cij3Column>(GetColumnHeadersFromDataSet(cmd,
(int)Enum.GetValues(typeof(Cij3Column)).Cast<Cij3Column>().Max())))
{
DbImportResult.ErrorMessages.Add(ExcelWorkSheetColumnsNotValidMessage());
return DbImportResult;
}
int rowNumber = 1;
using (OleDbDataReader dr = cmd.ExecuteReader())
{
while (dr != null && dr.Read())
{
rowNumber++;
try
{
var adapter = new Cji3DataAdapter(dr, rowNumber);
if (adapter.IsValid())
{
if (ContainsDuplicates(importData, adapter))
{
//string message = String.Format("Duplicate Po Number '{0}', Project Definition '{1} an Reference Item '{2}''. Will SKIPP this row.",
// adapter.PoNumber, adapter.ProjectDefinition, adapter.ReferenceItem);
DbImportResult.ErrorMessages.Add(string.Format("FinancialDataAdapter row {0} - {1}", rowNumber, ""));
}
else
{
importData.Add(adapter);
}
}
else
{
foreach (string message in adapter.ErrorMessages)
{
RaiseMessage(CommonUtils.MessageType.Error, message);
}
}
}
catch (Exception ex)
{
DbImportResult.ErrorMessages.Add(string.Format("FinancialDataAdapter row {0} - {1}", rowNumber, ex.Message));
}
}
excelConn.Close();
}
}
if (MetaData.ImportType == CommonUtils.ImportType.Cji3)
{
//First insert data into FinancialActual table
InsertFinancialActuals(importData);
//Then Insert/Update IssueFinancials
//InsertUpdateData(importData);
//Removed as per https://jira.issgroup.com.au/browse/BODCMS-1625
}
else
{
}
DbImportResult.ImportedCount = mInsertedResults.Count + mUpdatedResults.Count + mInsertedFinancialActualsCount;
return DbImportResult;
}
catch (Exception ex)
{
DbImportResult.ErrorMessages.Add(ex.ToString());
return DbImportResult;
}
finally
{
if (excelConn.State == ConnectionState.Open)
{
excelConn.Close();
}
}
}
}
private bool ContainsDuplicates(IList<Cji3DataAdapter> importData, Cji3DataAdapter adapter)
{
return false;// dont need to check for duplicates
//if (importData.Any(x => x.ProjectDefinition == adapter.ProjectDefinition))
//{
// return true;
//}
//return false;
}
