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); } }
// //////////////////////////////////////////////////////////////////////// // STEP4 - LABOUR HOUR INFORMATION - METHODS // private void StepLabourHourInformationIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Please verify Labour Hour information"; // Load ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS); int projectId = Int32.Parse(hdfProjectId.Value); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); if (projectCostingSheetAddTDS.LabourHoursInformation.Rows.Count <= 0) { ArrayList works = new ArrayList(); if (cbxRehabAssessmentData.Checked) works.Add("Rehab Assessment"); if (cbxFullLengthLiningData.Checked) works.Add("Full Length"); if (cbxPointRepairData.Checked) { works.Add("Point Lining"); works.Add("Grouting"); } if (cbxJunctionLiningData.Checked) works.Add("Junction Lining"); if (cbxManholeRehabData.Checked) works.Add("MH Rehab"); if (cbxMobilizationData.Checked) works.Add("Mobilization"); if (cbxOtherData.Checked) { 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, tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value), ""); } 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, tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value), ""); } } // Store tables Session.Remove("labourHoursInformationDummy"); labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table; Session["labourHoursInformation"] = labourHoursInformation; Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS; grdTeamMembers.Columns[10].Visible = false; grdTeamMembers.Columns[11].Visible = false; grdTeamMembers.Columns[12].Visible = false; grdTeamMembers.Columns[13].Visible = false; grdTeamMembers.Columns[15].Visible = false; grdTeamMembers.Columns[16].Visible = false; grdTeamMembers.Columns[19].Visible = false; grdTeamMembers.Columns[20].Visible = false; // Validate grid columns if (projectGateway.GetCountryID(projectId) == 1) //Canada { // Team Members Grid grdTeamMembers.Columns[14].Visible = true; grdTeamMembers.Columns[17].Visible = true; grdTeamMembers.Columns[18].Visible = false; grdTeamMembers.Columns[21].Visible = false; // Totals lblTeamMembersTotalCost.Text = "Total Cost (CAD) : "; tbxTeamMembersTotalCostCAD.Visible = true; tbxTeamMembersTotalCostUSD.Visible = false; } else { if (projectGateway.GetCountryID(projectId) == 2) //USA { // Team Members Grid grdTeamMembers.Columns[14].Visible = false; grdTeamMembers.Columns[17].Visible = false; grdTeamMembers.Columns[18].Visible = true; grdTeamMembers.Columns[21].Visible = true; // Totals lblTeamMembersTotalCost.Text = "Total Cost (USD) : "; tbxTeamMembersTotalCostCAD.Visible = false; tbxTeamMembersTotalCostUSD.Visible = true; } } grdTeamMembers.DataBind(); StepLabourHoursInformationProcessGrid(); }
protected void grdTeamMembers_RowUpdating(object sender, GridViewUpdateEventArgs e) { int projectId = Int32.Parse(hdfProjectId.Value); ProjectGateway projectGateway = new ProjectGateway(); // Validate general data Page.Validate("labourHoursEdit"); if (Page.IsValid) { projectGateway.LoadByProjectId(projectId); // Validate costs if (projectGateway.GetCountryID(projectId) == 1) //Canada { Page.Validate("labourHoursCadEdit"); } else { Page.Validate("labourHoursUsdEdit"); } } if (Page.IsValid) { int costingSheetId = (int)e.Keys["CostingSheetID"]; string work_ = (string)e.Keys["Work_"]; int employeeId = (int)e.Keys["EmployeeID"]; int refId = (int)e.Keys["RefID"]; int companyId = Int32.Parse(hdfCompanyId.Value); string name = ((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxTeamMemberEdit")).Text; string unitOfMeasurementLH = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitOfMeasurementLHEdit")).SelectedValue; double lHQuantity = double.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxLHQtyEdit")).Text.Trim()); string unitOfMeasurementMeals = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitsOfMeasurementLHMealsEdit")).SelectedValue; int? mealsQuantity = null; if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsQtyEdit")).Text.Trim() != "") mealsQuantity = Int32.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsQtyEdit")).Text.Trim()); string unitOfMeasurementMotel = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlUnitsOfMeasurementLHMotelEdit")).SelectedValue; int? motelQuantity = null; if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelQtyEdit")).Text.Trim() != "") motelQuantity = Int32.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelQtyEdit")).Text.Trim()); decimal lhCostCad = 0.0M; decimal totalCostCad = 0.0M; decimal? mealsCostCad = null; decimal? motelCostCad = null; decimal lhCostUsd = 0.0M; decimal totalCostUsd = 0.0M; decimal? mealsCostUsd = null; decimal? motelCostUsd = null; if (projectGateway.GetCountryID(projectId) == 1) //Canada { lhCostCad = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxLHCostCADEdit")).Text.Trim()); if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostCADEdit")).Text.Trim() != "") mealsCostCad = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostCADEdit")).Text.Trim()); if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostCADEdit")).Text.Trim() != "") motelCostCad = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostCADEdit")).Text.Trim()); totalCostCad = (lhCostCad * decimal.Parse(lHQuantity.ToString())); if (mealsCostCad.HasValue && mealsQuantity.HasValue) totalCostCad = totalCostCad + (mealsCostCad.Value * decimal.Parse(mealsQuantity.Value.ToString())); if (motelCostCad.HasValue && motelQuantity.HasValue) totalCostCad = totalCostCad + (motelCostCad.Value * decimal.Parse(motelQuantity.Value.ToString())); totalCostCad = Decimal.Round(totalCostCad, 2); } else { lhCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxLHCostUSDEdit")).Text.Trim()); if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostUSDEdit")).Text.Trim() != "") mealsCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMealsCostUSDEdit")).Text.Trim()); if (((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostUSDEdit")).Text.Trim() != "") motelCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tbxMotelCostUSDEdit")).Text.Trim()); totalCostUsd = (lhCostUsd * decimal.Parse(lHQuantity.ToString())); if (mealsCostUsd.HasValue && mealsQuantity.HasValue) totalCostUsd = totalCostUsd + (mealsCostUsd.Value * decimal.Parse(mealsQuantity.Value.ToString())); if (motelCostUsd.HasValue && motelQuantity.HasValue) totalCostUsd = totalCostUsd + (motelCostUsd.Value * decimal.Parse(motelQuantity.Value.ToString())); totalCostUsd = Decimal.Round(totalCostUsd, 2); } DateTime startDate = ((RadDatePicker)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tkrdpStartDateEdit")).SelectedDate.Value; DateTime endDate = ((RadDatePicker)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("tkrdpEndDateEdit")).SelectedDate.Value; string workFunctionConcat = ""; string function_ = ""; workFunctionConcat = ((DropDownList)grdTeamMembers.Rows[e.RowIndex].Cells[0].FindControl("ddlWorkFunctionEdit")).SelectedValue; if (workFunctionConcat != "(Select)") { string[] workFunction = workFunctionConcat.ToString().Trim().Split('.'); function_ = workFunction[1].Trim(); } // Update data ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS); model.Update(costingSheetId, work_, employeeId, refId, lHQuantity, unitOfMeasurementLH, unitOfMeasurementMeals, mealsQuantity, unitOfMeasurementMotel, motelQuantity, lhCostCad, mealsCostCad, motelCostCad, totalCostCad, lhCostUsd, mealsCostUsd, motelCostUsd, totalCostUsd, false, companyId, name, startDate, endDate, workFunctionConcat, function_); // Store dataset labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table; Session["labourHoursInformation"] = labourHoursInformation; Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS; StepLabourHoursInformationProcessGrid(); } else { e.Cancel = true; } }
protected void grdTeamMembers_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Team member Gridview, if the gridview is edition mode if (grdTeamMembers.EditIndex >= 0) { grdTeamMembers.UpdateRow(grdTeamMembers.EditIndex, true); } // Add New Team Member int costingSheetId = (int)e.Keys["CostingSheetID"]; string work_ = (string)e.Keys["Work_"]; int employeeId = (int)e.Keys["EmployeeID"]; int refId = (int)e.Keys["RefID"]; ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS); // Delete Team Member Cost model.Delete(costingSheetId, work_, employeeId, refId); // Store dataset labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table; Session["labourHoursInformation"] = labourHoursInformation; Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS; StepLabourHoursInformationProcessGrid(); }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP4 - LABOUR HOUR INFORMATION // // //////////////////////////////////////////////////////////////////////// // STEP4 - LABOUR HOUR INFORMATION - EVENTS // protected void grdTeamMembers_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "Add": // Team member Gridview, if the gridview is edition mode if (grdTeamMembers.EditIndex >= 0) { grdTeamMembers.UpdateRow(grdTeamMembers.EditIndex, true); } // Add New Team Member int projectId = Int32.Parse(hdfProjectId.Value); ProjectGateway projectGateway = new ProjectGateway(); // Validate general data Page.Validate("labourHoursNew"); if (Page.IsValid) { projectGateway.LoadByProjectId(projectId); // Validate costs if (projectGateway.GetCountryID(projectId) == 1) //Canada { Page.Validate("labourHoursCadNew"); } else { Page.Validate("labourHoursUsdNew"); } } if (Page.IsValid) { int companyId = Int32.Parse(hdfCompanyId.Value); string typeOfWork = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlTypeOfWork_New")).SelectedValue; int employeeId = Int32.Parse(((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlTeamMemberNew")).SelectedValue); string name = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlTeamMemberNew")).SelectedItem.Text; string unitOfMeasurementLH = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlUnitOfMeasurementLHNew")).SelectedValue; double lHQuantity = double.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxLHQtyNew")).Text.Trim()); string unitOfMeasurementMeals = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlUnitsOfMeasurementLHMealsNew")).SelectedValue; int? mealsQuantity = null; if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsQtyNew")).Text.Trim() != "") mealsQuantity = Int32.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsQtyNew")).Text.Trim()); string unitOfMeasurementMotel = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlUnitsOfMeasurementLHMotelNew")).SelectedValue; int? motelQuantity = null; if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelQtyNew")).Text.Trim() != "") motelQuantity = Int32.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelQtyNew")).Text.Trim()); decimal lhCostCad = 0.0M; decimal totalCostCad = 0.0M; decimal? mealsCostCad = null; decimal? motelCostCad = null; decimal lhCostUsd = 0.0M; decimal totalCostUsd = 0.0M; decimal? mealsCostUsd = null; decimal? motelCostUsd = null; if (projectGateway.GetCountryID(projectId) == 1) //Canada { lhCostCad = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxLHCostCADNew")).Text.Trim()); if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostCADNew")).Text.Trim() != "") mealsCostCad = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostCADNew")).Text.Trim()); if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostCADNew")).Text.Trim() != "") motelCostCad = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostCADNew")).Text.Trim()); totalCostCad = (lhCostCad * decimal.Parse(lHQuantity.ToString())); if (mealsCostCad.HasValue && mealsQuantity.HasValue) totalCostCad = totalCostCad + (mealsCostCad.Value * decimal.Parse(mealsQuantity.Value.ToString())); if (motelCostCad.HasValue && motelQuantity.HasValue) totalCostCad = totalCostCad + (motelCostCad.Value * decimal.Parse(motelQuantity.Value.ToString())); totalCostCad = Decimal.Round(totalCostCad, 2); } else { lhCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxLHCostUSDNew")).Text.Trim()); if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostUSDNew")).Text.Trim() != "") mealsCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMealsCostUSDNew")).Text.Trim()); if (((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostUSDNew")).Text.Trim() != "") motelCostUsd = Decimal.Parse(((TextBox)grdTeamMembers.FooterRow.FindControl("tbxMotelCostUSDNew")).Text.Trim()); totalCostUsd = (lhCostUsd * decimal.Parse(lHQuantity.ToString())); if (mealsCostUsd.HasValue && mealsQuantity.HasValue) totalCostUsd = totalCostUsd + (mealsCostUsd.Value * decimal.Parse(mealsQuantity.Value.ToString())); if (motelCostUsd.HasValue && motelQuantity.HasValue) totalCostUsd = totalCostUsd + (motelCostUsd.Value * decimal.Parse(motelQuantity.Value.ToString())); totalCostUsd = Decimal.Round(totalCostUsd, 2); } DateTime startDate = ((RadDatePicker)grdTeamMembers.FooterRow.FindControl("tkrdpStartDateNew")).SelectedDate.Value; DateTime endDate = ((RadDatePicker)grdTeamMembers.FooterRow.FindControl("tkrdpEndDateNew")).SelectedDate.Value; string workFunctionConcat = ""; string function_ = ""; workFunctionConcat = ((DropDownList)grdTeamMembers.FooterRow.FindControl("ddlWorkFunctionNew")).SelectedValue; if (workFunctionConcat != "(Select)") { string[] workFunction = workFunctionConcat.ToString().Trim().Split('.'); function_ = workFunction[1].Trim(); } ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS); model.Insert(0, typeOfWork, employeeId, lHQuantity, unitOfMeasurementLH, unitOfMeasurementMeals, mealsQuantity, unitOfMeasurementMotel, motelQuantity, lhCostCad, mealsCostCad, motelCostCad, totalCostCad, lhCostUsd, mealsCostUsd, motelCostUsd, totalCostUsd, false, companyId, name, startDate, endDate, workFunctionConcat, function_); Session.Remove("labourHoursInformationDummy"); labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table; Session["labourHoursInformation"] = labourHoursInformation; Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS; grdTeamMembers.DataBind(); StepLabourHoursInformationProcessGrid(); } break; } }
// //////////////////////////////////////////////////////////////////////// // 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; }