private void SetUpChart(DataSet ds)
{
try
{
barChart.Title = DataSetTitle;
barChart.AxisY.Step = 10;
barChart.AxisYMin = 0;
barChart.YAxisSuffix = String.Empty;
// if (GlobalValues.Group.Key == GroupKeys.All)
//{
List <String> friendlyAxisXName = new List <String>();
friendlyAxisXName.Add("All Students");
barChart.FriendlyAxisXNames = friendlyAxisXName;
// }
barChart.AxisYDescription = "Incidents per 1,000 Students";
//Bind Data Source & Display
barChart.DisplayColumnName = (GlobalValues.Weapon.Key == WeaponKeys.Yes)
? v_SuspExpIncidentsWWoDisSchoolDistState.WeaponDrugIncidentRate
: v_SuspExpIncidentsWWoDisSchoolDistState.NonWeaponDrugIncidentRate;
barChart.MaxRateInResult = GraphBarChart.GetMaxRateInColumn(ds.Tables[0], barChart.DisplayColumnName);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
public override void DataBindGraph(ChartFX.WebForms.Chart graph, DataSet ds)
{
DataTable tbl = ds.Tables[0];
if (GlobalValues.HighSchoolCompletion.Key == HighSchoolCompletionKeys.All)
{//Stacked Bar Chart
List <String> myCols = new List <string>();
myCols.Add(barChart.LabelColumnName);
myCols.Add(v_HSCWWoDisSchoolDistStateEconELP.Regular_Diplomas);
myCols.Add(v_HSCWWoDisSchoolDistStateEconELP.HSEDs);
myCols.Add(v_HSCWWoDisSchoolDistStateEconELP.Certificates);
tbl = GraphBarChart.RemoveUnusedColumns(tbl, myCols);
//ds.Tables[0].Columns[v_HSCWWoDisSchoolDistStateEconELP.Regular_Diplomas].ColumnName = "Regular Diploma";
//ds.Tables[0].Columns[v_HSCWWoDisSchoolDistStateEconELP.HSEDs].ColumnName = "HSED";
//ds.Tables[0].Columns[v_HSCWWoDisSchoolDistStateEconELP.Certificates]
}
base.DataBindGraph(graph, tbl.DataSet);
}
private void SetLevelSeriesLabelsOverrides(GraphBarChart barChart)
{
if (GlobalValues.WOW.Key == WOWKeys.WSASCombined)
{
barChart.OverrideSeriesLabels.Add("AdvancedWSAS", "Advanced WSAS");
barChart.OverrideSeriesLabels.Add("ProficientWSAS", "Proficient WSAS");
barChart.OverrideSeriesLabels.Add("BasicWSAS", "Basic WSAS");
barChart.OverrideSeriesLabels.Add("MinPerfWSAS", "MinPerf WSAS");
barChart.OverrideSeriesLabels.Add("NoWSAS", "No WSAS");
}
else
{
barChart.OverrideSeriesLabels.Add("Percent Advanced", "Advanced WKCE");
barChart.OverrideSeriesLabels.Add("Percent Proficient", "Proficient WKCE");
barChart.OverrideSeriesLabels.Add("Percent Basic", "Basic WKCE");
barChart.OverrideSeriesLabels.Add("Percent Minimal", "MinPerf WKCE");
barChart.OverrideSeriesLabels.Add("Percent Pre-Req Skill", "WAA-SwD");
barChart.OverrideSeriesLabels.Add("Percent Pre-Req Eng", "WAA-ELL");
barChart.OverrideSeriesLabels.Add("No WSAS Total", "No WSAS");
}
}
/// <summary>
/// Set up graph
/// </summary>
/// <param name="ds"></param>
private void SetUpChart(DataSet ds)
{
try
{
barChart.Title = DataSetTitle;
//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.LegendBox.ContentLayout = ChartFX.WebForms.ContentLayout.Center;
//barChart.LegendBox.PlotAreaOnly = false;
if (GlobalValues.Group.Key == GroupKeys.All)
{
List <String> friendlyAxisXName = new List <String>();
friendlyAxisXName.Add("All Students");
barChart.FriendlyAxisXNames = friendlyAxisXName;
}
barChart.AxisYDescription = "Truancy Rate";
barChart.DisplayColumnName = v_TruancySchoolDistState.Truancy_Rate;
barChart.MaxRateInResult = GraphBarChart.GetMaxRateInColumn(ds.Tables[0], barChart.DisplayColumnName);
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
private List <String> SetMeasuresForLevels(GraphBarChart barChart)
{
List <String> graphColumns = new List <String>();
if (GlobalValues.WOW.Key == WOWKeys.WKCE)
{
graphColumns.Add(v_WSAS.Percent_Advanced);
graphColumns.Add(v_WSAS.Percent_Proficient);
graphColumns.Add(v_WSAS.Percent_Basic);
graphColumns.Add(v_WSAS.Percent_Minimal);
graphColumns.Add(v_WSAS.Percent_PreReq_Eng);
graphColumns.Add(v_WSAS.Percent_PreReq_Skill);
graphColumns.Add(v_WSAS.No_WSAS_Total);
}
else// if (GlobalValues.WOW.Key == WOWKeys.WSASCombined)
{
graphColumns.Add(v_WSAS.AdvancedWSAS);
graphColumns.Add(v_WSAS.ProficientWSAS);
graphColumns.Add(v_WSAS.BasicWSAS);
graphColumns.Add(v_WSAS.MinPerfWSAS);
graphColumns.Add(v_WSAS.No_WSAS_Total);
}
return(graphColumns);
}
