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