public void insert(PointDeVenteStock pv) { try { pointDeVenteStockDAO.insert(pv); } catch (Exception e) { throw new Exception("Erreur dans PointDeVenteStockService => insert:" + e.Message); } }
public void remove(PointDeVenteStock pv) { try { pointDeVenteStockDAO.remove(pv); } catch (Exception e) { throw new Exception("Erreur dans PointDeVenteStockService => remove:" + e.Message); } }
public void remove(PointDeVenteStock pv) { conn = new DB().getConn(); try { string query = "delete * from point_de_vente_stock where id = " + pv.Id; cmd = new NpgsqlCommand(query, conn); cmd.ExecuteNonQuery(); } catch (Exception e) { throw new Exception("Erreur dans PointDeVenteStockDAO=>remove " + e.Message); } finally { conn.Close(); } }
public void insert(PointDeVenteStock pv) { conn = new DB().getConn(); try { string query = "insert into point_de_vente (id,point_de_vente,stock) values (nextval('sq_pv_stock')," + pv.PointDeVente + "," + pv.Stock + ")"; cmd = new NpgsqlCommand(query, conn); cmd.ExecuteNonQuery(); } catch (Exception e) { throw new Exception("Erreur dans PointDeVenteStockDAO=>insert" + e.Message); } finally { conn.Close(); } }