public void AddProduct(Product product) { using (CustomerDbContext customerDbContext = new CustomerDbContext()) { customerDbContext.Products.Add(product); customerDbContext.SaveChanges(); } }
public void DeleteProduct(int id) { using (CustomerDbContext customerDbContext = new CustomerDbContext()) { Product result = customerDbContext.Products.Find(id); customerDbContext.Products.Remove(result); customerDbContext.SaveChanges(); } }
public IEnumerable <Product> EditProduct(int id) { using (CustomerDbContext customerDbContext = new CustomerDbContext()) { IEnumerable <Product> result = from p in customerDbContext.Products.Where(x => x.id == id) select p; return(result); } }
public IEnumerable <Product> DisplayPoduct() { using (CustomerDbContext customerDbContext = new CustomerDbContext()) { IEnumerable <Product> result = from p in customerDbContext.Products select p; return(result); } }
public void UpdateProduct(int id, Product product) { using (CustomerDbContext customerDbContext = new CustomerDbContext()) { Product products = customerDbContext.Products.Where(x => x.id == id).FirstOrDefault(); products.name = product.name; products.description = product.description; products.price = product.price; customerDbContext.SaveChanges(); } }