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));
}
