public void UpdateZone(DOZone obj)
{
if (obj != null)
{
string query = "UPDATE " + _table + "(area, Etude_iDEtude, Plage_idPlage) "
+ "VALUES('" + obj.area + "', '" + obj.idEtude + "', '" + obj.idPlage + "')";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
// check ... ?
}
this.CloseConnection();
}
}
public void InsertZone(DOZone obj)
{
if (obj != null)
{
string query = "INSERT INTO " + _table + "(area, Etude_iDEtude, Plage_idPlage) "
+ "VALUES('" + obj.area + "', '" + obj.idEtude + "', '" + obj.idPlage + "')";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
// check rows pour vérifier qu'il y a bien eu insertion ?
// get de l'id de la dernière row insérée
}
this.CloseConnection();
}
}
public void SelectZoneById(int id, DOZone obj)
{
DOZone selected = new DOZone();
string query = "SELECT * FROM " + _table + " WHERE idZone = '" + id + "';";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
obj.idZone = reader.GetInt32(0);
obj.area = reader.GetInt32(5);
obj.idEtude = reader.GetInt32(6);
obj.idPlage = reader.GetInt32(7);
}
reader.Close();
}
this.CloseConnection();
}
public List <DOZone> SelectZone()
{
List <DOZone> col = new List <DOZone>();
string query = "SELECT * FROM " + _table + ";";
this.OpenConnection();
{
MySqlCommand cmd = new MySqlCommand(query, this.connection);
int rows = cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DOZone obj = new DOZone(reader.GetInt32(0), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7));
col.Add(obj);
}
reader.Close();
}
this.CloseConnection();
return(col);
}
