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