public static ZoneEtudeViewModel getZoneEtude(int idZoneEtude)
{
ZoneEtudeDAO pDAO = ZoneEtudeDAO.getZoneEtude(idZoneEtude);
int idPersonne = pDAO.idPersonneDAO;
PersonneViewModel personne = PersonenORM.getPersonne(2);
int idEtude = pDAO.idEtudeDAO;
EtudeViewModel etude = EtudeORM.getEtude(idEtude);
int idPlage = pDAO.idPlageDAO;
PlageViewModel plage = PlageORM.getPlage(idPlage);
ZoneEtudeViewModel p = new ZoneEtudeViewModel(pDAO.dateEtudeDAO, pDAO.CoordonnéeADAO, pDAO.CoordonnéeBDAO, pDAO.CoordonnéeCDAO, pDAO.CoordonnéeDDAO, pDAO.superficieZoneEtudeDAO, pDAO.idZoneEtudeDAO, personne, etude, plage);
return(p);
}
public static ZoneEtudeDAO getZoneEtude(int idZoneEtude)
{
string query = "SELECT * FROM ZoneEtude WHERE idZoneEtude=@idZoneEtude;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@idZoneEtude", idZoneEtude);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
ZoneEtudeDAO ZoneEtude = new ZoneEtudeDAO(reader.GetDateTime(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetFloat(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetInt32(9));
reader.Close();
return(ZoneEtude);
}
public static ObservableCollection <ZoneEtudeViewModel> listeZoneEtude()
{
ObservableCollection <ZoneEtudeDAO> lDAO = ZoneEtudeDAO.listeZoneEtude();
ObservableCollection <ZoneEtudeViewModel> l = new ObservableCollection <ZoneEtudeViewModel>();
foreach (ZoneEtudeDAO element in lDAO)
{
int idPersonne = element.idPersonneDAO;
PersonneViewModel personne = PersonenORM.getPersonne(2);
int idEtude = element.idEtudeDAO;
EtudeViewModel etude = EtudeORM.getEtude(idEtude);
int idPlage = element.idPlageDAO;
PlageViewModel plage = PlageORM.getPlage(idPlage);
ZoneEtudeViewModel p = new ZoneEtudeViewModel(element.dateEtudeDAO, element.CoordonnéeADAO, element.CoordonnéeBDAO, element.CoordonnéeCDAO, element.CoordonnéeDDAO, element.superficieZoneEtudeDAO, element.idZoneEtudeDAO, personne, etude, plage);
l.Add(p);
}
return(l);
}
public static void insertZoneEtude(ZoneEtudeDAO c)
{
string query = "INSERT INTO ZoneEtude (CoordonneeA,CoordonneeB,CoordonneeC,CoordonneeD,SuperficieEtude,idZoneEtude,IdPersonne,idEtude,idPlage) VALUES (@CoordonneeA,@CoordonneeB,@CoordonneeC,@CoordonneeD,@SuperficieEtude,@idZoneEtude,@IdPersonne,@idEtude,@idPlage);";
MySqlCommand cmd1 = new MySqlCommand(query, DALConnection.OpenConnection());
cmd1.Parameters.AddWithValue("@CoordonneeA", c.CoordonnéeADAO);
cmd1.Parameters.AddWithValue("@CoordonneeB", c.CoordonnéeBDAO);
cmd1.Parameters.AddWithValue("@CoordonneeC", c.CoordonnéeCDAO);
cmd1.Parameters.AddWithValue("@CoordonneeD", c.CoordonnéeDDAO);
cmd1.Parameters.AddWithValue("@SuperficieEtude", c.superficieZoneEtudeDAO);
cmd1.Parameters.AddWithValue("@idZoneEtude", c.idZoneEtudeDAO);
cmd1.Parameters.AddWithValue("@IdPersonne", c.idPersonneDAO);
cmd1.Parameters.AddWithValue("@idEtude", c.idEtudeDAO);
cmd1.Parameters.AddWithValue("@idPlage", c.idPlageDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd1);
cmd1.ExecuteNonQuery();
}
public static ObservableCollection <ZoneEtudeDAO> selectZoneEtude()
{
ObservableCollection <ZoneEtudeDAO> l = new ObservableCollection <ZoneEtudeDAO>();
string query = "SELECT * FROM ZoneEtude;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ZoneEtudeDAO c = new ZoneEtudeDAO(reader.GetDateTime(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetFloat(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetInt32(9));
l.Add(c);
}
reader.Close();
return(l);
}
public static int getMaxIdZone(EtudeViewModel etude, PlageViewModel plage)
{
int idMax = ZoneEtudeDAO.getMaxIdZone(etude.idEtudeProperty, plage.idPlageProperty);
return(idMax);
}
public static void insertZoneEtude(ZoneEtudeViewModel d)
{
ZoneEtudeDAO.insertZoneEtude(new ZoneEtudeDAO(d.dateEtudeProperty, d.coordonneeAProperty, d.coordonneeBProperty, d.coordonneeCProperty, d.coordonneeDProperty, d.superficieEtudeProperty, d.idZoneEtudeProperty, d.personneProperty.idPersonneProperty, d.etudeProperty.idEtudeProperty, d.plageProperty.idPlageProperty));
}
public static void supprimerZoneEtude(int id)
{
ZoneEtudeDAO.supprimerZoneEtude(id);
}
