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