public static EspeceViewModel getEspece(int id)
{
DAOEspece pDAO = DAOEspece.getEspece(id);
EspeceViewModel p = new EspeceViewModel(pDAO.idDAOEspece, pDAO.nomDAOEspece);
return(p);
}
public static void insertEspece(DAOEspece e)
{
string query = "INSERT INTO espece (`nom`) VALUES (\"" + e.nomDAOEspece + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static void updateEspece(DAOEspece e)
{
string query = "UPDATE Groupe set nomEspece=\"" + e.nomDAOEspece + "\" where idEspece=" + e.idDAOEspece + ";";
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));
DAOEspece.updateEspece(this);
}
}
public static ObservableCollection <EspeceViewModel> listeEspeces()
{
ObservableCollection <DAOEspece> lDAO = DAOEspece.listeEspeces();
ObservableCollection <EspeceViewModel> l = new ObservableCollection <EspeceViewModel>();
foreach (DAOEspece element in lDAO)
{
EspeceViewModel p = new EspeceViewModel(element.idDAOEspece, element.nomDAOEspece);
l.Add(p);
}
return(l);
}
public static DAOEspece getEspece(int id)
{
string query = "SELECT * FROM Espece WHERE idEspece=" + id + ";";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
DAOEspece met = new DAOEspece(reader.GetInt32(0), reader.GetString(1));
reader.Close();
return(met);
}
public static ObservableCollection <DAOEspece> selectEspece()
{
ObservableCollection <DAOEspece> l = new ObservableCollection <DAOEspece>();
string query = "SELECT * FROM espece;";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DAOEspece e = new DAOEspece(reader.GetInt32(0), reader.GetString(1));
l.Add(e);
}
reader.Close();
return(l);
}
public static void deleteEspece(EspeceViewModel espece)
{
DAOEspece.supprimerEspece(espece);
}
public static void ajouterEspece(EspeceViewModel espece)
{
DAOEspece.insertEspece(espece);
}
public static DAOEspece getEspece(int id)
{
DAOEspece p = DALEspece.getEspece(id);
return(p);
}
