public JsonResult UpdateCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category)
{
var categoryDb = this.Data.Categories.All().Where(c => c.Id == category.Id).FirstOrDefault();
categoryDb.Name = category.Name;
this.Data.SaveChanges();
return Json(new[] { category }.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public JsonResult CreateCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category)
{
var newCategory = new Category() { Name = category.Name };
this.Data.Categories.Add(newCategory);
this.Data.SaveChanges();
category.Id = newCategory.Id;
return Json(new[] { category }.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public JsonResult UpdateCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category)
{
var existingCategory = this.Data.Categories.All().FirstOrDefault(c => c.Id == category.Id);
if (category != null && ModelState.IsValid)
{
existingCategory.Name = category.Name;
this.Data.SaveChanges();
}
return Json((new[] { category }.ToDataSourceResult(request, ModelState)), JsonRequestBehavior.AllowGet);
}
public JsonResult CreateCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category)
{
if (category != null && ModelState.IsValid)
{
var newCategory = new Category
{
Name = category.Name
};
this.Data.Categories.Add(newCategory);
this.Data.SaveChanges();
}
return Json(new[] { category }.ToDataSourceResult(request, ModelState), JsonRequestBehavior.AllowGet);
}
public JsonResult DeleteCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category)
{
var existingCategory = this.Data.Categories.All().FirstOrDefault(c => c.Id == category.Id);
foreach (var ticket in existingCategory.Tickets.ToList())
{
foreach (var comment in ticket.Comments.ToList())
{
this.Data.Comments.Delete(comment);
}
this.Data.Tickets.Delete(ticket);
}
this.Data.Categories.Delete(existingCategory);
this.Data.SaveChanges();
return Json(new[] { category }, JsonRequestBehavior.AllowGet);
}