public static void updateEtude(DAOEtude p) { string query = "UPDATE etude set titre=\"" + p.titreDAOEtude + "\", date=\"" + p.dateDAOEtude + "\", idChef=\"" + p.idChef + "\" where idEtude=" + p.idDAOEtude + ";"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static void insertEtude(DAOEtude p) { string query = "INSERT INTO etude (`titre`, `date`,`idChef`) VALUES (\"" + p.titreDAOEtude + "\",\"" + p.dateDAOEtude + "\",\"" + p.idChef + "\");"; MySqlCommand cmd2 = new MySqlCommand(query, connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
private void OnPropertyChanged(string info) { PropertyChangedEventHandler handler = PropertyChanged; if (handler != null) { handler(this, new PropertyChangedEventArgs(info)); DAOEtude.updateEtude(this); } }
public static EtudeViewModel getEtude(int id) { DAOEtude pDAO = DAOEtude.getEtude(id); DAOEnsembles eDAO = DAOEnsembles.getEnsembles(pDAO.idEnsemblePlagesDAOEtude); EnsemblesViewModel e = new EnsemblesViewModel(eDAO.idDAOEnsemblePlage, eDAO.nomDAOEnsemblePlage); DAOEquipe eqDAO = DAOEquipe.getEquipe(pDAO.idEquipe); EquipeViewModel eq = new EquipeViewModel(eqDAO.idDAOEquipe, eqDAO.nomDAOEquipe); EtudeViewModel p = new EtudeViewModel(pDAO.idDAOEtude, pDAO.titreDAOEtude, e, pDAO.dateDAOEtude, eq); return(p); }
public static DAOEtude getEtude(int id) { string query = "SELECT * FROM etude WHERE idEtude=" + id + ";"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); DAOEtude p = new DAOEtude(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(3), reader.GetInt32(4)); reader.Close(); return(pers); }
public static ObservableCollection <EtudeViewModel> listeEtudes() { ObservableCollection <DAOEtude> lDAO = DAOEtude.listeEtudes(); ObservableCollection <EtudeViewModel> l = new ObservableCollection <EtudeViewModel>(); foreach (DAOEtude element in lDAO) { DAOEnsembles eDAO = DAOEnsembles.getEnsembles(element.idEnsemblePlagesDAOEtude); DAOEquipe eqDAO = DAOEquipe.getEquipe(element.idEquipe); EquipeViewModel eq = new EquipeViewModel(eqDAO.idDAOEquipe, eqDAO.nomDAOEquipe); EnsemblesViewModel e = new EnsemblesViewModel(eDAO.idDAOEnsemblePlage, eDAO.nomDAOEnsemblePlage); EtudeViewModel p = new EtudeViewModel(element.idDAOEtude, element.titreDAOEtude, e, element.dateDAOEtude, eq); l.Add(p); } return(l); }
public static ObservableCollection <DAOEtude> selectEtudes() { ObservableCollection <DAOEtude> l = new ObservableCollection <DAOEtude>(); string query = "SELECT * FROM etude;"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DAOEtude p = new DAOEtude(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(3), reader.GetInt32(4)); l.Add(p); } reader.Close(); return(l); }
public static DAOEtude getEtude(int id) { DAOEtude p = DALEtude.getEtude(id); return(p); }
public static void supprimerEtude(int id) { DAOEtude.supprimerEtude(id); }
public static void insertEtude(string titre, EnsemblesViewModel ensembles, EquipeViewModel equipe) { DAOEtude.insertEtude(new EtudeViewModel(titre, ensembles, DateTime.Now, equipe)); }