// ////////////////////////////////////////////////////////////////////////
// METHODS
//
private void Save()
{
// process sections
DataMigrationTDS dataSet = new DataMigrationTDS();
dataSet.JlDataMigration.Merge(dataMigration, true);
dataSet.DataMigrationProject.Merge(dataMigrationProject, true);
JlDataMigration model = new JlDataMigration(dataSet);
DataMigrationProject modelProject = new DataMigrationProject(dataSet);
int loginId = Convert.ToInt32(Session["loginID"]);
// save to database
DB.Open();
DB.BeginTransaction();
try
{
modelProject.Save(int.Parse(hdfCompanyId.Value), loginId);
model.Save(int.Parse(hdfCompanyId.Value), loginId);
DB.CommitTransaction();
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
// /////////////////////////////////////////////////////////////////////////////////////////////////////
//
// STEP1 - PROJECTS
//
// ////////////////////////////////////////////////////////////////////////
// STEP1 - PROJECTS - METHODS
//
private void StepProjectsIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please select a Microsoft Excel file of migration project";
//--- Initialize
DataMigrationTDS dataSet = new DataMigrationTDS();
dataSet.DataMigrationProject.Merge(dataMigrationProject, true);
DataMigrationProject model = new DataMigrationProject(dataSet);
model.Table.Rows.Clear();
dataMigrationProject = dataSet.DataMigrationProject;
Session["dataMigrationProject"] = dataSet.DataMigrationProject;
}
private bool ProcessBulkProjectsUpload(string fName, out string bulkUploadProjectsResultMessage)
{
bool bulkUploadProccessed = true;
bulkUploadProjectsResultMessage = "";
AppSettingsReader appSettingReader = new AppSettingsReader();
string excelConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;IMEX=1';Data Source=" + fName + ";";
OleDbConnection connection = new OleDbConnection(excelConnectionString);
OleDbCommand command = null;
OleDbDataReader dataReader = null;
try
{
try
{
//--- Process bulk upload
if (bulkUploadProccessed)
{
connection.Open();
command = new OleDbCommand("select * from [projects]", connection);
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
if (!IsEmptyRow(dataReader))
{
int companiesId = 0;
Int64 countryId = 0;
Int64? provinceId = null;
Int64? countyId = null;
Int64? cityId = null;
int officeId = 0;
int? projectLeadId = null;
int salesmanId = 0;
string project = "";
string dataCell = null;
string dataCellToUpper = null;
//--- ... fill section row
for (int i = 0; i < dataReader.FieldCount; i++)
{
dataCell = dataReader.GetValue(i).ToString().Trim();
dataCellToUpper = dataReader.GetValue(i).ToString().Trim().ToUpper();
switch (dataReader.GetName(i).Trim())
{
case "COMPANIES_ID":
companiesId = int.Parse(dataCell);
break;
case "Country":
if (dataCellToUpper != "NULL")
{
countryId = Int64.Parse(dataCell);
}
break;
case "Province":
if (dataCellToUpper != "NULL")
{
provinceId = Int64.Parse(dataCell);
}
break;
case "County":
if (dataCellToUpper != "NULL")
{
countyId = Int64.Parse(dataCell);
}
break;
case "City":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
cityId = Int64.Parse(dataCell);
}
break;
case "Office":
if (dataCellToUpper != "NULL")
{
officeId = int.Parse(dataCell);
}
break;
case "Project Lead (optional)":
if (dataCellToUpper != "NULL" && dataCellToUpper != "")
{
projectLeadId = int.Parse(dataCell);
}
break;
case "Salesman":
if (dataCellToUpper != "NULL")
{
salesmanId = int.Parse(dataCell);
}
break;
case "Project":
if (dataCellToUpper != "NULL")
{
project = dataCell;
}
else
{
bulkUploadProjectsResultMessage = "Invalid value in 'Project' column. Bulk upload ABORTED.";
bulkUploadProccessed = false;
}
break;
}
if (!bulkUploadProccessed)
{
break;
}
}
if (bulkUploadProccessed)
{
//--- Initialize
DataMigrationTDS dataSet = new DataMigrationTDS();
dataSet.DataMigrationProject.Merge(dataMigrationProject, true);
DataMigrationProject model = new DataMigrationProject(dataSet);
model.Insert(companiesId, countryId, provinceId, countyId, cityId, officeId, projectLeadId, salesmanId, project);
dataMigrationProject = dataSet.DataMigrationProject;
Session["dataMigrationProject"] = dataSet.DataMigrationProject;
}
}
}
dataReader.Close();
connection.Close();
}
}
catch (Exception ex)
{
bulkUploadProjectsResultMessage = "You did not define the 'projects' data range. Bulk upload ABORTED. Original message: " + ex.Message;
bulkUploadProccessed = false;
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
catch (Exception ex)
{
if (!dataReader.IsClosed)
{
dataReader.Close();
}
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
throw ex;
}
return (bulkUploadProccessed) ? true : false;
}
