public void AjouterArticle(string reference, string designation, decimal prixVente, decimal qteStock, bool sommeil) { if (reference == null) { throw new Exception("Reference nulle impossible."); } if (designation == null || designation.Length < 1) { throw new Exception("Designation vide impossible."); } if (prixVente < 0) { throw new Exception("Prix de vente inférieur à 0 impossible."); } if (qteStock < 0) { throw new Exception("Quantité stock inférieur à 0 impossible."); } using (var context = new DBProdEntities()) { context.DatabaseArticles.Add(new DatabaseArticle() { Reference = reference, Designation = designation, PrixVente = prixVente, QteStock = qteStock, Sommeil = sommeil, }); context.SaveChanges(); } }
public void ModifierParRef(string reference, string designation = null, decimal?prixVente = null, decimal?qteStock = null) { if (prixVente < 0) { throw new Exception("Prix de vente inférieur à 0 impossible."); } if (qteStock < 0) { throw new Exception("Quantité stock inférieur à 0 impossible."); } using (var context = new DBProdEntities()) { var temp = context.DatabaseArticles.Where(r => r.Reference == reference); var result = temp.FirstOrDefault(); if (result != null) { result.Designation = designation ?? result.Designation; result.PrixVente = prixVente ?? result.PrixVente; result.QteStock = qteStock ?? result.QteStock; } context.SaveChanges(); } }