public Product GetProduct(int ID) { using (var context = new LBContext()) { return(context.Products.Find(ID)); } }
public List <Product> GetProducts() { using (var context = new LBContext()) { return(context.Products.ToList()); } }
public List <Category> GetCategories() { using (var context = new LBContext()) { return(context.Categories.ToList()); } }
public Category GetCategory(int ID) { using (var context = new LBContext()) { return(context.Categories.Find(ID)); } }
public void UpdateProduct(Product product) { using (var context = new LBContext()) { context.Entry(product).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void SaveProduct(Product product) { using (var context = new LBContext()) { context.Products.Add(product); context.SaveChanges(); } }
public void UpdateCategory(Category category) { using (var context = new LBContext()) { context.Entry(category).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } }
public void SaveCategory(Category category) { using (var context = new LBContext()) { context.Categories.Add(category); context.SaveChanges(); } }
public void DeleteProduct(int ID) { using (var context = new LBContext()) { //context.Entry(category).State = System.Data.Entity.EntityState.Deleted; var product = context.Products.Find(ID); context.Products.Remove(product); context.SaveChanges(); } }
public void DeleteCategory(int ID) { using (var context = new LBContext()) { //context.Entry(category).State = System.Data.Entity.EntityState.Deleted; var category = context.Categories.Find(ID); context.Categories.Remove(category); context.SaveChanges(); } }