public ZoneDeTravail findById(int id) { conn = new DB().getConn(); ZoneDeTravail zoneTrav = null; try { string query = "select * from zone_travail where id=" + id; cmd = new NpgsqlCommand(query, conn); reader = cmd.ExecuteReader(); if (reader.Read() == true) { zoneTrav = new ZoneDeTravail(reader.GetInt16(0), reader.GetString(1)); } } catch (Exception e) { throw new Exception("Erreur dans ZoneTravail=>findBydId " + e.Message); } finally { conn.Close(); reader.Close(); } return(zoneTrav); }
public List <ZoneDeTravail> search(ZoneDeTravail zoneTrav) { conn = new DB().getConn(); List <ZoneDeTravail> listAll = new List <ZoneDeTravail>(); try { string query = "select * from zone_travail when "; if (zoneTrav.Libelle != null) { query += "libelle =" + zoneTrav.Libelle; } cmd = new NpgsqlCommand(query, conn); reader = cmd.ExecuteReader(); while (reader.Read() == true) { ZoneDeTravail zTrav = new ZoneDeTravail(reader.GetInt16(0), reader.GetString(1)); listAll.Add(zTrav); } } catch (Exception e) { throw new Exception("Erreur dans ZoneDeTravailDAO=>search " + e.Message); } finally { conn.Close(); reader.Close(); } return(listAll); }
public List <ZoneDeTravail> getAll() { List <ZoneDeTravail> listAll = new List <ZoneDeTravail>(); conn = new DB().getConn(); try { string query = "select * from zone_travail"; cmd = new NpgsqlCommand(query, conn); reader = cmd.ExecuteReader(); while (reader.Read() == true) { ZoneDeTravail zoneTrav = new ZoneDeTravail(reader.GetInt16(0), reader.GetString(1)); listAll.Add(zoneTrav); } } catch (Exception e) { throw new Exception("Erreur dans ZoneDeTravailDAO->getAll" + e.Message); } finally { conn.Close(); reader.Close(); } return(listAll); }
public void insert(ZoneDeTravail zoneTrav) { conn = new DB().getConn(); try { string query = "insert into zone_travail (id,libelle) values (nextval('seq_zone_travail')," + zoneTrav.Libelle + ")"; cmd = new NpgsqlCommand(query, conn); cmd.ExecuteNonQuery(); } catch (Exception e) { throw new Exception("Erreur dans ZoneDeTravailDAO=>insert" + e.Message); } finally { conn.Close(); } }
public void remove(ZoneDeTravail zoneTrav) { conn = new DB().getConn(); try { string query = "delete * from zone_travail where id = " + zoneTrav.Id; cmd = new NpgsqlCommand(query, conn); cmd.ExecuteNonQuery(); } catch (Exception e) { throw new Exception("Erreur dans ZoneDeTravailDAO=>remove " + e.Message); } finally { conn.Close(); } }