protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                AfpaBNBEntities afpaBNBEntities = new AfpaBNBEntities();

                this.gdvAvi.DataSource = afpaBNBEntities.Avis.ToList();
                this.gdvAvi.DataBind();
            }
        }
        protected void btnActiver_Click(object sender, EventArgs e)
        {
            string arg      = ((Button)sender).CommandArgument;
            int    idclient = Convert.ToInt32(arg);

            AfpaBNBEntities afpaBNBEntities = new AfpaBNBEntities();

            Client client = afpaBNBEntities.Clients.Find(idclient);

            client.Etat = true;
            afpaBNBEntities.SaveChanges();
        }
        protected void btnDesactiver_Click(object sender, EventArgs e)
        {
            string arg      = ((Button)sender).CommandArgument;
            int    idclient = Convert.ToInt32(arg);

            //afpaBNBEntities.Hebergements.Where(h => h.IdHebergement => idhebergement).First();
            AfpaBNBEntities afpaBNBEntities = new AfpaBNBEntities();

            Client client = afpaBNBEntities.Clients.Find(idclient);

            client.Etat = false;
            afpaBNBEntities.SaveChanges();
        }
        protected void btnActiver_Click(object sender, EventArgs e)
        {
            string arg    = ((Button)sender).CommandArgument;
            int    idavis = Convert.ToInt32(arg);

            //afpaBNBEntities.Hebergements.Where(h => h.IdHebergement => idhebergement).First();

            AfpaBNBEntities afpaBNBEntities = new AfpaBNBEntities();

            Avi avi = afpaBNBEntities.Avis.Find(idavis);

            avi.Etat = true;
            afpaBNBEntities.SaveChanges();
        }