void IntfDalAgent.insertToGridAgentParType(GridView gridView, string param, string paramLike, string valueLike, string numAgence, string typeAgent)
{
#region declaration
IntfDalAgent serviceAgent = new ImplDalAgent();
#endregion
#region implementation
this.strCommande = "SELECT agent.matriculeAgent, agent.typeAgent, agent.numAgence, agent.nomAgent,";
this.strCommande += " agent.prenomAgent, agent.dateNaissanceAgent, agent.lieuNaissanceAgent,";
this.strCommande += " agent.loginAgent, agent.motDePasseAgent, agent.cinAgent, agent.adresseAgent,";
this.strCommande += " agent.telephoneAgent, agent.telephoneMobileAgent, agent.imageAgent,";
this.strCommande += " agent.situationFamilialeAgent FROM agent";
this.strCommande += " WHERE agent.typeAgent LIKE '%" + typeAgent + "%' AND";
this.strCommande += " agent.numAgence LIKE '%" + numAgence + "%' AND";
this.strCommande += " " + paramLike + " LIKE '%" + valueLike + "%'";
this.strCommande += " ORDER BY " + param + " ASC";
gridView.DataSource = serviceAgent.getDataTableAgentParType(this.strCommande);
gridView.DataBind();
#endregion
}
