void IntfDalVille.insertToGridVille(GridView gridView, string param, string paramLike, string valueLike) { #region declaration IntfDalVille serviceVille = new ImplDalVille(); #endregion #region implementation this.strCommande = "SELECT ville.numVille, ville.nomVille, ville.nomRegion, ville.nomProvince"; this.strCommande += " FROM ville WHERE " + paramLike + " LIKE '%" + valueLike + "%' ORDER BY " + param; gridView.DataSource = serviceVille.getDataTableVille(this.strCommande); gridView.DataBind(); #endregion }
void IntfDalVille.insertToGridVilleDestination(GridView gridView, string param, string paramLike, string valueLike, string numVille) { #region declaration IntfDalVille serviceVille = new ImplDalVille(); #endregion #region implementation this.strCommande = "SELECT ville.numVille, ville.nomVille, ville.nomRegion, ville.nomProvince FROM ville"; this.strCommande += " Inner Join trajet ON trajet.numVilleD = ville.numVille OR trajet.numVilleF = ville.numVille"; this.strCommande += " WHERE ville.numVille <> '" + numVille + "' AND " + paramLike + " LIKE '%" + valueLike + "%'"; this.strCommande += " AND ( trajet.numVilleD = '" + numVille + "' OR trajet.numVilleF = '" + numVille + "' )"; this.strCommande += " GROUP BY ville.nomVille ORDER BY " + param; gridView.DataSource = serviceVille.getDataTableVille(this.strCommande); gridView.DataBind(); #endregion }