/// <summary> /// LoadByProjectIdJlNavigatorTDS /// </summary> /// <param name="projectId">projectId</param> /// <param name="jlNavigatorTDS">jlNavigatorTDS</param> /// <param name="companyId">companyId</param> public void LoadByProjectIdJlNavigatorTDS(int projectId, JlNavigatorTDS jlNavigatorTDS, int companyId) { ArrayList sections = new ArrayList(); LateralLocationSheetReportGateway lateralLocationSheetReportGateway = new LateralLocationSheetReportGateway(Data); lateralLocationSheetReportGateway.ClearBeforeFill = false; foreach (JlNavigatorTDS.JlNavigatorRow jlNavigatorRow in jlNavigatorTDS.JlNavigator) { if (jlNavigatorRow.Selected) { if (!sections.Contains(jlNavigatorRow.AssetID)) { sections.Add(jlNavigatorRow.AssetID); int assetId = jlNavigatorRow.AssetID; int workIdFll = GetWorkId(projectId, assetId, "Full Length Lining", companyId); string measuredFrom = "USMH"; if (workIdFll > 0) { FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(); fullLengthLiningWorkDetailsGateway.LoadByWorkIdAssetId(workIdFll, assetId, companyId); measuredFrom = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workIdFll); } // Get Data lateralLocationSheetReportGateway.LoadByAssetId(assetId, companyId); UpdateForReportForJunctionLining(assetId, workIdFll, projectId, measuredFrom, companyId); } } } lateralLocationSheetReportGateway.ClearBeforeFill = true; }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_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["row_asset_id"] == null) || ((string)Request.QueryString["row_focus"] == null) || ((string)Request.QueryString["work_type"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jl_comments.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString(); hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString(); hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); hdfAssetId.Value = Convert.ToString(Request.QueryString["row_asset_id"]); hdfAdminPermission.Value = Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_ADMIN"]).ToString(); hdfWorkType.Value = Request.QueryString["work_type"].ToString(); hdfSection_.Value = Request.QueryString["section_"].ToString(); hdfUpdate.Value = "yes"; // ... Names for UserList string workType = hdfWorkType.Value.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(Convert.ToInt32(hdfLoginId.Value), companyId); hdfCreatedBy.Value = loginGateway.GetLastName(Convert.ToInt32(hdfLoginId.Value), companyId) + " " + loginGateway.GetFirstName(Convert.ToInt32(hdfLoginId.Value), companyId); hdfCreationDateTime.Value = DateTime.Now.ToString(); // Prepare initial data Session.Remove("flatSectionJlCommentDetailsDummy"); // If coming from // ... flat_section_jl_summary.aspx or flat_section_jl_edit.aspx if (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx" || Request.QueryString["source_page"] == "flat_section_jl_edit.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; Session["rowFocus"] = Convert.ToInt32(Request.QueryString["row_focus"].ToString()); // ... Load comments to edit flatSectionJlTDS = (FlatSectionJlTDS)Session["flatSectionJlTDS"]; jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"]; // Get workId int assetId = Int32.Parse(hdfAssetId.Value.Trim()); int currentProjectId = Int32.Parse(hdfCurrentProjectId.Value.Trim()); int jlWorkId = 0; int raWorkId = 0; int flWorkId = 0; WorkGateway searchWorkGateway = new WorkGateway(); searchWorkGateway.LoadByProjectIdAssetIdWorkType(currentProjectId, assetId, "Junction Lining Lateral", companyId); // ... If the project has jl works if (searchWorkGateway.Table.Rows.Count > 0) { jlWorkId = searchWorkGateway.GetWorkId(assetId, "Junction Lining Lateral", currentProjectId); // ... ...Tag Page hdfWorkId.Value = jlWorkId.ToString().Trim(); // ... ...Get ra work id for comments int section_ = Int32.Parse(hdfSection_.Value) ; WorkGateway workGatewayRAFL = new WorkGateway(); // ... ...Get fl work id for comments workGatewayRAFL.LoadByProjectIdAssetIdWorkType(currentProjectId, section_, "Full Length Lining", companyId); if (workGatewayRAFL.Table.Rows.Count > 0) { flWorkId = workGatewayRAFL.GetWorkId(section_, "Full Length Lining", currentProjectId); } workGatewayRAFL.LoadByProjectIdAssetIdWorkType(currentProjectId, section_, "Rehab Assessment", companyId); if (workGatewayRAFL.Table.Rows.Count > 0) { raWorkId = workGatewayRAFL.GetWorkId(section_, "Rehab Assessment", currentProjectId); } // ... ...Get comments FlatSectionJlCommentDetailsGateway flatSectionJlCommentDetailsGateway = new FlatSectionJlCommentDetailsGateway(flatSectionJlTDS); flatSectionJlCommentDetailsGateway.LoadAllByJlWorkIdRaWorkIdFlWorkId(jlWorkId, raWorkId, flWorkId, companyId); FlatSectionJlCommentDetails flatSectionJlCommentDetails = new FlatSectionJlCommentDetails(flatSectionJlCommentDetailsGateway.Data); flatSectionJlCommentDetails.UpdateForProcess(); // ... ...Get history FlatSectionJlHistoryDetailsGateway flatSectionJlHistoryDetailsGateway = new FlatSectionJlHistoryDetailsGateway(flatSectionJlTDS); flatSectionJlHistoryDetailsGateway.LoadAllByJlWorkIdRaWorkIdFlWorkId(jlWorkId, raWorkId, flWorkId, companyId); } // ... Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; Session["jlNavigatorTDS"] = jlNavigatorTDS; Session["flatSectionJlCommentDetails"] = flatSectionJlTDS.FlatSectionJlCommentDetails; } } else { // Restore datasets flatSectionJlTDS = (FlatSectionJlTDS)Session["flatSectionJlTDS"]; jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"]; flatSectionJlCommentDetails = flatSectionJlTDS.FlatSectionJlCommentDetails; // Store Session["flatSectionJlCommentDetails"] = flatSectionJlTDS.FlatSectionJlCommentDetails; } }
protected void btnSearch_Click(object sender, EventArgs e) { if (Page.IsValid) { // Tag Page hdfBtnOrigin.Value = "Search"; string url = ""; // Delete store data Session.Contents.Remove("jlNavigatorTDS"); // Get data from DA gateway jlNavigatorTDS = SubmitSearch(); // Show results if (jlNavigatorTDS.JlNavigator.Rows.Count > 0) { // ... Store data Session["jlNavigatorTDS"] = jlNavigatorTDS; // ... Go to the results page url = "./jl_navigator2.aspx?source_page=jl_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState(); } else { // ... Go to the search page url = "./jl_navigator.aspx?source_page=jl_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState() + "&no_results=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_JUNCTIONLINING_VIEW"]))) { 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["work_type"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in jl_navigator2.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfCurrentProjectId.Value = Request.QueryString["project_id"].ToString(); hdfCurrentClientId.Value = Request.QueryString["client_id"].ToString(); hdfWorkType.Value = Request.QueryString["work_type"].ToString(); // Prepare initial data // ... For sortByList odsSortByList.DataBind(); ddlSortBy.DataSourceID = "odsSortByList"; ddlSortBy.DataValueField = "SortID"; ddlSortBy.DataTextField = "Name"; ddlSortBy.DataBind(); // ... For odsViewForDisplayList.DataBind(); odsViewForDisplayList2.DataBind(); // ... For view ddl int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string workType = hdfWorkType.Value; int loginId = Convert.ToInt32(Session["loginID"]); string viewTypeGlobal = ""; string viewTypePersonal = "Personal"; // Global Views check if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"])) { viewTypeGlobal = "Global"; } WorkViewList workViewList = new WorkViewList(); workViewList.LoadAndAddItem(workType, viewTypeGlobal, viewTypePersonal, loginId, companyId); ddlView.DataSource = workViewList.Table; ddlView.DataValueField = "ViewID"; ddlView.DataTextField = "Name"; ddlView.DataBind(); ddlView.SelectedIndex = 1; WorkTypeViewSubAreaList workTypeViewSubAreaList = new WorkTypeViewSubAreaList(); workTypeViewSubAreaList.LoadAndAddItem("Junction Lining", Int32.Parse(hdfCompanyId.Value), int.Parse(hdfCurrentProjectId.Value), "(All)"); ddlSubArea.DataSource = workTypeViewSubAreaList.Table; ddlSubArea.DataValueField = "SubArea"; ddlSubArea.DataTextField = "SubArea"; ddlSubArea.DataBind(); // ... 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 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) + ")"; // If coming from // ... jl_navigator.aspx or jl_navigator2.aspx if ((Request.QueryString["source_page"] == "jl_navigator.aspx") || (Request.QueryString["source_page"] == "jl_navigator2.aspx")) { // Restore data RestoreNavigatorState(); jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"]; } // ... flat_section_jl_edit.aspx, flat_section_jl_summary.aspx or jl_delete.aspx if ((Request.QueryString["source_page"] == "flat_section_jl_edit.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx") || (Request.QueryString["source_page"] == "jl_delete.aspx")) { RestoreNavigatorState(); if (Request.QueryString["update"] == "no") { jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"]; } else { // ... Delete store data Session.Contents.Remove("jlNavigatorTDS"); // ... Search data with updates if (hdfBtnOrigin.Value == "Search") { jlNavigatorTDS = SubmitSearch(); } else { if (hdfBtnOrigin.Value == "Go") { jlNavigatorTDS = SubmitSearchForViews(); } } // ... store datasets Session["jlNavigatorTDS"] = jlNavigatorTDS; } } // ... jl_delete.aspx, flat_section_jl_summary.aspx or flat_section_jl_edit.aspx if ((Request.QueryString["source_page"] == "jl_delete.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_summary.aspx") || (Request.QueryString["source_page"] == "flat_section_jl_edit.aspx")) { if (jlNavigatorTDS.JlNavigator.Rows.Count == 0) { string url = "./jl_navigator.aspx?source_page=jl_navigator2.aspx&client_id=" + hdfCurrentClientId.Value + "&project_id=" + hdfCurrentProjectId.Value + "&work_type=" + hdfWorkType.Value + GetNavigatorState() + "&no_results=yes"; Response.Redirect(url); } } // Update for comments JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS); jlNavigator.UpdateEnterForComments(); // Store data Session["jlNavigatorTDS"] = jlNavigatorTDS; // For the grid grdJLNavigator.DataSource = jlNavigatorTDS.JlNavigator; grdJLNavigator.DataBind(); // ... for the total rows if (jlNavigatorTDS.JlNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + jlNavigatorTDS.JlNavigator.Rows.Count; lblTotalRows.Visible = true; } else { lblTotalRows.Visible = false; } } else { // Restore TDS jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"]; // Update for comments JlNavigator jlNavigator = new JlNavigator(jlNavigatorTDS); jlNavigator.UpdateEnterForComments(); // ... for the total rows if (jlNavigatorTDS.JlNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + jlNavigatorTDS.JlNavigator.Rows.Count; lblTotalRows.Visible = true; } else { lblTotalRows.Visible = false; } } }
/// <summary> /// InitData /// </summary> protected override void InitData() { _data = new JlNavigatorTDS(); }