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); }