//------------------new ticket by it resource --------------------------//
public void NewWeeklyByResource()
{
ChartResource.Width = Unit.Percentage(100);
ChartResource.Height = Unit.Pixel(400);
ChartResource.CssClass = "chart";
ChartResource.PrimaryHeader.Text = "New IT Tickets (Last 12 Weeks)";
ChartResource.TooltipSettings.AxisMarkers.Enabled = true;
ChartResource.TooltipSettings.AxisMarkers.Mode = ChartXYMode.Y;
ChartResource.TooltipSettings.AxisMarkers.Width = new Unit(1);
ChartResource.TooltipSettings.AxisMarkers.ZIndex = 3;
ChartResource.Font.Size = 12;
ChartResource.Font.Bold = true;
ChartAxisX axisX = new ChartAxisX();
axisX.CategoricalValuesField = "label";
// axisX.CategoricalValues = label.ToArray();
//axisX.CategoricalValues = monthLabels;
ChartResource.Axes.Add(axisX);
ChartAxisY axisY = new ChartAxisY();
axisY.Title.Text = "# of New Tickets";
ChartResource.Axes.Add(axisY);
List <Tickets> datasource = new List <Tickets>();
ChartLineSeries splineSeriesNew = new ChartLineSeries();
splineSeriesNew.DataFieldY = "New";
splineSeriesNew.ID = "New Tickets";
splineSeriesNew.CollectionAlias = ddlResource.SelectedValue;
ChartResource.DataSeries.Add(splineSeriesNew);
List <int> newData = ScoreCardReports.Get12WeekNewByResource(ddlResource.SelectedValue);
List <string> label = ScoreCardReports.Get12WeekLabels();
for (int i = 0; i < newData.Count; i++)
{
datasource.Add(new Tickets()
{
New = newData[i], label = label[i]
});
}
ChartResource.DataSource = datasource;
//ChartResource.TakeDataSource += ChartResource_TakeDataSource;
NewWeekly.DataBind();
NewWeekly.Controls.Add(ChartResource);
}
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;
}
