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; } }