public static void insertEtudeHasEspece(EtudeHasEspeceDAO e)
{
string query = "INSERT INTO etude_has_espece VALUES (\"" + e.Etude_idEtudeDAO + "\",\"" + e.Espece_idEspeceDAO + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static void updateEtudeHasEspece(EtudeHasEspeceDAO e)
{
string query = "UPDATE etude_has_espece SET densiteTotaleEspece =" + e.densiteTotaleEspeceDAO + " WHERE Etude_idEtude =" + e.Etude_idEtudeDAO + " AND Espece_idespece =" + e.Espece_idEspeceDAO + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static EtudeHasEspeceViewModel getEtudeHasEspece(int idEtude, int idEspece)
{
EtudeHasEspeceDAO eDAO = EtudeHasEspeceDAO.getEtudeHasEspece(idEtude, idEspece);
int Etude_idEtude = eDAO.Etude_idEtudeDAO;
EtudeViewModel et = EtudeORM.getEtude(Etude_idEtude);
int Espece_idEspece = eDAO.Espece_idEspeceDAO;
EspeceViewModel e = EspeceORM.getEspece(Espece_idEspece);
EtudeHasEspeceViewModel ee = new EtudeHasEspeceViewModel(et, e, eDAO.densiteTotaleEspeceDAO);
return(ee);
}
public static ObservableCollection <EtudeHasEspeceDAO> selectEtudeHasEspeces()
{
ObservableCollection <EtudeHasEspeceDAO> l = new ObservableCollection <EtudeHasEspeceDAO>();
string query = "SELECT * FROM etude_has_espece;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
EtudeHasEspeceDAO u = new EtudeHasEspeceDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetDecimal(2));
l.Add(u);
}
reader.Close();
return(l);
}
public static ObservableCollection <EtudeHasEspeceViewModel> listeEtudeHasEspeces()
{
ObservableCollection <EtudeHasEspeceDAO> lDAO = EtudeHasEspeceDAO.listeEtudeHasEspeces();
ObservableCollection <EtudeHasEspeceViewModel> l = new ObservableCollection <EtudeHasEspeceViewModel>();
foreach (EtudeHasEspeceDAO element in lDAO)
{
int Etude_idEtude = element.Etude_idEtudeDAO;
EtudeViewModel et = EtudeORM.getEtude(Etude_idEtude);
int Espece_idEspece = element.Espece_idEspeceDAO;
EspeceViewModel e = EspeceORM.getEspece(Espece_idEspece);
EtudeHasEspeceViewModel ee = new EtudeHasEspeceViewModel(et, e, element.densiteTotaleEspeceDAO);
l.Add(ee);
}
return(l);
}
//Select général -> pas de select de tout les user avec tel equipe
//public static EtudeHasEspeceDAO getEtudeHasEspeceByUtilisateur(int idUtilisateur)
//{
// string query = "SELECT * FROM etude_has_espece WHERE idUtilisateur=" + idUtilisateur + ";";
// MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
// cmd.ExecuteNonQuery();
// MySqlDataReader reader = cmd.ExecuteReader();
// reader.Read();
// EtudeHasEspeceDAO user = new EtudeHasEspeceDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetDecimal(2));
// reader.Close();
// return user;
//}
public static EtudeHasEspeceDAO getEtudeHasEspece(int idEtude, int idEspece)
{
string query = "SELECT * FROM etude_has_espece WHERE Etude_idEtude=" + idEtude + " and esepce_idEspece=" + idEspece + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
EtudeHasEspeceDAO etude;
if (reader.HasRows)
{
etude = new EtudeHasEspeceDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetDecimal(2));
}
else
{
etude = new EtudeHasEspeceDAO(1, 1, 0.0M);
}
reader.Close();
return(etude);
}
public static void insertEtudeHasEspece(EtudeHasEspeceViewModel ee)
{
EtudeHasEspeceDAO.insertEtudeHasEspece(new EtudeHasEspeceDAO(ee.Etude_EtudeHasEspeceProperty.idEtudeProperty, ee.Espece_EtudeHasEspeceProperty.idEspeceProperty, ee.densiteTotaleEspeceProperty));
}
public static void supprimerEtudeHasEspece(int idEtude, int idEspece)
{
EtudeHasEspeceDAO.supprimerEtudeHasEspece(idEtude, idEspece);
}
