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