private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int loginId = Convert.ToInt32(Session["loginID"]);
if (cbxEndConfirm.Checked)
{
ProjectCostingSheetAddBasicInformation projectCostingSheetAddBasicInformation = new ProjectCostingSheetAddBasicInformation(projectCostingSheetAddTDS);
int costingSheetId = projectCostingSheetAddBasicInformation.Save(companyId);
hdfCostingSheetId.Value = costingSheetId.ToString();
// Save costs information
ProjectCostingSheetAddLabourHoursInformation projectCostingSheetAddLabourHoursInformation = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS);
projectCostingSheetAddLabourHoursInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddUnitsInformation projectCostingSheetAddUnitsInformation = new ProjectCostingSheetAddUnitsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddUnitsInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddMaterialsInformation projectCostingSheetAddMaterialsInformation = new ProjectCostingSheetAddMaterialsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddMaterialsInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddSubcontractorsInformation projectCostingSheetAddSubcontractorsInformation = new ProjectCostingSheetAddSubcontractorsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddSubcontractorsInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddOtherCostsInformation projectCostingSheetAddOtherCostsInformation = new ProjectCostingSheetAddOtherCostsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddOtherCostsInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddHotelsInformation projectCostingSheetAddHotelsInformation = new ProjectCostingSheetAddHotelsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddHotelsInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddBondingsInformation projectCostingSheetAddBondingsInformation = new ProjectCostingSheetAddBondingsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddBondingsInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddInsurancesInformation projectCostingSheetAddInsurancesInformation = new ProjectCostingSheetAddInsurancesInformation(projectCostingSheetAddTDS);
projectCostingSheetAddInsurancesInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddOtherCategoryInformation projectCostingSheetAddOtherCategoryInformation = new ProjectCostingSheetAddOtherCategoryInformation(projectCostingSheetAddTDS);
projectCostingSheetAddOtherCategoryInformation.Save(companyId, costingSheetId);
ProjectCostingSheetAddRevenueInformation projectCostingSheetAddRevenueInformation = new ProjectCostingSheetAddRevenueInformation(projectCostingSheetAddTDS);
projectCostingSheetAddRevenueInformation.Save(companyId, costingSheetId);
if (rbtnBeginTemplate.Checked)
{
ProjectCostingSheetTemplateInformation projectCostingSheetTemplateInformation = new ProjectCostingSheetTemplateInformation(projectCostingSheetAddTDS);
projectCostingSheetTemplateInformation.Save(companyId);
}
}
else
{
if (cbxEndSave.Checked)
{
ProjectCostingSheetTemplateInformation projectCostingSheetTemplateInformation = new ProjectCostingSheetTemplateInformation(projectCostingSheetAddTDS);
projectCostingSheetTemplateInformation.Save(companyId);
}
else
{
if (rbtnBeginTemplate.Checked)
{
ProjectCostingSheetTemplateInformation projectCostingSheetTemplateInformation = new ProjectCostingSheetTemplateInformation(projectCostingSheetAddTDS);
projectCostingSheetTemplateInformation.Save(companyId);
}
}
}
DB.CommitTransaction();
// Store datasets
projectCostingSheetAddTDS.AcceptChanges();
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
}
catch (Exception ex)
{
DB.RollbackTransaction();
string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' '));
Response.Redirect(url);
}
}
