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);
}
