public List<Product> GetProductDiscount(int id) { using (ProductContext _db = new ProductContext()) { PromotionDetail pd = _db.PromotionDetails.Find(id); return _db.Products.Where(item => item.ID == id).ToList(); } }
public void UpdatePromotion(Promotion p, PromotionDetail detail) { using (ProductContext _db = new ProductContext()) { var obj = _db.Promotions.Where(x => x.ID == p.ID).FirstOrDefault(); ChangePromotionData(obj, p); PromotionDetail promotionDetail = _db.PromotionDetails.Where(x => x.PromotionID == obj.ID).FirstOrDefault(); ChangePromotioDTData(promotionDetail, detail); _db.SaveChanges(); } }
public void DeletePromotion(int id) { using (ProductContext _db = new ProductContext()) { Promotion p = _db.Promotions.Find(id); _db.Entry(p).State = EntityState.Deleted; _db.SaveChanges(); PromotionDetail d = _db.PromotionDetails.Find(id); _db.Entry(d).State = EntityState.Deleted; _db.SaveChanges(); } }
public void AddPromotion(Promotion p, PromotionDetail detail) { using (ProductContext _db = new ProductContext()) { Promotion obj = _db.Promotions.Where(x => x.ID == p.ID).FirstOrDefault(); if (obj != null) return; _db.Promotions.Add(p); _db.SaveChanges(); detail.PromotionID = _db.Products.Select(i => i.ID).ToList().Max(); _db.PromotionDetails.Add(detail); _db.SaveChanges(); } }
public void ChangePromotioDTData(PromotionDetail A, PromotionDetail B) { A.ProductID = B.ProductID; }