public void update(EmployeStock empStock)
{
conn = new DB().getConn();
try
{
string query = "update employe_stock set";
if (empStock.Stock != null)
{
query += " stock = " + empStock.Stock + " where 1<2";
}
if (empStock.Id != 0)
{
query += " and id = " + empStock.Id;
}
if (empStock.Employe != 0)
{
query += " and employe = " + empStock.Employe;
}
if (empStock.Carte != 0)
{
query += " and carte = " + empStock.Carte;
}
Debug.WriteLine(query);
cmd = new NpgsqlCommand(query, conn);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockDAO=>update " + e.Message);
}
}
//INSERT LIVRAISON
public ActionResult Livraison(int empStock, int employe, int quantite,
int resteNonVendu, string dateLivraison, int pointDeVente)
{
//Insertion livraison
livraisonCarteService = new LivraisonCarteService();
empStockService = new EmployeStockService();
empService = new EmployeService();
Employe emp = new Employe(employe);
PointDeVente pointVente = new PointDeVente(pointDeVente);
EmployeStock employeStock = new EmployeStock(empStock);
DateTime date = DateTime.Parse(dateLivraison);
LivraisonCarte livCarte = new LivraisonCarte(employeStock, quantite, resteNonVendu,
date, pointVente);
livraisonCarteService.insert(livCarte);
//Update stock
EmployeStockVue emplStock = empStockService.findById(empStock);
Debug.WriteLine("Emp stock update " + emplStock.Stock + "-" + empStock);
int stockUpdate = emplStock.Stock - quantite;
EmployeStock empStockUpdate = new EmployeStock(emplStock.Id, stockUpdate);
empStockService.update(empStockUpdate);
//GET ALL STOCK
EmployeVue empl = empService.findById(employe);
List <EmployeStockVue> listAll = empStockService.search(new EmployeStockVue(empl.Nom, emp.Prenom));
ViewBag.listStock = listAll;
return(View());
}
public void update(EmployeStock empStock)
{
try
{
empStockDAO.update(empStock);
}
catch (Exception e) {
throw new Exception("Erreur dans EmployeStockService => update:" + e.Message);
}
}
public void insert(EmployeStock empStock)
{
try
{
empStockDAO.insert(empStock);
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockService => insert:" + e.Message);
}
}
public void remove(EmployeStock empStock)
{
conn = new DB().getConn();
try
{
string query = "delete * from employe_stock where id = " + empStock.Id;
cmd = new NpgsqlCommand(query, conn);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockDAO=>remove " + e.Message);
}
finally
{
conn.Close();
}
}
public void insert(EmployeStock empStock)
{
conn = new DB().getConn();
try
{
string query = "insert into employe_stock (id, employe, stock, carte) "
+ " values (nextval('seq_employe_stock')," + empStock.Employe + ","
+ empStock.Stock + empStock.Carte + ")";
cmd = new NpgsqlCommand(query, conn);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockDAO=>insert" + e.Message);
}
finally
{
conn.Close();
}
}
