protected void SligoDataGrid2_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
//decode the link to specific schools, so that it appears as a normal URL link.
int colIndex = SligoDataGrid2.FindBoundColumnIndex(
_ds._v_RetentionWWoDisEconELPSchoolDistState.LinkedNameColumn.ColumnName);
e.Row.Cells[colIndex].Text = Server.HtmlDecode(e.Row.Cells[colIndex].Text);
//format the numerical values
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _ds._v_RetentionWWoDisEconELPSchoolDistState.
_Total_Enrollment__K_12_Column.ColumnName, Constants.FORMAT_RATE_03);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _ds._v_RetentionWWoDisEconELPSchoolDistState.
Completed_School_TermColumn.ColumnName, Constants.FORMAT_RATE_03);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _ds._v_RetentionWWoDisEconELPSchoolDistState.
Number_of_RetentionsColumn.ColumnName, Constants.FORMAT_RATE_03);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _ds._v_RetentionWWoDisEconELPSchoolDistState.
Retention_RateColumn.ColumnName, Constants.FORMAT_RATE_02_PERC);
//Does not apply to Retention page.
SligoDataGrid2.SetOrgLevelRowLabels(GlobalValues, e.Row);
//// replace long race label with shourt race label
FormatHelper formater = new FormatHelper();
formater.SetRaceAbbr(SligoDataGrid2, e.Row,
_ds._v_RetentionWWoDisEconELPSchoolDistState.RaceLabelColumn.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Master.EnableViewState = false;
//set the page heading
((SligoCS.Web.WI.WI)Page.Master).SetPageHeading("What is the drop out rate?");
_ds = _dropouts.GetDropoutData2();
_myTable = _ds._v_DropoutsWWoDisEconELPSchoolDistState;
GlobalValues.SQL = _dropouts.SQL;
SligoDataGrid2.DataSource = _ds;
SligoDataGrid2.DataBind();
SetVisibleColumns2(SligoDataGrid2, _ds, _dropouts.ViewBy, _dropouts.OrgLevel, _dropouts.CompareTo, GlobalValues.STYP);
SligoDataGrid2.AddSuperHeader(base.GetTitle("Dropout Rates", _dropouts));
set_state();
}
//protected override void SetVisibleColumns2(SligoDataGrid grid, DataSet ds, ViewByGroup viewBy, OrgLevel orgLevelKey, CompareToEnum compareTo, STYP schoolType)
//{
// base.SetVisibleColumns2(grid, ds, viewBy, orgLevelKey, compareTo, schoolType);
// //grid.SetBoundColumnVisible(_ds._v_DropoutsWWoDisEconELPSchoolDistState.District_NameColumn.ColumnName.Replace("_", " "), (compareTo == CompareToEnum.DISTSTATE));
// if ((compareTo == CompareToEnum.SELSCHOOLS) || (compareTo == CompareToEnum.CURRENTONLY))
// {
// //When user selects "Compare To = Selected Schools" the first column in the grid
// //should show the school name, but with no header.
// SligoDataGrid2.SetBoundColumnVisible(_ds._v_DropoutsWWoDisEconELPSchoolDistState.NameColumn.ColumnName, true);
// }
// else
// {
// SligoDataGrid2.SetBoundColumnVisible(_ds._v_DropoutsWWoDisEconELPSchoolDistState.NameColumn.ColumnName, false);
// }
//}
protected void SligoDataGrid2_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
v_DropoutsWWoDisEconELPSchoolDistState.v_DropoutsWWoDisEconELPSchoolDistStateDataTable _myTable
= _ds._v_DropoutsWWoDisEconELPSchoolDistState;
//decode the link to specific schools, so that it appears as a normal URL link.
int colIndex = SligoDataGrid2.FindBoundColumnIndex(_myTable.LinkedNameColumn.ColumnName);
e.Row.Cells[colIndex].Text = Server.HtmlDecode(e.Row.Cells[colIndex].Text);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _myTable.EnrollmentColumn.ColumnName, Constants.FORMAT_RATE_03);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _myTable.Students_expected_to_complete_the_school_termColumn.ColumnName, Constants.FORMAT_RATE_03);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _myTable.Students_who_completed_the_school_termColumn.ColumnName, Constants.FORMAT_RATE_03);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _myTable.Drop_OutsColumn.ColumnName, Constants.FORMAT_RATE_03);
SligoDataGrid2.SetCellToFormattedDecimal(e.Row, _myTable.Drop_Out_RateColumn.ColumnName, Constants.FORMAT_RATE_01_PERC);
SligoDataGrid2.SetOrgLevelRowLabels(GlobalValues, e.Row);
FormatHelper formater = new FormatHelper();
formater.SetRaceAbbr(SligoDataGrid2, e.Row, _myTable.RaceLabelColumn.ToString());
}
}
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;
}
}
