public void UpdatProduct(TblProducts product)
{
using (var context = new DRYFRUITSSERVICESMDFContext())
{
var updateproduct = context.TblProducts.Find(product.ProductId);
updateproduct.Quantity = product.Quantity;
updateproduct.Description = product.Description;
updateproduct.Price = product.Price;
updateproduct.Modified = DateTime.Now;
context.Update(updateproduct);
context.SaveChanges();
}
}
public List <TblProducts> GetAllProducts()
{
try
{
using (var context = new DRYFRUITSSERVICESMDFContext())
{
return(context.TblProducts.ToList());
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddProduct(TblProducts product)
{
try
{
using (var context = new DRYFRUITSSERVICESMDFContext())
{
context.TblProducts.Add(product);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public TblProducts GetProductById(int productId)
{
try
{
using (var context = new DRYFRUITSSERVICESMDFContext())
{
var product = context.TblProducts.Where(x => x.ProductId == productId).FirstOrDefault();
return(product);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void DeleteProduct(int productId)
{
try
{
using (var context = new DRYFRUITSSERVICESMDFContext())
{
var product = context.TblProducts.Find(productId);
context.TblProducts.Remove(product);
context.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
