public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.nomEtudeDAO, pDAO.dateEtudeDAO, pDAO.nbPersonneDAO, pDAO.idPersonneDAO);
return(p);
}
public static void updateEtude(EtudeDAO p)
{
string query = "UPDATE etude set nomEtude=\"" + p.nomEtudeDAO + "\", dateEtude=\"" + p.dateEtudeDAO + "\", nbPersonne=\"" + p.nbPersonneDAO + "\", idPersonne=\"" + p.idPersonneDAO + "\" where idEtude=" + p.idEtudeDAO + ";";
MySqlCommand cmd = new MySqlCommand(query, connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.DateDAO, pDAO.SuperficieEtudierDAO);
return(p);
}
public static void insertEtude(EtudeDAO p)
{
int id = getMaxIdEtude() + 1;
string query = "INSERT INTO etude VALUES (\"" + id + "\",\"" + p.nomEtudeDAO + "\",\"" + p.dateEtudeDAO.ToString("yyyy-MM-dd") + "\",\"" + p.nbPersonneDAO + "\",\"" + p.idPersonneDAO + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
//int idMetier = pDAO.idMetierPersonneDAO;
//MetierViewModel m = MetierORM.getMetier(idMetier);
EtudeViewModel p = new EtudeViewModel(pDAO.id, pDAO.nom, pDAO.date, UtilisateurORM.getPersonne(pDAO.proprio) /*, m*/);
return(p);
}
public static void updateEtude(EtudeDAO u)
{
string query = "UPDATE Etude set date=\"" + u.dateEtudeDAO + "\", titre=\"" + u.titreEtudeDAO + "\", nbTotalEspeceRencontree=\"" + u.nbTotalEspeceRencontreeEtudeDAO + "\", idEquipe=\"" + u.idEquipeEtudeDAO + "\" where idEtude=" + u.idEtudeDAO + ";";
//UPDATE Etude set date= + STR_TO_DATE('\"" + u.dateEtudeDAO + "\"', ' % d/%m/%Y %H:%i:%s'), titre=\"" + u.titreEtudeDAO + "\", nbTotalEspeceRencontree=\"" + u.nbTotalEspeceRencontreeEtudeDAO + "\", idEquipe=\"" + u.idEquipeEtudeDAO + "\" where idEtude=" + u.idEtudeDAO + ";"
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertEtude(EtudeDAO p)
{
int id = getMaxIdEtude() + 1;
string query = "INSERT INTO etude VALUES (\"" + id + "\",\"" + p.dateEtudeDAO + "\",\"" + p.titreEtudeDAO + "\",\"" + p.nbTotalEspeceRencontreeEtudeDAO + "\",\"" + p.idEquipeEtudeDAO + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, ConnexionBaseDAL.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
int idPlage = pDAO.PlageEtudeDAO;
PlageViewModel m = PlageORM.getPlage(idPlage);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.NbPersonneEtudeDAO, pDAO.TitreEtudeEtudeDAO, m, pDAO.dateCreationDAO, pDAO.dateFinDAO);
return(p);
}
public static EtudeViewModel getEtude(int idEtude)
{
EtudeDAO pDAO = EtudeDAO.getEtude(idEtude);
int idEquipe = pDAO.idEquipeEtudeDAO;
EquipeViewModel m = EquipeORM.getEquipe(idEquipe);
EtudeViewModel p = new EtudeViewModel(pDAO.idEtudeDAO, pDAO.dateEtudeDAO, pDAO.titreEtudeDAO, pDAO.nbTotalEspeceRencontreeEtudeDAO, m);
return(p);
}
public static void updateEtude(EtudeDAO p)
{
if (p.idEtudeDAO != 1)
{
string query = "UPDATE etude set titre=\"" + p.titreEtudeDAO + "\", idEquipe=\"" + p.idEquipeEtudeDAO + "\", nbTotalEspeceRencontree=\"" + p.nbTotalEspeceRencontreeEtudeDAO + "\", date=\"" + p.dateEtudeDAO + "\" where idEtude=" + p.idEtudeDAO + ";";
MySqlCommand cmd = new MySqlCommand(query, ConnexionBaseDAL.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
}
public static void insertEtude(EtudeDAO d)
{
string query = "INSERT INTO Etude (nom) VALUES (@nomEtude);";
MySqlCommand cmd1 = new MySqlCommand(query, DALConnection.OpenConnection());
cmd1.Parameters.AddWithValue("@nomEtude", d.nomEtudeDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd1);
cmd1.ExecuteNonQuery();
}
private void OnPropertyChanged(string info)
{
PropertyChangedEventHandler handler = PropertyChanged;
if (handler != null)
{
handler(this, new PropertyChangedEventArgs(info));
EtudeDAO.updateEtude(this);
}
}
public static void updateEtude(EtudeDAO d)
{
string query = "UPDATE Etude set nom=@nomEtude where IdEtude=@idEtude;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@idEtude", d.idEtudeDAO);
cmd.Parameters.AddWithValue("@nomEtude", d.nomEtudeDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static ObservableCollection <EtudeViewModel> listeEtude()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtude();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.DateDAO, element.SuperficieEtudierDAO);
l.Add(p);
}
return(l);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.nomEtudeDAO, element.dateEtudeDAO, element.nbPersonneDAO, element.idPersonneDAO);
l.Add(p);
}
return(l);
}
public static ObservableCollection <EtudeViewModel> ListeEtude()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
int idPlage = element.PlageEtudeDAO;
PlageViewModel m = PlageORM.getPlage(idPlage);
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.NbPersonneEtudeDAO, element.TitreEtudeEtudeDAO, m, element.dateCreationDAO, element.dateFinDAO);
l.Add(p);
}
return(l);
}
public static EtudeDAO getEtude(int idEtude)
{
string query = "SELECT * FROM Etude WHERE idEtude=" + idEtude + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
EtudeDAO Etude = new EtudeDAO(reader.GetInt32(0), reader.GetString(1));
reader.Close();
return(Etude);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
int idEquipe = element.idEquipeEtudeDAO;
EquipeViewModel m = EquipeORM.getEquipe(idEquipe);
EtudeViewModel u = new EtudeViewModel(element.idEtudeDAO, element.dateEtudeDAO, element.titreEtudeDAO, element.nbTotalEspeceRencontreeEtudeDAO, m);
l.Add(u);
}
return(l);
}
public static EtudeDAO getEtude(int idEtude)
{
string query = "SELECT * FROM etude WHERE id=" + idEtude + ";";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
EtudeDAO etu = new EtudeDAO(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(2), reader.GetString(3), reader.GetInt32(4));
reader.Close();
return(etu);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
int idEquipe = element.idEquipeEtudeDAO;
EquipeViewModel m = EquipeORM.getEquipe(idEquipe); // Plus propre que d'aller chercher le métier dans la DAO.
EtudeViewModel p = new EtudeViewModel(element.idEtudeDAO, element.dateEtudeDAO, element.titreEtudeDAO, element.nbTotalEspeceRencontreeEtudeDAO, m);
l.Add(p);
}
return(l);
}
public static ObservableCollection <EtudeViewModel> listeEtudes()
{
ObservableCollection <EtudeDAO> lDAO = EtudeDAO.listeEtudes();
ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>();
foreach (EtudeDAO element in lDAO)
{
//int idMetier = element.idMetierPersonneDAO;
//MetierDAO m = MetierDAO.getMetier(idMetier);
//MetierViewModel metier = new MetierViewModel(m.idMetierDAO, m.libMetierDAO);
EtudeViewModel p = new EtudeViewModel(element.id, element.nom, element.date, UtilisateurORM.getPersonne(element.proprio) /*, metier*/);
l.Add(p);
}
return(l);
}
public static void updateEtude(EtudeDAO p)
{
string query = "UPDATE Etude set NbPersonne=@Nombre,Titre=@Titre,NbPlage=@Plage,dateCreation=@DateCrea, dateFin=@DateFin where idEtude=@IdEude;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@Nombre", p.NbPersonneEtudeDAO);
cmd.Parameters.AddWithValue("@Titre", p.TitreEtudeEtudeDAO);
cmd.Parameters.AddWithValue("@Plage", p.PlageEtudeDAO);
cmd.Parameters.AddWithValue("@DateCrea", p.dateCreationDAO);
cmd.Parameters.AddWithValue("@DateFin", p.dateFinDAO);
cmd.Parameters.AddWithValue("@IdEude", p.idEtudeDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertEtude(EtudeDAO p)
{
int id = getMaxIdEtude() + 1;
string query = "INSERT INTO Etude VALUES (@ID,@Nombre,@Titre,@Plage,@DateCrea,@DateFin);";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@ID", id);
cmd.Parameters.AddWithValue("@Nombre", p.NbPersonneEtudeDAO);
cmd.Parameters.AddWithValue("@Titre", p.TitreEtudeEtudeDAO);
cmd.Parameters.AddWithValue("@Plage", p.PlageEtudeDAO);
cmd.Parameters.AddWithValue("@DateCrea", p.dateCreationDAO);
cmd.Parameters.AddWithValue("@DateFin", p.dateFinDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static ObservableCollection <EtudeDAO> selectEtudes()
{
ObservableCollection <EtudeDAO> l = new ObservableCollection <EtudeDAO>();
string query = "SELECT * FROM etude;";
MySqlCommand cmd = new MySqlCommand(query, ConnexionBaseDAL.connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
EtudeDAO p = new EtudeDAO(reader.GetInt32(0), reader.GetDateTime(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4));
l.Add(p);
}
reader.Close();
return(l);
}
public static ObservableCollection <EtudeDAO> selectEtude()
{
ObservableCollection <EtudeDAO> l = new ObservableCollection <EtudeDAO>();
string query = "SELECT * FROM Etude;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
EtudeDAO d = new EtudeDAO(reader.GetInt32(0), reader.GetString(1));
l.Add(d);
}
reader.Close();
return(l);
}
public static EtudeDAO getEtude(int idEtude)
{
string query = "SELECT * FROM etude WHERE id=" + idEtude + ";";
MySqlCommand cmd = new MySqlCommand(query, ConnexionBaseDAL.connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
EtudeDAO pers;
if (reader.HasRows)
{
pers = new EtudeDAO(reader.GetInt32(0), reader.GetDateTime(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4));
}
else
{
pers = new EtudeDAO(1, DateTime.Now, "MauvaisNumeroEtude", 0, 1);
}
reader.Close();
return(pers);
}
public static EtudeDAO getEtude(int idEtude)
{
string query = " SELECT * FROM etude WHERE idEtude =@ID;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@ID", idEtude);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
EtudeDAO com;
if (reader.HasRows)
{
com = new EtudeDAO(reader.GetInt32(0), reader.GetDecimal(1), reader.GetString(2), reader.GetInt32(3), reader.GetDateTime(4), reader.GetDateTime(5));
}
else
{
com = new EtudeDAO(1, 0, "Mauvaise superficie d'etude", 1, DateTime.Today, DateTime.Today);
}
reader.Close();
return(com);
}
public static ObservableCollection <EtudeDAO> selectEtude()
{
ObservableCollection <EtudeDAO> l = new ObservableCollection <EtudeDAO>();
string query = "SELECT * FROM Etude;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
try
{
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
EtudeDAO p = new EtudeDAO(reader.GetInt32(0), reader.GetDecimal(1), reader.GetString(2), reader.GetInt32(3), reader.GetDateTime(4), reader.GetDateTime(5));
l.Add(p);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("La base de données n'est pas connectée");
}
return(l);
}
public static void insertEtude(EtudeViewModel p)
{
EtudeDAO.insertEtude(new EtudeDAO(p.idEtudeProperty, p.nomEtudeProperty, p.dateEtudeProperty, p.nbPersonneProperty, p.idPersonneProperty));
}
public static void supprimerEtude(int id)
{
EtudeDAO.supprimerEtude(id);
}
