void IntfDalUSCarteReduction.insertToGridCarteReduction(GridView gridView, string param, string paramLike, string valueLike)
{
#region declaration
IntfDalUSCarteReduction serviceUSCarteReduction = new ImplDalUSCarteReduction();
#endregion
#region implementation
this.strCommande = "SELECT client.numClient, client.nomClient, client.prenomClient, client.adresseClient,";
this.strCommande += " client.cinClient, client.telephoneClient, client.mobileClient, client.isCheque,";
this.strCommande += " client.isBonCommande, uscartereduction.numCarteReduction,";
this.strCommande += " uscartereduction.numClient, uscartereduction.etatCivil,";
this.strCommande += " uscartereduction.dateNaissance, dateAtestationEmployeur, dateDelivranceCertificatScolarite,";
this.strCommande += " uscartereduction.dateValideDu, uscartereduction.dateValideAu,";
this.strCommande += " uscartereduction.isLundi, uscartereduction.isMardi, uscartereduction.isMercredi,";
this.strCommande += " uscartereduction.isJeudi, uscartereduction.isVendredi, uscartereduction.isSamedi,";
this.strCommande += " uscartereduction.isDimanche, uscartereduction.numCategorieBillet,";
this.strCommande += " uscartereduction.imageCarteReduction FROM uscartereduction";
this.strCommande += " Inner Join client ON client.numClient = uscartereduction.numClient";
this.strCommande += " WHERE " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " ORDER BY " + param;
gridView.DataSource = serviceUSCarteReduction.getDataTableCarteReduction(this.strCommande);
gridView.DataBind();
#endregion
}
