private void GenerateColumns(BaseCsvBuilder builder)
{
builder.GenerateRow(String.Concat(Separator,
Separator,
Separator,
Separator,
CultureManager.GetLabel("TOTALES"),
Separator,
Separator,
Separator,
Separator,
CultureManager.GetLabel("INFRACCIONES")));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("CHOFER"), Separator,
CultureManager.GetLabel("LEGAJO"), Separator,
CultureManager.GetEntity("PARENTI37"), Separator,
CultureManager.GetEntity("PARENTI04"), Separator, Separator,
CultureManager.GetLabel("KILOMETROS"), Separator,
CultureManager.GetLabel("MOVIMIENTO"), Separator,
CultureManager.GetLabel("PUNTAJE"), Separator, Separator,
CultureManager.GetLabel("LEVES"), Separator,
CultureManager.GetLabel("MEDIAS"), Separator,
CultureManager.GetLabel("GRAVES"), Separator,
CultureManager.GetLabel("TOTALES"), Separator));
}
/// <summary>
/// Generates the CSV data of the Stadistic Iframe.
/// </summary>
/// <param name="builder"></param>
private void GenerateStadisticsColumns(BaseCsvBuilder builder)
{
if (Stadistics == null)
{
return;
}
var separator = Usuario.CsvSeparator;
builder.GenerateRow(CultureManager.GetLabel("DETALLE_VEHICULO"));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("RECORRIDO"), separator, CultureManager.GetLabel("TOTAL"), ":", Stadistics.KilometrosTotales, separator,
CultureManager.GetLabel("PROMEDIO_DIARIO"), ":", Stadistics.KilometrosPromedio, separator));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("DIAS"), separator, CultureManager.GetLabel("TOTALES"), ":", Stadistics.Dias, separator,
CultureManager.GetLabel("CON_ACTIVIDAD"), ":", Stadistics.DiasActivo, separator, CultureManager.GetLabel("SIN_ACTIVIDAD"), ":", Stadistics.Dias - Stadistics.DiasActivo, separator));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("VELOCIDAD"), separator, CultureManager.GetLabel("MAXIMA_ALCANZADA"), ":", Stadistics.VelocidadMaxima, separator,
CultureManager.GetLabel("PROMEDIO"), ":", Stadistics.VelocidadPromedio, separator));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("TIEMPOS"), separator, CultureManager.GetLabel("MOVIMIENTO"), ":", Stadistics.HorasMovimiento, separator,
CultureManager.GetLabel("DETENCION"), ":", Stadistics.HorasDetenido, separator, CultureManager.GetLabel("SIN_REPORTAR"), ":", Stadistics.HorasSinReportar, separator));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("INFRACCIONES"), separator, CultureManager.GetLabel("CANTIDAD"), ":", Stadistics.Infracciones, separator,
CultureManager.GetLabel("TIEMPO"), ":", Stadistics.HsInfraccion, separator));
builder.GenerateRow("");
}
private void GenerateCsvHeader(BaseCsvBuilder builder)
{
var param = new Dictionary <string, string>
{
{ CultureManager.GetEntity("PARENTI01"), ddlDistrito.SelectedItem.Text },
{ CultureManager.GetEntity("PARENTI02"), GetSelectedBases() }
};
builder.GenerateHeader(CultureManager.GetMenu("ACC_RANKING_TRANSPORTISTAS"), param,
dpDesde.SelectedDate.GetValueOrDefault(), dpHasta.SelectedDate.GetValueOrDefault());
}
/// <summary>
/// Generates the sub-columns Programado,Manual y Automatico
/// </summary>
/// <param name="csv"></param>
private void GenerateCSVSubColumns(BaseCsvBuilder csv)
{
var separator = Usuario.CsvSeparator;
var subheaders = string.Concat(separator, separator, separator, separator);
for (var i = _PRIMER_ESTADO; i < Grid.Columns.Count; i += 3)
{
subheaders = String.Concat(subheaders, "Programado", separator, "Manual", separator, "Dif.Manual", separator, "Automatico", separator, "Dif.Automatico", separator);
}
csv.GenerateRow(subheaders);
}
private void GenerateColumns(BaseCsvBuilder builder)
{
builder.GenerateRow(String.Concat(CultureManager.GetEntity("PARENTI07"), Separator,
CultureManager.GetMenu("PAR_VEHICULOS"), Separator,
CultureManager.GetLabel("KILOMETROS"), Separator,
CultureManager.GetLabel("MOVIMIENTO"), Separator,
CultureManager.GetLabel("PUNTAJE"), Separator,
CultureManager.GetLabel("LEVES"), Separator,
CultureManager.GetLabel("MEDIAS"), Separator,
CultureManager.GetLabel("GRAVES"), Separator,
CultureManager.GetLabel("TOTALES"), Separator));
}
/// <summary>
/// Generates the Header With Report Filters.
/// </summary>
/// <param name="builder"></param>
private void GenerateCsvHeader(BaseCsvBuilder builder)
{
var param = new Dictionary <string, string>
{
{ CultureManager.GetEntity("PARENTI01"), ddlDistrito.SelectedItem.Text },
{ CultureManager.GetEntity("PARENTI02"), ddlBase.SelectedItem.Text },
{ CultureManager.GetEntity("PARENTI03"), ddlVehiculo.SelectedItem.Text },
{ CultureManager.GetLabel("DESDE"), dpDesde.SelectedDate.ToString() },
{ CultureManager.GetLabel("HASTA"), dpHasta.SelectedDate.ToString() }
};
builder.GenerateHeader(CultureManager.GetMenu("STAT_RESUMEN_VEHICULAR"), param);
}
/// <summary>
/// Generates the columns of the report*/
/// </summary>
private void GenerateCSVColumns(BaseCsvBuilder csv)
{
var separator = Usuario.CsvSeparator;
var headers = string.Concat("Ticket", separator, "Interno", separator, "Transportista", separator, "Fecha");
for (var i = _PRIMER_ESTADO; i < Grid.Columns.Count; i += 3)
{
var str = Grid.Columns[i].HeaderText;
var columName = str.Remove(str.IndexOf('<')); /*removes the html used in the grid*/
headers = String.Concat(headers, string.Concat(separator, columName, separator, separator, separator, separator));
}
csv.GenerateRow(headers);
}
/// <summary>
/// Exports the report into a csv file.
/// </summary>
protected override void ExportToCsv()
{
var builder = new BaseCsvBuilder(Usuario.CsvSeparator);
GenerateCsvHeader(builder);
GenerateStadisticsColumns(builder);
GenerateMaximumSpeedColumns(builder);
GenerateOperatorsColumns(builder);
Session["CSV_EXPORT"] = builder.Build();
Session["CSV_FILE_NAME"] = "report";
OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
}
private void GenerateFields(BaseCsvBuilder builder)
{
foreach (var o in GetResults())
{
var str = string.Concat(o.Transportista, Separator,
o.Vehiculos, Separator,
string.Format("{0:F}", o.Kilometros), Separator,
string.Format("{0:00}.{1:00}:{2:00}:{3:00}", o.HorasMovimiento.Days, o.HorasMovimiento.Hours, o.HorasMovimiento.Minutes, o.HorasMovimiento.Seconds), Separator,
string.Format("{0:F}", o.Puntaje), Separator,
o.InfraccionesLeves, Separator,
o.InfraccionesMedias, Separator,
o.InfraccionesGraves, Separator,
o.InfraccionesTotales);
builder.GenerateRow(str);
}
}
/// <summary>
/// Fills the report with the Items of the grid*/
/// </summary>
private void GenerateCSVFields(BaseCsvBuilder csv)
{
var separator = Usuario.CsvSeparator;
foreach (C1GridViewRow row in Grid.Rows)
{
var data = string.Concat(row.Cells[0].Text, separator, row.Cells[1].Text, separator, row.Cells[2].Text, separator, row.Cells[3].Text, separator);
for (var i = _PRIMER_ESTADO; i < Grid.Columns.Count; i += 3)
{
data = String.Concat(data, String.Format("{0}",
row.Cells[i + 1].Text.Equals(_EMPTY_STRING) ? string.Concat(separator, separator, separator, separator, separator)
: row.Cells[i + 1].Text));
}
csv.GenerateRow(data.TrimEnd(separator));
}
csv.GenerateRow("");
}
protected override void ExportToCsv()
{
var builder = new BaseCsvBuilder(Usuario.CsvSeparator);
GenerateCsvHeader(builder);
GenerateColumns(builder);
GenerateFields(builder);
builder.GenerateRow(string.Empty);
builder.GenerateRow(CultureManager.GetLabel("TOTALES"));
builder.GenerateRow(string.Format(CultureManager.GetLabel("PONDERACION_GRAVES_RANKING"), TransportistasGraves));
builder.GenerateRow(string.Format(CultureManager.GetLabel("PONDERACION_MEDIAS_RANKING"), TransportistasMedios));
builder.GenerateRow(string.Format(CultureManager.GetLabel("PONDERACION_LEVES_RANKING"), TransportistasLeves));
SetCsvSessionVars(builder.Build());
OpenWin(string.Concat(ApplicationPath, "Common/exportCSV.aspx"), CultureManager.GetSystemMessage("EXPORT_CSV_DATA"));
}
/// <summary>
/// Generates the CSV data of the Mobiles Iframe.
/// </summary>
/// <param name="builder"></param>
private void GenerateOperatorsColumns(BaseCsvBuilder builder)
{
if (MobileDrivers == null)
{
return;
}
var separator = Usuario.CsvSeparator;
builder.GenerateRow(CultureManager.GetEntity("PARENTI09"));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("LEGAJO"), separator, CultureManager.GetLabel("NAME"), separator, CultureManager.GetEntity("TARJETA"), separator,
CultureManager.GetLabel("INFRACCIONES"), separator, CultureManager.GetLabel("KILOMETROS"), separator, CultureManager.GetLabel("MOVIMIENTO"), separator));
foreach (var o in MobileDrivers)
{
builder.GenerateRow(String.Concat(o.Legajo, separator, o.Nombre, separator, o.Tarjeta, separator, o.Infracciones, separator, o.Kilometros, separator, o.TiempoConduccion, separator));
}
}
private void GenerateFields(BaseCsvBuilder builder)
{
foreach (var o in GetResults())
{
var str = String.Concat(o.Operador, Separator,
o.Legajo, Separator,
o.CentroCosto, Separator,
o.Departamento, Separator, Separator,
String.Format("{0:F}", o.Kilometros), Separator,
String.Format("{0:00}.{1:00}:{2:00}:{3:00}", o.HorasMovimiento.Days, o.HorasMovimiento.Hours, o.HorasMovimiento.Minutes, o.HorasMovimiento.Seconds), Separator,
String.Format("{0:F}", o.Puntaje), Separator, Separator,
o.InfraccionesLeves, Separator,
o.InfraccionesMedias, Separator,
o.InfraccionesGraves, Separator,
o.InfraccionesTotales);
builder.GenerateRow(str);
}
}
private void GenerateMobilesColumns(BaseCsvBuilder builder)
{
if (OperatorMobiles == null)
{
return;
}
var separator = Usuario.CsvSeparator;
builder.GenerateRow(CultureManager.GetEntity("PARENTI03"));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("PATENTE"), separator, CultureManager.GetLabel("INTERNO"), separator, CultureManager.GetLabel("INFRACCIONES"), separator,
CultureManager.GetLabel("KILOMETROS"), separator, CultureManager.GetLabel("TIEMPO_CONDUCCION"), separator));
foreach (var o in OperatorMobiles)
{
builder.GenerateRow(String.Concat(o.Patente, separator, o.Interno, separator, o.Infracciones, separator, o.Kilometros, separator, o.Movimiento, separator));
}
}
private void GenerateMaximumSpeedColumns(BaseCsvBuilder builder)
{
if (ReportObjectsList == null)
{
return;
}
var separator = Usuario.CsvSeparator;
builder.GenerateRow(CultureManager.GetLabel("MAXIMAS_DIARIAS"));
builder.GenerateRow(String.Concat(CultureManager.GetLabel("DIA"), separator, CultureManager.GetLabel("VELOCIDAD"), separator, CultureManager.GetLabel("ALCANZADA_POR"), separator));
foreach (var o in ReportObjectsList)
{
builder.GenerateRow(String.Concat(o.Dia, separator, o.Velocidad, separator, o.CometidoPor, separator));
}
builder.GenerateRow(string.Empty);
}
