Esempio n. 1
0
        void IntfDalAgent.insertToGridAgent(GridView gridView, string param, string paramLike, string valueLike, string numAgence)
        {
            #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, agent.loginAgent,";
            this.strCommande += " agent.motDePasseAgent, agent.cinAgent, agent.adresseAgent, agent.telephoneAgent,";
            this.strCommande += " agent.telephoneMobileAgent, agent.imageAgent FROM agent";
            this.strCommande += " WHERE agent.numAgence = '" + numAgence + "' AND";
            this.strCommande += " " + paramLike + " LIKE '%" + valueLike + "%'";
            this.strCommande += " ORDER BY " + param + " ASC";

            gridView.DataSource = serviceAgent.getDataTableAgent(this.strCommande);
            gridView.DataBind();
            #endregion
        }