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