public ActionResult ChartOrders() { Highcharts orders = new Highcharts("OrderID"); orders.SetTitle(new Title() { Text = Resources.Resource.OrdersRoma }); orders.SetYAxis(new YAxis { Title = new YAxisTitle() { Text = Resources.Resource.CountRoma }, }); //var ord = orderManager.GetQueryableOrders(); var drivers = userManager.GetQueryableDrivers(); //var res = ord.Join(drivers, x => x.DriverId, y => y.Id, (x, y) => new { Name = y.UserName, Orders = 1 }).GroupBy(x=>x.Name).ToList(); List<Series> series = new List<Series>(); List<object> serieData = new List<object>(); /*foreach (var i in res) { Series serie = new Series(); serie.Name = i.Key; serie.Type = ChartTypes.Column; serieData.Clear(); serieData.Add(i.Count()); serie.Data = new Data(serieData.ToArray()); series.Add(serie); }*/ orders.SetSeries(series.ToArray()); orders.SetLegend(new Legend() { Align = HorizontalAligns.Right, Layout = Layouts.Vertical, VerticalAlign = VerticalAligns.Top }); orders.SetPlotOptions(new PlotOptions() { Area = new PlotOptionsArea() { Stacking = Stackings.Normal } }); orders.SetCredits(new Credits() { Enabled = false }); ViewBag.Order = orders; return View(); }
private void GetAreaChart() { DashboardViewModel dashboard = new DashboardViewModel(); dashboard.ViewModelEvent += dashboard_ViewModelEvent; // Get statistics List<Dictionary<string, object>> values = dashboard.GetAreaChart(); if (values != null) { Highcharts areaChart = new Highcharts("areaChart"); areaChart.InitChart(new Chart() { DefaultSeriesType = ChartTypes.Area, BackgroundColor = new DotNet.Highcharts.Helpers.BackColorOrGradient(Color.Transparent), Height = 300 }); areaChart.SetPlotOptions(new PlotOptions() { Series = new PlotOptionsSeries() { ConnectNulls = true, ConnectEnds = true } }); areaChart.SetLegend(new DotNet.Highcharts.Options.Legend() { Align = DotNet.Highcharts.Enums.HorizontalAligns.Center, Layout = DotNet.Highcharts.Enums.Layouts.Horizontal, VerticalAlign = DotNet.Highcharts.Enums.VerticalAligns.Bottom, BorderWidth = 0 }); areaChart.SetCredits(new DotNet.Highcharts.Options.Credits() { Enabled = false }); areaChart.SetTitle(new DotNet.Highcharts.Options.Title() { Text = "" }); YAxis yAxis = new YAxis(); yAxis.Title = new DotNet.Highcharts.Options.YAxisTitle() { Text = "" }; yAxis.Min = 0; XAxis xAxis = new XAxis(); xAxis.Categories = values[0].Keys.ToArray(); List<Series> seriesCollection = new List<Series>(); Series seriesUsers = new Series(); seriesUsers.Data = new DotNet.Highcharts.Helpers.Data(values[0].Values.ToArray()); seriesUsers.Name = "Users"; seriesCollection.Add(seriesUsers); Series seriesMailbox = new Series(); seriesMailbox.Data = new DotNet.Highcharts.Helpers.Data(values[1].Values.ToArray()); seriesMailbox.Name = "Mailbox"; seriesCollection.Add(seriesMailbox); if (StaticSettings.CitrixEnabled) { Series seriesCitrix = new Series(); seriesCitrix.Data = new DotNet.Highcharts.Helpers.Data(values[2].Values.ToArray()); seriesCitrix.Name = "Citrix"; seriesCollection.Add(seriesCitrix); } areaChart.SetXAxis(xAxis); areaChart.SetYAxis(yAxis); areaChart.SetSeries(seriesCollection.ToArray()); litAreaChart.Text = areaChart.ToHtmlString(); } else litAreaChart.Text = "Error populating chart."; }
public void DriversIncome() { //var DriversInc = orderManager.GetDriversIncome(); Highcharts driversIncomeChart = new Highcharts("driversChartId"); driversIncomeChart.SetTitle(new Title() { Text = Resources.Resource.DriversIncome }); driversIncomeChart.SetXAxis(new XAxis() { Title = new XAxisTitle() { Text = @Resources.Resource.Drivers }, Categories = new string[] {Resources.Resource.Info} }); driversIncomeChart.SetYAxis(new YAxis() { Title = new YAxisTitle() { Text = @Resources.Resource.IncomeUAH }}); List<Series> series = new List<Series>(); List<object> serieData = new List<object>(); Series serie = new Series(); /*foreach (ChartsColumnDTO item in DriversInc) { serie = new Series(); serie.Name = item.ColumnName; serie.Type = ChartTypes.Column; serieData.Clear(); serieData.Add(new object[] { item.Value }); serie.Data = new Data(serieData.ToArray()); series.Add(serie); };*/ driversIncomeChart.SetSeries(series.ToArray()); driversIncomeChart.SetLegend(new Legend() { Align = HorizontalAligns.Right, Layout = Layouts.Vertical, VerticalAlign = VerticalAligns.Top }); driversIncomeChart.SetPlotOptions(new PlotOptions() { Area = new PlotOptionsArea() { Stacking = Stackings.Normal } }); driversIncomeChart.SetCredits(new Credits() { Enabled = false }); ViewBag.DriversIncomeChart = driversIncomeChart; }
private void DorinTewst() { Queue<string> categoriesQueue = new Queue<string>(new string[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" }); for (int i = 0; i < DateTime.Now.Month; i++) { categoriesQueue.Enqueue(categoriesQueue.Dequeue()); } var categories = categoriesQueue.ToArray(); Highcharts chart = new Highcharts("FuelConsumptionID"); chart.SetTitle(new Title() { Text = Resources.Resource.FuelConsumDorin }); ///var list = orderManager.AnnualFuelConsumption(); List<object> obList = new List<object>(); /*foreach (var item in list) { var iut = (int)item; obList.Add((object)iut); }*/ chart.SetYAxis(new YAxis { Title = new YAxisTitle() { Text = Resources.Resource.FuleLDorin }, }); chart.SetXAxis(new XAxis { Title = new XAxisTitle() { Text = Resources.Resource.FuleMonthDorin }, Categories = categories }); List<Series> series = new List<Series>(); Series serie = new Series(); serie.Name = Resources.Resource.LetresDorin; serie.Type = ChartTypes.Column; //serie.Data = new Data(serieData.ToArray()); serie.Data = new Data(obList.ToArray()); series.Add(serie); chart.SetSeries(series.ToArray()); chart.SetLegend(new Legend() { Align = HorizontalAligns.Right, Layout = Layouts.Vertical, VerticalAlign = VerticalAligns.Top }); chart.SetPlotOptions(new PlotOptions() { Area = new PlotOptionsArea() { Stacking = Stackings.Normal } }); chart.SetCredits(new Credits() { Enabled = false }); ViewBag.Chart = chart; }