public static void updateZoneInvestigation(ZoneInvestigationDAO p)
{
string query = "UPDATE etude_has_plage set NomZone=@NomZone,Angle1=@Angle1,Angle2=@Angle2,Angle3=@Angle3,Angle4=@Angle4 where IdZone=@IdZone;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@IdZone", p.IdZoneDAO);
cmd.Parameters.AddWithValue("@NomZone", p.NomZoneDAO);
cmd.Parameters.AddWithValue("@Angle1", p.Angle1DAO);
cmd.Parameters.AddWithValue("@Angle2", p.Angle2DAO);
cmd.Parameters.AddWithValue("@Angle3", p.Angle3DAO);
cmd.Parameters.AddWithValue("@Angle4", p.Angle4DAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertZoneInvestigation(ZoneInvestigationDAO p)
{
int id = getMaxIdZoneInvestigation() + 1;
string query = "INSERT INTO etude_has_plage (IdZone,Etude_idEtude,Plage_idPlage,Date,NomZone,Angle1,Angle2,Angle3,Angle4,Users_idUsers) VALUES (@IdZone,@IdEtude,@IdPlage,@DateCrea,@NomZone,@Angle1,@Angle2,@Angle3,@Angle4,@IdUsers);";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@IdZone", id);
cmd.Parameters.AddWithValue("@NomZone", p.NomZoneDAO);
cmd.Parameters.AddWithValue("@IdEtude", p.IdEtudeDAO);
cmd.Parameters.AddWithValue("@IdPlage", p.IdPlageDAO);
cmd.Parameters.AddWithValue("@DateCrea", p.EtudeDateDAO);
cmd.Parameters.AddWithValue("@Angle1", p.Angle1DAO);
cmd.Parameters.AddWithValue("@Angle2", p.Angle2DAO);
cmd.Parameters.AddWithValue("@Angle3", p.Angle3DAO);
cmd.Parameters.AddWithValue("@Angle4", p.Angle4DAO);
cmd.Parameters.AddWithValue("@IdUsers", p.IdUsersDAO);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static ZoneInvestigationDAO getZoneInvestigation(int IdZone)
{
string query = " SELECT * FROM etude_has_plage WHERE IdZone =@ID;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.Parameters.AddWithValue("@ID", IdZone);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
ZoneInvestigationDAO com;
if (reader.HasRows)
{
com = new ZoneInvestigationDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3), reader.GetString(4), reader.GetDecimal(5), reader.GetDecimal(6), reader.GetDecimal(7), reader.GetDecimal(8), reader.GetInt32(9));
}
else
{
com = new ZoneInvestigationDAO(1, 1, 1, DateTime.Today, "Mauvais nom", 0, 0, 0, 0, 1);
}
reader.Close();
return(com);
}
public static ObservableCollection <ZoneInvestigationDAO> selectZoneInvestigation()
{
ObservableCollection <ZoneInvestigationDAO> l = new ObservableCollection <ZoneInvestigationDAO>();
string query = "SELECT * FROM etude_has_plage;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
try
{
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ZoneInvestigationDAO p = new ZoneInvestigationDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3), reader.GetString(4), reader.GetDecimal(5), reader.GetDecimal(6), reader.GetDecimal(7), reader.GetDecimal(8), reader.GetInt32(9));
l.Add(p);
}
reader.Close();
}
catch (Exception e)
{
MessageBox.Show("La base de données n'est pas connectée");
}
return(l);
}