protected void Page_Load(object sender, EventArgs e) { MessagePanel.Visible = false; Message.Text = String.Format( "Only four (4) {0} can be selected at a time. You must remove a currently selected {0} in the list on the right by clicking on the name before you can add another {0}.", (GlobalValues.CompareTo.Key == CompareToKeys.SelSchools) ? "schools" : "districts" ); set_state(); if (GlobalValues.CompareTo.Key == CompareToKeys.SelSchools) { selectedFullkeys = GlobalValues.SSchoolFullKeys; } if (GlobalValues.CompareTo.Key == CompareToKeys.SelDistricts) { selectedFullkeys = GlobalValues.SDistrictFullKeys; } selectedFullkeys = ProcessUserRequest(selectedFullkeys); PersistSelection(selectedFullkeys); populateAvailableSchoolsGrid( BLUtil.GetCommaDeliFullKeyString(selectedFullkeys + FullKeyUtils.GetMaskedFullkey(GlobalValues.FULLKEY, GlobalValues.OrgLevel)) ); populateSelectedGrid( BLUtil.GetCommaDeliFullKeyString(selectedFullkeys) ); }
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"; } }
void TeacherQualificationsScatterPlot_OnCheckPrerequisites(PageBaseWI page, EventArgs args) { if (GlobalValues.OrgLevel.Key == OrgLevelKeys.State) { return; } if (FullKeyUtils.GetOrgLevelFromFullKeyX(GlobalValues.FULLKEY).Key == OrgLevelKeys.State) { OnRedirectUser += InitialAgencyRedirect; } }
void StateTestsSimilarSchools_OnCheckPrerequisites(PageBaseWI page, EventArgs args) { if (GlobalValues.OrgLevel.Key == OrgLevelKeys.State) { return; } if (FullKeyUtils.GetOrgLevelFromFullKeyX(GlobalValues.FULLKEY).Key == OrgLevelKeys.State) { OnRedirectUser += InitialAgencyRedirect; } }
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; } }
private String GetLegendTitleText() { if (GlobalValues.Group2.Key == Group2Keys.None) { return(String.Empty); } String title = String.Empty; if (GlobalValues.Group2.Key == Group2Keys.DistrictSpending) { title = "District Current Education Cost per Member"; } else if (GlobalValues.Group2.Key == Group2Keys.DistrictSize) { title = "District Size -- Number of Students Enrolled"; } else { title = GlobalValues.Group2.Key + " FAY"; } DataRow[] data = DataSet.Tables[0].Select("fullkey = '" + FullKeyUtils.GetMaskedFullkey(GlobalValues.FULLKEY, GlobalValues.OrgLevel) + "'"); if (data.Length != 1) { return(title); } int col = data[0].Table.Columns.IndexOf(GetSeriesColumnName()); String val = String.Empty; if (col > -1) { val = data[0].ItemArray[col].ToString(); } if (GlobalValues.Group2.Key == Group2Keys.DistrictSpending || GlobalValues.Group2.Key == Group2Keys.DistrictSize) { String frmt; if (GlobalValues.Group2.Key == Group2Keys.DistrictSpending) { frmt = "{0:$#,###}"; } else //if (GlobalValues.Group2.Key == Group2Keys.DistrictSize) { frmt = "{0:#,###}"; } try { val = String.Format(frmt, Convert.ToDecimal(val)); //format doesn't work properly on a string } catch { } } else { val = val + "%"; } title = title + WebSupportingClasses.TitleBuilder.newline + "Current Value = " + val; return(title); }