public GaugeBO GetGauge(string sp, object[] filter) { try { IConsultantReader <object, GaugeBO> consultor = new ConsultantReader <object, GaugeBO>(); MapperManager <object, GaugeBO> mapper = FactoryTransformer.Create <object, GaugeBO>(); GaugeBO response = consultor.ConsultarProcedimientoObjArray(sp, ConnectionString, CommandType.StoredProcedure, filter, mapper); return(response); } catch (Exception ex) { throw ex; } }
private static Highcharts GaugeChart(MenuBO menu, object[] parameter) { GaugeBO gauge = Dal.GetGauge(menu.ProcedureName, parameter); #region Chart Highcharts chart = new Highcharts("chart" + menu.Oid) .InitChart(new Chart { Type = ChartTypes.Gauge, PlotBackgroundColor = null, PlotBackgroundImage = null, PlotBorderWidth = 0, PlotShadow = false }) .SetTitle(new Title { Text = menu.Title }) .SetPane(new Pane { StartAngle = -150, EndAngle = 150, Background = new[] { new BackgroundObject { BackgroundColor = new BackColorOrGradient(new Gradient { LinearGradient = new[] { 0, 0, 0, 1 }, Stops = new object[, ] { { 0, "#FFF" }, { 1, "#333" } } }), BorderWidth = new PercentageOrPixel(0), OuterRadius = new PercentageOrPixel(109, true) }, new BackgroundObject { BackgroundColor = new BackColorOrGradient(new Gradient { LinearGradient = new[] { 0, 0, 0, 1 }, Stops = new object[, ] { { 0, "#333" }, { 1, "#FFF" } } }), BorderWidth = new PercentageOrPixel(1), OuterRadius = new PercentageOrPixel(107, true) }, new BackgroundObject(), new BackgroundObject { BackgroundColor = new BackColorOrGradient(ColorTranslator.FromHtml("#DDD")), BorderWidth = new PercentageOrPixel(0), OuterRadius = new PercentageOrPixel(105, true), InnerRadius = new PercentageOrPixel(103, true) } } }) .SetYAxis(new YAxis { Min = 0, Max = gauge.ObjectiveValue, //MinorTickInterval = "auto", MinorTickWidth = 1, MinorTickLength = 10, MinorTickPosition = TickPositions.Inside, MinorTickColor = ColorTranslator.FromHtml("#666"), TickPixelInterval = 30, TickWidth = 2, TickPosition = TickPositions.Inside, TickLength = 10, TickColor = ColorTranslator.FromHtml("#666"), Labels = new YAxisLabels { Step = 2, //Rotation = "auto" }, Title = new YAxisTitle { Text = "Creditos" }, PlotBands = new[] { new YAxisPlotBands { From = 0, To = gauge.Range, Color = ColorTranslator.FromHtml("#DF5353") }, new YAxisPlotBands { From = gauge.Range, To = gauge.Range * 2, Color = ColorTranslator.FromHtml("#DDDF0D") }, new YAxisPlotBands { From = gauge.Range * 2, To = gauge.Range * 3, Color = ColorTranslator.FromHtml("#55BF3B") } } }) .SetSeries(new Series { Name = gauge.Descripcion, Data = new Data(new object[] { gauge.RealValue }) }); #endregion return(chart); }