private void Delete() { Page.Validate(); if (Page.IsValid) { // Delete int workId = Int32.Parse(hdfWorkId.Value); RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS); rehabAssessmentSectionDetails.Delete(workId); RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.DeleteAll(workId); RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS); rehabAssessmentWorkDetails.Delete(workId); // Update databse UpdateDatabase(); // Store datasets Session["rehabAssessmentTDS"] = rehabAssessmentTDS; // Redirect string url = ""; url = "./ra_navigator2.aspx?source_page=ra_delete.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + GetNavigatorState() + "&update=yes"; Response.Redirect(url); } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_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)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_delete.aspx"); } // Tag Page TagPage(); // Prepare initial data // ... for client int currentClientId = Int32.Parse(hdfCurrentClientId.Value.ToString()); int companyId = Int32.Parse(hdfCompanyId.Value); 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 Sections"; // If coming from // ... ra_navigator2.aspx if (Request.QueryString["source_page"] == "ra_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; rehabAssessmentTDS = new RehabAssessmentTDS(); int workId = Int32.Parse(hdfWorkId.Value); RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS); rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId); RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS); rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId); RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.LoadAllByWorkId(workId, companyId); // Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; } // ... ra_summary.aspx if (Request.QueryString["source_page"] == "ra_summary.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore dataset rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; } } else { // Restore datasets rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; } }
protected void grdLaterals_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("AddLateralsUpdate"); if (Page.IsValid) { if (((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlLiveEdit")).Visible == true) { Page.Validate("AddLateralsUpdateSpecial"); } if (Page.IsValid) { int lateral = int.Parse(((Label)grdLaterals.Rows[e.RowIndex].Cells[1].FindControl("lblLateral")).Text.Trim()); string lateralId = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxLateralIdEdit")).Text.Trim(); string clientLateralId = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxClientLateralIdEdit")).Text.Trim(); string size = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxSizeEdit")).Text.Trim(); // Load material string material = ""; material = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlMaterialEdit")).SelectedValue.ToString().Trim(); // Load lateral state string live = ""; if (((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxJlLive")).Visible == true) { live = "Live"; } else { if (((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlLiveEdit")).Visible == true) { live = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlLiveEdit")).SelectedValue.Trim(); } } string videoDistance = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxVideoDistanceEdit")).Text.Trim(); string clockPosition = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxClockPositionEdit")).Text.Trim(); string distanceToCentre = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxDistanceToCentreEdit")).Text.Trim(); string timeOpened = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxTimeOpenedEdit")).Text.Trim(); // Reverse Setup calculation string reverseSetup = ""; if (videoDistance != "") { Distance videoLength = new Distance(tbxVideoLength.Text.Trim()); Distance videoDistanceD = new Distance(videoDistance); Distance reverseSetupD = videoLength - videoDistanceD; switch (videoDistanceD.DistanceType) { case 1: reverseSetup = reverseSetupD.ToStringInEng1(); break; case 2: reverseSetup = reverseSetupD.ToStringInEng2(); break; case 3: reverseSetup = reverseSetupD.ToStringInEng3(); break; case 4: reverseSetup = reverseSetupD.ToStringInMet1(); break; case 5: reverseSetup = reverseSetupD.ToStringInMil1(); break; } } DateTime? reinstate = null; if (((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpReinstateEdit")).SelectedDate.HasValue) { reinstate = ((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpReinstateEdit")).SelectedDate.Value; } string comments = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxCommentsEdit")).Text.Trim(); bool inProject = true; bool inFll = true; bool inJl = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("cbxJlEdit")).Checked; string connectionType = ""; connectionType = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlConnectionTypeEdit")).SelectedValue; string mn = ""; mn = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxMnEdit")).Text.Trim(); string clientInspectionNo = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxClientInspectionNoEdit")).Text.Trim(); DateTime? v1Inspection = null; if (((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpV1InspectionEdit")).SelectedDate.HasValue) { v1Inspection = ((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpV1InspectionEdit")).SelectedDate.Value; } bool requiredRoboticPrep = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxRequiresRoboticPrepEdit")).Checked; DateTime? requiredRoboticPrepDate = null; if (((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpRequiresRoboticPrepDateEdit")).SelectedDate.HasValue) { requiredRoboticPrepDate = ((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpRequiresRoboticPrepDateEdit")).SelectedDate.Value; } bool holdClientIssue = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxHoldClientIssueEdit")).Checked; bool holdLFSIssue = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxHoldLFSIssueEdit")).Checked; bool lineLateral = inJl; string flange = ((DropDownList)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ddlFlangeEdit")).SelectedValue; bool dyeTestReq = ((CheckBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("ckbxDyeTestReqEdit")).Checked; DateTime? dyeTestComplete = null; if (((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpDyeTestCompleteEdit")).SelectedDate.HasValue) { dyeTestComplete = ((RadDatePicker)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tkrdpDyeTestCompleteEdit")).SelectedDate.Value; } string contractYear = ((TextBox)grdLaterals.Rows[e.RowIndex].Cells[2].FindControl("tbxContractYearEdit")).Text.Trim(); // Update RehabAssessmentLateralDetails lateralModel = new RehabAssessmentLateralDetails(rehabAssessmentTDS); lateralModel.Update(lateral, lateralId, size, material, live, videoDistance, clockPosition, distanceToCentre, timeOpened, reverseSetup, reinstate, comments, inProject, clientLateralId, inFll, inJl, connectionType, mn, clientInspectionNo, v1Inspection, requiredRoboticPrep, requiredRoboticPrepDate, holdClientIssue, holdLFSIssue, lineLateral, flange, dyeTestReq, dyeTestComplete, contractYear); tbxLaterals.Text = lateralModel.GetTotalLaterals().ToString(); tbxLiveLaterals.Text = lateralModel.GetLiveLaterals().ToString(); // Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; // Update JL lateral issues FLLateralsSave(lateralId, requiredRoboticPrep, requiredRoboticPrepDate, holdClientIssue, holdLFSIssue, dyeTestReq, dyeTestComplete, contractYear); } else { e.Cancel = true; } } else { e.Cancel = true; } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); bool isFromTabClick = false; if (!IsPostBack) { if (!isFromTabClick) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_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 ra_edit.aspx"); } // Tag Page TagPage(); // Prepare initial data Session.Remove("raAddLateralsNewDummy"); Session.Remove("materialInformationTDS"); materialInformationTDS = new MaterialInformationTDS(); // 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.Trim()); int workIdFll = Int32.Parse(hdfWorkIdFll.Value.Trim()); string workType = hdfWorkType.Value; // ... ra_navigator2.aspx if (Request.QueryString["source_page"] == "ra_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; // ... Set initial tab if ((string)Session["dialogOpenedRa"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; rehabAssessmentTDS = new RehabAssessmentTDS(); RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS); rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId); RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS); rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId); RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId); } else { hdfActiveTab.Value = (string)Session["activeTabRa"]; // Restore dataset rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; } // Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; } // ... ra_summary.aspx or ra_edit.aspx if ((Request.QueryString["source_page"] == "ra_summary.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // ... Set initial tab if ((string)Session["dialogOpenedRa"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; } else { hdfActiveTab.Value = (string)Session["activeTabRa"]; } if (ViewState["update"].ToString().Trim() == "yes") { rehabAssessmentTDS = new RehabAssessmentTDS(); RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS); rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId); RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS); rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId); RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId); // Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; } // Restore dataset rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; } // Prepare initial data lblMissingData.Visible = false; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcRaDetails.ActiveTabIndex = activeTab; // ... 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 work LoadRehabAssessmentData(currentProjectId, assetId, companyId); // Databind Page.DataBind(); ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewMaterial")).SelectedIndex = 0; // For usmh, dsmh autocomplete string provinceId_ = "0"; if (hdfProvinceId.Value != "") provinceId_ = hdfProvinceId.Value; string countyId_ = "0"; if (hdfCountyId.Value != "") countyId_ = hdfCountyId.Value; string cityId_ = "0"; if (hdfCityId.Value != "") cityId_ = hdfCityId.Value; aceUsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value; aceDsmh.ContextKey = hdfCountryId.Value + "," + provinceId_ + "," + countyId_ + "," + cityId_ + "," + hdfCompanyId.Value; // Load Materials MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS); materialInformationGateway.LoadAllByAssetId(assetId, companyId); materialInformation = materialInformationTDS.MaterialInformation; Session["materialInformationTDS"] = materialInformationTDS; } } else { // Restore datasets rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; flatSectionJlTDSForRA = (FlatSectionJlTDS)Session["flatSectionJlTDSForRA"]; materialInformationTDS = (MaterialInformationTDS)Session["materialInformationTDS"]; materialInformation = materialInformationTDS.MaterialInformation; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcRaDetails.ActiveTabIndex = activeTab; } }
protected void cvMeasuredFromMH_ServerValidate(object source, ServerValidateEventArgs args) { int assetId = Int32.Parse(hdfAssetId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); int workId = Int32.Parse(hdfWorkIdFll.Value); int workIdFll = Int32.Parse(hdfWorkIdFll.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); RehabAssessmentLateralDetails raLateralDetails = new RehabAssessmentLateralDetails(); raLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId); if (raLateralDetails.Table.Rows.Count > 0) { args.IsValid = true; } else { if (ddlM1DataMeasuredFromMh.SelectedValue == "") { args.IsValid = false; } else { args.IsValid = true; } } }
protected void grdLaterals_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Laterals Gridview, if the gridview is edition mode if (grdLaterals.EditIndex >= 0) { grdLaterals.UpdateRow(grdLaterals.EditIndex, true); } // Delete laterals int lateral = int.Parse(((Label)grdLaterals.Rows[e.RowIndex].Cells[1].FindControl("lblLateral")).Text); RehabAssessmentLateralDetails model = new RehabAssessmentLateralDetails(rehabAssessmentTDS); // Delete lateral model.Delete(lateral); tbxLaterals.Text = model.GetTotalLaterals().ToString(); tbxLiveLaterals.Text = model.GetLiveLaterals().ToString(); // Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; }
protected void cvLateralId_ServerValidate(object source, ServerValidateEventArgs args) { RehabAssessmentLateralDetails model = new RehabAssessmentLateralDetails(rehabAssessmentTDS); // Initialize CustomValidator cvLateralId = (CustomValidator)source; args.IsValid = true; // Verify in this step if (model.ExistsByLateralId(args.Value)) { cvLateralId.Text = "Duplicated lateral. (you already have this lateral here)"; args.IsValid = false; } }
protected void cvLateralsMaxNumber_ServerValidate(object source, ServerValidateEventArgs args) { // Get Measured From Mh value int assetId = Int32.Parse(hdfAssetId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); int workId = Int32.Parse(hdfWorkId.Value); int workIdFll = Int32.Parse(hdfWorkIdFll.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); string measuredFromMh = ""; RehabAssessmentLateralDetails raLateralDetails = new RehabAssessmentLateralDetails(); raLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId); if (raLateralDetails.Table.Rows.Count > 0) { measuredFromMh = "USMH"; } else { measuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue; } // Generate increment RehabAssessmentLateralDetails rehabAssessmentLateraldetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); if (measuredFromMh == "USMH" || measuredFromMh == "") { if (rehabAssessmentLateraldetails.GetMaxLateralId2() == "A[") args.IsValid = false; else args.IsValid = true; } else { if (measuredFromMh == "DSMH") { if (rehabAssessmentLateraldetails.GetMinLateralId2() == "@") args.IsValid = false; else args.IsValid = true; } } }
private void GrdRaAddLateralsNewAdd() { if (ValidateLateralFooter()) { Page.Validate("AddLateralsAdd"); if (Page.IsValid) { string size = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewSize")).Text.Trim(); string material = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewMaterial")).SelectedValue.ToString().Trim(); string live = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewLive")).SelectedValue.Trim(); string videoDistance = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewVideoDistance")).Text.Trim(); string clockPosition = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewClockPosition")).Text.Trim(); string distanceToCentre = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewDistanceToCentre")).Text.Trim(); string timeOpened = ""; DateTime? reinstate = null; string comments = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewComments")).Text.Trim(); // Reverse Setup calculation string reverseSetup = ""; if (videoDistance != "") { Distance videoDistanceD = new Distance(videoDistance); Distance videoLength = new Distance(tbxVideoLength.Text.Trim()); Distance reverseSetupD = videoLength - videoDistanceD; switch (videoDistanceD.DistanceType) { case 1: reverseSetup = reverseSetupD.ToStringInEng1(); break; case 2: reverseSetup = reverseSetupD.ToStringInEng2(); break; case 3: reverseSetup = reverseSetupD.ToStringInEng3(); break; case 4: reverseSetup = reverseSetupD.ToStringInMet1(); break; case 5: reverseSetup = reverseSetupD.ToStringInMil1(); break; } } bool inProject = true; bool inFll = true; bool inJl = ((CheckBox)grdLaterals.FooterRow.FindControl("cbxNewJl")).Checked; int companyId = Int32.Parse(hdfCompanyId.Value); string lateralId = GetLateralIdIncrement(); string clientLateralId = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewClientLateralId")).Text.Trim(); string connectionType = ""; connectionType = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewConnectionType")).SelectedValue; string mn = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewMn")).Text.Trim(); string clientInspectionNo = ((TextBox)grdLaterals.FooterRow.FindControl("tbxNewClientInspectionNo")).Text.Trim(); DateTime? v1Inspection = null; if (((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpNewV1Inspection")).SelectedDate.HasValue) v1Inspection = ((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpNewV1Inspection")).SelectedDate.Value; bool requiresRoboticPrep = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxRequiresRoboticPrepNew")).Checked; DateTime? requiresRoboticPrepDate = null; if (((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpRequiresRoboticPrepDateNew")).SelectedDate.HasValue) { requiresRoboticPrepDate = ((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpRequiresRoboticPrepDateNew")).SelectedDate.Value; } bool holdClientIssue = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxHoldClientIssueNew")).Checked; bool holdLFSIssue = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxHoldLFSIssueNew")).Checked; bool lineLateral = inJl; string flange = ((DropDownList)grdLaterals.FooterRow.FindControl("ddlFlangeNew")).SelectedValue; bool dyeTestReq = ((CheckBox)grdLaterals.FooterRow.FindControl("ckbxDyeTestReqNew")).Checked; DateTime? dyeTestComplete = null; if (((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpDyeTestCompleteNew")).SelectedDate.HasValue) dyeTestComplete = ((RadDatePicker)grdLaterals.FooterRow.FindControl("tkrdpDyeTestCompleteNew")).SelectedDate.Value; string contractYear =((TextBox)grdLaterals.FooterRow.FindControl("tbxNewContractYear")).Text.Trim(); // Insert RehabAssessmentLateralDetails model = new RehabAssessmentLateralDetails(rehabAssessmentTDS); model.Insert(videoDistance, clockPosition, distanceToCentre, timeOpened, reverseSetup, reinstate, comments, lateralId, size, material, false, companyId, inProject, live, clientLateralId, inFll, inJl, connectionType, mn, clientInspectionNo, v1Inspection, requiresRoboticPrep, requiresRoboticPrepDate, holdClientIssue, holdLFSIssue, lineLateral, flange, dyeTestReq, dyeTestComplete, contractYear); // Store datasets Session.Remove("raAddLateralsNewDummy"); Session["rehabAssessmentTDS"] = rehabAssessmentTDS; grdLaterals.DataBind(); grdLaterals.PageIndex = grdLaterals.PageCount - 1; tbxLaterals.Text = model.GetTotalLaterals().ToString(); tbxLiveLaterals.Text = model.GetLiveLaterals().ToString(); } } }
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); bool isNewMeasuredFromDsmh = false; RehabAssessmentLateralDetails raLateralDetails = new RehabAssessmentLateralDetails(); raLateralDetails.LoadForEdit(workIdFll, sectionAssetId, companyId, projectId); if (raLateralDetails.Table.Rows.Count == 0) { if (ddlM1DataMeasuredFromMh.SelectedValue == "DSMH") { isNewMeasuredFromDsmh = true; RehabAssessmentLateralDetails raaLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); raaLateralDetails.ModifyLateralId(); } } DB.Open(); DB.BeginTransaction(); try { // Save lateral details bool roboticPrepCompleted = ckbxPrepDataRoboticPrepCompleted.Checked; DateTime? roboticPrepCompletedCompleted = null; if (tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.HasValue) roboticPrepCompletedCompleted = tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.Value; RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.Save(workIdFll, projectId, sectionAssetId, countryId, provinceId, countyId, cityId, tbxVideoLength.Text.Trim(), companyId, isNewMeasuredFromDsmh, roboticPrepCompleted, roboticPrepCompletedCompleted); // Save section details RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS); rehabAssessmentSectionDetails.Save(countryId, provinceId, countyId, cityId, projectId, companyId); // Save work details RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS); rehabAssessmentWorkDetails.Save(countryId, provinceId, countyId, cityId, projectId, companyId, sectionAssetId); // Save material details string newMaterial = ddlM1DataMaterial.SelectedValue; if (ddlM1DataMaterial.SelectedIndex > 0) { LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null); if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(sectionAssetId, newMaterial, companyId)) { MaterialInformation materialInformation = new MaterialInformation(materialInformationTDS); materialInformation.Save(companyId); } } DB.CommitTransaction(); // Store datasets rehabAssessmentTDS.AcceptChanges(); Session["rehabAssessmentTDS"] = rehabAssessmentTDS; materialInformationTDS.AcceptChanges(); Session["materialInformationTDS"] = materialInformationTDS; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private string GetLateralIdIncrement() { // Get Measured From Mh value int assetId = Int32.Parse(hdfAssetId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); int workId = Int32.Parse(hdfWorkId.Value); int workIdFll = Int32.Parse(hdfWorkIdFll.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); string measuredFromMh = ""; RehabAssessmentLateralDetails raLateralDetails = new RehabAssessmentLateralDetails(); raLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId); if (raLateralDetails.Table.Rows.Count > 0) { measuredFromMh = "USMH"; } else { measuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue; } // Generate increment string lateralIdIncrement = ""; RehabAssessmentLateralDetails rehabAssessmentLateraldetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); if (measuredFromMh == "USMH" || measuredFromMh == "") { lateralIdIncrement = rehabAssessmentLateraldetails.GetMaxLateralId2(); } else { if (measuredFromMh == "DSMH") { lateralIdIncrement =rehabAssessmentLateraldetails.GetMinLateralId2(); } } return "RA-"+lateralIdIncrement; }
private bool Apply() { // Validate data bool validData = true; validData = ValidatePage(); if (validData) { // Save Lateral data GrdRaAddLateralsNewAdd(); // Save data int companyId = Int32.Parse(hdfCompanyId.Value); int assetId = Int32.Parse(hdfAssetId.Value); int workId = Int32.Parse(hdfWorkId.Value); int workIdFll = Int32.Parse(hdfWorkIdFll.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); // Get Section Details // ... RehabAssessmentSectionDetails data string newStreet = ""; if (tbxStreet.Text != "") newStreet = tbxStreet.Text.Trim(); string newUsmh = ""; if (tbxUSMH.Text != "") newUsmh = tbxUSMH.Text.Trim(); string newDsmh = ""; if (tbxDSMH.Text != "") newDsmh = tbxDSMH.Text.Trim(); string newMapSize = ""; if (tbxMapSize.Text != "") newMapSize = tbxMapSize.Text.Trim(); string newSize = ""; if (tbxConfirmedSize.Text != "") newSize = tbxConfirmedSize.Text.Trim(); string newThickness = ""; if (ddlThickness.SelectedValue != "") newThickness = ddlThickness.SelectedValue; string newMapLength = ""; if (tbxMapLength.Text != "") newMapLength = tbxMapLength.Text.Trim(); string newSteelTapeThroughSewer = ""; string newLength = ""; if (tbxM1DataSteelTapeThroughSewer.Text != "") { newSteelTapeThroughSewer = tbxM1DataSteelTapeThroughSewer.Text.Trim(); newLength = tbxM1DataSteelTapeThroughSewer.Text.Trim(); } int? newLaterals = null; if (tbxLaterals.Text != "") newLaterals = Int32.Parse(tbxLaterals.Text.Trim()); int? newLiveLaterals = null; if (tbxLiveLaterals.Text != "") newLiveLaterals = Int32.Parse(tbxLiveLaterals.Text.Trim()); // Get m1 data // ... assetSewerSection data string newUsmhDepth = ""; if ((tbxM1DataUsmhDepth.Text != "") && (tbxUSMH.Text != "")) newUsmhDepth = tbxM1DataUsmhDepth.Text.Trim(); string newDsmhDepth = ""; if ((tbxM1DataDsmhDepth.Text != "") && (tbxDSMH.Text != "")) newDsmhDepth = tbxM1DataDsmhDepth.Text.Trim(); // ... lfsAssetSewerSection data string newUsmhMouth12 = ""; if ((tbxM1DataUsmhMouth12.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth12 = tbxM1DataUsmhMouth12.Text.Trim(); string newUsmhMouth1 = ""; if ((tbxM1DataUsmhMouth1.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth1 = tbxM1DataUsmhMouth1.Text.Trim(); string newUsmhMouth2 = ""; if ((tbxM1DataUsmhMouth2.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth2 = tbxM1DataUsmhMouth2.Text.Trim(); string newUsmhMouth3 = ""; if ((tbxM1DataUsmhMouth3.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth3 = tbxM1DataUsmhMouth3.Text.Trim(); string newUsmhMouth4 = ""; if ((tbxM1DataUsmhMouth4.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth4 = tbxM1DataUsmhMouth4.Text.Trim(); string newUsmhMouth5 = ""; if ((tbxM1DataUsmhMouth5.Text != "") && (tbxUSMH.Text != "")) newUsmhMouth5 = tbxM1DataUsmhMouth5.Text.Trim(); string newDsmhMouth12 = ""; if ((tbxM1DataDsmhMouth12.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth12 = tbxM1DataDsmhMouth12.Text.Trim(); string newDsmhMouth1 = ""; if ((tbxM1DataDsmhMouth1.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth1 = tbxM1DataDsmhMouth1.Text.Trim(); string newDsmhMouth2 = ""; if ((tbxM1DataDsmhMouth2.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth2 = tbxM1DataDsmhMouth2.Text.Trim(); string newDsmhMouth3 = ""; if ((tbxM1DataDsmhMouth3.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth3 = tbxM1DataDsmhMouth3.Text.Trim(); string newDsmhMouth4 = ""; if ((tbxM1DataDsmhMouth4.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth4 = tbxM1DataDsmhMouth4.Text.Trim(); string newDsmhMouth5 = ""; if ((tbxM1DataDsmhMouth5.Text != "") && (tbxDSMH.Text != "")) newDsmhMouth5 = tbxM1DataDsmhMouth5.Text.Trim(); string newGeneralSubArea = ""; if (tbxGeneralSubArea.Text != "") newGeneralSubArea = tbxGeneralSubArea.Text.Trim(); // ... assetSewerMH Data string newUsmhAddress = ""; if (tbxM1DataUsmhAddress.Text != "") newUsmhAddress = tbxM1DataUsmhAddress.Text.Trim(); string newDsmhAddress = ""; if (tbxM1DataDsmhAddress.Text != "") newDsmhAddress = tbxM1DataDsmhAddress.Text.Trim(); // Update section details RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS); rehabAssessmentSectionDetails.Update(workId, assetId, newStreet, newMapSize, newSize, newMapLength, newLength, newLaterals, newLiveLaterals, newUsmhDepth, newDsmhDepth, newSteelTapeThroughSewer, newUsmhMouth12, newUsmhMouth1, newUsmhMouth2, newUsmhMouth3, newUsmhMouth4, newUsmhMouth5, newDsmhMouth12, newDsmhMouth1, newDsmhMouth2, newDsmhMouth3, newDsmhMouth4, newDsmhMouth5, newUsmh, newDsmh, newUsmhAddress, newDsmhAddress, newGeneralSubArea, newThickness); // Get GeneralData // ... FullLengthLining Data string newGeneralClientId = ""; if (tbxGeneralClientId.Text != "") newGeneralClientId = tbxGeneralClientId.Text.Trim(); // ... Rehab Assessment Data DateTime? newPreFlushDate = null; if (tkrdpGeneralPreFlushDate.SelectedDate.HasValue) newPreFlushDate = tkrdpGeneralPreFlushDate.SelectedDate.Value; DateTime? newPreVideoDate = null; if (tkrdpGeneralPreVideoDate.SelectedDate.HasValue) newPreVideoDate = tkrdpGeneralPreVideoDate.SelectedDate.Value; // ... Prep Data int? newPrepDataCXIsRemoved = null; if (tbxPrepDataCXIsRemoved.Text != "") newPrepDataCXIsRemoved = Int32.Parse(tbxPrepDataCXIsRemoved.Text.Trim()); DateTime? newPrepDataP1Date = null; if (tkrdpPrepDataP1Date.SelectedDate.HasValue) newPrepDataP1Date = tkrdpPrepDataP1Date.SelectedDate.Value; bool newRoboticPrepCompleted = ckbxPrepDataRoboticPrepCompleted.Checked; DateTime? newRoboticPrepCompletedDate = null; if (tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.HasValue) newRoboticPrepCompletedDate = tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate.Value; bool newP1Completed = ckbxPrepDataP1Completed.Checked; // ... M1 Data DateTime? newM1Date = null; if (tkrdpM1DataM1Date.SelectedDate.HasValue) newM1Date = tkrdpM1DataM1Date.SelectedDate.Value; string newMeasurementsTakenBy = ""; if (tbxM1DataMeasurementsTakenBy.Text != "") newMeasurementsTakenBy = tbxM1DataMeasurementsTakenBy.Text.Trim(); string newTrafficControl = ddlM1DataTrafficControl.SelectedValue; string newSiteDetails = ""; if (ddlM1DataSiteDetails.SelectedValue != "(Select)") newSiteDetails = ddlM1DataSiteDetails.SelectedValue; bool newPipeSizeChange = ckbxM1DataPipeSizeChange.Checked; bool newStandardByPass = ckbxM1DataStandardBypass.Checked; string newStandardBypassComments = ""; if (tbxM1DataStandardBypassComments.Text != "") newStandardBypassComments = tbxM1DataStandardBypassComments.Text.Trim(); string newTrafficControlDetails = ""; if (tbxM1DataTrafficControlDetails.Text != "") newTrafficControlDetails = tbxM1DataTrafficControlDetails.Text.Trim(); string newMaterial = ddlM1DataMaterial.SelectedValue; string newMeasurementType = ddlM1DataMeasurementType.SelectedValue; string newMeasuredFromMh = ""; if (tbxM1DataMeasuredFromMh.Visible) newMeasuredFromMh = tbxM1DataMeasuredFromMh.Text; else newMeasuredFromMh = ddlM1DataMeasuredFromMh.SelectedValue; string newVideoDoneFromMh = ""; if (tbxM1DataVideoDoneFromMh.Visible) newVideoDoneFromMh = tbxM1DataVideoDoneFromMh.Text; else newVideoDoneFromMh = ddlM1DataVideoDoneFromMh.SelectedValue; string newVideoDoneToMh = ""; if (tbxM1DataVideoDoneToMh.Visible) newVideoDoneToMh = tbxM1DataVideoDoneToMh.Text; else newVideoDoneToMh = ddlM1DataVideoDoneToMh.SelectedValue; string newAccessType = ""; if (ddlM1DataAccessType.SelectedValue != "(Select)") newAccessType = ddlM1DataAccessType.SelectedValue; // ... M2 Data (Video Length) string newVideoDistanceM2 = tbxVideoLength.Text.Trim(); // ... Update work details RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS); rehabAssessmentWorkDetails.Update(workId, workIdFll, newGeneralClientId, newPrepDataP1Date, newM1Date, newPrepDataCXIsRemoved, newRoboticPrepCompleted, newRoboticPrepCompletedDate, newMeasurementsTakenBy, newTrafficControl, newSiteDetails, newPipeSizeChange, newStandardByPass, newStandardBypassComments, newTrafficControlDetails, newMaterial, newMeasurementType, newMeasuredFromMh, newVideoDoneFromMh, newVideoDoneToMh, newVideoDistanceM2, newPreVideoDate, newPreFlushDate, newAccessType, newP1Completed); if (ddlM1DataMaterial.SelectedIndex > 0) { LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null); if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(assetId, newMaterial, companyId)) { MaterialInformation model = new MaterialInformation(materialInformationTDS); model.Insert(assetId, newMaterial, DateTime.Now, false, companyId, false); } } // Store datasets Session["rehabAssessmentTDS"] = rehabAssessmentTDS; Session["materialInformationTDS"] = materialInformationTDS; // Update database UpdateDatabase(); // Restore datasets rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId); rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId); int newWorkIdFll = GetWorkId(currentProjectId, assetId, "Full Length Lining", companyId); hdfWorkIdFll.Value = GetWorkId(currentProjectId, assetId, "Full Length Lining", companyId).ToString(); rehabAssessmentTDS.LateralDetails.Clear(); RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.LoadForEdit(newWorkIdFll, assetId, companyId, currentProjectId); grdLaterals.DataBind(); // ... Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; ViewState["update"] = "yes"; } return validData; }
protected void tbxVideoLength_TextChanged(object sender, EventArgs e) { int workId = Int32.Parse(hdfWorkId.Value); int assetId = Int32.Parse(hdfAssetId.Value); string videoLength = tbxVideoLength.Text.Trim(); // Update reverse setup RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.UpdateLengthReverseSetup(workId, assetId, videoLength); // Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; for (int i = 0; i < grdLaterals.Rows.Count; i++) { if ((grdLaterals.Rows[i].RowType == DataControlRowType.DataRow) && ((grdLaterals.Rows[i].RowState == DataControlRowState.Normal) || (grdLaterals.Rows[i].RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { // Reverse Setup calculation string videoDistance = ((TextBox)grdLaterals.Rows[i].Cells[2].FindControl("tbxVideoDistance")).Text.Trim(); string reverseSetup = ""; if (videoDistance != "") { Distance videoLengthD = new Distance(tbxVideoLength.Text.Trim()); Distance videoDistanceD = new Distance(videoDistance); Distance reverseSetupD = videoLengthD - videoDistanceD; switch (videoDistanceD.DistanceType) { case 1: reverseSetup = reverseSetupD.ToStringInEng1(); break; case 2: reverseSetup = reverseSetupD.ToStringInEng2(); break; case 3: reverseSetup = reverseSetupD.ToStringInEng3(); break; case 4: reverseSetup = reverseSetupD.ToStringInMet1(); break; case 5: reverseSetup = reverseSetupD.ToStringInMil1(); break; } } ((TextBox)grdLaterals.Rows[i].Cells[2].FindControl("tbxReverseSetup")).Text = reverseSetup; } } }
protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm8 master = (mForm8)this.Master; master.ActiveToolbar = "eSewers"; // For error message hdfErrorFieldList.Value = ""; // For Video Done From MH and Measured From MH int companyId = Int32.Parse(hdfCompanyId.Value); int assetId = Int32.Parse(hdfAssetId.Value); int workId = Int32.Parse(hdfWorkId.Value); int workIdFll = Int32.Parse(hdfWorkIdFll.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); RehabAssessmentWorkDetailsGateway raWorkDetailsGateway = new RehabAssessmentWorkDetailsGateway(); raWorkDetailsGateway.LoadByWorkId(workId, companyId); RehabAssessmentLateralDetails raLateralDetails = new RehabAssessmentLateralDetails(); raLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId); if (Int32.Parse(tbxLaterals.Text) > 0) { ddlM1DataVideoDoneFromMh.Visible = false; tbxM1DataVideoDoneFromMh.Visible = true; tbxM1DataVideoDoneFromMh.Text = ddlM1DataVideoDoneFromMh.SelectedValue; ddlM1DataVideoDoneToMh.Visible = false; tbxM1DataVideoDoneToMh.Visible = true; tbxM1DataVideoDoneToMh.Text = ddlM1DataVideoDoneToMh.SelectedValue; ddlM1DataMeasuredFromMh.Visible = false; tbxM1DataMeasuredFromMh.Visible = true; tbxM1DataMeasuredFromMh.Text = ddlM1DataMeasuredFromMh.SelectedValue; btnClear.Visible = false; } else { ddlM1DataVideoDoneFromMh.Visible = true; tbxM1DataVideoDoneFromMh.Visible = false; ddlM1DataVideoDoneToMh.Visible = true; tbxM1DataVideoDoneToMh.Visible = false; ddlM1DataMeasuredFromMh.Visible = true; tbxM1DataMeasuredFromMh.Visible = false; btnClear.Visible = true; } // For materials // ... Load material for m1 MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(); materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId); if (materialInformationGateway.Table.Rows.Count > 0) { ddlM1DataMaterial.SelectedValue = materialInformationGateway.GetLastMaterialType(assetId); } // Hide or show the Old CWP ID field if (tbxOldCwpId.Text == "") { lblOldCwpId.Visible = false; tbxOldCwpId.Visible = false; } if (tbxFlowOrderId.Text == "") { LoadRehabAssessmentData(currentProjectId, assetId, companyId); } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_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)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in ra_summary.aspx"); } // Tag Page TagPage(); Session.Remove("raAddLateralsNewDummy"); // If coming from int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); int assetId = Int32.Parse(hdfAssetId.Value.Trim()); string workType = hdfWorkType.Value; int workId = Int32.Parse(hdfWorkId.Value); // ... ra_navigator2.aspx if (Request.QueryString["source_page"] == "ra_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; // Set initial tab if ((string)Session["dialogOpenedRa"] != "1") { rehabAssessmentTDS = new RehabAssessmentTDS(); RehabAssessmentSectionDetails rehabAssessmentSectionDetails = new RehabAssessmentSectionDetails(rehabAssessmentTDS); rehabAssessmentSectionDetails.LoadByWorkId(workId, companyId); RehabAssessmentWorkDetails rehabAssessmentWorkDetails = new RehabAssessmentWorkDetails(rehabAssessmentTDS); rehabAssessmentWorkDetails.LoadByWorkId(workId, companyId); int workIdFll = GetWorkId(currentProjectId, assetId, "Full Length Lining", companyId); RehabAssessmentLateralDetails rehabAssessmentLateralDetails = new RehabAssessmentLateralDetails(rehabAssessmentTDS); rehabAssessmentLateralDetails.LoadForEdit(workIdFll, assetId, companyId, currentProjectId); hdfActiveTab.Value = Request.QueryString["active_tab"]; } else { hdfActiveTab.Value = (string)Session["activeTabRa"]; // Restore dataset rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; } tcRaDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); // Store dataset Session["rehabAssessmentTDS"] = rehabAssessmentTDS; } // ... ra_delete.aspx or ra_edit.aspx if ((Request.QueryString["source_page"] == "ra_delete.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore dataset rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; // ... Set initial tab if ((string)Session["dialogOpenedRa"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; } else { hdfActiveTab.Value = (string)Session["activeTabRa"]; } tcRaDetails.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); } // 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 work LoadRehabAssessmentData(currentProjectId, assetId, companyId); // Databind Page.DataBind(); } else { // Restore datasets rehabAssessmentTDS = (RehabAssessmentTDS)Session["rehabAssessmentTDS"]; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcRaDetails.ActiveTabIndex = activeTab; } }