// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_DELETE"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // 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["asset_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in pr_delete.aspx"); } // Tag Page TagPage(); // Prepare initial data // ... for client int companyId = Int32.Parse(hdfCompanyId.Value); int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString()); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId); // ... for project int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); if (name.Length > 23) name = name.Substring(0, 20) + "..."; lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section"; // If coming from // ... pr_navigator2.aspx if (Request.QueryString["source_page"] == "pr_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; pointRepairsTDS = new PointRepairsTDS(); int workId = Int32.Parse(hdfWorkId.Value); int assetId = Int32.Parse(hdfAssetId.Value); PointRepairsSectionDetails pointRepairsSectionDetails = new PointRepairsSectionDetails(pointRepairsTDS); pointRepairsSectionDetails.LoadByWorkId(workId, companyId); PointRepairsWorkDetails pointRepairsWorkDetails = new PointRepairsWorkDetails(pointRepairsTDS); pointRepairsWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId); PointRepairsRepairDetails pointRepairsRepairDetails = new PointRepairsRepairDetails(pointRepairsTDS); pointRepairsRepairDetails.LoadAllByWorkId(workId, companyId); // Store dataset Session["pointRepairsTDS"] = pointRepairsTDS; } // ... pr_summary.aspx if (Request.QueryString["source_page"] == "pr_summary.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore dataset pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"]; } } else { // Restore datasets pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"]; } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_EDIT"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // 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["asset_id"] == null) || ((string)Request.QueryString["active_tab"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in pr_summary.aspx"); } // Tag Page TagPage(); // If coming from int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); int assetId = Int32.Parse(hdfAssetId.Value.Trim()); int workId = Int32.Parse(hdfWorkId.Value); Session.Remove("pointRepairsRepairsTempDummy"); Session.Remove("pointRepairsCommentsTempDummy"); // ... pr_navigator2.aspx if (Request.QueryString["source_page"] == "pr_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; // ... Set initial tab if ((string)Session["dialogOpenedPr"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; pointRepairsTDS = new PointRepairsTDS(); pointRepairsRepairsTemp = new PointRepairsTDS.RepairDetailsDataTable(); pointRepairsCommentsTemp = new PointRepairsTDS.CommentDetailsDataTable(); PointRepairsSectionDetails pointRepairsSectionDetails = new PointRepairsSectionDetails(pointRepairsTDS); pointRepairsSectionDetails.LoadByWorkId(workId, companyId); PointRepairsWorkDetails pointRepairsWorkDetails = new PointRepairsWorkDetails(pointRepairsTDS); pointRepairsWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId); PointRepairsRepairDetails pointRepairsRepairDetails = new PointRepairsRepairDetails(pointRepairsTDS); pointRepairsRepairDetails.LoadAllByWorkId(workId, companyId); PointRepairsCommentDetails pointRepairsCommentDetails = new PointRepairsCommentDetails(pointRepairsTDS); pointRepairsCommentDetails.LoadAllByWorkIdWorkType(workId, companyId, "Point Repairs"); } else { hdfActiveTab.Value = (string)Session["activeTabPr"]; // Restore datasets pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"]; pointRepairsRepairsTemp = (PointRepairsTDS.RepairDetailsDataTable)Session["pointRepairsRepairsTemp"]; pointRepairsCommentsTemp = (PointRepairsTDS.CommentDetailsDataTable)Session["pointRepairsCommentsTemp"]; } tcPrDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); Session["filterExpression"] = "Deleted = 0"; // Store dataset Session["pointRepairsTDS"] = pointRepairsTDS; Session["pointRepairsRepairsTemp"] = pointRepairsRepairsTemp; Session["pointRepairsCommentsTemp"] = pointRepairsCommentsTemp; } // ... pr_delete.aspx or pr_edit.aspx if ((Request.QueryString["source_page"] == "pr_delete.aspx") || (Request.QueryString["source_page"] == "pr_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore dataset pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"]; pointRepairsRepairsTemp = (PointRepairsTDS.RepairDetailsDataTable)Session["pointRepairsRepairsTemp"]; pointRepairsCommentsTemp = (PointRepairsTDS.CommentDetailsDataTable)Session["pointRepairsCommentsTemp"]; // ... Set initial tab if ((string)Session["dialogOpenedPr"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; } else { hdfActiveTab.Value = (string)Session["activeTabPr"]; } tcPrDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); ApplyFilter(); switch ((string)Session["filterExpression"]) { case "Deleted = 0": ddlFilter.SelectedIndex = 0; break; case "Type='Robotic Reaming' AND Deleted = 0": ddlFilter.SelectedIndex = 1; break; case "Type='Point Lining' AND Deleted = 0": ddlFilter.SelectedIndex = 2; break; case "Type='Grouting' AND Deleted = 0": ddlFilter.SelectedIndex = 3; break; default: ddlFilter.SelectedIndex = 0; break; } } // Prepare initial data // ... for client int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString()); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(currentClientId, companyId); lblTitleClientName.Text = "Client: " + companiesGateway.GetName(currentClientId); // ... for project ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(currentProjectId); string name = projectGateway.GetName(currentProjectId); if (name.Length > 23) name = name.Substring(0, 20) + "..."; lblTitleProjectName.Text = " > Project: " + name + " (" + projectGateway.GetProjectNumber(currentProjectId) + ") > Selected Section"; // ... Data for current point repairs work LoadPointRepairsData(currentProjectId, assetId, companyId); } else { // Restore datasets pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"]; pointRepairsRepairsTemp = (PointRepairsTDS.RepairDetailsDataTable)Session["pointRepairsRepairsTemp"]; pointRepairsCommentsTemp = (PointRepairsTDS.CommentDetailsDataTable)Session["pointRepairsCommentsTemp"]; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcPrDetails.ActiveTabIndex = activeTab; ApplyFilter(); } }
private void Save() { try { // Validate page // Add data if exist at grid's foot GrdSizeAdd(); string sizeSelected = GetSize_(); int workId = Int32.Parse(hdfWorkId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); string repairPointId = hdfRepairPointId.Value; if (sizeSelected != "") { PointRepairsRepairDetails model = new PointRepairsRepairDetails(pointRepairsTDS); model.UpdateSizePointLining(workId, repairPointId, sizeSelected); } // Update data UpdateDatabase(); Session["pointRepairsTDS"] = pointRepairsTDS; // If coming from // ... pr_edit.aspx if (Request.QueryString["source_page"] == "pr_edit.aspx") { ViewState["update"] = "yes"; Response.Write("<script language='javascript'> {window.close();}</script>"); } } catch { if (Request.QueryString["source_page"] == "pr_edit.aspx") { ViewState["update"] = "yes"; Response.Write("<script language='javascript'> {window.close();}</script>"); } } }
private void Delete() { Page.Validate(); if (Page.IsValid) { // Delete Point Repairs int workId = Int32.Parse(hdfWorkId.Value); PointRepairsSectionDetails pointRepairsSectionDetails = new PointRepairsSectionDetails(pointRepairsTDS); pointRepairsSectionDetails.Delete(workId); PointRepairsRepairDetails pointRepairsRepairDetails = new PointRepairsRepairDetails(pointRepairsTDS); pointRepairsRepairDetails.DeleteAll(); PointRepairsWorkDetails pointRepairsWorkDetails = new PointRepairsWorkDetails(pointRepairsTDS); pointRepairsWorkDetails.Delete(workId); // Update database UpdateDatabase(); // Store datasets Session["pointRepairsTDS"] = pointRepairsTDS; // Redirect string url = ""; url = "./pr_navigator2.aspx?source_page=pr_delete.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + GetNavigatorState() + "&update=yes"; Response.Redirect(url); } }
protected void grdRepairs_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("repairsDataEdit"); if (Page.IsValid) { PointRepairsRepairDetails model = new PointRepairsRepairDetails(pointRepairsTDS); int workId = (int)e.Keys["WorkID"]; string repairPointId = e.Keys["RepairPointID"].ToString(); string type = ((Label)grdRepairs.Rows[e.RowIndex].Cells[2].FindControl("lblRepairType")).Text.Trim(); switch (type) { case "Robotic Reaming": string rmReamDistance = ((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxRmReamDistanceEdit")).Text.Trim(); DateTime? rmReamDate = null; if (((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpRmReamDateEdit")).SelectedDate.HasValue) rmReamDate = ((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpRmReamDateEdit")).SelectedDate.Value; bool rmExtraRepair = ((CheckBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("cbxRmExtraRepairEdit")).Checked; bool rmCancelled = ((CheckBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("cbxRmCancelledEdit")).Checked; string rmApproval = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlRmApprovalEdit")).SelectedValue.ToString().Trim(); string rmComments = ((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxRmCommentsEdit")).Text.Trim(); string rmDefectQualifier = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlRmDefectQualifierEdit")).SelectedValue; string rmDefectDetails = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlRmDefectDetailsEdit")).SelectedValue; DateTime? rmReinstateDate = null; if (((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpRmReinstateDateEdit")).SelectedDate.HasValue) rmReinstateDate = ((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpRmReinstateDateEdit")).SelectedDate.Value; model.UpdateRoboticReaming(workId, repairPointId, rmReamDistance, rmReamDate, rmExtraRepair, rmCancelled, rmApproval, rmComments, rmDefectQualifier, rmDefectDetails, rmReinstateDate); break; case "Point Lining": string plLinerDistance = ((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxPlLinerDistanceEdit")).Text.Trim(); string plDirection = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlDirectionEdit")).SelectedValue.ToString().Trim(); int? plReinstates = null; if (((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxPlReinstatesEdit")).Text.Trim() != "") plReinstates = Int32.Parse(((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxPlReinstatesEdit")).Text.Trim()); string plLtmh = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlLtmhEdit")).SelectedValue; string plVtmh = ""; if (plLtmh != "") { int selectedIndex = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlLtmhEdit")).SelectedIndex; if (selectedIndex == 1) { plVtmh = hdfDSMH.Value; } else { plVtmh = hdfUSMH.Value; } } string plDistance = ((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxPlDistanceEdit")).Text.Trim(); string plSize_ = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlSize_Edit")).SelectedValue.ToString().Trim(); DateTime? plInstallDate = null; if (((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpPlInstallDateEdit")).SelectedDate.HasValue) plInstallDate = ((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpPlInstallDateEdit")).SelectedDate.Value; string plMhShot = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlMhShotEdit")).SelectedValue.ToString().Trim(); bool plExtraRepair = ((CheckBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("cbxPlExtraRepairEdit")).Checked; bool plCancelled = ((CheckBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("cbxPlCancelledEdit")).Checked; string plApproval = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlAprovalEdit")).SelectedValue.ToString().Trim(); string plComments = ((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxPlCommentsEdit")).Text.Trim(); string plDefectQualifier = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlDefectQualifierEdit")).SelectedValue; string plDefectDetails = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlDefectDetailsEdit")).SelectedValue; string plLength = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlPlLengthEdit")).SelectedValue.ToString().Trim(); DateTime? plReinstateDate = null; if (((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpPlReinstateDateEdit")).SelectedDate.HasValue) plReinstateDate = ((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpPlReinstateDateEdit")).SelectedDate.Value; model.UpdatePointLining(workId, repairPointId, plLinerDistance, plDirection, plReinstates, plLtmh, plVtmh, plDistance, plSize_, plInstallDate, plMhShot, plExtraRepair, plCancelled, plApproval, plComments, plDefectQualifier, plDefectDetails, plLength, plReinstateDate); break; case "Grouting": string gtGroutDistance = ((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxGtGroutDistanceEdit")).Text.Trim(); DateTime? gtInstallDate = null; DateTime? gtGroutDate = null; if (((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpGtGroutDateEdit")).SelectedDate.HasValue) gtGroutDate = ((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpGtGroutDateEdit")).SelectedDate.Value; bool gtExtraRepair = ((CheckBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("cbxGtExtraRepairEdit")).Checked; bool gtCancelled = ((CheckBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("cbxGtCancelledEdit")).Checked; string gtApproval = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlGtApprovalEdit")).SelectedValue.ToString().Trim(); string gtComments = ((TextBox)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tbxGtCommentsEdit")).Text.Trim(); string gtDefectQualifier = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlGtDefectQualifierEdit")).SelectedValue; string gtDefectDetails = ((DropDownList)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("ddlGtDefectDetailsEdit")).SelectedValue; DateTime? gtReinstateDate = null; if (((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpGtReinstateDateEdit")).SelectedDate.HasValue) gtReinstateDate = ((RadDatePicker)grdRepairs.Rows[e.RowIndex].Cells[3].FindControl("tkrdpGtReinstateDataEdit")).SelectedDate.Value; model.UpdateGrouting(workId, repairPointId, gtGroutDistance, gtInstallDate, gtGroutDate, gtExtraRepair, gtCancelled, gtApproval, gtComments, gtDefectQualifier, gtDefectDetails, gtReinstateDate); break; } // Store dataset Session["pointRepairsTDS"] = pointRepairsTDS; } else { e.Cancel = true; } }
protected void grdRepairs_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Repair Gridview, if the gridview is edition mode if (grdRepairs.EditIndex >= 0) { grdRepairs.UpdateRow(grdRepairs.EditIndex, true); } // Delete repairs int workId = (int)e.Keys["WorkID"]; string repairPointId = e.Keys["RepairPointID"].ToString(); PointRepairsRepairDetails model = new PointRepairsRepairDetails(pointRepairsTDS); // Delete repair model.Delete(workId, repairPointId); // Store dataset Session["pointRepairsTDS"] = pointRepairsTDS; }
private void UpdateDatabase() { // Get ids & location int projectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); ProjectGateway projectGateway = new ProjectGateway(); projectGateway.LoadByProjectId(projectId); Int64 countryId = projectGateway.GetCountryID(projectId); Int64? provinceId = null; if (projectGateway.GetProvinceID(projectId).HasValue) provinceId = (Int64)projectGateway.GetProvinceID(projectId); Int64? countyId = null; if (projectGateway.GetCountyID(projectId).HasValue) countyId = (Int64)projectGateway.GetCountyID(projectId); Int64? cityId = null; if (projectGateway.GetCityID(projectId).HasValue) cityId = (Int64)projectGateway.GetCityID(projectId); string workType = hdfWorkType.Value.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value); int workId = Int32.Parse(hdfWorkId.Value); int workIdFll = Int32.Parse(hdfWorkIdFll.Value); int sectionAssetId = Int32.Parse(hdfAssetId.Value); DB.Open(); DB.BeginTransaction(); try { // Save repair details PointRepairsRepairDetails pointRepairsRepairDetails = new PointRepairsRepairDetails(pointRepairsTDS); pointRepairsRepairDetails.Save(companyId); // Save comment details PointRepairsCommentDetails pointRepairsCommentDetails = new PointRepairsCommentDetails(pointRepairsTDS); pointRepairsCommentDetails.Save(companyId); // Save section details PointRepairsSectionDetails pointRepairsSectionDetails = new PointRepairsSectionDetails(pointRepairsTDS); pointRepairsSectionDetails.Save(countryId, provinceId, countyId, cityId, projectId, companyId); // Save work details PointRepairsWorkDetails pointRepairsWorkDetails = new PointRepairsWorkDetails(pointRepairsTDS); pointRepairsWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, sectionAssetId, companyId); DB.CommitTransaction(); // Store datasets pointRepairsTDS.AcceptChanges(); Session["pointRepairsTDS"] = pointRepairsTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void GrdRepairsAdd() { if (ValidateRepairsFooter()) { Page.Validate("repairsDataAdd"); if (Page.IsValid) { PointRepairsRepairDetails model = new PointRepairsRepairDetails(pointRepairsTDS); // static values int workId = Int32.Parse(hdfWorkId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); bool inDatabase = false; // Repair Type string repairType = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlRepairTypeNew")).SelectedValue; // Auto-generate value string repairPointId = GetRepairPointIdIncrement(repairType); switch (repairType) { case "Robotic Reaming": string rmReamDistance = ((TextBox)grdRepairs.FooterRow.FindControl("tbxRmReamDistanceNew")).Text.Trim(); DateTime? rmReamDate = null; if (((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpRmReamDateNew")).SelectedDate.HasValue) rmReamDate = ((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpRmReamDateNew")).SelectedDate.Value; bool rmExtraRepair = ((CheckBox)grdRepairs.FooterRow.FindControl("cbxRmExtraRepairNew")).Checked; bool rmCancelled = ((CheckBox)grdRepairs.FooterRow.FindControl("cbxRmCancelledNew")).Checked; string rmApproval = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlRmApprovalNew")).SelectedValue.ToString().Trim(); string rmComments = ((TextBox)grdRepairs.FooterRow.FindControl("tbxRmCommentsNew")).Text.Trim(); string rmDefectQualifier = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlRmDefectQualifierNew")).SelectedValue; string rmDefectDetails = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlRmDefectDetailsNew")).SelectedValue; DateTime? rmReinstateDate = null; if (((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpRmReinstateDateNew")).SelectedDate.HasValue) rmReinstateDate = ((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpRmReinstateDateNew")).SelectedDate.Value; model.Insert(workId, repairPointId, repairType, rmReamDistance, rmReamDate, "", null, null, "", "", "", "", null, "", "", null, rmApproval, rmExtraRepair, rmCancelled, rmComments, false, companyId, inDatabase, rmDefectQualifier, rmDefectDetails, "", rmReinstateDate); break; case "Point Lining": string plLinerDistance = ((TextBox)grdRepairs.FooterRow.FindControl("tbxPlLinerDistanceNew")).Text.Trim(); string plDirection = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlDirectionNew")).SelectedValue.ToString().Trim(); int? plReinstates = null; if (((TextBox)grdRepairs.FooterRow.FindControl("tbxPlReinstatesNew")).Text.Trim() != "") plReinstates = Int32.Parse(((TextBox)grdRepairs.FooterRow.FindControl("tbxPlReinstatesNew")).Text.Trim()); string plLtmh = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlLtmhNew")).SelectedValue; string plVtmh = ""; if (plLtmh != "") { int selectedIndex = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlLtmhNew")).SelectedIndex; if (selectedIndex == 1) { plVtmh = hdfDSMH.Value; } else { plVtmh = hdfUSMH.Value; } } string plDistance = ((TextBox)grdRepairs.FooterRow.FindControl("tbxPlDistanceNew")).Text.Trim(); string plSize_ = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlSize_New")).SelectedValue.ToString().Trim(); DateTime? plInstallDate = null; if (((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpPlInstallDateNew")).SelectedDate.HasValue) plInstallDate = ((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpPlInstallDateNew")).SelectedDate.Value; string plMhShot = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlMhShotNew")).SelectedValue.ToString().Trim(); bool plExtraRepair = ((CheckBox)grdRepairs.FooterRow.FindControl("cbxPlExtraRepairNew")).Checked; bool plCancelled = ((CheckBox)grdRepairs.FooterRow.FindControl("cbxPlCancelledNew")).Checked; string plApproval = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlAprovalNew")).SelectedValue.ToString().Trim(); string plComments = ((TextBox)grdRepairs.FooterRow.FindControl("tbxPlCommentsNew")).Text.Trim(); string plDefectQualifier = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlDefectQualifierNew")).SelectedValue; string plDefectDetails = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlDefectDetailsNew")).SelectedValue; string plLength = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlPlLengthNew")).SelectedValue; DateTime? plReinstateDate = null; if (((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpPlReinstateDateNew")).SelectedDate.HasValue) plReinstateDate = ((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpPlReinstateDateNew")).SelectedDate.Value; model.Insert(workId, repairPointId, repairType, "", null, plLinerDistance, plDirection, plReinstates, plLtmh, plVtmh, plDistance, plSize_, plInstallDate, plMhShot, "", null, plApproval, plExtraRepair, plCancelled, plComments, false, companyId, inDatabase, plDefectQualifier, plDefectDetails, plLength, plReinstateDate); break; case "Grouting": string gtGroutDistance = ((TextBox)grdRepairs.FooterRow.FindControl("tbxGtGroutDistanceNew")).Text.Trim(); DateTime? gtInstallDate = null; DateTime? gtGroutDate = null; if (((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpGtGroutDateNew")).SelectedDate.HasValue) gtGroutDate = ((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpGtGroutDateNew")).SelectedDate.Value; bool gtExtraRepair = ((CheckBox)grdRepairs.FooterRow.FindControl("cbxGtExtraRepairNew")).Checked; bool gtCancelled = ((CheckBox)grdRepairs.FooterRow.FindControl("cbxGtCancelledNew")).Checked; string gtApproval = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlGtApprovalNew")).SelectedValue.ToString().Trim(); string gtComments = ((TextBox)grdRepairs.FooterRow.FindControl("tbxGtCommentsNew")).Text.Trim(); string gtDefectQualifier = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlGtDefectQualifierNew")).SelectedValue; string gtDefectDetails = ((DropDownList)grdRepairs.FooterRow.FindControl("ddlGtDefectDetailsNew")).SelectedValue; DateTime? gtReinstateDate = null; if (((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpGtReinstateDateNew")).SelectedDate.HasValue) gtReinstateDate = ((RadDatePicker)grdRepairs.FooterRow.FindControl("tkrdpGtReinstateDateNew")).SelectedDate.Value; model.Insert(workId, repairPointId, repairType, "", null, "", "", null, "", "", "", "", gtInstallDate, "", gtGroutDistance, gtGroutDate, gtApproval, gtExtraRepair, gtCancelled, gtComments, false, companyId, inDatabase, gtDefectQualifier, gtDefectDetails, "", gtReinstateDate); break; } Session.Remove("pointRepairsRepairsTempDummy"); Session["pointRepairsTDS"] = pointRepairsTDS; switch (ddlFilter.SelectedValue) { case "(All)": SetFilter("Deleted = 0"); break; case "Robotic Reaming": SetFilter("Type='Robotic Reaming' AND Deleted = 0"); break; case "Point Lining": SetFilter("Type='Point Lining' AND Deleted = 0"); break; case "Grouting": SetFilter("Type='Grouting' AND Deleted = 0"); break; } grdRepairs.DataBind(); } } }
private string GetRepairPointIdIncrement(string type) { string repairPointIdIncrement = ""; switch (type) { case "Robotic Reaming": repairPointIdIncrement = "RM-"; break; case "Point Lining": repairPointIdIncrement = "PL-"; break; case "Grouting": repairPointIdIncrement = "GT-"; break; } // Generate increment PointRepairsRepairDetails pointRepairsRepairDetails = new PointRepairsRepairDetails(pointRepairsTDS); repairPointIdIncrement += Convert.ToChar(pointRepairsRepairDetails.GetMaxRepairPointId(type) + 1).ToString(); return repairPointIdIncrement; }