public ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable GetProjectAddSectionsNew() { projectAddSectionsNew = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable)Session["projectAddSectionsNewDummy"]; if (projectAddSectionsNew == null) { projectAddSectionsNew = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable)Session["projectAddSectionsNew"]; } return projectAddSectionsNew; }
protected void grdProjectAddSectionsNew_RowUpdating(object sender, GridViewUpdateEventArgs e) { // Update section Page.Validate("AddSectionsUpdate"); if (Page.IsValid) { int id = (int)e.Keys["ID"]; int companyId = Int32.Parse(hdfCompanyId.Value); string sectionId = ((Label)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[0].FindControl("lblSectionIdEdit")).Text; string street = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxStreetEdit")).Text; string usmh = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhEdit")).Text; string dsmh = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhEdit")).Text; string mapSize = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxMapSizeEdit")).Text; string mapLength = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxMapLengthEdit")).Text; string clientId = ""; if (((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxClientIdEdit")).Text.Trim() != "") { clientId = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxClientIdEdit")).Text; } string sectionMaterial = ""; if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("ddlSectionMaterialEdit")).SelectedValue != "-1") { sectionMaterial = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("ddlSectionMaterialEdit")).SelectedValue; } bool cbxRA = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxRehabAssessmentWorkEdit")).Checked; bool cbxFLL = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxFullLengthLiningWorkEdit")).Checked; bool cbxPR = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxPointRepairsWorkEdit")).Checked; bool cbxJL = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxJunctionLiningWorkEdit")).Checked; bool cbxMHRehabUsmh = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxMHRehabUsmhEdit")).Checked; bool cbxMHRehabDsmh = ((CheckBox)grdProjectAddSectionsNew.Rows[e.RowIndex].FindControl("cbxMHRehabDsmhEdit")).Checked; string usmhStreet = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhStreetEdit")).Text.Trim(); string usmhLatitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhLatitudeEdit")).Text.Trim(); string usmhLongitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxUsmhLongitudeEdit")).Text.Trim(); string usmhShape = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhShapeEdit")).SelectedValue; string usmhLocation = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhLocationEdit")).SelectedValue; int? usmhConditionRating = null; if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhConditionRatingEdit")).SelectedValue != "-1") { usmhConditionRating = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhConditionRatingEdit")).SelectedValue); } int? usmhMaterialId = null; string usmhMaterial = ""; if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhMaterialEdit")).SelectedValue != "-1") { usmhMaterialId = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlUsmhMaterialEdit")).SelectedValue); AssetSewerMHMaterialTypeGateway assetSewerMHMaterialTypeGatewayForUsmh = new AssetSewerMHMaterialTypeGateway(); assetSewerMHMaterialTypeGatewayForUsmh.LoadByMaterialId((int)usmhMaterialId, companyId); usmhMaterial = assetSewerMHMaterialTypeGatewayForUsmh.GetMaterialType((int)usmhMaterialId); } string dsmhStreet = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhStreetEdit")).Text.Trim(); string dsmhLatitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhLatitudeEdit")).Text.Trim(); string dsmhLongitude = ((TextBox)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("tbxDsmhLongitudeEdit")).Text.Trim(); string dsmhShape = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhShapeEdit")).SelectedValue; string dsmhLocation = ((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhLocationEdit")).SelectedValue; int? dsmhConditionRating = null; if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhConditionRatingEdit")).SelectedValue != "-1") { dsmhConditionRating = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhConditionRatingEdit")).SelectedValue); } int? dsmhMaterialId = null; string dsmhMaterial = ""; if (((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhMaterialEdit")).SelectedValue != "-1") { dsmhMaterialId = Int32.Parse(((DropDownList)grdProjectAddSectionsNew.Rows[e.RowIndex].Cells[1].FindControl("ddlDsmhMaterialEdit")).SelectedValue); AssetSewerMHMaterialTypeGateway assetSewerMHMaterialTypeGatewayForDsmh = new AssetSewerMHMaterialTypeGateway(); assetSewerMHMaterialTypeGatewayForDsmh.LoadByMaterialId((int)dsmhMaterialId, companyId); dsmhMaterial = assetSewerMHMaterialTypeGatewayForDsmh.GetMaterialType((int)dsmhMaterialId); } // ... get structure data string usmhTopDiameter = ""; string usmhTopDepth = ""; string usmhDownDiameter = ""; string usmhDownDepth = ""; int? usmhManholeRugs = null; string usmhRectangle1LongSide = ""; string usmhRectangle1ShortSide = ""; string usmhRectangle2LongSide = ""; string usmhRectangle2ShortSide = ""; string usmhTotalSurfaceArea = ""; string dsmhTopDiameter = ""; string dsmhTopDepth = ""; string dsmhDownDiameter = ""; string dsmhDownDepth = ""; int? dsmhManholeRugs = null; string dsmhRectangle1LongSide = ""; string dsmhRectangle1ShortSide = ""; string dsmhRectangle2LongSide = ""; string dsmhRectangle2ShortSide = ""; string dsmhTotalSurfaceArea = ""; // Update datasets ProjectAddSectionsTDS dataSet = new ProjectAddSectionsTDS(); dataSet.ProjectAddSectionsNew.Merge(projectAddSectionsNew, true); ProjectAddSectionsNew model = new ProjectAddSectionsNew(dataSet); // Update model.Update(id, sectionId, street, usmh, dsmh, cbxJL, cbxRA, cbxFLL, cbxPR, false, sectionId, mapSize, mapLength, usmhStreet, usmhLatitude, usmhLongitude, usmhShape, usmhLocation, usmhConditionRating, usmhMaterialId, usmhMaterial, usmhTopDiameter, usmhTopDepth, usmhDownDiameter, usmhDownDepth, usmhManholeRugs, usmhRectangle1LongSide, usmhRectangle1ShortSide, usmhRectangle2LongSide, usmhRectangle2ShortSide, usmhTotalSurfaceArea, dsmhStreet, dsmhLatitude, dsmhLongitude, dsmhShape, dsmhLocation, dsmhConditionRating, dsmhMaterialId, dsmhMaterial, dsmhTopDiameter, dsmhTopDepth, dsmhDownDiameter, dsmhDownDepth, dsmhManholeRugs, dsmhRectangle1LongSide, dsmhRectangle1ShortSide, dsmhRectangle2LongSide, dsmhRectangle2ShortSide, dsmhTotalSurfaceArea, sectionMaterial, clientId, cbxMHRehabUsmh, cbxMHRehabDsmh); Session["projectAddSectionsNew"] = dataSet.ProjectAddSectionsNew; projectAddSectionsNew = dataSet.ProjectAddSectionsNew; } else { e.Cancel = true; } }
protected void grdProjectAddSectionsNew_RowDataBound(object sender, GridViewRowEventArgs e) { // Edit controls if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { int companyId = Int32.Parse(hdfCompanyId.Value); int id = Int32.Parse(((Label)e.Row.FindControl("lblID")).Text); ProjectAddSectionsTDS dataSet = new ProjectAddSectionsTDS(); dataSet.ProjectAddSectionsNew.Merge(projectAddSectionsNew, true); ProjectAddSectionsNew model = new ProjectAddSectionsNew(dataSet); projectAddSectionsNew = dataSet.ProjectAddSectionsNew; ProjectAddSectionsNewGateway projectAddSectionsNewGatewayForGrid = new ProjectAddSectionsNewGateway(dataSet); if (projectAddSectionsNewGatewayForGrid.Table.Rows.Count > 0) { ((DropDownList)e.Row.FindControl("ddlSectionMaterialEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetSectionMaterial(id).ToString(); ((DropDownList)e.Row.FindControl("ddlUsmhShapeEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhShape(id); ((DropDownList)e.Row.FindControl("ddlUsmhLocationEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhLocation(id); ((DropDownList)e.Row.FindControl("ddlUsmhConditionRatingEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhConditionRating(id).ToString(); ((DropDownList)e.Row.FindControl("ddlUsmhMaterialEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetUsmhMaterialId(id).ToString(); ((DropDownList)e.Row.FindControl("ddlDsmhShapeEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhShape(id); ((DropDownList)e.Row.FindControl("ddlDsmhLocationEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhLocation(id); ((DropDownList)e.Row.FindControl("ddlDsmhConditionRatingEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhConditionRating(id).ToString(); ((DropDownList)e.Row.FindControl("ddlDsmhMaterialEdit")).SelectedValue = projectAddSectionsNewGatewayForGrid.GetDsmhMaterialId(id).ToString(); } } // Footer Item if (e.Row.RowType == DataControlRowType.Footer) { switch (hdfWorkType.Value) { case "All": ((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = true; break; case "Rehab Assessment": ((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false; break; case "Full Length Lining": ((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false; break; case "Point Repairs": ((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false; break; case "Junction Lining": ((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = false; break; case "Manhole Rehabilitation": ((CheckBox)e.Row.FindControl("cbxRehabAssessmentWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxFullLengthLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxPointRepairsWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxJunctionLiningWorkAdd")).Checked = false; ((CheckBox)e.Row.FindControl("cbxMHRehabUsmhAdd")).Checked = true; ((CheckBox)e.Row.FindControl("cbxMHRehabDsmhAdd")).Checked = true; break; } } }
protected void ProjectAddSectionsNewEmptyFix(GridView grdView) { if (grdView.Rows.Count == 0) { ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable dt = new ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable(); dt.AddProjectAddSectionsNewRow(-1, "", "", "", "", false, false, false, false, "", "", "", false, "", "", "", "","", -1, "", "","","", "", -1, "", "","","","","","","","","",-1, "","","","","",-1,"","","","","", -1, -1, "", "", false, false); Session["projectAddSectionsNewDummy"] = dt; grdView.DataBind(); } // normally executes at all postbacks if (grdView.Rows.Count == 1) { ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable dt = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable)Session["projectAddSectionsNewDummy"]; if (dt != null) { // hide row grdView.Rows[0].Visible = false; grdView.Rows[0].Controls.Clear(); } } }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Validate query string if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["client_id"] == null) || ((string)Request.QueryString["project_id"] == null) || ((string)Request.QueryString["work_type"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in project_add_sections.aspx"); } // Security check if ((string)Request.QueryString["work_type"] == "Rehab Assessment") { if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_ADD"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } if ((string)Request.QueryString["work_type"] == "Full Length Lining") { if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADD"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } if ((string)Request.QueryString["work_type"] == "Junction Lining") { if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_ADD"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } if ((string)Request.QueryString["work_type"] == "Point Repairs") { if (!(Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_ADD"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } if ((string)Request.QueryString["work_type"] == "Manhole Rehabilitation") { if (!(Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_ADD"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } // Tag Page TagPage(); // Prepare initial data Session.Remove("projectAddSectionsNew"); Session.Remove("projectAddSectionsNewDummy"); Session.Remove("projectAddSectionsSearch"); Session.Remove("projectAddSectionsSearchDummy"); Session.Remove("projectAddSectionsTemp"); Session.Remove("projectAddSectionsTempDummy"); // Initialize viewstate variables ViewState["StepFrom"] = "Out"; // If coming from // ... ra_navigator.aspx, ra_navigator2.aspx, jl_navigator.aspx, jl_navigator2.aspx, project_sections_navigator.aspx, project_sections_navigator2.aspx, fl_navigator.aspx, fl_navigator2.aspx, ra_lining_plan.aspx, fl_edit.aspx, fl_summary.aspx, ra_edit.aspx, ra_summary.aspx, flat_section_jl_summary.aspx, flat_section_jl_edit.aspx, flat_section_jls_summary.aspx, flat_section_jls_edit.aspx, jl_lining_plan.aspx, pr_navigator.aspx, pr_navigator2.aspx, pr_summay.aspx, pr_edit.aspx, pr_lining_plan, mr_navigator.aspx, mr_navigator2.aspx, mr_edit.aspx, mr_summary.aspx if ((Request.QueryString["source_page"] == "ra_navigator.aspx") || (Request.QueryString["source_page"] == "ra_navigator2.aspx") || (Request.QueryString["source_page"] == "jl_navigator.aspx") || (Request.QueryString["source_page"] == "jl_navigator2.aspx") || (Request.QueryString["source_page"] == "project_sections_navigator.aspx") || (Request.QueryString["source_page"] == "project_sections_navigator2.aspx") || (Request.QueryString["source_page"] == "fl_navigator.aspx") || (Request.QueryString["source_page"] == "fl_navigator2.aspx") || (Request.QueryString["source_page"] == "ra_lining_plan.aspx") || (Request.QueryString["source_page"] == "fl_edit.aspx") || (Request.QueryString["source_page"] == "fl_summary.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx") || (Request.QueryString["source_page"] == "ra_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_edit.aspx") || (Request.QueryString["source_page"] == "flat_section_jls_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jls_edit.aspx") || (Request.QueryString["source_page"] == "jl_lining_plan.aspx") || (Request.QueryString["source_page"] == "pr_navigator.aspx") || (Request.QueryString["source_page"] == "pr_navigator2.aspx") || (Request.QueryString["source_page"] == "pr_summary.aspx") || (Request.QueryString["source_page"] == "pr_edit.aspx") || (Request.QueryString["source_page"] == "pr_lining_plan.aspx") || (Request.QueryString["source_page"] == "mr_navigator.aspx") || (Request.QueryString["source_page"] == "mr_navigator2.aspx") || (Request.QueryString["source_page"] == "mr_edit.aspx") || (Request.QueryString["source_page"] == "mr_summary.aspx")) { // ... Initialize tables projectAddSectionsNew = new ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable(); projectAddSectionsSearch = new ProjectAddSectionsTDS.ProjectAddSectionsSearchDataTable(); projectAddSectionsTemp = new ProjectAddSectionsTDS.ProjectAddSectionsTempDataTable(); // ... Store tables Session["projectAddSectionsNew"] = projectAddSectionsNew; Session["projectAddSectionsSearch"] = projectAddSectionsSearch; Session["projectAddSectionsTemp"] = projectAddSectionsTemp; } // StepSection1In wzSections.ActiveStepIndex = 0; StepBeginIn(); } else { // Restore tables projectAddSectionsNew = (ProjectAddSectionsTDS.ProjectAddSectionsNewDataTable) Session["projectAddSectionsNew"]; projectAddSectionsSearch = (ProjectAddSectionsTDS.ProjectAddSectionsSearchDataTable)Session["projectAddSectionsSearch"]; projectAddSectionsTemp = (ProjectAddSectionsTDS.ProjectAddSectionsTempDataTable)Session["projectAddSectionsTemp"]; } // control for postback hdfTag.Value = DateTime.Now.ToLongTimeString(); }