public static void insertEspeceHasPlage(EspeceHasPlageDAO e) { string query = "INSERT INTO Espece_has_Plage VALUES (\"" + e.Espece_idEspeceDAO + "\",\"" + e.Plage_idPlageDAO + "\",\"" + e.densiteDAO + "\",\"" + e.populationTotaleDAO + "\");"; MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
public static void updateEspeceHasPlage(EspeceHasPlageDAO e) { string query = "UPDATE Espece_has_Plage SET densite =" + e.densiteDAO + ", populationTotale =" + e.populationTotaleDAO + " WHERE Espece_idEspece =" + e.Espece_idEspeceDAO + " AND Plage_idPlage =" + e.Plage_idPlageDAO + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static EspeceHasPlageViewModel getEspeceHasPlage(int idEspece, int idPlage) { EspeceHasPlageDAO eDAO = EspeceHasPlageDAO.getEspeceHasPlage(idEspece, idPlage); int Espece_idEspece = eDAO.Espece_idEspeceDAO; EspeceViewModel e = EspeceORM.getEspece(Espece_idEspece); int Plage_idPlage = eDAO.Plage_idPlageDAO; PlageViewModel p = PlageORM.getPlage(Plage_idPlage); EspeceHasPlageViewModel ep = new EspeceHasPlageViewModel(e, p, eDAO.densiteDAO, eDAO.populationTotaleDAO); return(ep); }
public static ObservableCollection <EspeceHasPlageDAO> selectEspeceHasPlages() { ObservableCollection <EspeceHasPlageDAO> l = new ObservableCollection <EspeceHasPlageDAO>(); string query = "SELECT * FROM Espece_has_Plage;"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { EspeceHasPlageDAO u = new EspeceHasPlageDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetDecimal(2), reader.GetDecimal(3)); l.Add(u); } reader.Close(); return(l); }
public static ObservableCollection <EspeceHasPlageViewModel> listeEspeceHasPlages() { ObservableCollection <EspeceHasPlageDAO> lDAO = EspeceHasPlageDAO.listeEspeceHasPlages(); ObservableCollection <EspeceHasPlageViewModel> l = new ObservableCollection <EspeceHasPlageViewModel>(); foreach (EspeceHasPlageDAO element in lDAO) { int Espece_idEspece = element.Espece_idEspeceDAO; EspeceViewModel e = EspeceORM.getEspece(Espece_idEspece); int Plage_idPlage = element.Plage_idPlageDAO; PlageViewModel p = PlageORM.getPlage(Plage_idPlage); EspeceHasPlageViewModel ep = new EspeceHasPlageViewModel(e, p, element.densiteDAO, element.populationTotaleDAO); l.Add(ep); } return(l); }
public static EspeceHasPlageDAO getEspeceHasPlage(int idEspece, int idPlage) { string query = "SELECT * FROM Espece_has_Plage WHERE Espece_idEspece=" + idEspece + " and plage_idPlage=" + idPlage + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); EspeceHasPlageDAO Espece; if (reader.HasRows) { Espece = new EspeceHasPlageDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetDecimal(2), reader.GetDecimal(3)); } else { Espece = new EspeceHasPlageDAO(1, 1, 0.0M, 0.0M); } reader.Close(); return(Espece); }
public static void insertEspeceHasPlage(EspeceHasPlageViewModel ep) { EspeceHasPlageDAO.insertEspeceHasPlage(new EspeceHasPlageDAO(ep.Espece_EspeceHasPlageProperty.idEspeceProperty, ep.Plage_EspeceHasPlageProperty.idPlageProperty, ep.densiteProperty, ep.populationTotaleProperty)); }
public static void supprimerEspeceHasPlage(int idEspece, int idPlage) { EspeceHasPlageDAO.supprimerEspeceHasPlage(idEspece, idPlage); }