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
}
