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();
}
}
