/// <summary>
/// This method search in database the brands of the most rented vehicles.
/// </summary>
/// <returns>And return a list with the brands of the most rented vehicles.</returns>
public ArrayList reporte6()
{
DB_Reportes rep = new DB_Reportes();
ArrayList rep6 = rep.reporte6();
return(rep6);
}
/// <summary>
/// This method search in database the names of the countries that have been scaled
/// </summary>
/// <returns>And return a list with the names of the countries that have been scaled</returns>
public ArrayList reporte7()
{
DB_Reportes rep = new DB_Reportes();
ArrayList rep7 = rep.reporte7();
return(rep7);
}
/// <summary>
/// This method search in database the number of people by country
/// </summary>
/// <returns>And return a list with the number of people by country</returns>
public ArrayList reporte3()
{
DB_Reportes rep = new DB_Reportes();
ArrayList rep3 = rep.reporte3();
return(rep3);
}
/// <summary>
/// This method search in database the number of children who have traveled in a range of dates
/// </summary>
/// <param name="fechainicio"></param>
/// <param name="fecha_final"></param>
/// <returns>And return a list with the number of children who have traveled in a range of dates</returns>
public ArrayList reporte5(string fechainicio, string fecha_final)
{
DB_Reportes rep = new DB_Reportes();
ArrayList rep5 = rep.reporte5(fechainicio, fecha_final);
return(rep5);
}
/// <summary>
/// This method search in database the number of people by hotel
/// </summary>
/// <returns>And return a list with the number of people by hotel</returns>
public ArrayList reporte2()
{
DB_Reportes rep = new DB_Reportes();
ArrayList rep2 = rep.reporte2();
return(rep2);
}
/// <summary>
/// This method search in database each of the times hotels have been reserved
/// </summary>
/// <returns>And return a list with hotels have been reserved name</returns>
public ArrayList reporte1()
{
DB_Reportes rep = new DB_Reportes();
ArrayList rep1 = rep.reporte1();
return(rep1);
}
public void Reporte7()
{
DB_Reportes repor = new DB_Reportes();
ArrayList reporte7 = repor.setimoreporte();
this.Grafico7.Series.Clear();
this.Grafico7.Titles.Clear();
this.Grafico7.Titles.Add("Nombres de los países en que se ha hecho escala");
Series Grafico = this.Grafico7.Series.Add("Nombres de los países en que se ha hecho escala");
Grafico.ChartType = SeriesChartType.Pie;
for (int i = 0; i < reporte7.Count; i++)
{
Grafico.Points.AddXY(reporte7[i], reporte7[i + 1]);
i++;
}
Grafico7.Series["Nombres de los países en que se ha hecho escala"].IsValueShownAsLabel = true;
}
public void sextoReporte()
{
DB_Reportes repor = new DB_Reportes();
ArrayList reporte6 = repor.sextoreporte();
this.Grafico6.Series.Clear();
this.Grafico6.Titles.Clear();
this.Grafico6.Titles.Add("Marcas de los vehículos más rentados");
Series Grafico = this.Grafico6.Series.Add("Marcas de los vehículos más rentados");
Grafico.ChartType = SeriesChartType.Pie;
for (int i = 0; i < reporte6.Count; i++)
{
Grafico.Points.AddXY(reporte6[i], reporte6[i + 1]);
i++;
}
Grafico6.Series["Marcas de los vehículos más rentados"].IsValueShownAsLabel = true;
}
public void tercerReporte()
{
DB_Reportes repor = new DB_Reportes();
ArrayList reporte3 = repor.Tercerreporte();
this.Grafico3.Series.Clear();
this.Grafico3.Titles.Clear();
this.Grafico3.Titles.Add("Porcentaje de visitas por pais");
Series Grafico = this.Grafico3.Series.Add("Porcentaje de visitas por pais");
Grafico.ChartType = SeriesChartType.Pie;
for (int i = 0; i < reporte3.Count; i++)
{
Grafico.Points.AddXY(reporte3[i], reporte3[i + 1]);
i++;
}
Grafico3.Series["Porcentaje de visitas por pais"].IsValueShownAsLabel = true;
}
