protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", CultureManager.GetLabel("MAXIMAS_DIARIAS")); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "0"); helper.AddConfigEntry("showValues", "0"); helper.AddConfigEntry("numberSuffix", string.Empty); helper.AddConfigEntry("rotateNames", "1"); helper.AddConfigEntry("limitsDecimalPrecision", "0"); helper.AddConfigEntry("hoverCapSepChar", "-"); foreach (var t in ReportObjectsList) { var item = new FusionChartsItem(); item.AddPropertyValue("name", t.Date.ToString("dd/MM")); item.AddPropertyValue("hoverText", t.Max.ToString("0")); item.AddPropertyValue("value", t.Max.ToString("0")); helper.AddItem(item); } if (ReportObjectsList.Count.Equals(0)) { ThrowError("NO_MATCHES_FOUND"); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(DesdeHasta), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "km"); helper.AddConfigEntry("hoverCapSepChar", " - "); helper.AddConfigEntry("rotateNames", "1"); foreach (var kilometer in ReportObjectsList) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", kilometer.Interno.Replace('&', 'y')); item.AddPropertyValue("value", kilometer.Kilometers.ToString(CultureInfo.InvariantCulture)); item.AddPropertyValue("hoverText", kilometer.Interno.Replace('&', 'y')); helper.AddItem(item); } return(helper.BuildXml()); } }
private void InitializeGraph(FusionChartsHelper helper) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(VariacionTemperaturaCaption), ddlSubentidad.SelectedItem.Text, dtpFecha.SelectedDate, dtpFecha.SelectedDate.GetValueOrDefault().Subtract(TimeSpan.FromMinutes(npMinutes.Value)), dtpFecha.SelectedDate.GetValueOrDefault().AddMinutes(npMinutes.Value))); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "1"); helper.AddConfigEntry("showValues", "0"); var numberSuffix = string.Empty; if (Subentidad > 0) { var subentidad = DAOFactory.SubEntidadDAO.FindById(Subentidad); if (subentidad != null && subentidad.Sensor != null && subentidad.Sensor.TipoMedicion != null && subentidad.Sensor.TipoMedicion.UnidadMedida != null) { numberSuffix = subentidad.Sensor.TipoMedicion.UnidadMedida.Simbolo; } } helper.AddConfigEntry("numberSuffix", numberSuffix); helper.AddConfigEntry("rotateNames", "1"); helper.AddConfigEntry("limitsDecimalPrecision", "1"); helper.AddConfigEntry("hoverCapSepChar", "-"); var max = (((int)(_maxVal / 10)) + 1) * 10; var min = (((int)(_minVal / 10)) - 1) * 10; helper.AddConfigEntry("yAxisMaxValue", max > _maxVal ? max.ToString() : _maxVal.ToString()); helper.AddConfigEntry("yAxisMinValue", min < _minVal ? min.ToString() : _minVal.ToString()); }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(DesdeHasta), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "km"); helper.AddConfigEntry("hoverCapSepChar", " - "); helper.AddConfigEntry("rotateNames", "1"); foreach (var kilometer in ReportObjectsList) { var item = new FusionChartsItem(); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Reportes/Estadistica/MonthKilometers.aspx?Movil={1}&InitialDate={2}&FinalDate={3}&SoloEnRuta={4}", ApplicationPath, kilometer.Movil, dpDesde.SelectedDate.GetValueOrDefault().ToString(CultureInfo.InvariantCulture), dpHasta.SelectedDate.GetValueOrDefault().ToString(CultureInfo.InvariantCulture), chkEnCiclo.Checked))); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", kilometer.Interno.Replace('&', 'y')); item.AddPropertyValue("value", kilometer.Kilometers.ToString(CultureInfo.InvariantCulture)); item.AddPropertyValue("hoverText", kilometer.Interno.Replace('&', 'y')); helper.AddItem(item); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(DesdeHasta), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "hs"); helper.AddConfigEntry("hoverCapSepChar", " - "); helper.AddConfigEntry("rotateNames", "1"); foreach (var time in ReportObjectsList) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", time.Intern.Replace('&', 'y')); item.AddPropertyValue("value", time.ElapsedTime.ToString(CultureInfo.InvariantCulture)); var hours = TimeSpan.FromHours(time.ElapsedTime); item.AddPropertyValue("hoverText", string.Concat(time.Intern.Replace('&', 'y'), string.Format(" - {0}dd {1}hh {2}mm {3}ss", hours.Days, hours.Hours, hours.Minutes, hours.Seconds))); helper.AddItem(item); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(DesdeHasta), dpDesde.SelectedDate.GetValueOrDefault().ToString("dd/MM/yyyy HH:mm"), dpHasta.SelectedDate.GetValueOrDefault().ToString("dd/MM/yyyy HH:mm"))); helper.AddConfigEntry("decimalPrecision", "1"); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("hoverCapSepChar", " - "); helper.AddConfigEntry("rotateNames", "1"); foreach (var checkout in ReportObjectsList) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", checkout.Fecha.ToDisplayDateTime().ToString("HH:mm")); item.AddPropertyValue("value", checkout.Cantidad.ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } return(helper.BuildXml()); } }
/// <summary> /// Gets graph xml definition based on the report data. /// </summary> /// <returns></returns> protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", CultureManager.GetLabel(MaximasDiarias)); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "km/h"); helper.AddConfigEntry("hoverCapSepChar", " -"); helper.AddConfigEntry("rotateNames", "1"); foreach (var speed in ReportObjectsList) { var item = new FusionChartsItem(); if (!speed.Dia.DayOfWeek.Equals(DayOfWeek.Saturday) & !speed.Dia.DayOfWeek.Equals(DayOfWeek.Sunday)) { item.AddPropertyValue("color", "008ED6"); } item.AddPropertyValue("name", speed.Dia.ToString("dd/MM")); item.AddPropertyValue("value", speed.Velocidad.ToString("#0")); item.AddPropertyValue("hoverText", string.Concat(CultureManager.GetLabel(Dia), string.Format(" {0:dd/MM/yyyy}", speed.Dia), " - ", CultureManager.GetLabel("ALCANZADA_POR"), " ", speed.CometidoPor)); helper.AddItem(item); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { var desde = dtFechaDesde.SelectedDate != null?SecurityExtensions.ToDataBaseDateTime(dtFechaDesde.SelectedDate.Value) : new DateTime(); var hasta = desde.AddMonths(1).AddSeconds(-1); helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), desde.ToDisplayDateTime(), hasta.ToDisplayDateTime())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); _dias.Clear(); var diasMes = GetDiasMes(desde.ToDisplayDateTime().Month, desde.ToDisplayDateTime().Year); for (var i = 0; i < diasMes; i++) { var fechaDesde = desde.AddDays(i).AddSeconds(-1); var fechaHasta = fechaDesde.AddDays(1); var dm = DAOFactory.DatamartDAO.GetSummarizedDatamart(fechaDesde, fechaHasta, cbVehiculo.Selected); var litrosConsumidos = dm.Consumo; var kmRecorridos = dm.Kilometros; var hsEnMarcha = dm.HsMarcha; var litrosXKm = litrosConsumidos > 0.0 && kmRecorridos > 0.0 ? litrosConsumidos / kmRecorridos : 0; var litrosXHora = litrosConsumidos > 0.0 && hsEnMarcha > 0.0 ? litrosConsumidos / hsEnMarcha : 0; _dias.Add((i + 1) + "/" + desde.ToDisplayDateTime().ToString("MM/yyyy"), new[] { litrosXHora, litrosXKm }); } foreach (var pair in _dias) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", pair.Key.Split('/')[0]); item.AddPropertyValue("value", pair.Value[1].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); item = new FusionChartsItem(); item.AddPropertyValue("color", "FF5904"); item.AddPropertyValue("value", pair.Value[0].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } lblLitrosXKm.Text = CultureManager.GetLabel("LITROS_X_KM"); lblLitrosXHora.Text = CultureManager.GetLabel("LITROS_X_HORA"); pnlInferior.Visible = true; return(helper.BuildXml()); } }
/// <summary> /// Adds configuration for the current report. /// </summary> /// <param name="helper"></param> private void AddConfiguration(FusionChartsHelper helper) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("HISTOGRAMA_DETENCIONES_CAPTION"), dpDesde.SelectedDate, dpHasta.SelectedDate)); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("hoverCapSepChar", "-"); helper.AddConfigEntry("rotateNames", "1"); helper.AddConfigEntry("numberSuffix", " detenciones"); helper.AddConfigEntry("decimalPrecision", "0"); }
/// <summary> /// Graph initialization. /// </summary> /// <param name="helper"></param> private void InitializeGraph(FusionChartsHelper helper) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("REP_HORAS_EXTRA_GRAPH"), dtpDesde.SelectedDate, dtpHasta.SelectedDate)); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("showValues", "0"); helper.AddConfigEntry("numberSuffix", "Hs"); helper.AddConfigEntry("hoverCapSepChar", "-"); helper.AddConfigEntry("rotateNames", "1"); }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { var desde = dtFechaDesde.SelectedDate != null?SecurityExtensions.ToDataBaseDateTime(dtFechaDesde.SelectedDate.Value) : new DateTime(); var hasta = dtFechaHasta.SelectedDate != null?SecurityExtensions.ToDataBaseDateTime(dtFechaHasta.SelectedDate.Value) : new DateTime(); helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), desde.ToDisplayDateTime(), hasta.ToDisplayDateTime())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); _despachos.Clear(); var despachos = GetResults(); for (var i = 0; i < despachos.Count; i++) { var totalCargado = despachos[i].Cantidad; var fechaHasta = i + 1 < despachos.Count ? despachos[i + 1].Fecha.ToDataBaseDateTime() : hasta; var totalDespachos = GetDespachos(despachos[i].Fecha.ToDataBaseDateTime(), fechaHasta); _despachos.Add(despachos[i].Fecha.ToString("dd/MM/yy HH:mm"), new[] { totalCargado, totalDespachos }); } foreach (var pair in _despachos) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", pair.Key); item.AddPropertyValue("value", pair.Value[0].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); item = new FusionChartsItem(); item.AddPropertyValue("color", "FF5904"); item.AddPropertyValue("value", pair.Value[1].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } lblLitrosCargados.Text = CultureManager.GetLabel("LITROS_CARGADOS"); lblLitrosDespachados.Text = CultureManager.GetLabel("LITROS_DESPACHADOS"); pnlInferior.Visible = true; return(helper.BuildXml()); } }
private string GetGraphXmlDias(DateTime fecha) { var desde = fecha.ToDataBaseDateTime(); var hasta = desde.AddMonths(1).AddSeconds(-1); using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), desde.ToDisplayDateTime(), hasta.ToDisplayDateTime())); helper.AddConfigEntry("xAxisName", "DIAS"); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); _dias.Clear(); var diasMes = GetDiasMes(desde.ToDisplayDateTime().Month, desde.ToDisplayDateTime().Year); for (var i = 0; i < diasMes; i++) { var fechaDesde = desde.AddDays(i).AddSeconds(-1); var fechaHasta = fechaDesde.AddDays(1); var valor = GetValorMedicion(fechaDesde, fechaHasta); _dias.Add((i + 1) + "/" + desde.ToDisplayDateTime().ToString("MM/yyyy"), valor); } var pb = new List <string>(); foreach (var pair in _dias) { var item = new FusionChartsItem(); item.AddPropertyValue("link", "javascript:a(" + pb.Count + ")"); pb.Add(ClientScript.GetPostBackEventReference(btnDia, "")); item.AddPropertyValue("color", "FF5904"); item.AddPropertyValue("name", pair.Key.Split('/')[0]); item.AddPropertyValue("value", pair.Value.ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } var script = "var pb =[" + string.Join(",", pb.Select(p => "\"" + p + "\"").ToArray()) + "]; function a(n) { document.getElementById('" + hidDia.ClientID + "').value = n; eval(pb[n]); }"; System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "a", script, true); return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { AddConfiguration(helper); foreach (var stoppedEvent in ReportObjectsList) { AddItem(helper, stoppedEvent); } return(helper.BuildXml()); } }
private void InitializeGraph(FusionChartsHelper helper) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(VariacionVelocidadCaption), ddlMovil.SelectedItem.Text, dtpFecha.SelectedDate, dtpFecha.SelectedDate.GetValueOrDefault().Subtract(TimeSpan.FromMinutes(npMinutes.Value)), dtpFecha.SelectedDate.GetValueOrDefault().AddMinutes(npMinutes.Value))); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "0"); helper.AddConfigEntry("showValues", "0"); helper.AddConfigEntry("numberSuffix", "Km/h"); helper.AddConfigEntry("rotateNames", "1"); helper.AddConfigEntry("limitsDecimalPrecision", "0"); helper.AddConfigEntry("hoverCapSepChar", "-"); }
/// <summary> /// Adds a daily kilometers refference trendline. /// </summary> /// <param name="helper"></param> /// <param name="vehicle"></param> private static void AddTrendline(FusionChartsHelper helper, Coche vehicle) { if (vehicle.KilometrosDiarios.Equals(0)) { return; } var trendline = new FusionChartsTrendline(); trendline.AddPropertyValue("startValue", Convert.ToInt32(vehicle.KilometrosDiarios).ToString("#0")); trendline.AddPropertyValue("displayValue", string.Format("{0}: {1}km", CultureManager.GetLabel(Refference), vehicle.KilometrosDiarios)); trendline.AddPropertyValue("color", "91C728"); trendline.AddPropertyValue("showOnTop", "1"); helper.AddTrendLine(trendline); }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { InitializeGraph(helper); var previousDateIndex = 0; //for saving last date putted in graph for (var i = 0; i < ReportObjectsList.Count; i++) { if (!ReportObjectsList[i].Velocidad.HasValue || ReportObjectsList[i].Velocidad < 0) { continue; } var item = new FusionChartsItem(); if (i == 0) { item.AddPropertyValue("name", ReportObjectsList[i].FechaHora.TimeOfDay.ToString()); ReportObjectsList[i].Hora = ReportObjectsList[i].FechaHora.ToString("hh:mm:ss"); } else if ((ReportObjectsList[previousDateIndex].FechaHora.Minute != ReportObjectsList[i].FechaHora.Minute) && ((i - previousDateIndex) > PointsDistance))//filters minimum distance between dates (points in graph) { item.AddPropertyValue("name", ReportObjectsList[i].FechaHora.TimeOfDay.ToString()); ReportObjectsList[i].Hora = ReportObjectsList[i].FechaHora.ToString("hh:mm:ss"); previousDateIndex = i; //saves the index of the most recently date putted in graph } item.AddPropertyValue("hoverText", ReportObjectsList[i].FechaHora.TimeOfDay.ToString()); item.AddPropertyValue("value", ReportObjectsList[i].Velocidad.ToString()); AddLink(item, i); helper.AddItem(item); } if (ReportObjectsList.Count.Equals(0)) { ThrowError("NO_MATCHES_FOUND"); } return(helper.BuildXml()); } }
/// <summary> /// Adds information about daily kilometers. /// </summary> /// <param name="helper"></param> /// <param name="stoppedEvent"></param> private void AddItem(FusionChartsHelper helper, MobileStoppedEvent stoppedEvent) { var item = new FusionChartsItem(); item.AddPropertyValue("name", stoppedEvent.Corner); item.AddPropertyValue("value", stoppedEvent.StoppedEvents.ToString("#0")); item.AddPropertyValue("hoverText", stoppedEvent.Corner); var desde = dpDesde.SelectedDate.GetValueOrDefault().ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture); var hasta = dpHasta.SelectedDate.GetValueOrDefault().ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Reportes/Estadistica/HistogramaDetenciones/HistogramaDetencionesDetalle.aspx?Vehiculos={1}&Desde={2}&Hasta={3}&Duracion={4}&Radio={5}&Latitud={6}&Longitud={7}", ApplicationPath, GetMobilesIdString(), desde, hasta, Convert.ToInt32(npDuracion.Value) , Convert.ToInt32(npRadio.Value), stoppedEvent.Latitude, stoppedEvent.Longitude))); helper.AddItem(item); }
/// <summary> /// Adds configuration for the current report. /// </summary> /// <param name="helper"></param> /// <param name="vehicle"></param> private void AddConfiguration(FusionChartsHelper helper, Coche vehicle) { var km = ReportObjectsList.Sum(d => d.Kilometers); helper.AddConfigEntry("caption", String.Format(CultureManager.GetLabel(MovilDesdeHasta), vehicle.Interno.Replace('&', 'y'), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString()) + km.ToString(" - 0.00 km") ); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "km"); helper.AddConfigEntry("hoverCapSepChar", "-"); helper.AddConfigEntry("rotateNames", "1"); }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { var vehicle = DAOFactory.CocheDAO.FindById(ddlMovil.Selected); AddConfiguration(helper, vehicle); foreach (var kilometer in ReportObjectsList) { AddItem(helper, kilometer); } AddTrendline(helper, vehicle); return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { InitializeGraph(helper); for (var i = 0; i < ReportObjectsList.Count; i++) { var item = new FusionChartsItem(); item.AddPropertyValue("name", ReportObjectsList[i].Interno.Replace('&', 'y')); item.AddPropertyValue("hoverText", ReportObjectsList[i].Interno.Replace('&', 'y')); item.AddPropertyValue("value", HoursValue(i)); helper.AddItem(item); } return(helper.BuildXml()); } }
/// <summary> /// Gets the graph XML file. /// </summary> /// <returns></returns> protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { var hs = ReportObjectsList.Sum(d => d.ElapsedTime); helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(MovilDesdeHasta), ddlMovil.SelectedItem.Text.Replace('&', 'y'), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString()) + TimeSpan.FromSeconds(hs).TotalHours.ToString(" - 0.00 hs") ); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "hs"); helper.AddConfigEntry("limitsDecimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", "-"); helper.AddConfigEntry("rotateNames", "1"); foreach (var timer in ReportObjectsList) { var item = new FusionChartsItem(); if (!timer.Fecha.DayOfWeek.Equals(DayOfWeek.Saturday) & !timer.Fecha.DayOfWeek.Equals(DayOfWeek.Sunday)) { item.AddPropertyValue("color", "008ED6"); } item.AddPropertyValue("name", String.Format("{0:dd/MM}", timer.Fecha)); item.AddPropertyValue("value", (timer.ElapsedTime / 3600.0).ToString(CultureInfo.InvariantCulture)); item.AddPropertyValue("hoverText", string.Concat(TimeSpan.FromSeconds(timer.ElapsedTime).ToString(), " ")); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Monitor/MonitorHistorico/monitorHistorico.aspx?Planta={1}&TypeMobile={2}&Movil={3}&InitialDate={4}&FinalDate={5}&Empresa={6}", ApplicationPath, ddlPlanta.Selected, ddlTipoVehiculo.Selected, ddlMovil.Selected, timer.Fecha.ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture), timer.Fecha.Add(new TimeSpan(23, 59, 59)).ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture), ddlDistrito.Selected))); helper.AddItem(item); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel(DesdeHasta), dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "hs"); helper.AddConfigEntry("hoverCapSepChar", " - "); helper.AddConfigEntry("rotateNames", "1"); if (ReportObjectsList.Select(r => r.ElapsedTime).Sum() == 0) { helper.AddConfigEntry("yAxisMaxValue", "24"); } foreach (var time in ReportObjectsList) { var item = new FusionChartsItem(); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Reportes/ControlDeAccesos/WorkedHours.aspx?Emp={1}&InitialDate={2}&FinalDate={3}", ApplicationPath, time.IdEmpleado, dpDesde.SelectedDate.GetValueOrDefault().ToString(CultureInfo.InvariantCulture), dpHasta.SelectedDate.GetValueOrDefault().ToString(CultureInfo.InvariantCulture)))); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", time.Empleado); item.AddPropertyValue("value", time.ElapsedTime.ToString(CultureInfo.InvariantCulture)); var hours = TimeSpan.FromHours(time.ElapsedTime); item.AddPropertyValue("hoverText", string.Concat(time.Empleado, string.Format(" - {0}dd {1}hh {2}mm {3}ss", hours.Days, hours.Hours, hours.Minutes, hours.Seconds))); helper.AddItem(item); } return(helper.BuildXml()); } }
/// <summary> /// Adds information about daily kilometers. /// </summary> /// <param name="helper"></param> /// <param name="kilometer"></param> private void AddItem(FusionChartsHelper helper, MobileKilometer kilometer) { var item = new FusionChartsItem(); if (!kilometer.Fecha.DayOfWeek.Equals(DayOfWeek.Saturday) & !kilometer.Fecha.DayOfWeek.Equals(DayOfWeek.Sunday)) { item.AddPropertyValue("color", "008ED6"); } item.AddPropertyValue("name", String.Format("{0:dd/MM}", kilometer.Fecha)); item.AddPropertyValue("value", kilometer.Kilometers.ToString(CultureInfo.InvariantCulture)); item.AddPropertyValue("hoverText", string.Format("{0:dd/MM/yyyy} ", kilometer.Fecha)); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Monitor/MonitorHistorico/monitorHistorico.aspx?Planta={1}&TypeMobile={2}&Movil={3}&InitialDate={4}&FinalDate={5}&Empresa={6}", ApplicationPath, ddlPlanta.Selected, ddlTipoVehiculo.Selected, ddlMovil.Selected, kilometer.Fecha.ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture), kilometer.Fecha.Add(new TimeSpan(23, 59, 59)).ToDataBaseDateTime().ToString(CultureInfo.InvariantCulture), ddlDistrito.Selected))); helper.AddItem(item); }
private string GetGraphXmlHoras(DateTime fecha) { var desde = fecha.ToDataBaseDateTime(); var hasta = desde.AddDays(1).AddSeconds(-1); using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), desde.ToDisplayDateTime(), hasta.ToDisplayDateTime())); helper.AddConfigEntry("xAxisName", "HORAS"); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); _horas.Clear(); for (var i = 0; i < 24; i++) { var fechaDesde = desde.AddHours(i).AddSeconds(-1); var fechaHasta = fechaDesde.AddHours(1); var valor = GetValorMedicion(fechaDesde, fechaHasta); _horas.Add(i.ToString("#0"), valor); } foreach (var pair in _horas) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "FF5904"); item.AddPropertyValue("name", pair.Key); item.AddPropertyValue("value", pair.Value.ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("EMPLEADO_DESDE_HASTA"), ddlEmpleado.SelectedItem.Text, dpDesde.SelectedDate.GetValueOrDefault().ToShortDateString(), dpHasta.SelectedDate.GetValueOrDefault().ToShortDateString())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("numberSuffix", "hs"); helper.AddConfigEntry("limitsDecimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", "-"); helper.AddConfigEntry("rotateNames", "1"); helper.AddConfigEntry("yAxisMaxValue", "24"); foreach (var timer in ReportObjectsList) { var item = new FusionChartsItem(); if (!timer.Fecha.DayOfWeek.Equals(DayOfWeek.Saturday) & !timer.Fecha.DayOfWeek.Equals(DayOfWeek.Sunday)) { item.AddPropertyValue("color", "008ED6"); } item.AddPropertyValue("name", String.Format("{0:dd/MM}", timer.Fecha)); item.AddPropertyValue("value", timer.ElapsedTime > 0 ? timer.ElapsedTime.ToString(CultureInfo.InvariantCulture) : "0.000001"); item.AddPropertyValue("hoverText", string.Concat(TimeSpan.FromHours(timer.ElapsedTime).ToString(), "hs ")); item.AddPropertyValue("link", Server.UrlEncode(string.Format( "n-{0}Reportes/ControlDeAccesos/AccessControl.aspx?Emp={1}&InitialDate={2}&FinalDate={3}", ApplicationPath, ddlEmpleado.Selected, timer.Fecha.ToString(CultureInfo.InvariantCulture), timer.Fecha.AddDays(1).ToString(CultureInfo.InvariantCulture)))); helper.AddItem(item); } return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), dtFecha.SelectedDate.HasValue ? dtFecha.SelectedDate.Value.ToShortDateString() : DateTime.MinValue.ToShortDateString(), dtFecha.SelectedDate.HasValue ? dtFecha.SelectedDate.Value.AddMonths(1).AddSeconds(-1).ToShortDateString() : DateTime.MinValue.ToShortDateString())); helper.AddConfigEntry("xAxisName", "MESES"); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); divChartDias.InnerHtml = ""; divChartHoras.InnerHtml = ""; _meses.Clear(); CargarAñoAnterior(); CargarMesAnterior(); CargarMesActual(); var pb = new List <string>(); foreach (var pair in _meses) { var item = new FusionChartsItem(); item.AddPropertyValue("link", "javascript:a(" + pb.Count + ")"); pb.Add(ClientScript.GetPostBackEventReference(btnMes, "")); var split = pair.Key.Split('/'); var key = GetMes(Convert.ToInt32(split[0])) + " " + split[1]; item.AddPropertyValue("color", "FF5904"); item.AddPropertyValue("name", key); item.AddPropertyValue("value", pair.Value.ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } var hasta = dtFecha.SelectedDate.HasValue ? dtFecha.SelectedDate.Value.AddMonths(1).AddSeconds(-1) : DateTime.MinValue; var now = DateTime.UtcNow; if (hasta.Year == now.Year && hasta.Month == now.Month && hasta > now) { var promedio = _meses[hasta.ToString("MM/yyyy")] / now.Day; var proyectado = promedio * GetDiasMes(hasta.Month, hasta.Year); var key = CultureManager.GetLabel("PROYECTADO") + " " + GetMes(Convert.ToInt32(hasta.Month)) + " " + hasta.Year; var item = new FusionChartsItem(); item.AddPropertyValue("color", "FAB802"); item.AddPropertyValue("name", key); item.AddPropertyValue("value", proyectado.ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } var script = "var pb =[" + string.Join(",", pb.Select(p => "\"" + p + "\"").ToArray()) + "]; function a(n) { document.getElementById('" + hidMes.ClientID + "').value = n; eval(pb[n]); }"; System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "a", script, true); return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { var desde = dtFechaDesde.SelectedDate != null?SecurityExtensions.ToDataBaseDateTime(dtFechaDesde.SelectedDate.Value) : new DateTime(); var hasta = dtFechaHasta.SelectedDate != null?SecurityExtensions.ToDataBaseDateTime(dtFechaHasta.SelectedDate.Value) : new DateTime(); helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), desde.ToDisplayDateTime(), hasta.ToDisplayDateTime())); helper.AddConfigEntry("xAxisName", XAxisLabel); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); _despachos.Clear(); var despachos = GetResults(); var vehiculo = DAOFactory.CocheDAO.FindById(cbVehiculo.Selected); var entidad = DAOFactory.EntidadDAO.FindByDispositivo(new[] { vehiculo.Empresa != null ? vehiculo.Empresa.Id : -1 }, new[] { vehiculo.Linea != null ? vehiculo.Linea.Id : -1 }, new[] { vehiculo.Dispositivo != null ? vehiculo.Dispositivo.Id : -1 }); var usaTelemetria = entidad != null && entidad.Id != 0; for (var i = 0; i < despachos.Count; i++) { var fecha = despachos[i].Fecha.ToString("dd/MM/yy HH:mm"); var totalDespacho = despachos[i].Cantidad; var fechaHasta = i + 1 < despachos.Count ? despachos[i + 1].Fecha : hasta; double totalConsumo; double km; double rendimiento; if (usaTelemetria) { totalConsumo = DAOFactory.DatamartDAO.GetSummarizedDatamart(despachos[i].Fecha, fechaHasta, cbVehiculo.Selected).Consumo; } else { km = DAOFactory.CocheDAO.GetDistance(vehiculo.Id, despachos[i].Fecha, fechaHasta); rendimiento = vehiculo.CocheOperacion != null && vehiculo.CocheOperacion.Rendimiento > 0.0 ? vehiculo.CocheOperacion.Rendimiento : vehiculo.Modelo != null ? vehiculo.Modelo.Rendimiento : 0.0; totalConsumo = km > 0 && rendimiento > 0 ? (km / 100.0) * rendimiento : 0.0; } while (totalConsumo == 0 && i + 1 < despachos.Count && despachos[i].Fecha.AddMinutes(5) > despachos[i + 1].Fecha) { fecha = despachos[i + 1].Fecha.ToString("dd/MM/yy HH:mm"); totalDespacho += despachos[i + 1].Cantidad; fechaHasta = i + 2 < despachos.Count ? despachos[i + 2].Fecha : hasta; if (usaTelemetria) { totalConsumo += DAOFactory.DatamartDAO.GetSummarizedDatamart(despachos[i + 1].Fecha, fechaHasta, cbVehiculo.Selected).Consumo; } else { km = DAOFactory.CocheDAO.GetDistance(vehiculo.Id, despachos[i + 1].Fecha, fechaHasta); rendimiento = vehiculo.CocheOperacion != null && vehiculo.CocheOperacion.Rendimiento > 0.0 ? vehiculo.CocheOperacion.Rendimiento : vehiculo.Modelo != null ? vehiculo.Modelo.Rendimiento : 0.0; totalConsumo += km > 0 && rendimiento > 0 ? (km / 100.0) * rendimiento : 0.0; } i++; } _despachos.Add(fecha, new[] { totalDespacho, totalConsumo }); } foreach (var pair in _despachos) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", pair.Key); item.AddPropertyValue("value", pair.Value[0].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); item = new FusionChartsItem(); var color = usaTelemetria ? "FF5904" : "FAB802"; item.AddPropertyValue("color", color); item.AddPropertyValue("value", pair.Value[1].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } lblLitrosCargados.Text = CultureManager.GetLabel("LITROS_CARGADOS"); lblLitros.Text = usaTelemetria ? CultureManager.GetLabel("LITROS_CONS") : CultureManager.GetLabel("LITROS_CALCULADOS"); tdLitros.BgColor = usaTelemetria ? "FF5904" : "FAB802"; pnlInferior.Visible = true; return(helper.BuildXml()); } }
private string GetGraphXmlDias(DateTime fecha) { var fechaSel = dtFechaDesde.SelectedDate.HasValue ? SecurityExtensions.ToDataBaseDateTime(dtFechaDesde.SelectedDate.Value) : DateTime.MinValue; var desde = fecha.ToDataBaseDateTime() < fechaSel ? fechaSel : fecha.ToDataBaseDateTime(); var fin = new DateTime(desde.Year, desde.Month, 1, 23, 59, 59).AddMonths(1).AddDays(-1).ToDataBaseDateTime(); var hasta = dtFechaHasta.SelectedDate.HasValue && fin > SecurityExtensions.ToDataBaseDateTime(dtFechaHasta.SelectedDate.Value) ? SecurityExtensions.ToDataBaseDateTime(dtFechaHasta.SelectedDate.Value) : fin; using (var helper = new FusionChartsHelper()) { helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), desde.ToDisplayDateTime(), hasta.ToDisplayDateTime())); helper.AddConfigEntry("xAxisName", "DIAS"); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); _dias.Clear(); while (desde.ToDisplayDateTime().Day < hasta.ToDisplayDateTime().Day) { fin = new DateTime(desde.Year, desde.Month, desde.Day, 23, 59, 59).ToDataBaseDateTime(); var valor = GetValorMedicion(desde, fin, cbVehiculo.Selected); var consumo = GetValorConsumo(desde, fin, cbVehiculo.Selected); var consumoCalculado = GetValorConsumoCalculado(desde, fin, cbVehiculo.Selected); _dias.Add(desde.ToDisplayDateTime().ToString("dd/MM/yyyy"), new[] { valor, consumo, consumoCalculado }); desde = fin.AddSeconds(1); } if (desde.ToDisplayDateTime().Day == hasta.ToDisplayDateTime().Day) { var valor = GetValorMedicion(desde, hasta, cbVehiculo.Selected); var consumo = GetValorConsumo(desde, hasta, cbVehiculo.Selected); var consumoCalculado = GetValorConsumoCalculado(desde, hasta, cbVehiculo.Selected); _dias.Add(desde.ToDisplayDateTime().ToString("dd/MM/yyyy"), new[] { valor, consumo, consumoCalculado }); } foreach (var pair in _dias) { var item = new FusionChartsItem(); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", pair.Key.Split('/')[0]); item.AddPropertyValue("value", pair.Value[1].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); item = new FusionChartsItem(); item.AddPropertyValue("color", "FF5904"); item.AddPropertyValue("value", pair.Value[0].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); item = new FusionChartsItem(); item.AddPropertyValue("color", "FAB802"); item.AddPropertyValue("value", pair.Value[2].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } lblLitrosCargados.Text = CultureManager.GetLabel("LITROS_CARGADOS"); lblLitrosConsumidos.Text = CultureManager.GetLabel("LITROS_CONS"); lblLitrosCalculados.Text = CultureManager.GetLabel("LITROS_CALCULADOS"); pnlInferior.Visible = true; return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { var desde = dtFechaDesde.SelectedDate != null?SecurityExtensions.ToDataBaseDateTime(dtFechaDesde.SelectedDate.Value) : new DateTime(); var hasta = dtFechaHasta.SelectedDate != null?SecurityExtensions.ToDataBaseDateTime(dtFechaHasta.SelectedDate.Value) : new DateTime(); helper.AddConfigEntry("caption", string.Format(CultureManager.GetLabel("DESDE_HASTA"), desde.ToDisplayDateTime(), hasta.ToDisplayDateTime())); helper.AddConfigEntry("xAxisName", "MESES"); helper.AddConfigEntry("yAxisName", YAxisLabel); helper.AddConfigEntry("decimalPrecision", "2"); helper.AddConfigEntry("hoverCapSepChar", " - "); divChartDias.InnerHtml = ""; _meses.Clear(); if (desde < hasta) { while (desde.ToDisplayDateTime().Month < hasta.ToDisplayDateTime().Month || desde.ToDisplayDateTime().Year < hasta.ToDisplayDateTime().Year) { var fin = new DateTime(desde.Year, desde.Month, 1, 23, 59, 59).AddMonths(1).AddDays(-1).ToDataBaseDateTime(); var valor = GetValorMedicion(desde, fin, cbVehiculo.Selected); var consumo = GetValorConsumo(desde, fin, cbVehiculo.Selected); var consumoCalculado = GetValorConsumoCalculado(desde, fin, cbVehiculo.Selected); _meses.Add(desde.ToDisplayDateTime().ToString("MM/yyyy"), new[] { valor, consumo, consumoCalculado }); desde = fin.AddSeconds(1); } if (desde.ToDisplayDateTime().Month == hasta.ToDisplayDateTime().Month&& desde.ToDisplayDateTime().Year == hasta.ToDisplayDateTime().Year) { var valor = GetValorMedicion(desde, hasta, cbVehiculo.Selected); var consumo = GetValorConsumo(desde, hasta, cbVehiculo.Selected); var consumoCalculado = GetValorConsumoCalculado(desde, hasta, cbVehiculo.Selected); _meses.Add(desde.ToDisplayDateTime().ToString("MM/yyyy"), new[] { valor, consumo, consumoCalculado }); } var pb = new List <string>(); foreach (var pair in _meses) { var item = new FusionChartsItem(); item.AddPropertyValue("link", "javascript:a(" + pb.Count + ")"); item.AddPropertyValue("color", "AFD8F8"); item.AddPropertyValue("name", pair.Key.Split('/')[0]); item.AddPropertyValue("value", pair.Value[1].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); item = new FusionChartsItem(); item.AddPropertyValue("link", "javascript:a(" + pb.Count + ")"); item.AddPropertyValue("color", "FF5904"); item.AddPropertyValue("value", pair.Value[0].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); item = new FusionChartsItem(); item.AddPropertyValue("link", "javascript:a(" + pb.Count + ")"); pb.Add(ClientScript.GetPostBackEventReference(btnMes, "")); item.AddPropertyValue("color", "FAB802"); item.AddPropertyValue("value", pair.Value[2].ToString(CultureInfo.InvariantCulture)); helper.AddItem(item); } var script = "var pb =[" + string.Join(",", pb.Select(p => "\"" + p + "\"").ToArray()) + "]; function a(n) { document.getElementById('" + hidMes.ClientID + "').value = n; eval(pb[n]); }"; System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "a", script, true); } lblLitrosCargados.Text = CultureManager.GetLabel("LITROS_CARGADOS"); lblLitrosConsumidos.Text = CultureManager.GetLabel("LITROS_CONS"); lblLitrosCalculados.Text = CultureManager.GetLabel("LITROS_CALCULADOS"); pnlInferior.Visible = true; return(helper.BuildXml()); } }
protected override string GetGraphXml() { using (var helper = new FusionChartsHelper()) { InitializeGraph(helper); var previousDateIndex = 0; //for saving last date putted in graph for (var i = 0; i < ReportObjectsList.Count; i++) { var item = new FusionChartsItem(); if (i == 0) { item.AddPropertyValue("name", ReportObjectsList[i].Fecha); } else { if ((DateTime.Parse(ReportObjectsList[previousDateIndex].Fecha).Minute != DateTime.Parse(ReportObjectsList[i].Fecha).Minute) && ((i - previousDateIndex) > PointsDistance)) //filters minimum distance between dates (points in graph) { item.AddPropertyValue("name", DateTime.Parse(ReportObjectsList[i].Fecha).TimeOfDay.ToString()); previousDateIndex = i; //saves the index of the most recently date putted in graph } } item.AddPropertyValue("hoverText", DateTime.Parse(ReportObjectsList[i].Fecha).TimeOfDay.ToString()); item.AddPropertyValue("value", ReportObjectsList[i].Valor.Replace(',', '.')); helper.AddItem(item); } if (Subentidad > 0) { var subentidad = DAOFactory.SubEntidadDAO.FindById(Subentidad); if (subentidad != null && subentidad.Sensor != null && subentidad.Sensor.TipoMedicion != null && subentidad.Sensor.TipoMedicion.ControlaLimites) { if (subentidad.ControlaMaximo) { var topInterval = new FusionChartsTrendline(); topInterval.AddPropertyValue("value", subentidad.Maximo.ToString(CultureInfo.InvariantCulture)); topInterval.AddPropertyValue("color", "ED1C24"); helper.AddTrendLine(topInterval); } if (subentidad.ControlaMinimo) { var lowInterval = new FusionChartsTrendline(); lowInterval.AddPropertyValue("value", subentidad.Minimo.ToString(CultureInfo.InvariantCulture)); lowInterval.AddPropertyValue("color", "579657"); helper.AddTrendLine(lowInterval); } } } if (ReportObjectsList.Count.Equals(0)) { ThrowError("NO_MATCHES_FOUND"); } return(helper.BuildXml()); } }