public List <Category> GetAllCategories() { DemoWebServiceEntities entity = new DemoWebServiceEntities(); List <Category> listCategory = entity.Categories.ToList(); //foreach (var item in listCategory) //{ // item.Products.Clear(); //} return(listCategory); }
public List <Category> DeleteCategory(int id) { DemoWebServiceEntities db = new DemoWebServiceEntities(); Category category = db.Categories.FirstOrDefault(x => x.CategoryID == id); if (category != null) { db.Categories.Remove(category); } db.SaveChanges(); List <Category> listCategory = db.Categories.ToList(); return(listCategory); }
public List <Category> EditCategory(int id, string name) { DemoWebServiceEntities db = new DemoWebServiceEntities(); Category category = db.Categories.FirstOrDefault(x => x.CategoryID == id); if (category != null) { category.CategoryName = name; } db.SaveChanges(); List <Category> listCategory = db.Categories.ToList(); return(listCategory); }
public List <Category> AddCategory(int CategoryID, string CategoryName) { DemoWebServiceEntities db = new DemoWebServiceEntities(); List <Category> listCategory = db.Categories.ToList(); try { Category category = new Category(); category.CategoryID = CategoryID; category.CategoryName = CategoryName; db.Categories.Add(category); db.SaveChanges(); listCategory.Add(category); return(listCategory); } catch (Exception) { } return(listCategory); }