private double GetMaxRateInResult(v_RetentionWWoDisEconELPSchoolDistState ds)
{
double maxRateInResult = 0;
foreach (DataRow row in ds.Tables[0].Rows)
{
try
{
if (Convert.ToDouble(
row[ds._v_RetentionWWoDisEconELPSchoolDistState.
Retention_RateColumn.ColumnName].ToString())
> maxRateInResult)
{
maxRateInResult = Convert.ToDouble
(row[ds._v_RetentionWWoDisEconELPSchoolDistState.
Retention_RateColumn.ColumnName].ToString());
}
}
catch
{
continue;
}
}
return(maxRateInResult);
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Master.EnableViewState = false;
base.PrepBLEntity(_retention);
//set the page heading
((SligoCS.Web.WI.WI)Page.Master).SetPageHeading(
"What percent of students did not advance to the next grade level?");
_ds = _retention.GetRetentionData2();
SetLinkChangeSelectedSchoolOrDistrict(ChangeSelectedSchoolOrDistrict);
SetVisibleColumns2(SligoDataGrid2, _ds, _retention.ViewBy,
_retention.OrgLevel, _retention.CompareTo, GlobalValues.STYP);
GlobalValues.SQL = _retention.SQL;
this.SligoDataGrid2.DataSource = _ds;
this.SligoDataGrid2.DataBind();
graphTitle = GetTitle("Retention Rate", _retention);
this.SligoDataGrid2.AddSuperHeader(graphTitle);
this.SligoDataGrid2.ShowSuperHeader = true;
if (base.GlobalValues.DETAIL != null &&
base.GlobalValues.DETAIL.ToString() == "NO")
{
this.SligoDataGrid2.Visible = false;
}
set_state();
setBottomLink(_retention);
////Notes: graph
GraphPanel.Visible = false;
if (CheckIfGraphPanelVisible(GraphPanel) == true)
{
SetUpChart(_ds);
}
//// graph
}
/// <summary>
/// Set up graph
/// </summary>
/// <param name="ds"></param>
private void SetUpChart(v_RetentionWWoDisEconELPSchoolDistState ds)
{
try
{
graphTitle = graphTitle.Replace("<br/>", "\n");
barChart.Title = graphTitle;
//Axis Y Settings
//int axisYStep = 1;
//int axisYMin = 0;
//int axisYMax = 10;
//ArrayList friendlyAxisYName = new ArrayList();
//GetAxisYSetting(ds, ref axisYStep, ref axisYMin,
// ref axisYMax, ref friendlyAxisYName);
//barChart.AxisYStep = axisYStep;
//barChart.AxisYMin = axisYMin;
//barChart.AxisYMax = axisYMax;
//barChart.FriendlyAxisYName = friendlyAxisYName;
barChart.MaxRateInResult = GetMaxRateInResult(ds);
if (_retention.ViewBy.Key == GroupKeys.All)
{
List <String> friendlyAxisXName = new List <String>();
friendlyAxisXName.Add("All Students");
barChart.FriendlyAxisXName = friendlyAxisXName;
}
barChart.AxisYDescription = "Retention Rate";
//Bind Data Source & Display
barChart.DisplayColumnName =
ds._v_RetentionWWoDisEconELPSchoolDistState.
Retention_RateColumn.ColumnName;
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
public v_RetentionWWoDisEconELPSchoolDistState GetRetentionData2()
{
List <int> schoolTypes = GetSchoolTypesList(this.SchoolType);
//create a bunch of Generics Lists, automatically populated with a 9 (the default value).
List <int> sexCodes, raceCodes, disabilityCodes, gradeCodes, econDisadvCodes, ELPCodes;
base.GetViewByList(ViewBy, OrgLevel, out sexCodes, out raceCodes,
out disabilityCodes, out gradeCodes, out econDisadvCodes, out ELPCodes);
Years = GetYearList(); // base.GetYearList();
_fullKeys = FullKeyUtils.GetFullKeysList(CompareTo, OrgLevel,
OrigFullKey, CompareToSchoolsOrDistrict, S4orALL);
bool useFullkeys = true; //
_clauseForCompareToSchoolsDistrict =
GetClauseForCompareToSchoolsDistrict(
OrigFullKey, S4orALL,
CompareTo, OrgLevel,
SCounty, SAthleticConf, SCESA, SRegion,
out useFullkeys);
DALRetention retention = new DALRetention();
v_RetentionWWoDisEconELPSchoolDistState ds = new v_RetentionWWoDisEconELPSchoolDistState();
List <string> orderBy = GetOrderByList(ds._v_RetentionWWoDisEconELPSchoolDistState,
CompareTo, OrigFullKey);
ds = retention.GetRetentionData2(
raceCodes, sexCodes, disabilityCodes, Years,
_fullKeys, gradeCodes,
schoolTypes, econDisadvCodes, ELPCodes,
_clauseForCompareToSchoolsDistrict,
useFullkeys,
orderBy);
this.sql = retention.SQL;
return(ds);
}
