// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// SectionUpdate /// </summary> public void SectionUpdate() { foreach (Fix1TDS.LFS_MASTER_AREARow masterAreaRow in (Fix1TDS.LFS_MASTER_AREADataTable)Table) { LinningPlanGateway liningPlanGateway = new LinningPlanGateway(); Fix1JlinerGateway fix1JlinerGateway = new Fix1JlinerGateway(); fix1JlinerGateway.LoadByIdCompanyId(masterAreaRow.ID, masterAreaRow.COMPANY_ID); Fix1Jliner fix1Jliner = new Fix1Jliner(fix1JlinerGateway.Data); // Update variables int numLats = fix1Jliner.GetNumLats(masterAreaRow.ID, masterAreaRow.COMPANY_ID); int notLinedYeet = fix1Jliner.GetNotLinedYet(masterAreaRow.ID, masterAreaRow.COMPANY_ID); bool allMeasured = fix1Jliner.GetAllMeasured(masterAreaRow.ID, masterAreaRow.COMPANY_ID); int notMeasuredYet = fix1Jliner.GetNotMeasuredYet(masterAreaRow.ID, masterAreaRow.COMPANY_ID); int notDeliveredYet = fix1Jliner.GetNotDeliveredYet(masterAreaRow.ID, masterAreaRow.COMPANY_ID); masterAreaRow.NumLats = numLats; masterAreaRow.NotLinedYet = notLinedYeet; masterAreaRow.AllMeasured = (numLats == 0) ? false : allMeasured; masterAreaRow.NotMeasuredYet = notMeasuredYet; masterAreaRow.NotDeliveredYet = notDeliveredYet; // Update IssueWithtLaterals Guid rowId = masterAreaRow.ID; if (liningPlanGateway.IsLateralsIssueNo(rowId)) { masterAreaRow.IssueWithLaterals = "No"; } else { if (liningPlanGateway.IsLateralsIssueOutOfScope(rowId)) { masterAreaRow.IssueWithLaterals = "Out Of Scope"; } else { if (liningPlanGateway.IsLateralsIssueYesOutOfScope(rowId)) { masterAreaRow.IssueWithLaterals = "Yes, Out Of Scope"; } else { if (liningPlanGateway.IsLateralsIssueYes(rowId)) { masterAreaRow.IssueWithLaterals = "Yes"; } } } } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!Convert.ToBoolean(Session["sgLFS_APP_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"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in linning_plan.aspx"); } // Tag page hdfCurrentClient.Value = (string)Request.QueryString["client"]; // Prepare initial data // ... for the client int companyId = Int32.Parse(Session["companyID"].ToString()); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(int.Parse(hdfCurrentClient.Value), companyId); TextBox tbxCurrentClient = (TextBox)tkrpbLeftMenuCurrentClient.FindItemByValue("mCurrentClient").FindControl("tbxCurrentClient"); tbxCurrentClient.Text = companiesGateway.GetName(int.Parse(hdfCurrentClient.Value)); // ... for the grid linningPlanTDS = new LinningPlanTDS(); LinningPlanGateway linningPlanGateway = new LinningPlanGateway(linningPlanTDS); linningPlanGateway.ClearBeforeFill = false; linningPlanGateway.LoadByCompaniesIdIssueWithLateralsNoOutOfScope(companyId, int.Parse(hdfCurrentClient.Value)); linningPlanGateway.LoadByCompaniesIdOtherIssueWithLaterals(companyId, int.Parse(hdfCurrentClient.Value)); grdLinningPlan.DataSource = linningPlanGateway.Table; grdLinningPlan.DataBind(); // Check results if (linningPlanTDS.LinningPlan.Rows.Count > 0) { pNoResults.Visible = false; } else { pNoResults.Visible = true; } // Store dataset Session["linningPlanTDS"] = linningPlanTDS; } else { // Restore dataset linningPlanTDS = (LinningPlanTDS) Session["linningPlanTDS"]; // ... for the grid LinningPlanGateway linningPlanGateway = new LinningPlanGateway(linningPlanTDS); linningPlanGateway.ClearBeforeFill = false; int companyId = Int32.Parse(Session["companyID"].ToString()); linningPlanGateway.LoadByCompaniesIdIssueWithLateralsNoOutOfScope(companyId, int.Parse(hdfCurrentClient.Value)); linningPlanGateway.LoadByCompaniesIdOtherIssueWithLaterals(companyId, int.Parse(hdfCurrentClient.Value)); grdLinningPlan.DataSource = linningPlanGateway.Table; grdLinningPlan.DataBind(); } }
/// <summary> /// UpdateIssueWithLaterals /// </summary> public void UpdateIssueWithLaterals() { LinningPlanGateway liningPlanGateway = new LinningPlanGateway(); foreach (SectionTDS.LFS_MASTER_AREARow lfsMasterAreaRow in (SectionTDS.LFS_MASTER_AREADataTable)Table) { Guid rowId = lfsMasterAreaRow.ID; if (lfsMasterAreaRow.NumLats > 0) { if (liningPlanGateway.IsLateralsIssueNo(rowId)) { lfsMasterAreaRow.IssueWithLaterals = "No"; } else { if (liningPlanGateway.IsLateralsIssueOutOfScope(rowId)) { lfsMasterAreaRow.IssueWithLaterals = "Out Of Scope"; } else { if (liningPlanGateway.IsLateralsIssueYesOutOfScope(rowId)) { lfsMasterAreaRow.IssueWithLaterals = "Yes, Out Of Scope"; } else { if (liningPlanGateway.IsLateralsIssueYes(rowId)) { lfsMasterAreaRow.IssueWithLaterals = "Yes"; } } } } } else { lfsMasterAreaRow.IssueWithLaterals = "No"; } } }