public static AnimauxViewModel getAnimaux(int idAnimaux)
{
AnimauxDAO pDAO = AnimauxDAO.getAnimaux(idAnimaux);
AnimauxViewModel p = new AnimauxViewModel(pDAO.nomAnimauxDAO);
return(p);
}
public static void insertAnimaux(AnimauxDAO d)
{
string query = "INSERT INTO Animaux (espece) VALUES (@nomAnimaux);";
MySqlCommand cmd1 = new MySqlCommand(query, DALConnection.OpenConnection());
cmd1.Parameters.AddWithValue("@nomAnimaux", d.nomAnimauxDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd1);
cmd1.ExecuteNonQuery();
}
public static ObservableCollection <AnimauxViewModel> listeAnimaux()
{
ObservableCollection <AnimauxDAO> lDAO = AnimauxDAO.listeAnimaux();
ObservableCollection <AnimauxViewModel> l = new ObservableCollection <AnimauxViewModel>();
foreach (AnimauxDAO element in lDAO)
{
AnimauxViewModel p = new AnimauxViewModel(element.nomAnimauxDAO);
l.Add(p);
}
return(l);
}
public static void updateAnimaux(AnimauxDAO d)
{
string query = "UPDATE Animaux set espece=@nomAnimaux where IdAnimaux=@idAnimaux;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@idAnimaux", d.idAnimauxDAO);
cmd.Parameters.AddWithValue("@nomAnimaux", d.nomAnimauxDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static AnimauxDAO getAnimaux(int idAnimaux)
{
string query = "SELECT * FROM Animaux WHERE idAnimaux=" + idAnimaux + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
AnimauxDAO Animaux = new AnimauxDAO(reader.GetString(0));
reader.Close();
return(Animaux);
}
public static ObservableCollection <AnimauxDAO> selectAnimaux()
{
ObservableCollection <AnimauxDAO> l = new ObservableCollection <AnimauxDAO>();
string query = "SELECT * FROM Animaux;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
AnimauxDAO d = new AnimauxDAO(reader.GetString(0));
l.Add(d);
}
reader.Close();
return(l);
}
public static void insertAnimaux(AnimauxViewModel d)
{
AnimauxDAO.insertAnimaux(new AnimauxDAO(d.nomEspeceAnimauxProperty));
}
public static void supprimerAnimaux(int id)
{
AnimauxDAO.supprimerAnimaux(id);
}
public static void updateAnimaux(AnimauxViewModel d)
{
AnimauxDAO.updateAnimaux(new AnimauxDAO(d.nomEspeceAnimauxProperty));
}
