private void UpdateDatabase()
{
DB.Open();
DB.BeginTransaction();
try
{
int companyId = Int32.Parse(hdfCompanyId.Value);
int loginId = Convert.ToInt32(Session["loginID"]);
if (cbxEndConfirm.Checked)
{
ProjectCombinedCostingSheetAddBasicInformation projectCostingSheetAddBasicInformation = new ProjectCombinedCostingSheetAddBasicInformation(projectCostingSheetAddTDS);
int costingSheetId = projectCostingSheetAddBasicInformation.Save(companyId);
hdfCostingSheetId.Value = costingSheetId.ToString();
// Save costs information
ProjectCombinedCostingSheetAddLabourHoursInformation projectCostingSheetAddLabourHoursInformation = new ProjectCombinedCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS);
projectCostingSheetAddLabourHoursInformation.Save(companyId, costingSheetId);
ProjectCombinedCostingSheetAddUnitsInformation projectCostingSheetAddUnitsInformation = new ProjectCombinedCostingSheetAddUnitsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddUnitsInformation.Save(companyId, costingSheetId);
ProjectCombinedCostingSheetAddMaterialsInformation projectCostingSheetAddMaterialsInformation = new ProjectCombinedCostingSheetAddMaterialsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddMaterialsInformation.Save(companyId, costingSheetId);
ProjectCombinedCostingSheetAddSubcontractorsInformation projectCostingSheetAddSubcontractorsInformation = new ProjectCombinedCostingSheetAddSubcontractorsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddSubcontractorsInformation.Save(companyId, costingSheetId);
ProjectCombinedCostingSheetAddOtherCostsInformation projectCostingSheetAddOtherCostsInformation = new ProjectCombinedCostingSheetAddOtherCostsInformation(projectCostingSheetAddTDS);
projectCostingSheetAddOtherCostsInformation.Save(companyId, costingSheetId);
ProjectCombinedCostingSheetAddRevenueInformation projectCostingSheetAddRevenueInformation = new ProjectCombinedCostingSheetAddRevenueInformation(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);
}
}
private void PostPageChanges()
{
if (cbxEndConfirm.Checked)
{
string combinedProjects = "";
foreach (int projectId in projectsSelected)
{
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
combinedProjects = combinedProjects + ", " + projectGateway.GetName(projectId);
}
ProjectCombinedCostingSheetAddBasicInformation model = new ProjectCombinedCostingSheetAddBasicInformation(projectCostingSheetAddTDS);
model.Insert(Int32.Parse(hdfClientId.Value), tbxName.Text, tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, decimal.Parse(tbxTeamMembersTotalCostCAD.Text), decimal.Parse(tbxTeamMembersTotalCostUSD.Text), decimal.Parse(tbxMaterialsTotalCostsCAD.Text), decimal.Parse(tbxMaterialsTotalCostsUSD.Text), decimal.Parse(tbxUnitsTotalCostsCAD.Text), decimal.Parse(tbxUnitsTotalCostsUSD.Text), decimal.Parse(tbxOtherCostsTotalCostsCAD.Text), decimal.Parse(tbxOtherCostsTotalCostsUSD.Text), 0, 0, "In Progress", false, Int32.Parse(hdfCompanyId.Value), decimal.Parse(tbxSubcontractorsTotalCostsCAD.Text), decimal.Parse(tbxSubcontractorsTotalCostsUSD.Text), decimal.Parse(tbxRevenueTotal.Text), decimal.Parse(tbxGrandProfit.Text), decimal.Parse(tbxGrandGrossMargin.Text), combinedProjects);
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
}
}
