public static void addZone(DAOZoneEspece zone)
{
string query = "INSERT INTO zoneespèce VALUES (\"" + zone.idZoneEDAO + "\",\"" + zone.IdEspeceDAO + "\",\"" + zone.IdZoneDAO + "\",\"" + zone.IdEtudeDAO + "\",\"" + zone.IdPlageDAO + "\",\"" + zone.NombreDAO + "\");";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(command);
command.ExecuteNonQuery();
}
public static ObservableCollection <ZoneEspeceViewModel> listeZones()
{
ObservableCollection <DAOZoneEspece> listeDAO = DAOZoneEspece.listeZones();
ObservableCollection <ZoneEspeceViewModel> listeZones = new ObservableCollection <ZoneEspeceViewModel>();
foreach (DAOZoneEspece item in listeDAO)
{
int idZone = item.IdZoneDAO;
int idEspece = item.IdEspeceDAO;
int idEtude = item.IdEtudeDAO;
int idPlage = item.IdPlageDAO;
ZonePrelevementViewModel zoneID = ORMZonePrelevement.getZone(idZone);
EspèceViewModel especeID = ORMEspèce.getEspèce(idEspece);
EtudeViewModel etudeID = ORMEtude.getEtude(idEtude);
PlageViewModel plageID = ORMPlage.getPlage(idPlage);
ZoneEspeceViewModel zone = new ZoneEspeceViewModel(item.idZoneEDAO, especeID, zoneID, etudeID, plageID, item.NombreDAO);
listeZones.Add(zone);
}
return(listeZones);
}
public static ObservableCollection <DAOZoneEspece> selectZones()
{
ObservableCollection <DAOZoneEspece> listeZones = new ObservableCollection <DAOZoneEspece>();
string query = "SELECT * FROM zoneespèce;";
MySqlCommand command = new MySqlCommand(query, DALConnection.Connection());
try
{
command.ExecuteNonQuery();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
DAOZoneEspece zone = new DAOZoneEspece(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5));
listeZones.Add(zone);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("Une erreur est survenue impossible de continuer...");
}
return(listeZones);
}
public static void addZone(ZoneEspeceViewModel zone)
{
DAOZoneEspece.addZone(new DAOZoneEspece(zone.idZoneEProperty, zone.idEspece.idEspèceProperty, zone.idZone.idZonePrelevementProperty, zone.idEtude.idEtudeProperty, zone.idPlage.idPlageProperty, zone.nombreProperty));
}
