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