protected override void GetGraphCategoriesAndDatasets()
{
var datasets = new List <FusionChartsDataset>();
var hoursInShift = new FusionChartsDataset {
Name = CultureManager.GetLabel("HS_EN_TURNO")
};
var hoursOutOfShift = new FusionChartsDataset {
Name = CultureManager.GetLabel("HS_FUERA_DE_TURNO")
};
foreach (var item in ReportObjectsList)
{
hoursInShift.addValue(item.HoursInShift.ToString(CultureInfo.InvariantCulture));
hoursOutOfShift.addValue(item.HoursOutOfShift.ToString(CultureInfo.InvariantCulture));
}
var categories = ReportObjectsList.Select(nivel => String.Format("{0} - {1}", nivel.Date.ToShortDateString(), nivel.Date.ToShortTimeString())).ToList();
datasets.Add(hoursOutOfShift);
datasets.Add(hoursInShift);
GraphCategories = categories;
GraphDataSet = datasets;
}
protected override string GetGraphXml()
{
using (var helper = new FusionChartsMultiSeriesHelper())
{
SetGraphConfiguration(helper);
var hoursInShift = new FusionChartsDataset {
Name = CultureManager.GetLabel("HS_EN_TURNO")
};
hoursInShift.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_EN_TURNO"));
var hoursOutOfShift = new FusionChartsDataset {
Name = CultureManager.GetLabel("HS_FUERA_DE_TURNO")
};
hoursOutOfShift.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_FUERA_DE_TURNO"));
hoursOutOfShift.SetPropertyValue("color", "1E90FF");
if (!ReportObjectsList.Any(d => !d.HoursInShift.Equals(0) || !d.HoursOutOfShift.Equals(0)))
{
return(helper.BuildXml());
}
foreach (var item in ReportObjectsList)
{
helper.AddCategory(item.Date.ToShortTimeString());
hoursInShift.addValue(item.HoursInShift.ToString(CultureInfo.InvariantCulture));
hoursOutOfShift.addValue(item.HoursOutOfShift.ToString(CultureInfo.InvariantCulture));
}
helper.AddDataSet(hoursInShift);
helper.AddDataSet(hoursOutOfShift);
return(helper.BuildXml());
}
}
/// <summary>
/// Generates the Datasets and Categories for the CSV.
/// </summary>
protected override void GetGraphCategoriesAndDatasets()
{
var datasets = new List <FusionChartsDataset>();
var consumos = new FusionChartsDataset {
Name = CultureManager.GetLabel("MOTORES")
};
foreach (var consumo in _motores)
{
consumos.addValue(consumo.VolumenConsumido.ToString(CultureInfo.InvariantCulture));
}
datasets.Add(consumos);
var niveles = new FusionChartsDataset {
Name = ddlTanque.SelectedItem.Text
};
foreach (var r in ReportObjectsList)
{
niveles.addValue(r.VolumenConsumido.ToString(CultureInfo.InvariantCulture));
}
datasets.Add(niveles);
var categories = ReportObjectsList.Select(nivel => String.Format("{0} - {1}", nivel.Fecha.ToShortDateString(), nivel.Fecha.ToShortTimeString())).ToList();
GraphCategories = categories;
GraphDataSet = datasets;
}
protected override string GetGraphXml()
{
using (var helper = new FusionChartsMultiSeriesHelper())
{
if (ReportObjectsList.Count <= 0)
{
throw new Exception("No se encontraron datos asociados a los filtros seleccionados!");
}
SetGraphProperties(helper);
AddDates(helper);
var maxTurnos = ReportObjectsList.Select(res => res.HsTurnos.Count).Max();
var colorGenerator = new ColorGenerator();
FusionChartsDataset niveles;
for (var i = 0; i < maxTurnos; i++)
{
niveles = new FusionChartsDataset();
niveles.SetPropertyValue("color", HexColorUtil.ColorToHex(colorGenerator.GetNextColor()));
foreach (var dia in ReportObjectsList)
{
if (dia.HsTurnos.Count > 1)
{
niveles.addValue(dia.HsTurnos.First().ToString(CultureInfo.InvariantCulture));
dia.HsTurnos.Remove(dia.HsTurnos.First());
niveles.addValue(dia.HsReales.First().ToString(CultureInfo.InvariantCulture));
dia.HsReales.Remove(dia.HsReales.First());
niveles.addValue("0");
}
else
if (dia.HsTurnos.Count == 1)
{
niveles.addValue("0");
niveles.addValue("0");
niveles.addValue("0");
}
}
helper.AddDataSet(niveles);
}
niveles = new FusionChartsDataset();
niveles.SetPropertyValue("color", HexColorUtil.ColorToHex(Color.Gray));
niveles.SetPropertyValue("seriesName", "Fuera de Turno");
foreach (var dia in ReportObjectsList)
{
niveles.addValue(dia.HsTurnos.First().ToString(CultureInfo.InvariantCulture));
niveles.addValue(dia.HsReales.First().ToString(CultureInfo.InvariantCulture));
niveles.addValue("0");
}
helper.AddDataSet(niveles);
return(helper.BuildXml());
}
}
protected override string GetGraphXml()
{
using (var helper = new FusionChartsMultiSeriesHelper())
{
SetGraphProperties(helper);
var teoricDataset = new FusionChartsDataset();
var realDataset = new FusionChartsDataset();
var labelInterval = (ReportObjectsList.Count / MaxLabels) + 1;
var i = labelInterval;
int resto;
Math.DivRem(Convert.ToInt32(npInterval.Value), 1440, out resto);
var printOnlyDate = resto.Equals(0);
teoricDataset.SetPropertyValue("seriesName", "Teórico");
realDataset.SetPropertyValue("seriesName", "Real");
realDataset.SetPropertyValue("color", "008ED6");
if (ReportObjectsList.Any(o => o.StockReal > 0 || o.StockTeorico > 0))
{
foreach (var consist in ReportObjectsList)
{
var str = String.Empty;
if (i == labelInterval)
{
str = printOnlyDate ? String.Format("{0}", consist.Fecha.ToShortDateString())
: String.Format("{0} - {1}", consist.Fecha.ToShortDateString(), consist.Fecha.ToShortTimeString());
i = 0;
}
i++;
helper.AddCategory(str);
teoricDataset.addValue(consist.StockTeorico.ToString(CultureInfo.InvariantCulture));
realDataset.addValue(consist.StockReal.ToString(CultureInfo.InvariantCulture));
}
}
if (chkTeorico.Checked)
{
helper.AddDataSet(teoricDataset);
}
if (chkReal.Checked)
{
helper.AddDataSet(realDataset);
}
var s = helper.BuildXml();
return(s);
}
}
protected override string GetGraphXml()
{
using (var helper = new FusionChartsMultiSeriesHelper())
{
if (ReportObjectsList.Count <= 0)
{
throw new Exception("No se encontraron datos asociados a los filtros seleccionados!");
}
if (!ReportObjectsList.Any(r => r.HsOff > 0 || r.HsOn > 0 || r.HsTurnoOff > 0 || r.HsTurnoOn > 0))
{
return(helper.BuildXml());
}
SetGraphProperties(helper);
var hsTurnoOn = new FusionChartsDataset();
hsTurnoOn.SetPropertyValue("color", "2E8B57");
hsTurnoOn.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_TURNO_ON"));
var hsTurnoOff = new FusionChartsDataset();
hsTurnoOff.SetPropertyValue("color", "FFD700");
hsTurnoOff.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_TURNO_OFF"));
var hsOn = new FusionChartsDataset();
hsOn.SetPropertyValue("color", "4876FF");
hsOn.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_ON"));
var hsOff = new FusionChartsDataset();
hsOff.SetPropertyValue("color", "B22222");
hsOff.SetPropertyValue("seriesName", CultureManager.GetLabel("HS_OFF"));
foreach (var result in ReportObjectsList)
{
helper.AddCategory(String.Format("{0}", result.Fecha.ToShortDateString()));
hsTurnoOn.addValue(result.HsTurnoOn.ToString(CultureInfo.InvariantCulture));
hsTurnoOff.addValue(result.HsTurnoOff.ToString(CultureInfo.InvariantCulture));
hsOn.addValue(result.HsOn.ToString(CultureInfo.InvariantCulture));
hsOff.addValue(result.HsOff.ToString(CultureInfo.InvariantCulture));
}
helper.AddDataSet(hsTurnoOn);
helper.AddDataSet(hsTurnoOff);
helper.AddDataSet(hsOn);
helper.AddDataSet(hsOff);
return(helper.BuildXml());
}
}
/// <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");
}
/// <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 tank level variation.
/// </summary>
/// <param name="helper"></param>
private void AddTankLevelVariation(FusionChartsMultiSeriesHelper helper)
{
var niveles = new FusionChartsDataset();
var labelInterval = (ReportObjectsList.Count / _MAX_LABELS) + 1;
var i = labelInterval;
int resto;
Math.DivRem(Convert.ToInt32(npIntervalo.Value), 1440, out resto);
var printOnlyDate = resto.Equals(0);
niveles.SetPropertyValue("seriesName", ddlTanque.SelectedItem.Text);
niveles.SetPropertyValue("color", HexColorUtil.ColorToHex(Color.SteelBlue));
if (ReportObjectsList.Any(o => o.VolumenConsumido > 0.01))
{
foreach (var nivel in ReportObjectsList)
{
var str = string.Empty;
if (i.Equals(labelInterval))
{
str = printOnlyDate ? String.Format("{0}", nivel.Fecha.ToShortDateString()) :
String.Format("{0} - {1}", nivel.Fecha.ToShortDateString(), nivel.Fecha.ToShortTimeString());
i = 0;
}
i++;
helper.AddCategory(str);
niveles.addValue(nivel.VolumenConsumido.ToString(CultureInfo.InvariantCulture));
}
}
helper.AddDataSet(niveles);
}
protected override void GetGraphCategoriesAndDatasets()
{
var avgConsumption = (from nivel in ReportObjectsList select nivel.Consumo).Average();
var consumos = new FusionChartsDataset
{
Name = string.Format("{0}: {1}lit", CultureManager.GetLabel("CONSUMO"), (int)avgConsumption)
};
var avgCaudal = (from nivel in ReportObjectsList select nivel.Caudal).Average();
var caudal = new FusionChartsDataset
{
Name = string.Format("{0}: {1}lit", CultureManager.GetLabel("CAUDAL"), (int)avgCaudal)
};
int resto;
Math.DivRem(Convert.ToInt32(npIntervalo.Value), 1440, out resto);
var printOnlyDate = resto.Equals(0);
var categories = ReportObjectsList.Select(nivel => printOnlyDate
? String.Format("{0}", nivel.Fecha.ToShortDateString())
: String.Format("{0} - {1}", nivel.Fecha.ToShortDateString(), nivel.Fecha.ToShortTimeString())).ToList();
foreach (var nivel in ReportObjectsList)
{
caudal.addValue(nivel.Caudal.ToString(CultureInfo.InvariantCulture));
}
foreach (var dia in ReportObjectsList)
{
consumos.addValue(dia.Consumo.ToString(CultureInfo.InvariantCulture));
}
GraphCategories = categories;
GraphDataSet = new List <FusionChartsDataset> {
caudal, consumos
};
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => t.Date.ToString("dd/MM"),
t => t.Max.ToString("0")));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => t.Fecha.ToShortDateString(),
t => (t.HsOff + t.HsOn + t.HsTurnoOff + t.HsTurnoOn).ToString(CultureInfo.InvariantCulture)));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => string.Format("{0:dd/MM}", t.Fecha),
t => (t.ElapsedTime / 3600).ToString(CultureInfo.InvariantCulture)));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => t.Date.ToString("dd/MM/yyyy HH:mm"),
t => (t.HoursInShift + t.HoursOutOfShift).ToString(CultureInfo.InvariantCulture)));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => String.Format("{0:dd/MM}", t.Dia),
t => t.Velocidad.ToString(CultureInfo.InvariantCulture)));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => DateTime.Parse(t.Fecha).TimeOfDay.ToString(),
t => t.Valor));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(st => st.Corner,
st => st.StoppedEvents.ToString("#0")));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => t.FechaHora.ToString("hh:mm:ss"),
t => t.Velocidad.ToString()));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => t.Empleado,
t => t.ElapsedTime.ToString(CultureInfo.InvariantCulture)));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => t.Interno,
t => t.Kilometers.ToString(CultureInfo.InvariantCulture)));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => t.Fecha.ToDisplayDateTime().ToString("HH:mm"),
t => t.Cantidad.ToString(CultureInfo.InvariantCulture)));
}
protected override Dictionary <string, string> GetExcelItemList()
{
return(ReportObjectsList.ToDictionary(t => string.Format("{0:dd/MM}", t.Fecha),
t => t.ElapsedTime.ToString()));
}
