public static void updateNbEspece(DAONbEspece p)
{
string query = "UPDATE nbespece set nombre=\"" + p.nbEspece + "\", idEspece=\"" + p.idEspece + "\" where idNbEspece=" + p.idNbEspece + ";";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertNbEspece(DAONbEspece p)
{
string query = "INSERT INTO nbespece (`nombre`, `idEspece`) VALUES (\"" + p.nombreDAOEtudeEspece + "\",\"" + p.idEspeceDAOEtudeEspece + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static ObservableCollection <DAONbEspece> listeNbEspece()
{
ObservableCollection <DAONbEspece> l = new ObservableCollection <DAONbEspece>();
string query = "SELECT * FROM nbespece;";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DAONbEspece p = new DAONbEspece(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2));
l.Add(p);
}
reader.Close();
return(l);
}
