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