Exemple #1
0
        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
        }