/// <summary> /// Given the json blob name, this helper will return a line chart for the data in it. /// </summary> /// <param name="blobNames"></param> /// <param name="title">The title for the chart. If unspecified, the blobName will be used.</param> /// <param name="dataPointCount">The number of datapoints to show in the graph.</param> /// <param name="chartDimensions">The width/height of the chart</param> /// <returns></returns> public static DotNet.Highcharts.Highcharts GetLineChartFromBlobName(string[] blobNames, string title = null, int dataPointCount = 6, int chartDimensions = 300) { if (string.IsNullOrEmpty(title)) { title = blobNames[0]; } List <DotNet.Highcharts.Options.Series> seriesSet = new List <DotNet.Highcharts.Options.Series>(); List <string> xValues = new List <string>(); foreach (string blobName in blobNames) { List <Object> yValues = new List <Object>(); BlobStorageService.GetJsonDataFromBlob(blobName + ".json", out xValues, out yValues); //Retrive only the last N data points (To do : need to update this to retrieve the data for last N hours intead of N data points). if (xValues.Count > dataPointCount) { xValues.RemoveRange(0, xValues.Count - dataPointCount); yValues.RemoveRange(0, yValues.Count - dataPointCount); } seriesSet.Add(new DotNet.Highcharts.Options.Series { Data = new Data(yValues.ToArray()), Name = GetSanitizedTitleFromBlobName(blobName) }); } DotNet.Highcharts.Highcharts chart = ChartingUtilities.GetLineChart(seriesSet, xValues, title, chartDimensions); return(chart); }
public PartialViewResult GetCompanyStatusChart() { SimpleChartModel chartModel = new SimpleChartModel(); chartModel.ChartType = DotNet.Highcharts.Enums.ChartTypes.Pie; chartModel.ContainerId = "companyStatusChart"; chartModel.Title = "客户状态"; YSeries series = new YSeries(); series.YName = "数量"; chartModel.ValueSuffix = "个"; //读取公司的表,group by 销售名 OtaCrmModel db = new OtaCrmModel(); var ss = from i in db.OtaCompany where i.BusinessStatus != null group i by i.BusinessStatus into g select new { count = g.Count(), businessStatus = g.Key }; List <object[]> pieDataList = new List <object[]>(); foreach (var item in ss) { object[] pieData = new object[] { item.businessStatus, item.count }; pieDataList.Add(pieData); } chartModel.pieDataList = pieDataList; DotNet.Highcharts.Highcharts chart = GetPieChart(chartModel); return(PartialView("_PartialChartView", chart)); }
public ActionResult IndexPost() { var random = new Random(); var viewModel = new ComparisonViewModel(null); TryUpdateModel(viewModel); Series[] series; if (!viewModel.AllIndexes) { series = new[] { this.GetSeries(viewModel.Query, viewModel.FirstIndex, random, viewModel.NumberOfQueries, viewModel.Data), this.GetSeries(viewModel.Query, viewModel.SecondIndex, random, viewModel.NumberOfQueries, viewModel.Data), }; } else { series = Enum.GetValues(typeof(IndexEnum)).OfType <IndexEnum>() .Select(t => this.GetSeries(viewModel.Query, t, random, viewModel.NumberOfQueries, viewModel.Data)).ToArray(); } DotNet.Highcharts.Highcharts chart = this.GetChart(series, viewModel.Data); viewModel.Chart = chart; var report = (Session["report"] as List <ReportViewModel>) ?? new List <ReportViewModel>(); report.Add(new ReportViewModel(viewModel, series)); Session["report"] = report; return(View(viewModel)); }
public static DotNet.Highcharts.Highcharts GetBarChart(List<string> xValues, List<Object> yValues, string YAxisTitle, string chartTitle) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartTitle) .InitChart(new DotNet.Highcharts.Options.Chart { DefaultSeriesType = ChartTypes.Column }) .SetPlotOptions(new PlotOptions { Column = new PlotOptionsColumn { Stacking = Stackings.Normal, } }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray(), }); chart.SetSeries(new DotNet.Highcharts.Options.Series { Data = new Data(yValues.ToArray()), Name = YAxisTitle }); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = chartTitle }); return chart; }
public PartialViewResult GetCompanyCountChart() { SimpleChartModel chartModel = new SimpleChartModel(); chartModel.Height = 500; chartModel.ContainerId = "companyCountChart"; chartModel.Title = "客户数量"; chartModel.SeriesList = new List <YSeries>(); YSeries series = new YSeries(); series.YSeriesList = new List <object>(); series.YName = "数量"; chartModel.YTitle = DateTime.Today.ToString("yyyy-MM-dd"); chartModel.ValueSuffix = "个"; //读取公司的表,group by 销售名 OtaCrmModel db = new OtaCrmModel(); var ss = from i in db.OtaCompany group i by i.SalesUserName into g select new { count = g.Count(), userName = g.Key }; foreach (var item in ss) { chartModel.XList.Add(item.userName); series.YSeriesList.Add(item.count); } chartModel.SeriesList.Add(series); DotNet.Highcharts.Highcharts chart = GetChart(chartModel); return(PartialView("_PartialChartView", chart)); }
public ActionResult FundsChart() { var xDates = fundList.Select(i => i.fundDate.ToShortDateString()).ToArray(); var doublevals = fundList.Select(i => i.value).ToArray(); object[] serie = doublevals.Cast <object>().ToArray(); DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("Fundusz") .SetXAxis(new XAxis { Categories = xDates, TickInterval = 50, Labels = new XAxisLabels { Align = HorizontalAligns.Right, Rotation = -90 } }).SetTitle(new Title { Text = "Fundusz" }) .SetSeries(new Series { Name = "Wartość", Data = new Data(serie) }); return(View(chart)); }
public void Add(string key, string title, DotNet.Highcharts.Highcharts chart) { queue.Add(new QueueItem() { Key = key, Title = title, Data = chart, Type = QueueItem.types.chart }); }
public static DotNet.Highcharts.Highcharts GetBarChart(List <string> xValues, List <Object> yValues, string YAxisTitle, string chartTitle) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartTitle) .InitChart(new DotNet.Highcharts.Options.Chart { DefaultSeriesType = ChartTypes.Column }) .SetPlotOptions(new PlotOptions { Column = new PlotOptionsColumn { Stacking = Stackings.Normal, } }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray(), }); chart.SetSeries(new DotNet.Highcharts.Options.Series { Data = new Data(yValues.ToArray()), Name = YAxisTitle }); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = chartTitle }); return(chart); }
/// <summary> /// Returns a bar chart for a given set of values. /// </summary> /// <param name="seriesSet"></param> /// <param name="xValues"></param> /// <param name="title"></param> /// <returns></returns> public static DotNet.Highcharts.Highcharts GetBarChart(List <DotNet.Highcharts.Options.Series> seriesSet, List <string> xValues, string title) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = 320, Width = 320, DefaultSeriesType = ChartTypes.Column }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray() }); chart.SetLegend(new Legend { Enabled = false }); chart.SetSeries(seriesSet.ToArray()); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title.Replace("_", " ") }); return(chart); }
public PartialViewResult GetChart() { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart"); //初始化 DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart(); chartOption.DefaultSeriesType = DotNet.Highcharts.Enums.ChartTypes.Line; chartOption.Width = 400; chartOption.Height = 400; chart.InitChart(chartOption); //设置标题 DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title(); title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center; title.Text = "图表"; chart.SetTitle(title); //提示 DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip(); tooltip.ValueSuffix = "摄氏度"; chart.SetTooltip(tooltip); DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions(); plotOptions.Bar = new DotNet.Highcharts.Options.PlotOptionsBar(); plotOptions.Bar.DataLabels = new DotNet.Highcharts.Options.PlotOptionsBarDataLabels(); plotOptions.Bar.DataLabels.Enabled = true; chart.SetPlotOptions(plotOptions); //横坐标 DotNet.Highcharts.Options.XAxis xs = new DotNet.Highcharts.Options.XAxis { Categories = new[] { "jan", "feb" } }; List <string> cList = new List <string>(); cList.Add("jan"); cList.Add("feb"); xs.Categories = cList.ToArray(); xs.Title = new DotNet.Highcharts.Options.XAxisTitle(); xs.Title.Text = "月份"; chart.SetXAxis(xs); //纵坐标 DotNet.Highcharts.Options.YAxis ys = new DotNet.Highcharts.Options.YAxis(); ys.Title = new DotNet.Highcharts.Options.YAxisTitle(); ys.Title.Text = "温度"; chart.SetYAxis(ys); //设置表现值 DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series(); List <object> oList = new List <object>(); oList.Add(29); oList.Add(33); ss.Data = new DotNet.Highcharts.Helpers.Data(oList.ToArray()); ss.Name = "温度"; chart.SetSeries(ss); return(PartialView("_PartialChartView", chart)); }
protected void Page_Load(object sender, EventArgs e) { SalesOrderDataAccess db = new SalesOrderDataAccess(); var orders = db.GetAllOrders(); var customers = orders.Select(order => order.CustomerName).ToArray(); var netAmount = orders.Select(order => order.TotalSum).ToList(); var netTax = orders.Select(order => order.Tax).ToList(); List <object> amount = new List <object>(); List <object> tax = new List <object>(); List <object> categories = new List <object>(); netAmount.ForEach(delegate(decimal net) { amount.Add((object)net); }); netTax.ForEach(delegate(decimal net) { tax.Add((object)net); }); DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { Height = 300, Width = 600, DefaultSeriesType = ChartTypes.Line, ClassName = "chart" }) .SetTitle(new Title { Text = "Sales Orders By Company", X = -20 }) .SetXAxis(new XAxis { Categories = customers }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "In Dollars" }, }) .SetSeries(new Series[] { new Series { Name = "Amount", Data = new Data(amount.ToArray()) }, new Series { Name = "Tax", Data = new Data(tax.ToArray()) }, }); ltrChart.Text = chart.ToHtmlString(); }
public void SetGraph() { List <cstPackingTime> lsShipInfo = Obj.call.GetPackingTimeQuantity(); String[] Sarray = new string[lsShipInfo.Count]; object[] Times = new object[lsShipInfo.Count]; for (int i = 0; i <= lsShipInfo.Count - 1; i++) { Sarray[i] = lsShipInfo[i].ShippingNumber.ToString(); String s = lsShipInfo[i].TimeSpend.ToString(); String[] t = s.Split(new char[] { ':', 'H', 'S', 'M' }); String timess = t[2].Trim() + "." + t[4].Trim(); Decimal D = Convert.ToDecimal(timess); Times[i] = Math.Round(D, 2); } #region Graph DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { Type = ChartTypes.Line }) .SetTitle(new Title { Text = "Shipment packing Time" }) .SetXAxis(new XAxis { Categories = Sarray, Title = new XAxisTitle { Text = "Shipment Numbers" }, Min = 10 }) .SetLegend(new Legend { VerticalAlign = VerticalAligns.Bottom }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Time in (Min.Sec)" } }) .SetSeries(new Series { Data = new Data(Times), Name = "Time Taken" }); #endregion ltrChart.Text = chart.ToHtmlString(); }
public DotNet.Highcharts.Highcharts GetChart(SimpleChartModel chartModel) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartModel.ContainerId); //初始化 DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart(); chartOption.DefaultSeriesType = chartModel.ChartType; chartOption.Width = chartModel.Width; chartOption.Height = chartModel.Height; chart.InitChart(chartOption); //设置标题 DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title(); title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center; title.Text = chartModel.Title; chart.SetTitle(title); //提示 DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip(); tooltip.ValueSuffix = chartModel.ValueSuffix; chart.SetTooltip(tooltip); DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions(); plotOptions.Bar = new DotNet.Highcharts.Options.PlotOptionsBar(); plotOptions.Bar.DataLabels = new DotNet.Highcharts.Options.PlotOptionsBarDataLabels(); plotOptions.Bar.DataLabels.Enabled = true; chart.SetPlotOptions(plotOptions); //横坐标 DotNet.Highcharts.Options.XAxis xs = new DotNet.Highcharts.Options.XAxis(); xs.Categories = chartModel.XList.ToArray(); xs.Title = new DotNet.Highcharts.Options.XAxisTitle(); xs.Title.Text = chartModel.XTitle; chart.SetXAxis(xs); //纵坐标 DotNet.Highcharts.Options.YAxis ys = new DotNet.Highcharts.Options.YAxis(); ys.Title = new DotNet.Highcharts.Options.YAxisTitle(); ys.Title.Text = chartModel.YTitle; chart.SetYAxis(ys); //设置表现值 List <DotNet.Highcharts.Options.Series> ssList = new List <DotNet.Highcharts.Options.Series>(); foreach (YSeries yserires in chartModel.SeriesList) { DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series(); ss.Data = new DotNet.Highcharts.Helpers.Data(yserires.YSeriesList.ToArray()); ss.Name = yserires.YName; ssList.Add(ss); } chart.SetSeries(ssList.ToArray()); return(chart); }
public static DotNet.Highcharts.Highcharts GetPieChart(Series seriesSet, string title) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = 250, Width = 250, DefaultSeriesType = ChartTypes.Pie }); chart.SetSeries(seriesSet); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title }); return chart; }
public void GetChart(List <FundValue> datesList, List <decimal> fund, List <decimal> deposit) { ChartDataBuilder cdb = new ChartDataBuilder(); cdb.ProcessData(datesList.Select(x => x.fundDate).ToList(), fund, deposit); DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("Porownanie"); Series s1 = new Series { Data = cdb.FundData, Name = "Fundusz" }; Series s2 = new Series { Data = cdb.DepositData, Name = "Lokata" }; Series[] serie = new Series[2]; serie[0] = s1; serie[1] = s2; var startandstop = GetValidDate(datesList); int interval; if (startandstop.Count / 80 > 1) { interval = startandstop.Count / 80; } else { interval = 1; } var xlabels = cdb.ChartData.Select(x => x.Date.ToShortDateString()).ToArray(); chart.SetXAxis(new XAxis { Categories = xlabels, TickInterval = interval, Labels = new XAxisLabels { Align = HorizontalAligns.Right, Rotation = -90 } }).SetSeries(serie); chart.SetTitle(new Title { Text = "Porównanie lokaty i funduszu" }); Chart = chart; }
protected void Page_Load(object sender, EventArgs e) { SalesOrderDataAccess db = new SalesOrderDataAccess(); var orders = db.GetAllOrders(); var customers = orders.Select(order => order.CustomerName).ToArray(); var netAmount = orders.Select(order => order.TotalSum).ToList(); var netTax = orders.Select(order => order.Tax).ToList(); List<object> amount = new List<object>(); List<object> tax = new List<object>(); List<object> categories = new List<object>(); netAmount.ForEach(delegate(decimal net) { amount.Add((object)net); }); netTax.ForEach(delegate(decimal net) { tax.Add((object)net); }); DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { Height = 300, Width = 600, DefaultSeriesType = ChartTypes.Line, ClassName = "chart" }) .SetTitle(new Title { Text = "Sales Orders By Company", X = -20 }) .SetXAxis(new XAxis { Categories = customers }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "In Dollars" }, }) .SetSeries(new Series[] { new Series { Name = "Amount", Data = new Data(amount.ToArray()) }, new Series { Name = "Tax", Data = new Data(tax.ToArray()) }, }); ltrChart.Text = chart.ToHtmlString(); }
// GET: MonthReportsViewModels public ActionResult Index3() { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .SetXAxis(new XAxis { Categories = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" } }) .SetSeries(new Series { Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 }) }); return(View(chart)); }
public ActionResult Index() { var random = new Random(); var series = new[] { this.GetSeries(QueryEnum.FindNearestNeighbours, IndexEnum.gist, random, 4, DataEnum.countries), this.GetSeries(QueryEnum.FindNearestNeighbours, IndexEnum.rtree, random, 4, DataEnum.countries), }; DotNet.Highcharts.Highcharts chart = this.GetChart(series, DataEnum.countries); return(View(new ComparisonViewModel(chart))); }
public static DotNet.Highcharts.Highcharts GetPieChart(Series seriesSet, string title) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = 250, Width = 250, DefaultSeriesType = ChartTypes.Pie }); chart.SetSeries(seriesSet); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title }); return(chart); }
public PartialViewResult Vote(int pollID, int option) { // default userId to 1 for now Vote vote = new Vote() { PollID = pollID, ChoiceID = option, DateVoted = DateTime.Now, UserID = 2 }; repository.AddVote(vote); // get the count of all votes for the poll Dictionary <string, int> voteDict = new Dictionary <string, int>(); Poll poll = repository.Poll(pollID); foreach (var opt in poll.Options) { int count = repository.GetVotes(pollID, opt.OptionID); voteDict.Add(opt.Text.Replace("'", "\\\'"), count); } string[] keys = voteDict.OrderByDescending(x => x.Value).Select(x => x.Key).ToArray(); int[] values = voteDict.OrderByDescending(x => x.Value).Select(x => x.Value).ToArray(); // now we have the votes for each option DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .SetTitle(new DotNet.Highcharts.Options.Title { Text = poll.PollQuestion }) .SetXAxis(new DotNet.Highcharts.Options.XAxis { Categories = keys }) .SetSeries(new DotNet.Highcharts.Options.Series { Type = DotNet.Highcharts.Enums.ChartTypes.Bar, Name = "Votes", Data = new DotNet.Highcharts.Helpers.Data(Array.ConvertAll(values, x => (object)x)) }); //chart.SetTooltip(new DotNet.Highcharts.Options.Tooltip //{ // UseHTML = true, // HeaderFormat = "<span>Those who voted</span><table>", // PointFormat = "<tr><td style" //}); return(PartialView("_PollResults", chart)); }
public void SetGraph() { List <cstStationToatlPacked> _lsTotalPacekedPerStation = Obj.Rcall.GetStationTotalPaked(); gvStationInfo.DataSource = _lsTotalPacekedPerStation.ToList(); gvStationInfo.DataBind(); Series[] sr = new Series[_lsTotalPacekedPerStation.Count]; // chart Veriables String[] StationNames = new string[_lsTotalPacekedPerStation.Count]; for (int i = 0; i < _lsTotalPacekedPerStation.Count; i++) { sr[i] = new Series { Name = _lsTotalPacekedPerStation[i].StationName, Data = new Data(new object[] { _lsTotalPacekedPerStation[i].TotalPacked, _lsTotalPacekedPerStation[i].PartiallyPacked }) }; } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("Chart") .InitChart(new DotNet.Highcharts.Options.Chart { Type = ChartTypes.Bar, BackgroundColor = new BackColorOrGradient(System.Drawing.Color.White), Height = 400, }) .SetXAxis(new DotNet.Highcharts.Options.XAxis { Categories = (new string[] { "Packed", "Partially Packed" }), Title = new XAxisTitle { Text = "Packi", Style = "fontSize: '15px', fontFamily: 'Verdana', color: 'Black'" } }) .SetTitle(new Title { Text = "Station Information ", Style = "fontSize: '30px',fontFamily: 'Verdana', fontBold: 'true', color: 'Black' " }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Staion Names", Style = "fontSize: '15px', fontFamily: 'Verdana', color: 'Black'" }, }) .SetSeries(sr); ltrChart.Text = chart.ToHtmlString(); }
static void Main(string[] args) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .SetXAxis(new XAxis { Categories = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" } }) .SetSeries(new Series { Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 }) }); string text = chart.ToHtmlString(); System.IO.File.AppendAllText(@"C:\Users\Ben\Desktop\chart.html", text); }
protected void Render_Chart(string name) { string[] created_time = created_time1.Select(a => a).ToArray(); object[] _like = Array.ConvertAll(likes, x => (object)x); object[] _comments = Array.ConvertAll(Comments, x => (object)x); object[] _links = Array.ConvertAll(link, x => (object)x); Array.Reverse(created_time); Array.Reverse(_like); Array.Reverse(_comments); Array.Reverse(link); string sear = searchBox.Text; DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart").InitChart(new Chart { ZoomType = ZoomTypes.X, SpacingRight = 20, DefaultSeriesType = ChartTypes.Line }) .SetTitle(new Title { Text = "Instagram " + " for: " + UserName, X = -20 }) .SetSubtitle(new Subtitle { Text = "Click and drag in the plot area to zoom in ", X = -20 }).SetXAxis(new XAxis { Categories = new[] { ConvertToString(created_time) }, Labels = new XAxisLabels { Step = null } }) .SetSeries(new[] { new Series { Type = ChartTypes.Spline, Data = new Data(_like), Name = "likes:", }, new Series { Type = ChartTypes.Column, Data = new Data(_comments), Name = "comments:", }, } ); ltChart1.Text = chart.ToHtmlString(); ExportCSV.Visible = true; Result.Visible = true; }
public ActionResult AverageTimeTakenInMsTrendToday() { List <DotNet.Highcharts.Options.Series> seriesSet = new List <DotNet.Highcharts.Options.Series>(); List <string> value = new List <string>(); Dictionary <string, string> dict = BlobStorageService.GetDictFromBlob("IISRequestDetails" + String.Format("{0:MMdd}", DateTime.Now.AddDays(-1)) + ".json"); if (dict != null) { List <IISRequestDetails> requestDetails = new List <IISRequestDetails>(); Dictionary <string, List <object> > request = new Dictionary <string, List <object> >(); foreach (KeyValuePair <string, string> keyValuePair in dict) { value.Add(keyValuePair.Key.Substring(0, 2)); requestDetails = new JavaScriptSerializer().Deserialize <List <IISRequestDetails> >(keyValuePair.Value); foreach (IISRequestDetails scenarios in requestDetails) { if (scenarios.ScenarioName.Equals("Over all requests")) { continue; } if (request.ContainsKey(scenarios.ScenarioName)) { request[scenarios.ScenarioName].Add(scenarios.AvgTimeTakenInMilliSeconds); } else { List <object> Yvalue = new List <object>(); Yvalue.Add(scenarios.AvgTimeTakenInMilliSeconds); request.Add(scenarios.ScenarioName, Yvalue); } } } foreach (KeyValuePair <string, List <object> > each in request) { seriesSet.Add(new DotNet.Highcharts.Options.Series { Data = new Data(each.Value.ToArray()), Name = each.Key.Replace(" ", "_") }); } } DotNet.Highcharts.Highcharts chart = ChartingUtilities.GetLineChart(seriesSet, value, "TodayAvgTimeInMsTrend", 500); return(PartialView("~/Views/Shared/PartialChart.cshtml", chart)); }
public DotNet.Highcharts.Highcharts GetPieChart(SimpleChartModel chartModel) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(chartModel.ContainerId); //初始化 DotNet.Highcharts.Options.Chart chartOption = new DotNet.Highcharts.Options.Chart(); chartOption.DefaultSeriesType = chartModel.ChartType; chartOption.Width = chartModel.Width; chartOption.Height = chartModel.Height; chart.InitChart(chartOption); //设置标题 DotNet.Highcharts.Options.Title title = new DotNet.Highcharts.Options.Title(); title.Align = DotNet.Highcharts.Enums.HorizontalAligns.Center; title.Text = chartModel.Title; chart.SetTitle(title); //提示 DotNet.Highcharts.Options.Tooltip tooltip = new DotNet.Highcharts.Options.Tooltip(); tooltip.ValueSuffix = chartModel.ValueSuffix; tooltip.PointFormat = "{point.name}: <b>{point.y}</b>"; chart.SetTooltip(tooltip); //饼图 DotNet.Highcharts.Options.PlotOptions plotOptions = new DotNet.Highcharts.Options.PlotOptions(); plotOptions.Pie = new DotNet.Highcharts.Options.PlotOptionsPie(); plotOptions.Pie.AllowPointSelect = true; plotOptions.Pie.Cursor = DotNet.Highcharts.Enums.Cursors.Pointer; plotOptions.Pie.ShowInLegend = true; plotOptions.Pie.DataLabels = new DotNet.Highcharts.Options.PlotOptionsPieDataLabels(); plotOptions.Pie.DataLabels.Enabled = true; plotOptions.Pie.DataLabels.Format = "<b>{point.name}</b>: {point.y}个"; chart.SetPlotOptions(plotOptions); //设置表现值 List <DotNet.Highcharts.Options.Series> ssList = new List <DotNet.Highcharts.Options.Series>(); DotNet.Highcharts.Options.Series ss = new DotNet.Highcharts.Options.Series(); ss.Type = DotNet.Highcharts.Enums.ChartTypes.Pie; ss.Name = chartModel.Title; ss.Data = new DotNet.Highcharts.Helpers.Data(chartModel.pieDataList.ToArray()); ssList.Add(ss); chart.SetSeries(ssList.ToArray()); return(chart); }
public static DotNet.Highcharts.Highcharts GetLineChart(List<DotNet.Highcharts.Options.Series> seriesSet, List<string> xValues, string title,int dimensions=300) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = dimensions, Width = dimensions }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray() }); chart.SetSeries(seriesSet.ToArray()); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title }); return chart; }
public ActionResult FundsChart(string val) { string[] dates = val.Split('-'); DateTime startDate = DateTime.ParseExact(dates[0], "MM/dd/yyyy ", CultureInfo.InvariantCulture); DateTime stopDate = DateTime.ParseExact(dates[1], " MM/dd/yyyy", CultureInfo.InvariantCulture); var cutList = from FundVal in fundList where FundVal.fundDate >= startDate && FundVal.fundDate <= stopDate select FundVal; List <FundValue> trimList = cutList.ToList(); var xDates = trimList.Select(i => i.fundDate.ToShortDateString()).ToArray(); var doublevals = trimList.Select(i => i.value).ToArray(); object[] serie = doublevals.Cast <object>().ToArray(); int interval; if (trimList.Count / 80 > 1) { interval = trimList.Count / 80; } else { interval = 1; } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("Fundusz") .SetXAxis(new XAxis { Categories = xDates, TickInterval = interval, Labels = new XAxisLabels { Align = HorizontalAligns.Right, Rotation = -90 } }).SetTitle(new Title { Text = "Fundusz" }) .SetSeries(new Series { Name = "Wartość", Data = new Data(serie) }); return(View(chart)); }
public static DotNet.Highcharts.Highcharts GetAreaChart(List<DotNet.Highcharts.Options.Series> seriesSet, List<string> xValues, string title) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = 300, Width = 300, DefaultSeriesType = ChartTypes.Area }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray() }); chart.SetSeries(seriesSet.ToArray()); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title }); return chart; }
public static DotNet.Highcharts.Highcharts GetLineChart(List <DotNet.Highcharts.Options.Series> seriesSet, List <string> xValues, string title, int dimensions = 300) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = dimensions, Width = dimensions }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray() }); chart.SetSeries(seriesSet.ToArray()); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title }); return(chart); }
public ActionResult Index2() { var itemSales = db.salesLineItem.GroupBy(s => s.item).Select(s => new { item = s.Key.name, sum = s.Sum(b => b.quantity) }); string[] namesOfItems = new string[10]; int i = 0; foreach (var itm in itemSales) { namesOfItems[i] = itm.item; i++; if (i == 10) { break; } } object[] sumOfItems = new object[10]; i = 0; foreach (var itm in itemSales) { sumOfItems[i] = itm.sum; i++; if (i == 10) { break; } } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart"); chart.SetXAxis(new XAxis { Categories = namesOfItems }); chart.SetSeries(new Series { Data = new Data(sumOfItems) }); return(View(chart)); }
public static DotNet.Highcharts.Highcharts GetAreaChart(List <DotNet.Highcharts.Options.Series> seriesSet, List <string> xValues, string title) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = 300, Width = 300, DefaultSeriesType = ChartTypes.Area }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray() }); chart.SetSeries(seriesSet.ToArray()); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title }); return(chart); }
/// <summary> /// Creates the Html for a Chart using Restore data /// </summary> /// <returns></returns> public string RestoreByNuGetVersionChart() { string[] blobNames = { "Restore7Day.json", "Restore-Dependency7Day.json" }; List <string> xValues = new List <string>(); List <object> yValues = new List <Object>(); ReportHelpers.GetValuesFromBlobs(blobNames, StorageAccount, ContainerName, out xValues, out yValues); List <DotNet.Highcharts.Options.Series> seriesSet = new List <DotNet.Highcharts.Options.Series>(); seriesSet.Add(new DotNet.Highcharts.Options.Series { Data = new Data(yValues.ToArray()) }); DotNet.Highcharts.Highcharts installChart = ReportHelpers.GetBarChart(seriesSet, xValues, "Restores_Per_NuGet_Version"); string installChartHtml = installChart.ToHtmlString(); return(installChartHtml); }
private void loadSummaryPieChart() { queryString = "select count(*) as count, CASE greatest(Neutral,Happy,Sad,Angry,Surprised,Scared,Disgusted)" + " WHEN Neutral THEN 'Neutral'" + " WHEN Happy THEN 'Happy'" + " WHEN Sad THEN 'Sad'" + " WHEN Angry THEN 'Angry'" + " WHEN Surprised THEN 'Surprised'" + " WHEN Scared THEN 'Scared'" + " WHEN Disgusted THEN 'Disgusted'" + " else 'Unknown'" + " END AS maxColumn from alef.emotions where Student_id=" + studentId + " and Timestamp BETWEEN " + start + " AND " + end + " group by maxColumn;"; DataTable data = loadDatafromDB(queryString); var percentages = new List <object[]>(); double totalNumOfRecords = 0; foreach (DataRow dr in data.Rows) { totalNumOfRecords += Convert.ToDouble(dr["count"]); } foreach (DataRow dr in data.Rows) { double percentage = Math.Round((((Convert.ToDouble(dr["count"])) / totalNumOfRecords) * 100.0), 2); percentages.Add(new object[] { dr["maxColumn"].ToString(), percentage.ToString() }); } Title title = new DotNet.Highcharts.Options.Title(); title.Text = ""; DotNet.Highcharts.Highcharts chart2 = new DotNet.Highcharts.Highcharts("chart2").SetTitle(title); chart2.SetSeries(new Series { Type = DotNet.Highcharts.Enums.ChartTypes.Pie, Data = new Data(percentages.ToArray()) }); ltrChart2.Text = chart2.ToHtmlString(); }
public ActionResult CoinsCompare(String coins) { Series[] series = new Series[coins.Split(',').Length]; XAxis[] xAxises = new XAxis[coins.Split(',').Length]; for (int i = 0; i < coins.Split(',').Length; i++ ) { string coinId = coins.Split(',')[i]; var coin = CoinManager.GetCoin(Guid.Parse(coinId)); var coinDealHistories = CoinManager.GetCoinDealHistories(coin); String[] dealDates = new String[coinDealHistories.Count]; String[] dealPrices = new String[coinDealHistories.Count]; for (int j = 0; j < dealDates.Length; j++) { dealDates[j] = coinDealHistories[j].DealDate.ToString("yyyy-MM-dd"); dealPrices[j] = coinDealHistories[j].DealPrice.ToString(); } series[i] = new Series { Name = coin.Name + "," + coin.AppraisalInstitute + "," + coin.AppraisalScore, Data = new Data(dealPrices), XAxis = i }; xAxises[i] = new XAxis { Title = new XAxisTitle { Text = "拍卖日期" }, Categories = dealDates }; } DotNet.Highcharts.Highcharts coinHistoryDealChart = new DotNet.Highcharts.Highcharts("CoinHistoryDealChart") .SetTitle(new Title { Text = "拍卖价格波动表" }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "拍卖价格" } }) .SetXAxis(xAxises) .SetSeries(series); CoinViewModel coinView = new CoinViewModel(); coinView.coinHistoryDealChart = coinHistoryDealChart; return View(coinView); }
public PartialViewResult GetMeetCountChart() { SimpleChartModel chartModel = new SimpleChartModel(); chartModel.ContainerId = "meetChart"; chartModel.Title = "沟通频率"; chartModel.SeriesList = new List <YSeries>(); YSeries series = new YSeries(); series.YSeriesList = new List <object>(); series.YName = "次数"; chartModel.ValueSuffix = "次"; //读取meeting表,按照时间为上一周 DateTime startWeek = DateTime.Now.AddDays(1 - Convert.ToInt32(DateTime.Now.DayOfWeek.ToString("d"))); startWeek = startWeek.AddDays(-7); DateTime endWeek = startWeek.AddDays(6); chartModel.YTitle = startWeek.ToString("yyyyMMdd") + "-" + endWeek.ToString("yyyyMMdd"); OtaCrmModel db = new OtaCrmModel(); var ss = from i in db.CompanyMeeting where i.MeetDate >= startWeek && i.MeetDate <= endWeek group i by i.CreateUserName into g select new { count = g.Count(), userName = g.Key }; AccountController ac = new AccountController(); foreach (var item in ss) { chartModel.XList.Add(ac.GetRealName(item.userName)); series.YSeriesList.Add(item.count); } chartModel.SeriesList.Add(series); DotNet.Highcharts.Highcharts chart = GetChart(chartModel); return(PartialView("_PartialChartView", chart)); }
public ActionResult ThisWeek() { //Returns the chart for Average response for the last week string[] checkNames = new string[] { "feed.raw.packages.list", "package.restore.download", "package.restore.lookup", "feed.top.30.by.downloads" }; List <DotNet.Highcharts.Options.Series> seriesSet = new List <DotNet.Highcharts.Options.Series>(); List <string> xValues = new List <string>(); List <object> yValues = new List <object>(); foreach (string check in checkNames) { //Get the response values from pre-created blobs for each check. BlobStorageService.GetJsonDataFromBlob(check + "WeeklyReport.json", out xValues, out yValues); seriesSet.Add(new DotNet.Highcharts.Options.Series { Data = new Data(yValues.ToArray()), Name = check }); } DotNet.Highcharts.Highcharts chart = ChartingUtilities.GetLineChart(seriesSet, xValues, "AvgResponseTime", 600); return(PartialView("~/Views/Shared/PartialChart.cshtml", chart)); }
// GET: WebService public ActionResult Index() { var visualSitecoreService = new SitecoreWS.VisualSitecoreServiceSoapClient(); string database = "master"; SitecoreWS.Credentials credentials = new SitecoreWS.Credentials(); credentials.UserName = @"sitecore\admin"; credentials.Password = "******"; string homeItem = "{641783AA-0EF2-4117-9503-C5CEA36E32F3}"; string homeItem2 = "{180A9978-A7F5-4AF3-AEA3-7E4062177DAA}"; //string parentItem = "{C5384188-D4B4-4C09-A053-094271353190}"; var children = visualSitecoreService.GetChildren(homeItem2, database, credentials); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.LoadXml(children.ToString()); string xpath = "sitecore/item/@id"; var nodes = xmlDoc.SelectNodes(xpath); foreach (XmlNode childrenNode in nodes) { //childrenNode.Value var item = visualSitecoreService.GetItemFields(childrenNode.Value, "en", "1", true, database, credentials); //var getItem = sitecoreService.GetItemFields(getChildren.ChildNodes[i].Attributes[0].Value, "en", "1", true, database, myCred); } using (XmlReader reader = XmlReader.Create((new StringReader(children.ToString())))) { XDocument loaded = XDocument.Load(reader); var q = from c in loaded.Descendants("id") select (string)c.Value; foreach (string name in q) Console.WriteLine("Item name = {0}", name); } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .SetXAxis(new XAxis { Categories = new[] { "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" } }) .SetSeries(new Series { Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 }) }); return View(chart); //string parentId = "{37F01BDF-AAF4-4C0C-87A0-CD26220F783D}"; //string templateId = "{1D7ADB59-3AB0-4131-93AB-AADE26297D65}"; //while (true) //{ // Console.WriteLine("Sitecore Terminal Web Service Integration"); // Console.WriteLine("========================================="); // var children = visualSitecoreService.GetChildren(parentId, database, credentials); // using (System.Xml.XmlReader reader = // XmlReader.Create((new System.IO.StringReader(children.ToString())))) // { // XDocument loaded = XDocument.Load(reader); // var q = from c in loaded.Descendants("item") // select (string)c.Value; // Console.WriteLine("Number of added items in Sitecore = " + q.Count().ToString() + "" + Environment.NewLine); // foreach (string name in q) // Console.WriteLine("Item name = {0}", name); // Console.WriteLine(Environment.NewLine); // } // Console.WriteLine("=========================================" + // Environment.NewLine); // Console.WriteLine("Enter a name for the new Item:" + // Environment.NewLine); // string itemName = Console.ReadLine(); // var result = visualSitecoreService.AddFromTemplate(parentId, templateId, itemName, database, credentials); // Console.WriteLine("Item '" + itemName + "' is added."); // Console.WriteLine("Press key to continue"); // Console.ReadKey(); // Console.Clear(); // return View(); //} //} }
// // GET: /OldCoins/Details/5 public ActionResult Details(Guid id) { if (Request.Cookies["FYCoins"] != null) { if (Request.Cookies["FYCoins"]["RateUSD"] != null) { ViewBag.RateUSD = Request.Cookies["FYCoins"]["RateUSD"] == null ? "" : Request.Cookies["FYCoins"]["RateUSD"]; ViewBag.DealDate = Request.Cookies["FYCoins"]["DealDate"] == null ? "" : Request.Cookies["FYCoins"]["DealDate"]; ViewBag.DealCompany = Request.Cookies["FYCoins"]["DealCompany"] == null ? "" : Request.Cookies["FYCoins"]["DealCompany"]; } else { ViewBag.RateUSD = "6.2"; ViewBag.DealDate = ""; ViewBag.DealCompany = ""; } } else { ViewBag.RateUSD = "6.2"; ViewBag.DealDate = ""; ViewBag.DealCompany = ""; } var coin = CoinManager.GetCoin(id); var coinDealHistories = CoinManager.GetCoinDealHistories(coin); //var coinWithLastDealHistory = CoinManager.GetLastCoinDealHistory(coin); CoinViewModel coinViewModel = new CoinViewModel(CoinManager.GetCoinWithLastCoinDealHistory(id)); coinViewModel.coinDealHistories = coinDealHistories; coinViewModel.coinDealHistory = new CoinDealHistory(); String[] dealDates = new String[coinDealHistories.Count]; String[] dealPrices = new String[coinDealHistories.Count]; for (int i = 0; i < dealDates.Length; i++) { dealDates[i] = coinDealHistories[i].DealDate.ToString("yyyy-MM-dd"); dealPrices[i] = coinDealHistories[i].DealPrice.ToString(); } DotNet.Highcharts.Highcharts coinHistoryDealChart = new DotNet.Highcharts.Highcharts("CoinHistoryDealChart") .SetTitle(new Title { Text = "拍卖价格波动表" }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "拍卖价格" } }) .SetXAxis(new XAxis { Title = new XAxisTitle { Text = "拍卖日期" }, Categories = dealDates }) .SetSeries(new Series { Name = "拍卖价格", Data = new Data(dealPrices) }); coinViewModel.coinHistoryDealChart = coinHistoryDealChart; return View(coinViewModel); //return View(); }
protected void Page_Load(object sender, EventArgs e) { /* get data */ DataTable dt = PostOrmDB.GetTop10MentionKeyword(); var query = dt.AsEnumerable() .GroupBy(row => new { Text = row.Field<string>("keyword_value"), Keyword = row.Field<int>("KeywordId"), Senti = row.Field<int>("SentiLabel") }) .Select(grp => new { Text = grp.Key.Text, Keyword = grp.Key.Keyword, Senti = grp.Key.Senti, Count = grp.Count() }); List<string> ltext = new List<string>(); List<string> lkeyword = new List<string>(); List<int> lpos = new List<int>(); List<int> lnor = new List<int>(); List<int> lneg = new List<int>(); /* * get value of pos/nor/neg */ /* foreach (var senti in query) { if (!lkeyword.Contains(senti.Keyword.ToString())) { lkeyword.Add(senti.Keyword.ToString()); if (senti.Senti == 0 || senti.Senti == 1) { lneg.Add(senti.Count); } else{ lneg.Add(0); } if (senti.Senti == 2) { lnor.Add(senti.Count); } else{ lnor.Add(0); } if (senti.Senti == 3 || senti.Senti == 4) { lpos.Add(senti.Count); } else { lpos.Add(0); } } else { if (senti.Senti == 0 || senti.Senti == 1) { lneg[lneg.Count-1]=senti.Count; } if (senti.Senti == 2) { lnor[lnor.Count - 1] = senti.Count; } if (senti.Senti == 3 || senti.Senti == 4) { lpos[lpos.Count - 1] = senti.Count; } } } * */ foreach (var senti in query) { if (!ltext.Contains(senti.Text)) { ltext.Add(senti.Text); if (senti.Senti == 0 || senti.Senti == 1) { lneg.Add(senti.Count); } else { lneg.Add(0); } if (senti.Senti == 2) { lnor.Add(senti.Count); } else { lnor.Add(0); } if (senti.Senti == 3 || senti.Senti == 4) { lpos.Add(senti.Count); } else { lpos.Add(0); } } else { if (senti.Senti == 0 || senti.Senti == 1) { lneg[lneg.Count - 1] = senti.Count; } if (senti.Senti == 2) { lnor[lnor.Count - 1] = senti.Count; } if (senti.Senti == 3 || senti.Senti == 4) { lpos[lpos.Count - 1] = senti.Count; } } } List<string> lstr = new List<string>(); /* foreach (var item in lkeyword) { lstr.Add(item.ToString()); } */ foreach (var item in ltext) { lstr.Add(item); } //string[] o_keyword = lstr.ToArray(); string[] o_text = lstr.ToArray(); object[] o_neg = lneg.Cast<object>().ToArray(); object[] o_nor = lnor.Cast<object>().ToArray(); object[] o_pos = lpos.Cast<object>().ToArray(); /* Display chart * */ DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = DotNet.Highcharts.Enums.ChartTypes.Bar }) .SetTitle(new Title { Text = "Distribution of Top 10 Keywords In A Week" }) //.SetXAxis(new XAxis { Categories = o_keyword }) .SetXAxis(new XAxis { Categories = o_text }) .SetPlotOptions(new PlotOptions { Column = new PlotOptionsColumn { Stacking = Stackings.Normal } }) .SetSeries(new[] { new Series { Name = "Negative", Data = new Data(o_neg) }, new Series { Name = "Normal", Data = new Data(o_nor) }, new Series { Name = "Positive", Data = new Data(o_pos) } }); huyChart.Text = chart.ToHtmlString(); }
// GET: Relatorio public ActionResult Index() { /// Total de Contatos int i = 0; for (i = 0; i < db.Contatos.Count(); ) { i++; } ViewBag.Resultado = i; /// Total de Contatos Femininos int j = 0; foreach (var item in db.Contatos) { if (item.Feminino == true) { j++; } } ViewBag.Feminino = j; /// Total de Contatos Masculinos int k = 0; foreach (var item in db.Contatos) { if (item.Masculino == true) { k++; } } ViewBag.Masculino = k; /// Graficos de Contatos DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Column }) .SetTitle(new Title { Text = "Gráfico de Contatos" }) .SetXAxis(new XAxis { Categories = new[] { "Masculino", "Feminino", "Total"} }) .SetYAxis(new YAxis { Min = 0, Title = new YAxisTitle { Text = "Quatidade de Contatos" } }) .SetSeries(new Series { Data = new Data(new object[] { k, j, i }) }); ViewBag.grafico = chart; return View(); }
/// <summary> /// Returns a bar chart for a given set of values. /// </summary> /// <param name="seriesSet"></param> /// <param name="xValues"></param> /// <param name="title"></param> /// <returns></returns> public static DotNet.Highcharts.Highcharts GetBarChart(List<DotNet.Highcharts.Options.Series> seriesSet, List<string> xValues, string title) { DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(title); chart.InitChart(new Chart { Height = 320, Width = 320, DefaultSeriesType = ChartTypes.Column }); chart.SetXAxis(new XAxis { Categories = xValues.ToArray() }); chart.SetLegend(new Legend { Enabled = false }); chart.SetSeries(seriesSet.ToArray()); chart.SetTitle(new DotNet.Highcharts.Options.Title { Text = title.Replace("_", " ")}); return chart; }
public ActionResult Speed(int id = 0) { if (Session["user"] == null) return RedirectToAction("Login", "Account"); var results = servicio.ObtenerPosiciones(id).Select( a => new { a.fechaPosicion, a.velocidad, }); if (id <= 0 || results.Count() == 0) return new HttpStatusCodeResult(404, "No se ha encontrado la ruta de la Entidad de ID " + id + ". (¿Quizás fue eliminada?)"); var xData = results.Select(i => i.fechaPosicion.ToString("HH:mm:ss")).ToArray(); var yData = results.Select(i => new object[] { i.velocidad }).ToArray(); double average = Math.Round(servicio.ObtenerPosiciones(id).Average(r => r.velocidad), 2); object[] yDataAverage = new object[yData.Length]; Array.Copy(yData,0,yDataAverage,0,yData.Length); for (int i = 0; i < yDataAverage.Length; i++) { yDataAverage[i] = average; } TempData["idEntidad"] = id; var chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Line }) .SetTitle(new Title { Text = "Velocidad de Entidad" }) .SetXAxis(new XAxis { Categories = xData }) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Velocidad (Km/h)" } }) .SetTooltip(new Tooltip { Enabled = true, Formatter = @"function() { var text = ''; if(this.series.name == 'Velocidad') { text = '<b>'+ 'Velocidad: ' + '</b>' + this.y + ' Km/h<br/>' + '<b>'+ 'Hora: ' +'</b> '+ this.x; } else { text = '<b>'+ 'Velocidad: ' + '</b>' + this.y + ' Km/h<br/>'; } return text; }" }) .SetSeries(new[] { new Series {Name = "Velocidad", Data = new Data(yData)}, new Series {Name = "Velocidad promedio", Data = new Data(yDataAverage)}, }); return View(chart); }
protected void Calculate(object sender, EventArgs e) { double L,C,A; var mydata = new ArrayList(); ; /* if (Inductance.Text.Length > 0 && Capacitance.Text.Length > 0) { A = Convert.ToDouble(Inductance.Text) + Convert.ToDouble(Capacitance.Text); Answer.Text = A.ToString("0.000"); } else { Answer.Text = "Invalid Input"; } //Debug.Write("Calculate Pressed\n"); * * */ //s = Inductance.Text; //C = Double.TryParse(s, L); if (Double.TryParse(Inductance.Text, out L)) { } if( (Double.TryParse(Capacitance.Text,out C))&&(Double.TryParse(Inductance.Text, out L))) { //A = L + C; A = 1.0 / (6.2831853 * Math.Sqrt(L * C/1000)); Answer.Text = A.ToString("0.000") + " MHz"; for( int i = 0; i < 10; i++ ) { //mydata.Add(1.0 * i); mydata.Add( 1.0 / (6.2831853 * Math.Sqrt(L * C/1000 * 0.2 * (i+1)))); } } else { Answer.Text = "Invalid Input"; } DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart") .InitChart(new Chart { DefaultSeriesType = ChartTypes.Line, Height = 300, MarginRight = 130, //MarginBottom = 25, ClassName = "chart" }) .SetTitle(new Title { Text = "Resonant Frequency", X = -20 }) .SetXAxis(new XAxis { Categories = new[] { "20%","40%","60%","80%","100%","120%","140%","160%","180%","200%" }, //Categories = mydata; Title = new XAxisTitle {Text = "% Capacitance"}, Min = 0, Max = 9, //TickLength = 20, //TickWidth = 20, //MinTickInterval = 20 TickInterval = 1 } ) .SetYAxis(new YAxis { Title = new YAxisTitle { Text = "Frequency MHz" }, PlotLines = new [] { new YAxisPlotLines { Value = 0, Width = 1, //Color = ColorTranslator.FromHtml("808080") } } } ) .SetSeries(new Series { // Data = new Data(new object[] { 29.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, 95.6, 54.4 }) //Data = new Data(new object mydata); Data = new Data(new object[] { mydata[0], mydata[1], mydata[2], mydata[3], mydata[4], mydata[5],mydata[6], mydata[7], mydata[8], mydata[9]}) }); ltrChart.Text = chart.ToHtmlString(); }