public static ObservableCollection <DepartementDAO> selectDepartements()
        {
            ObservableCollection <DepartementDAO> l = new ObservableCollection <DepartementDAO>();
            string       query = "SELECT * FROM Departement;";
            MySqlCommand cmd   = new MySqlCommand(query, DALConnection.OpenConnection());

            try
            {
                cmd.ExecuteNonQuery();
                MySqlDataReader reader = cmd.ExecuteReader();

                while (reader.Read())
                {
                    DepartementDAO p = new DepartementDAO(reader.GetInt32(0), reader.GetString(1));
                    l.Add(p);
                }
                reader.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show("La base de données n'est pas connectée");
            }
            return(l);
        }
 public static void insertDepartement(DepartementDAO p)
 {
     DepartementDAO.insertDepartement(p);
 }
 public static void supprimerDepartement(int id)
 {
     DepartementDAO.supprimerDepartement(id);
 }
 public static void updateDepartement(DepartementDAO p)
 {
     DepartementDAO.updateDepartement(p);
 }
        public static DepartementDAO getDepartement(int idDepartement)
        {
            DepartementDAO p = DepartementDAL.getDepartement(idDepartement);

            return(p);
        }