protected override void OnPreRender(EventArgs e) { base.OnPreRender(e); //set the URLs for the left hand hyperlinks if (!Page.IsPostBack) { SetLeftHandLinksText(); SetDataLinks(); SetHideShowNumbersLink(); SetScatterplotLink(); SetReadAboutLink(); SetGlossaryLink(); string qsChangeSchoolOrDistrict = user.GetQueryString( "FULLKEY", FullKeyUtils.StateFullKey(globals.FULLKEY)); qsChangeSchoolOrDistrict = QueryStringUtils.ReplaceQueryString(qsChangeSchoolOrDistrict, globals.OrgLevel.Name, globals.OrgLevel.Range[OrgLevelKeys.State]); qsChangeSchoolOrDistrict = QueryStringUtils.ReplaceQueryString(qsChangeSchoolOrDistrict, "DN", String.Empty); qsChangeSchoolOrDistrict = QueryStringUtils.ReplaceQueryString(qsChangeSchoolOrDistrict, "SN", String.Empty); this.ChangeSchoolOrDistrict.NavigateUrl = globals.CreateURL("~/selschool.aspx", qsChangeSchoolOrDistrict); ViewTitle.Text = globals.OrgLevel.Key + " View"; } }
protected void Page_Load(object sender, EventArgs e) { globals = ((PageBaseWI)Page).GlobalValues; string qs = globals.GetQueryString( "FULLKEY", FullKeyUtils.StateFullKey(globals.FULLKEY)); qs = QueryStringUtils.ReplaceQueryString(qs, globals.OrgLevel.Name, globals.OrgLevel.Range[OrgLevelKeys.State]); qs = QueryStringUtils.ReplaceQueryString(qs, "DN", "None Chosen"); qs = QueryStringUtils.ReplaceQueryString(qs, "SN", "None Chosen"); EDITselection.NavigateUrl = "~/SelSchool.aspx" + qs; }
protected void Load_Display(string s_type, string alpha_fl, string f_key, string var_hs) { switch (s_type) { case "SC": ((SligoCS.Web.WI.WI)Page.Master).set_visible_state(WI.displayed_obj.InitSelSchoolInfo1, false); ((SligoCS.Web.WI.WI)Page.Master).set_visible_state(WI.displayed_obj.DistrictMapInfo1, false); ((SligoCS.Web.WI.WI)Page.Master).set_visible_state(WI.displayed_obj.DistrictInfo1, true); ((SligoCS.Web.WI.WI)Page.Master).set_visible_state(WI.displayed_obj.WI_DPI_Disclaim1, true); if ((alpha_fl != string.Empty) && (f_key == FullKeyUtils.StateFullKey(GlobalValues.FULLKEY))) // if (alpha_fl != string.Empty) { QueryMarshaller.Database = new SligoCS.DAL.WI.DALAgencies(); QueryMarshaller.Database.SQL = SligoCS.DAL.WI.DALALLAgencies.GetSchoolsByStartNameSQL(alpha_fl); QueryMarshaller.ManualQuery(); GlobalValues.SQL = GlobalValues.SQL + "//" + QueryMarshaller.Database.SQL; SligoDataGrid1.DataSource = QueryMarshaller.Database.DataSet; SligoDataGrid1.DataBind(); SligoDataGrid1.AddSuperHeader("Searching in SCHOOL by Letter " + alpha_fl); SligoDataGrid1.Visible = true; No_Records_Found("No Schools Found Starting with ", alpha_fl); } else { QueryMarshaller.Database = new SligoCS.DAL.WI.DALAgencies(); QueryMarshaller.Database.SQL = SligoCS.DAL.WI.DALALLAgencies.GetSchoolByDistrictKeySQL(f_key); QueryMarshaller.ManualQuery(); GlobalValues.SQL = GlobalValues.SQL + " //" + QueryMarshaller.Database.SQL; SligoDataGrid4.DataSource = QueryMarshaller.Database.DataSet; SligoDataGrid4.DataBind(); try { SligoDataGrid4.AddSuperHeader("Searching Schools in DISTRICT, " + QueryMarshaller.Database.DataSet.Tables[0].Rows[0][SligoCS.DAL.WI.v_AgencyFull.DistrictName].ToString()); } catch { } SligoDataGrid4.Visible = true; } break; case "DI": GlobalValues.SQL = DALALLAgencies.GetDistrictByNameSQL(alpha_fl); QueryMarshaller.AssignQuery(new DALAgencies(), GlobalValues.SQL); SligoDataGrid2.DataSource = QueryMarshaller.Database.DataSet; SligoDataGrid2.DataBind(); SligoDataGrid2.AddSuperHeader("Searching in DISTRICT by Letter " + alpha_fl); SligoDataGrid2.Visible = true; No_Records_Found("No Districts Found Starting with ", alpha_fl); break; case "CO": GlobalValues.SQL = DALALLAgencies.GetCountyByNameSQL(alpha_fl); QueryMarshaller.AssignQuery(new DALAgencies(), GlobalValues.SQL); SligoDataGrid3.DataSource = QueryMarshaller.Database.DataSet; SligoDataGrid3.DataBind(); SligoDataGrid3.AddSuperHeader("Searching in COUNTY by Letter " + alpha_fl); SligoDataGrid3.Visible = true; No_Records_Found("No Counties Found Starting with ", alpha_fl); break; case "CE": if (alpha_fl.Length == 1) { string pad = "0"; alpha_fl = pad + alpha_fl; } CESA_maps(alpha_fl, var_hs); GlobalValues.SQL = DALALLAgencies.GetDistrictByCESASQL(alpha_fl, var_hs); QueryMarshaller.AssignQuery(new DALAgencies(), GlobalValues.SQL); SligoDataGrid5.DataSource = QueryMarshaller.Database.DataSet; SligoDataGrid5.DataBind(); SligoDataGrid5.AddSuperHeader("Results for CESA " + alpha_fl); if ((var_hs == "1") || (var_hs == "0")) { if (var_hs == "1") { SligoDataGrid5.AddSuperHeader(SligoDataGrid5.SuperHeaderText + " with Union High School Districts"); } else { SligoDataGrid5.AddSuperHeader(SligoDataGrid5.SuperHeaderText + " with Elementary School Districts"); } } SligoDataGrid5.Visible = true; break; } }