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