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