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), reader.GetString(2)); 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(DepartementViewModel p) { DepartementDAO.insertDepartement(new DepartementDAO(p.idDepartementProperty, p.nomDepartementProperty)); }
public static void supprimerDepartement(int id) { DepartementDAO.supprimerDepartement(id); }
public static void updateDepartement(DepartementViewModel p) { DepartementDAO.updateDepartement(new DepartementDAO(p.idDepartementProperty, p.nomDepartementProperty, p.numeroDepartementProperty)); }