void IntfDalStatistique.insertToGridCANombrePassagerJour(GridView gridView, DateTime dateDebut, DateTime dateFin, List <crlItineraire> itineraires)
{
#region declaration
IntfDalStatistique serviceStatistique = new ImplDalStatistique();
DateTime dateD;
DateTime dateF;
#endregion
#region implementation
if (dateDebut > dateFin)
{
dateD = dateFin;
dateF = dateDebut;
}
else
{
dateD = dateDebut;
dateF = dateFin;
}
gridView.DataSource = serviceStatistique.getDataTableNombrePassagerJour(dateD, dateF, itineraires);
gridView.DataBind();
#endregion
}
DataTable IntfDalStatistique.getDataTableNombrePassagerAnnee(DateTime dateDebut, DateTime dateFin, List <crlItineraire> itineraires)
{
#region declaration
DataTable dataTable = new DataTable();
IntfDalStatistique serviceStatistique = new ImplDalStatistique();
DateTime dateD = dateDebut;
DateTime dateF = dateFin;
string strAxe = "";
#endregion
#region implementation
#region initialisation du dataTable
dataTable = new DataTable();
dataTable.Columns.Add("Itineraire", typeof(string));
dataTable.Columns.Add("Axe", typeof(string));
while (dateD <= dateF)
{
dataTable.Columns.Add(dateD.ToString("yyyy"), typeof(string));
dateD = dateD.AddYears(1);
}
DataRow dr;
#endregion
for (int i = 0; i < itineraires.Count; i++)
{
dateD = dateDebut;
dateF = dateFin;
dr = dataTable.NewRow();
strAxe = "";
if (itineraires[i] != null)
{
if (itineraires[i].routeNationale != null)
{
for (int j = 0; j < itineraires[i].routeNationale.Count; j++)
{
if (j == 0)
{
strAxe = strAxe + itineraires[i].routeNationale[j].RouteNationale;
}
else
{
strAxe = strAxe + "-" + itineraires[i].routeNationale[j].RouteNationale;
}
}
}
}
dr["Itineraire"] = itineraires[i].villeD.NomVille + "-" + itineraires[i].villeF.NomVille;
dr["Axe"] = strAxe;
while (dateD <= dateF)
{
dr[dateD.ToString("yyyy")] = serviceStatistique.getNombrePassager(itineraires[i].IdItineraire, dateD.ToString("yyyy"), dateD.ToString("yyyy") + "-13").ToString("0");
dateD = dateD.AddYears(1);
}
dataTable.Rows.Add(dr);
}
#endregion
return(dataTable);
}
