public Discount GetById(int id)
{
using (var _dataContext = new CreativeEntities())
{
return(_dataContext.Discounts.Find(id));
}
}
public bool Delete(int id)
{
try
{
using (var _dataContext = new CreativeEntities())
{
Discount discount = _dataContext.Discounts.Find(id);
if (discount != null)
{
_dataContext.Discounts.Remove(discount);
_dataContext.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception e)
{
return(false);
}
}
public Product GetById(int id)
{
using (var _dataContext = new CreativeEntities())
{
return(_dataContext.Products.Find(id));
}
}
public IList <Discount> GetAll()
{
using (var _dataContext = new CreativeEntities())
{
var data = _dataContext.Discounts.ToList();
return(data);
}
}
public IList <Product> GetAll()
{
using (var _dataContext = new CreativeEntities())
{
var data = _dataContext.Products.Where(x => x.IsActive).ToList();
return(data);
}
}
public Discount Insert(Discount entity)
{
using (var _dataContext = new CreativeEntities())
{
Discount discount = _dataContext.Discounts.Add(entity);
_dataContext.SaveChanges();
return(discount);
}
}
public Product Insert(Product entity)
{
using (var _dataContext = new CreativeEntities())
{
Product Product = _dataContext.Products.Add(entity);
_dataContext.SaveChanges();
return(Product);
}
}
public void Update(Discount entity)
{
using (var _dataContext = new CreativeEntities())
{
var original = _dataContext.Discounts.FirstOrDefault(e => e.DiscountId.Equals(entity.DiscountId));
if (original != null)
{
_dataContext.Entry(original).CurrentValues.SetValues(entity);
_dataContext.SaveChanges();
}
}
}
