public JsonResult DestroyCategories([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { var cat = this.Data.Categories.GetById(category.Id); var tickets = cat.Tickets.ToList(); foreach (var ticket in tickets) { ticket.Author = null; var comments = ticket.Comments.ToList(); foreach (var comment in comments) { this.Data.Commetns.Delete(comment); } this.Data.Tickets.Delete(ticket); } this.Data.Categories.Delete(cat); this.Data.SaveChanges(); return Json(new[] { category }.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }
public JsonResult UpdateCommand([DataSourceRequest] DataSourceRequest request, CategoryViewModel model) { var entity = this.Data.Categories.GetById(model.Id); entity.Name = model.Name; this.Data.SaveChanges(); return Json(new[] { model }.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }
public JsonResult UpdateCategories([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { var categoryDb = this.Data.Categories.GetById(category.Id); categoryDb.Name = category.Name; this.Data.SaveChanges(); return Json(new[] { category }.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }
public JsonResult DestroyCommand([DataSourceRequest] DataSourceRequest request, CategoryViewModel model) { var tickets = Data.Tickets.All().Where(x => x.CategoryId == model.Id).ToList(); foreach (var ticket in tickets) { Data.Tickets.Delete(ticket); } this.Data.Categories.Delete(model.Id); this.Data.SaveChanges(); return Json(new[] { model }.ToDataSourceResult(request), JsonRequestBehavior.AllowGet); }
public ActionResult Delete([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { if (ModelState.IsValid) { // Delete is cascading!!! var categoryForDelete = this.Data.Categories.GetById(category.Id); this.Data.Categories.Delete(categoryForDelete); this.Data.SaveChanges(); } return Json(new[] { category }.ToDataSourceResult(request, ModelState)); }
public JsonResult UpdateCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { var existingCategory = this.Data.Categories.All().FirstOrDefault(x => x.Id == category.CategoryId); if (category != null && ModelState.IsValid) { existingCategory.Name = category.CategoryName; this.Data.SaveChanges(); } return Json((new[] { category }.ToDataSourceResult(request, ModelState)), JsonRequestBehavior.AllowGet); }
public ActionResult Edit([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { if (ModelState.IsValid) { var editedCategory = this.Data.Categories.GetById(category.Id); editedCategory.Name = category.Name; this.Data.Categories.Update(editedCategory); this.Data.SaveChanges(); } else { ModelState.AddModelError("Name", "Category name is invalid!"); } return Json(new[] { category }.ToDataSourceResult(request, ModelState)); }
public JsonResult CreateCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { if (ModelState.IsValid) { Category newCategory = new Category() { Name = category.Name }; this.Data.Categories.Add(newCategory); this.Data.SaveChanges(); //category.Id = newCategory.Id; } return Json(new[] { category }.ToDataSourceResult(request, ModelState)); }
public JsonResult CreateCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { if (category != null && ModelState.IsValid) { var newCategory = new Category { Id = category.CategoryId, Name = category.CategoryName }; this.Data.Categories.Add(newCategory); this.Data.SaveChanges(); category.CategoryId = newCategory.Id; } return Json(new[] { category }.ToDataSourceResult(request, ModelState), JsonRequestBehavior.AllowGet); }
public JsonResult DeleteCategory([DataSourceRequest] DataSourceRequest request, CategoryViewModel category) { var existingCategory = this.Data.Categories.All().FirstOrDefault(x => x.Id == category.CategoryId); 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); }