// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // public FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable GetHistoryNew() { flatSectionJlHistoryDetails = (FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable)Session["flatSectionJlHistoryDetailsDummy"]; if (flatSectionJlHistoryDetails == null) { flatSectionJlHistoryDetails = ((FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable)Session["flatSectionJlHistoryDetails"]); } return flatSectionJlHistoryDetails; }
protected void AddCommentsNewEmptyFix(GridView grdHistory) { if (grdHistory.Rows.Count == 0) { int companyId = Int32.Parse(hdfCompanyId.Value); FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable dt = new FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable(); dt.AddFlatSectionJlHistoryDetailsRow(-1, -1, "", "", -1, DateTime.Now, "", -1, false, companyId, false, "", false, ""); Session["flatSectionJlHistoryDetailsDummy"] = dt; grdHistory.DataBind(); } // Normally executes at all postbacks if (grdHistory.Rows.Count == 1) { FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable dt = (FlatSectionJlTDS.FlatSectionJlHistoryDetailsDataTable)Session["flatSectionJlHistoryDetailsDummy"]; if (dt != null) { grdHistory.Rows[0].Visible = false; grdHistory.Rows[0].Controls.Clear(); } } }
// //////////////////////////////////////////////////////////////////////// // 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_history.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("flatSectionJlHistoryDetailsDummy"); // If comming 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 (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 history FlatSectionJlHistoryDetailsGateway flatSectionJlHistoryDetailsGateway = new FlatSectionJlHistoryDetailsGateway(flatSectionJlTDS); flatSectionJlHistoryDetailsGateway.LoadAllByJlWorkIdRaWorkIdFlWorkId(jlWorkId, raWorkId, flWorkId, companyId); FlatSectionJlHistoryDetails flatSectionJlHistoryDetails = new FlatSectionJlHistoryDetails(flatSectionJlTDS); flatSectionJlHistoryDetails.UpdateForProcess(); // Get comments FlatSectionJlCommentDetailsGateway flatSectionJlCommentDetailsGateway = new FlatSectionJlCommentDetailsGateway(flatSectionJlTDS); flatSectionJlCommentDetailsGateway.LoadAllByJlWorkIdRaWorkIdFlWorkId(jlWorkId, raWorkId, flWorkId, companyId); } // ... Store datasets Session["flatSectionJlTDS"] = flatSectionJlTDS; Session["jlNavigatorTDS"] = jlNavigatorTDS; Session["flatSectionJlHistoryDetails"] = flatSectionJlTDS.FlatSectionJlHistoryDetails; } } else { // Restore datasets flatSectionJlTDS = (FlatSectionJlTDS)Session["flatSectionJlTDS"]; jlNavigatorTDS = (JlNavigatorTDS)Session["jlNavigatorTDS"]; flatSectionJlHistoryDetails = flatSectionJlTDS.FlatSectionJlHistoryDetails; // Store Session["flatSectionJlHistoryDetails"] = flatSectionJlTDS.FlatSectionJlHistoryDetails; } }