protected void WeeklyChart_TakeDataSource(object sender, Shield.Web.UI.ChartTakeDataSourceEventArgs e) { String myLabel = ""; //Define datasource List <Tickets> datasource = new List <Tickets>(); //Get Data from SQL Stored Procs List <int> Open = ScoreCardReports.WeekGetNumberOfOpenTickets(Int32.Parse(ddlWeek.SelectedValue), Int32.Parse(ddlYear.SelectedValue)); List <int> New = ScoreCardReports.WeekGetNumberOfNewTickets(Int32.Parse(ddlWeek.SelectedValue), Int32.Parse(ddlYear.SelectedValue)); List <int> Closed = ScoreCardReports.WeekGetNumberOfClosedTickets(Int32.Parse(ddlWeek.SelectedValue), Int32.Parse(ddlYear.SelectedValue)); myLabel = "Week " + ddlWeek.SelectedValue + " of " + ddlYear.SelectedValue; datasource.Add(new Tickets() { Open = Open[0], New = New[0], Closed = Closed[0], label = myLabel }); //Databind WeeklyChart.DataSource = datasource; }
protected void Chart12MthAging_TakeDataSource(object sender, Shield.Web.UI.ChartTakeDataSourceEventArgs e) { //Define datasource List <Tickets> datasource = new List <Tickets>(); //Get Data from SQL Stored Procs List <int> agingData = ScoreCardReports.Get12WeekAgingTickets(); List <string> label = ScoreCardReports.Get12WeekLabels(); // Merge 3 arraylist data into multidimentional class array for (int i = 0; i < agingData.Count; i++) { datasource.Add(new Tickets() { Aging = agingData[i], label = label[i] }); } //Databind ChartAging.DataSource = datasource; }
protected void Chart12WkComparison_TakeDataSource(object sender, Shield.Web.UI.ChartTakeDataSourceEventArgs e) { //Define datasource List <Tickets> datasource = new List <Tickets>(); //Get Data from SQL Stored Procs List <int> closedData = ScoreCardReports.Week12GetNumberOfClosedTickets(); List <int> openData = ScoreCardReports.Week12GetNumberOfOpenTickets(); List <int> newData = ScoreCardReports.Week12GetNumberOfNewTickets(); List <string> label = ScoreCardReports.Get12WeekLabels(); // Merge 3 arraylist data into multidimentional class array for (int i = 0; i < closedData.Count; i++) { datasource.Add(new Tickets() { Open = openData[i], New = newData[i], Closed = closedData[i], label = label[i] }); } //Databind Chart12WkComparison.DataSource = datasource; }
protected void MonthDrillDown_TakeDataSource(object sender, Shield.Web.UI.ChartTakeDataSourceEventArgs e) { //Databind MonthPanel.DataSource = mthdrillDownDatasource; }
protected void WeekDrillDown_TakeDataSource(object sender, Shield.Web.UI.ChartTakeDataSourceEventArgs e) { //Databind TypePanel.DataSource = drillDownDatasource; }