public static DepartementViewModel getDepartement(int idDep)
{
DAODepartement m = DAODepartement.getDepatrement(idDep);
DepartementViewModel departement = new DepartementViewModel(m.idDepartement, m.nomDAODepartement);
return(departement);
}
public static void insertDepartement(DAODepartement d)
{
string query = "INSERT INTO departement (`nom`) VALUES (\"" + d.nomDAODepartement + ");";
MySqlCommand cmd2 = new MySqlCommand(query, connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static void updateDepartement(DAODepartement d)
{
string query = "UPDATE departement set nom=\"" + d.nomDAODepartement + "\" where idDepartement=" + d.idDepartement + ";";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
private void OnPropertyChanged(string info)
{
PropertyChangedEventHandler handler = PropertyChanged;
if (handler != null)
{
handler(this, new PropertyChangedEventArgs(info));
DAODepartement.updateDepartement(this);
}
}
public static ObservableCollection <DepartementViewModel> listeDepartement()
{
ObservableCollection <DAODepartement> lDAO = DAODepartement.listeDepartements();
ObservableCollection <DepartementViewModel> l = new ObservableCollection <DepartementViewModel>();
foreach (var element in lDAO)
{
DepartementViewModel p = new DepartementViewModel(element.idDepartement, element.nomDAODepartement);
l.Add(p);
}
return(l);
}
public static DAODepartement getDepartement(int idDepartement)
{
string query = "SELECT * FROM departement WHERE idDepartement=" + idDepartement + ";";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
DAODepartement dep = new DAODepartement(reader.GetInt32(0), reader.GetString(1));
reader.Close();
return(dep);
}
public static ObservableCollection <DAODepartement> selectDepartement()
{
ObservableCollection <DAODepartement> l = new ObservableCollection <DAODepartement>();
string query = "SELECT * FROM departement;";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DAODepartement d = new DAODepartement(reader.GetInt32(0), reader.GetString(1));
l.Add(d);
}
reader.Close();
return(l);
}
public static DAODepartement getDepatrement(int idDepartement)
{
DAODepartement p = DALDepartement.getDepartement(idDepartement);
return(p);
}
public static void updateDepartement(DepartementViewModel d)
{
DAODepartement.updateDepartement(d);
}