public static void deletedPlageEtude(DAOPlageEtude plageEtude)
        {
            string           query       = "DELETE FROM plage_has_etude WHERE etude_idEtude = \"" + plageEtude.idEtude + "\" AND plage_idPlage =\"" + plageEtude.idPlage + "\";";
            MySqlCommand     cmd         = new MySqlCommand(query, connection);
            MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);

            cmd.ExecuteNonQuery();
        }
        public static void updatePlageEtude(DAOPlageEtude plageEtude)
        {
            string           query       = "UPDATE plage_has_etude set plage_idPlage=\"" + plageEtude.idPlage + "\" where etude_idEtude=" + plageEtude.idEtude + ";";
            MySqlCommand     cmd         = new MySqlCommand(query, connection);
            MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);

            cmd.ExecuteNonQuery();
        }
        public static void insertPlageEtude(DAOPlageEtude plageEtude)
        {
            string           query       = "INSERT INTO plage_has_etude ( `plage_idPlage`,`etude_idEtude`) VALUES (\"" + plageEtude.idPlage + "\",\"" + plageEtude.idEtude + "\");";
            MySqlCommand     cmd2        = new MySqlCommand(query, connection);
            MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);

            cmd2.ExecuteNonQuery();
        }
        public static ObservableCollection <DAOPlageEtude> listePlageEtude()
        {
            ObservableCollection <DAOPlageEtude> l = new ObservableCollection <DAOPlageEtude>();
            string       query = "SELECT * FROM plage_has_etude;";
            MySqlCommand cmd   = new MySqlCommand(query, connection);

            cmd.ExecuteNonQuery();

            MySqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            {
                DAOPlageEtude c = new DAOPlageEtude(reader.GetInt32(0), reader.GetInt32(1));
                l.Add(c);
            }
            reader.Close();
            return(l);
        }