protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm8 master = (mForm8)this.Master; master.ActiveToolbar = "eSewers"; // For error message hdfErrorFieldList.Value = ""; if ((tbxWetOutDataHoistHeight.Text == "OK")|| (tbxWetOutDataHoistHeight.Text == "")) { lblWetOutDataWarning.Visible = false; } else { lblWetOutDataWarning.Visible = true; } // 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 currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); // set visible VideoDoneFromMh and Measured From and To FullLengthLiningWorkDetailsGateway flWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(); flWorkDetailsGateway.LoadByWorkIdAssetId(workId, assetId, companyId); FullLengthLiningLateralDetails flLateralDetails = new FullLengthLiningLateralDetails(); flLateralDetails.LoadForEdit(workId, 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 (m1) MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(); materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId); if (materialInformationGateway.Table.Rows.Count > 0) { ddlM1DataMaterial.SelectedValue = materialInformationGateway.GetLastMaterialType(assetId); } // For PreFlush Date and PreVideo Date int projectId = Int32.Parse(hdfCurrentProjectId.Value); FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(); fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workId, assetId, companyId); int? raProjectId = fullLengthLiningWorkDetailsGateway.GetRaProjectId(workId); if ((raProjectId.HasValue) && (raProjectId == projectId)) { // ... if ra data is from the same project tkrdpGeneralPreFlushDate.Visible = true; tkrdpGeneralPreVideoDate.Visible = true; tkrdpGeneralPreFlushDateReadOnly.Visible = false; tkrdpGeneralPreVideoDateReadOnly.Visible = false; } else { tkrdpGeneralPreFlushDate.Visible = false; tkrdpGeneralPreVideoDate.Visible = false; tkrdpGeneralPreFlushDateReadOnly.Visible = true; tkrdpGeneralPreVideoDateReadOnly.Visible = true; } // ... if there is no data if (tkrdpGeneralPreFlushDate.SelectedDate.HasValue) { tkrdpGeneralPreFlushDate.Calendar.Enabled = false; tkrdpGeneralPreFlushDate.DateInput.ReadOnly = true; } else { tkrdpGeneralPreFlushDate.Calendar.Enabled = true; tkrdpGeneralPreFlushDate.DateInput.ReadOnly = false; } if (tkrdpGeneralPreVideoDate.SelectedDate.HasValue) { tkrdpGeneralPreVideoDate.Calendar.Enabled = false; tkrdpGeneralPreVideoDate.DateInput.ReadOnly = true; } else { tkrdpGeneralPreVideoDate.Calendar.Enabled = true; tkrdpGeneralPreVideoDate.DateInput.ReadOnly = false; } // Hide or show the Old CWP ID field if (tbxOldCwpId.Text == "") { lblOldCwpId.Visible = false; tbxOldCwpId.Visible = false; } if (tbxFlowSectionId.Text == "") { LoadFullLengthLiningData(currentProjectId, assetId, companyId); } // Validate tools if (Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADMIN"])) { tkrpbLeftMenuTools.Items[0].Items[1].Visible = true; // Resins option tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Catalyst option tkrdpInstallDataInstallDate.Enabled = true; tkrdpInstallDataFinalVideoDate.Enabled = true; } else { tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; // Resins option tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Catalyst option tkrdpInstallDataInstallDate.Enabled = false; tkrdpInstallDataFinalVideoDate.Enabled = false; } }
/// <summary> /// Save all materials to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { MaterialInformationTDS materialInformationChanges = (MaterialInformationTDS)Data.GetChanges(); if (materialInformationChanges.MaterialInformation.Rows.Count > 0) { MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationChanges); foreach (MaterialInformationTDS.MaterialInformationRow row in (MaterialInformationTDS.MaterialInformationDataTable)materialInformationChanges.MaterialInformation) { // Insert new materials if ((!row.Deleted) && (!row.InDatabase)) { AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null); assetSewerMaterial.InsertDirect(row.AssetID, row.RefID, row.MaterialType, row.Date_, row.Deleted, row.COMPANY_ID); } // Update materials if ((!row.Deleted) && (row.InDatabase)) { int assetId = row.AssetID; int refId = row.RefID; bool originalDeleted = false; int originalCompanyId = companyId; // original values string originalMaterialType = materialInformationGateway.GetMaterialTypeOriginal(assetId, refId); DateTime originalDate_ = materialInformationGateway.GetDate_Original(assetId, refId); // new values string newMaterialType = materialInformationGateway.GetMaterialType(assetId, refId); AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null); assetSewerMaterial.UpdateDirect(assetId, refId, originalMaterialType, originalDate_, originalCompanyId, originalDeleted, assetId, refId, newMaterialType, originalDate_, originalCompanyId, originalDeleted); } // Deleted materials if ((row.Deleted) && (row.InDatabase)) { AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(null); assetSewerMaterial.DeleteDirect(row.AssetID, row.RefID, row.COMPANY_ID); } } } }
protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm6 master = (mForm6)this.Master; master.ActiveToolbar = "eSewers"; int companyId = Int32.Parse(hdfCompanyId.Value); int assetId = Int32.Parse(hdfAssetId.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(); materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId); if (materialInformationGateway.Table.Rows.Count > 0) { tbxGeneralDataMaterial.Text = materialInformationGateway.GetLastMaterialType(assetId); } if (tbxFlowOrderId.Text == "") { LoadPointRepairsData(currentProjectId, assetId, companyId); } }
// //////////////////////////////////////////////////////////////////////// // 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_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_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 fl_edit.aspx"); } // Tag Page TagPage(); // Prepare initial data Session.Remove("flAddLateralsNewDummy"); Session.Remove("wetOutCatalystsDetailsDummy"); Session.Remove("materialInformationTDS"); materialInformationTDS = new MaterialInformationTDS(); // ... for wet out section list AssetSewerSectionList assetSewerSectionList = new AssetSewerSectionList(); assetSewerSectionList.LoadAndAddItem(Int32.Parse(hdfCurrentProjectId.Value), hdfWorkType.Value, "-1", "(All)", Int32.Parse(hdfCompanyId.Value)); cbxlSectionId.DataSource = assetSewerSectionList.Table; cbxlSectionId.DataValueField = "SectionID"; cbxlSectionId.DataTextField = "FlowOrderID"; cbxlSectionId.DataBind(); cbxlInversionDataSectionId.DataSource = assetSewerSectionList.Table; cbxlInversionDataSectionId.DataValueField = "SectionID"; cbxlInversionDataSectionId.DataTextField = "FlowOrderID"; cbxlInversionDataSectionId.DataBind(); // 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()); string workType = hdfWorkType.Value; // ... fl_navigator2.aspx if (Request.QueryString["source_page"] == "fl_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; // ... Set initial tab if ((string)Session["dialogOpenedFll"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; fullLengthLiningTDS = new FullLengthLiningTDS(); FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS); fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId); FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS); fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId); FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS); fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId); FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS); fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId); } else { hdfActiveTab.Value = (string)Session["activeTabFll"]; // Restore datasets fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"]; } // ... Store dataset Session["fullLengthLiningTDS"] = fullLengthLiningTDS; } // ... fl_summary.aspx or fl_edit.aspx if ((Request.QueryString["source_page"] == "fl_summary.aspx") || (Request.QueryString["source_page"] == "fl_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // ... Restore dataset fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"]; // ... Set initial tab if ((string)Session["dialogOpenedFll"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; } else { hdfActiveTab.Value = (string)Session["activeTabFll"]; } if (ViewState["update"].ToString().Trim() == "yes") { FullLengthLiningSectionDetails fullLengthLiningSectionDetails = new FullLengthLiningSectionDetails(fullLengthLiningTDS); fullLengthLiningSectionDetails.LoadByWorkId(workId, companyId); FullLengthLiningWorkDetails fullLengthLiningWorkDetails = new FullLengthLiningWorkDetails(fullLengthLiningTDS); fullLengthLiningWorkDetails.LoadByWorkIdAssetId(workId, assetId, companyId); FullLengthLiningLateralDetails fullLengthLiningLateralDetails = new FullLengthLiningLateralDetails(fullLengthLiningTDS); fullLengthLiningLateralDetails.LoadForEdit(workId, assetId, companyId, currentProjectId); FullLengthLiningWetOutCatalystsDetails fullLengthLiningWetOutCatalystsDetails = new FullLengthLiningWetOutCatalystsDetails(fullLengthLiningTDS); fullLengthLiningWetOutCatalystsDetails.LoadAll(workId, companyId); // ... Store dataset Session["fullLengthLiningTDS"] = fullLengthLiningTDS; } } // Prepare initial data lblMissingData.Visible = false; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcFlDetails.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 full length lining work LoadFullLengthLiningData(currentProjectId, assetId, companyId); // Databind Page.DataBind(); // Especial load for Run details string runDetails = hdfRunDetails.Value; WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway(); workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId); // ... Verify if work has cipp information to load run details if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0) { string[] runDetailsList = runDetails.Split('>'); for (int i = 0; i < runDetailsList.Length; i++) { cbxlSectionId.Items.FindByValue(runDetailsList[i]).Selected = true; cbxlInversionDataSectionId.Items.FindByValue(runDetailsList[i]).Selected = true; } } else { if (cbxlSectionId.Items.Count > 1) { cbxlSectionId.Items.FindByValue(runDetails).Selected = true; } } // SelectIndex for grids ((DropDownList)grdLaterals.FooterRow.FindControl("ddlNewMaterial")).SelectedIndex = 0; ((DropDownList)grdCatalysts.FooterRow.FindControl("ddlNameFooter")).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; // Make Wetout tab visible if (ckbxWetOutDataIncludeWetOutInformation.Checked) { pnlVisibleInformation.Visible = true; upnlVisibleInformation.Update(); } else { pnlVisibleInformation.Visible = false; upnlVisibleInformation.Update(); } // Make inversion tab visible lblInversionDataInversionMissingData.Visible = false; uplInversionDataInversionMissingData.Update(); if (ckbxInversionDataIncludeInversionInformation.Checked) { // ... ... visible only if wet out information is provided. if (!ckbxWetOutDataIncludeWetOutInformation.Checked) { pnlInversionVisibleInformation.Visible = false; upnlInversionVisibleInformation.Update(); } else { pnlInversionVisibleInformation.Visible = true; upnlInversionVisibleInformation.Update(); } } else { pnlInversionVisibleInformation.Visible = false; upnlInversionVisibleInformation.Update(); } // Load Materials MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS); materialInformationGateway.LoadAllByAssetId(assetId, companyId); materialInformation = materialInformationTDS.MaterialInformation; Session["materialInformationTDS"] = materialInformationTDS; } } else { // Restore datasets fullLengthLiningTDS = (FullLengthLiningTDS)Session["fullLengthLiningTDS"]; flatSectionJlTDSForFLL = (FlatSectionJlTDS)Session["flatSectionJlTDSForFLL"]; materialInformationTDS = (MaterialInformationTDS)Session["materialInformationTDS"]; materialInformation = materialInformationTDS.MaterialInformation; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcFlDetails.ActiveTabIndex = activeTab; } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_EDIT"])) || !(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["asset_id"] == null) || ((string)Request.QueryString["work_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in asset_sewer_material.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfAssetId.Value = Convert.ToString(Request.QueryString["asset_id"]); hdfWorkId.Value = Convert.ToString(Request.QueryString["work_id"]); hdfUpdate.Value = "yes"; Session.Remove("materialInformationNewDummy"); Session.Remove("materialInformation"); // If coming from // ... fl_edit.aspx or ra_edit.aspx if ((Request.QueryString["source_page"] == "fl_edit.aspx") || (Request.QueryString["source_page"] == "ra_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // ... Load materials to edit materialInformationTDS = new MaterialInformationTDS(); // Get workId int assetId = Int32.Parse(hdfAssetId.Value.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS); materialInformationGateway.LoadAllByAssetId(assetId, companyId); // ... Store datasets Session["materialInformationTDS"] = materialInformationTDS; Session["materialInformation"] = materialInformationTDS.MaterialInformation; } } else { // Restore datasets materialInformationTDS = (MaterialInformationTDS)Session["materialInformationTDS"]; materialInformation = materialInformationTDS.MaterialInformation; } }
protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm6 master = (mForm6)this.Master; master.ActiveToolbar = "eSewers"; // For error message lblWetOutDataWarning.Visible = false; if (tbxWetOutDataHoistHeight.Text == "OK") { lblWetOutDataWarning.Visible = false; } else { lblWetOutDataWarning.Visible = true; } // For Material int companyId = Int32.Parse(hdfCompanyId.Value); int assetId = Int32.Parse(hdfAssetId.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(); materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId); if (materialInformationGateway.Table.Rows.Count > 0) { tbxM1DataMaterial.Text = materialInformationGateway.GetLastMaterialType(assetId); } // Hide or Show the Old CWP ID field if (tbxOldCwpId.Text == "") { lblOldCwpId.Visible = false; tbxOldCwpId.Visible = false; } if (tbxFlowOrderId.Text == "") { LoadFullLengthLiningData(currentProjectId, assetId, companyId); } // Validate tools if (Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_ADMIN"])) { tkrpbLeftMenuTools.Items[0].Items[1].Visible = true; // Resins option tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Catalyst option } else { tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; // Resins option tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Catalyst option } // Make Wetout tab visible if (ckbxWetOutDataIncludeWetOutInformation.Checked) { upnlVisibleInformation.Visible = true; } else { upnlVisibleInformation.Visible = false; } // Make inversion tab visible if (ckbxInversionDataIncludeInversionInformation.Checked) { upnlInversionVisibleInformation.Visible = true; } else { upnlInversionVisibleInformation.Visible = false; } }
protected void grdMaterials_RowDataBound(object sender, GridViewRowEventArgs e) { if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { int assetId = Int32.Parse(hdfAssetId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefIDEdit")).Text.Trim()); MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(materialInformationTDS); string materialType = materialInformationGateway.GetMaterialType(assetId, refId); ((DropDownList)e.Row.FindControl("ddlMaterialTypeEdit")).SelectedValue = materialType; } }
// //////////////////////////////////////////////////////////////////////// // 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 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); } }
protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm6 master = (mForm6)this.Master; master.ActiveToolbar = "eSewers"; // For materials // ... Load material for m1 int companyId = Int32.Parse(hdfCompanyId.Value); int assetId = Int32.Parse(hdfAssetId.Value); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.ToString()); MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(); materialInformationGateway.LoadLastMaterialByAssetId(assetId, companyId); if (materialInformationGateway.Table.Rows.Count > 0) { tbxM1DataMaterial.Text = 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); } }
/// <summary> /// Insert a material /// </summary> /// <param name="lateral_assetId">lateral_assetId</param> /// <param name="material">material</param> /// <param name="companyId">companyId</param> private void InsertMaterial(int lateral_assetId, string material, int companyId) { LfsAssetSewerLateralGateway lfsAssetSewertLateralGateway = new LfsAssetSewerLateralGateway(null); if (!lfsAssetSewertLateralGateway.IsUsedInMaterials(lateral_assetId, material, companyId)) { MaterialInformationGateway materialInformationGateway = new MaterialInformationGateway(); materialInformationGateway.LoadAllByAssetId(lateral_assetId, companyId); AssetSewerMaterial assetSewerMaterial = new AssetSewerMaterial(materialInformationGateway.Data); assetSewerMaterial.InsertDirect(lateral_assetId, materialInformationGateway.Table.Rows.Count + 1, material, DateTime.Now, false, companyId); } }