public IEnumerable <Product> GetAllProducts()
{
using (var db = new ProductsDBEntities())
{
return(db.Products.ToList());
}
}
public void CreateProduct(Product product)
{
using (var db = new ProductsDBEntities())
{
db.Products.Add(product);
db.SaveChanges();
}
}
public void DeleteProduct(int id)
{
using (var db = new ProductsDBEntities())
{
var entity = db.Products.SingleOrDefault(p => p.Id == id);
db.Products.Remove(entity);
db.SaveChanges();
}
}
public List <Product> GetProductbyId(int id)
{
using (var db = new ProductsDBEntities())
{
// thats way using sp !!!
//var byCat = db.GetProductaByCategory("gghghg");
return(db.Products.Where(p => p.Id == id).ToList());
}
}
public void UpdateProduct(int id, Product product)
{
using (var db = new ProductsDBEntities())
{
var entity = db.Products.SingleOrDefault(p => p.Id == id);
entity.Name = product.Name;
entity.Price = product.Price;
entity.Category = product.Category;
db.SaveChanges();
}
}
