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