private void BuildChart(RadChart chart, DataTable seriesData) { // Handle Legend Labels chart.Series.Clear(); var nSeries = new ChartSeries(); var nSeries2 = new ChartSeries(); nSeries.Name = "School %"; nSeries2.Name = "District %"; chart.Legend.Appearance.ItemTextAppearance.AutoTextWrap = AutoTextWrap.False; //double minval = 100; //double maxval = 0; ChartAxisItemsCollection caic = new ChartAxisItemsCollection(); var year_list = new List<String>(); // Begin Experience tab foreach (DataRow dr in seriesData.Rows) { var myItem = new ChartSeriesItem(DataIntegrity.ConvertToDouble(dr["SuspensionRate"]), dr["LevelLabel"].ToString()) { Name = dr["SchoolYear"].ToString() }; if (String.IsNullOrEmpty(dr["SuspensionRate"].ToString())) myItem.Appearance.Visible = false; // hide bar and text if the value is null (no data) //myItem.Label.Appearance.LabelLocation = StyleSeriesItemLabel.ItemLabelLocation.Auto; if (dr["Level"].Equals("District")) { nSeries2.AddItem(myItem); } else { nSeries.AddItem(myItem); } year_list.Add(dr["SchoolYear"].ToString()); //if (minval > DataIntegrity.ConvertToDouble(dr["SuspensionRate"])) minval = DataIntegrity.ConvertToDouble(dr["SuspensionRate"]); //if (maxval < DataIntegrity.ConvertToDouble(dr["SuspensionRate"])) maxval = DataIntegrity.ConvertToDouble(dr["SuspensionRate"]); } foreach (var yl in year_list.Distinct()) { ChartAxisItem ai = new ChartAxisItem(); ai.TextBlock.Text = yl; caic.Add(ai); } chart.PlotArea.XAxis.AddItem(caic); chart.PlotArea.YAxis.MinValue = 0; //chart.PlotArea.YAxis.Step = (maxval - (minval - 5)) / 2; chart.PlotArea.YAxis.Step = 5; chart.PlotArea.YAxis.AutoScale = true; //chart.PlotArea.YAxis.MaxValue = maxval == 100 ? maxval : maxval + 5; //chart.PlotArea.YAxis.a = maxval == 100 ? maxval : maxval + 5; chart.Series.Add(nSeries); chart.Series.Add(nSeries2); chart.ChartTitle.Visible = false; chart.SetSkin("SuspensionRate"); }
protected void Page_Load(object sender, EventArgs e) { /******************************************************************* * If user does not have Icon_Expanded_Staff permissions, then hide * the "Advanced Search" link via its surrounding div tag. * ****************************************************************/ _level = (Thinkgate.Base.Enums.EntityTypes)Tile.TileParms.GetParm("level"); _levelID = DataIntegrity.ConvertToInt(Tile.TileParms.GetParm("levelID")); List<AsyncPageTask> taskList = new List<AsyncPageTask>(); taskList.Add(new AsyncPageTask(GetAttendRateForSchool)); foreach (AsyncPageTask page in taskList) { PageAsyncTask newTask = new PageAsyncTask(page.OnBegin, page.OnEnd, page.OnTimeout, "SchoolAttendance", true); Page.RegisterAsyncTask(newTask); } taskList = null; Page.ExecuteRegisteredAsyncTasks(); // Handle Legend Labels teacherCountChart.Series.Clear(); var nSeries = new ChartSeries(); var nSeries2 = new ChartSeries(); nSeries.Name = "School %"; nSeries2.Name = "District %"; //double minval = 100; //double maxval = 0; ChartAxisItemsCollection caic = new ChartAxisItemsCollection(); var year_list = new List<String>(); foreach (DataRow dr in countData.Rows) { var myItem = new ChartSeriesItem(DataIntegrity.ConvertToDouble(dr["AttendanceRate"]), dr["LevelLabel"].ToString()) { Name = dr["SchoolYear"].ToString() }; if (String.IsNullOrEmpty(dr["AttendanceRate"].ToString())) myItem.Appearance.Visible = false; // hide bar and text if the value is null (no data) if (dr["Level"].Equals("District")) { nSeries2.AddItem(myItem); } else { nSeries.AddItem(myItem); } year_list.Add(dr["SchoolYear"].ToString()); //if (minval > DataIntegrity.ConvertToDouble(dr["AttendanceRate"])) minval = DataIntegrity.ConvertToDouble(dr["AttendanceRate"]); //if (maxval < DataIntegrity.ConvertToDouble(dr["AttendanceRate"])) maxval = DataIntegrity.ConvertToDouble(dr["AttendanceRate"]); } foreach (var yl in year_list.Distinct()) { ChartAxisItem ai = new ChartAxisItem(); ai.TextBlock.Text = yl; caic.Add(ai); } teacherCountChart.PlotArea.XAxis.AddItem(caic); teacherCountChart.PlotArea.YAxis.MinValue = 0; teacherCountChart.PlotArea.YAxis.Step = 5; teacherCountChart.PlotArea.YAxis.MaxValue = 1; teacherCountChart.Series.Add(nSeries); teacherCountChart.Series.Add(nSeries2); teacherCountChart.ChartTitle.Visible = false; teacherCountChart.SetSkin("SchoolAttendanceRates"); }