private void SectionsReinstatePostVideoProcessGrid() { TeamProjectTime2Section model = new TeamProjectTime2Section(teamProjectTime2TDS); // Update rows foreach (GridViewRow row in grdSectionsReinstatePostVideo.Rows) { string sectionId = grdSectionsReinstatePostVideo.DataKeys[row.RowIndex].Values["SectionID"].ToString(); string flowOrderId = ((Label)row.FindControl("lblFlowOrderID")).Text; bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; bool completed = ((CheckBox)row.FindControl("cbxCompleted")).Checked; int percentageOpened = Convert.ToInt32(((Label)row.FindControl("lblPercentageOpened")).Text); int percentageBrushed = Convert.ToInt32(((Label)row.FindControl("lblPercentageBrushed")).Text); DateTime? postVideo = Convert.ToDateTime(((Label)row.FindControl("lblPostVideo")).Text); if (selected) { model.Update2(sectionId, completed, postVideo, selected, percentageOpened, percentageBrushed); } } model.Table.AcceptChanges(); teamProjectTimeSection = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTIONDataTable)model.Table; Session["teamProjectTimeSection"] = teamProjectTimeSection; Session["teamProjectTime2TDS"] = teamProjectTime2TDS; }
private void ManholesRehabPrepProcessGrid() { TeamProjectTime2Section modelSection = new TeamProjectTime2Section(teamProjectTime2TDS); TeamProjectTime2SectionMH model = new TeamProjectTime2SectionMH(teamProjectTime2TDS); // Update rows foreach (GridViewRow row in grdManholesRehabPrep.Rows) { int assetId = Convert.ToInt32(grdManholesRehabPrep.DataKeys[row.RowIndex].Values["AssetID"].ToString()); bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; if (selected) { DateTime prepDate = Convert.ToDateTime(((Label)row.FindControl("lblPrepDate")).Text); model.Update(assetId, prepDate, selected); } } model.Table.AcceptChanges(); teamProjectTimeSectionMH = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION_MHDataTable)model.Table; Session["teamProjectTimeSection"] = teamProjectTimeSection; Session["teamProjectTime2TDS"] = teamProjectTime2TDS; }
private void SectionsPrepAndMeasureProcessGrid() { TeamProjectTime2Section model = new TeamProjectTime2Section(teamProjectTime2TDS); // Update rows foreach (GridViewRow row in grdSections.Rows) { string sectionId = grdSections.DataKeys[row.RowIndex].Values["SectionID"].ToString(); string flowOrderId = ((Label)row.FindControl("lblFlowOrderID")).Text; bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; bool completed = ((CheckBox)row.FindControl("cbxCompleted")).Checked; DateTime? prepDate = Convert.ToDateTime(((Label)row.FindControl("lblPrepDate")).Text); if (selected) { if (completed) { if (prepDate != tkrdpDate_.SelectedDate.Value) { prepDate = tkrdpDate_.SelectedDate.Value; } } model.Update(sectionId, completed, prepDate, selected); } } model.Table.AcceptChanges(); teamProjectTimeSection = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTIONDataTable)model.Table; Session["teamProjectTimeSection"] = teamProjectTimeSection; Session["teamProjectTime2TDS"] = teamProjectTime2TDS; }
protected void ddlFunction_SelectedIndexChanged(object sender, EventArgs e) { pnlFullLengthInstall.Visible = false; pnlFullLengthPrepMeasure.Visible = false; pnlFullLengthReinstatePostVideo.Visible = false; pnlSectionsManholesRehabPrep.Visible = false; pnlSectionsManholesRehabSpray.Visible = false; if (ddlTypeOfWork.SelectedValue == "Full Length") { TeamProjectTime2Section model = new TeamProjectTime2Section(teamProjectTime2TDS); switch (ddlFunction.SelectedValue) { case "Install": pnlFullLengthInstall.Visible = true; model.LoadForFllInstall(Int32.Parse(ddlProject.SelectedValue), "Full Length Lining", tkrdpDate_.SelectedDate.Value); // Store tables teamProjectTimeSection = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTIONDataTable)model.Table; Session["teamProjectTimeSection"] = teamProjectTimeSection; Session["teamProjectTime2TDS"] = teamProjectTime2TDS; grdSectionsInstall.DataBind(); break; case "Prep & Measure": pnlFullLengthPrepMeasure.Visible = true; model.LoadForFllPrepAndMeasure(Int32.Parse(ddlProject.SelectedValue), "Full Length Lining", tkrdpDate_.SelectedDate.Value); // Store tables teamProjectTimeSection = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTIONDataTable)model.Table; Session["teamProjectTimeSection"] = teamProjectTimeSection; Session["teamProjectTime2TDS"] = teamProjectTime2TDS; grdSections.DataBind(); break; case "Reinstate & Post Video": pnlFullLengthReinstatePostVideo.Visible = true; model.LoadForFllReinstatePostVideo(Int32.Parse(ddlProject.SelectedValue), "Full Length Lining", tkrdpDate_.SelectedDate.Value); // Store tables teamProjectTimeSection = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTIONDataTable)model.Table; Session["teamProjectTimeSection"] = teamProjectTimeSection; Session["teamProjectTime2TDS"] = teamProjectTime2TDS; grdSectionsReinstatePostVideo.DataBind(); break; } } else { if (ddlTypeOfWork.SelectedValue == "MH Rehab") { TeamProjectTime2SectionMH model = new TeamProjectTime2SectionMH(teamProjectTime2TDS); model.LoadByProjectIdAndUpdateDate(Convert.ToInt32(ddlProject.SelectedValue), tkrdpDate_.SelectedDate.Value, Convert.ToInt32(hdfCompanyId.Value)); // Store tables teamProjectTimeSectionMH = (TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION_MHDataTable)model.Table; Session["teamProjectTimeSectionMH"] = teamProjectTimeSectionMH; Session["teamProjectTime2TDS"] = teamProjectTime2TDS; Session.Remove("teamProjectTimeSectionMHDummy"); switch (ddlFunction.SelectedValue) { case "Prep": pnlSectionsManholesRehabPrep.Visible = true; grdManholesRehabPrep.DataBind(); break; case "Spray": pnlSectionsManholesRehabSpray.Visible = true; grdManholesRehabSpray.DataBind(); break; } } } upnlFullLengthInstall.Update(); upnlFullLengthPrepMeasure.Update(); upnlFullLengthReinstatePostVideo.Update(); upnlManholesRehabPrep.Update(); upnlManholesRehabSpray.Update(); }