private void PostPageChanges()
{
if (cbxEndConfirm.Checked)
{
ProjectCostingSheetAddBasicInformation model = new ProjectCostingSheetAddBasicInformation(projectCostingSheetAddTDS);
model.Insert(Int32.Parse(hdfProjectId.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), decimal.Parse(tbxHotelsTotalCostsCAD.Text), decimal.Parse(tbxBondingsTotalCostsCAD.Text), decimal.Parse(tbxInsurancesTotalCostsCAD.Text), decimal.Parse(tbxOtherCategoryTotalCostsCAD.Text), "");
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
}
}
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);
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
public int LoadAll(DateTime startDate, DateTime endDate, int companyId, string month)
{
int rows = 0;
PrintSummaryCostingSheetByMonthDummyInformationGateway printSummaryCostingSheetByMonthDummyInformationGateway = new PrintSummaryCostingSheetByMonthDummyInformationGateway(Data);
printSummaryCostingSheetByMonthDummyInformationGateway.LoadProjectsWithTimesheets(startDate, endDate);
// Load
ProjectCostingSheetAddLabourHoursInformationGateway projectCostingSheetAddLabourHoursInformationGateway = new ProjectCostingSheetAddLabourHoursInformationGateway(Data);
projectCostingSheetAddLabourHoursInformationGateway.ClearBeforeFill = false;
ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(Data);
foreach (ProjectCostingSheetAddTDS.DummyInformationRow projectListRow in (ProjectCostingSheetAddTDS.DummyInformationDataTable)printSummaryCostingSheetByMonthDummyInformationGateway.Table)
{
int projectId = projectListRow.ProjectID;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
ArrayList works = new ArrayList();
works.Add("Rehab Assessment");
works.Add("Full Length");
works.Add("Point Lining"); works.Add("Grouting");
works.Add("Junction Lining");
works.Add("MH Rehab");
works.Add("Mobilization");
works.Add("Other");
works.Add("Downtime");
works.Add("Office");
works.Add("Office / Shop");
works.Add("R & D");
works.Add("Special Projects");
works.Add("Subcontractor");
works.Add("Watermain Relining");
works.Add("SOTA");
if (!projectGateway.GetFairWageApplies(projectId))
{
model.Load(works, projectId, startDate, endDate, companyId, month);
}
else
{
ArrayList jobClassType = new ArrayList();
jobClassType.Add("Laborer Group 2");
jobClassType.Add("Laborer Group 6");
jobClassType.Add("Operator Group 1");
jobClassType.Add("Operator Group 2");
jobClassType.Add("Regular Rate");
model.LoadFairWageProject(works, jobClassType, projectId, startDate, endDate, companyId, month);
}
decimal totalCostLH = StepLabourHoursInformationProcessGrid();
ProjectCostingSheetAddBasicInformation projectCostingSheetAddBasicInformation = new ProjectCostingSheetAddBasicInformation(Data);
projectCostingSheetAddBasicInformation.Insert2(projectId, projectId, "", startDate, endDate, totalCostLH, totalCostLH, 0, 0, 0, 0, 0, 0, 0, 0, "", false, companyId, 0, 0, 0, 0, 0, 0, 0, 0, 0, month);
rows = rows + projectCostingSheetAddLabourHoursInformationGateway.Table.Rows.Count;
}
projectCostingSheetAddLabourHoursInformationGateway.ClearBeforeFill = true;
return rows;
}
