public ActionResult DestroySystemSkillCategory([DataSourceRequest] DataSourceRequest request, SystemSkillCategoryVM viewModel) { try { if (viewModel != null) { ModelState.Clear(); SystemSkillCategory delviewModel = db.SystemSkillCategories.Find(viewModel.SystemSkillCategoryId); if (delviewModel != null) { db.SystemSkillCategories.Remove(delviewModel); db.SaveChanges(); } } } catch (DbUpdateException dbUpdEx) { ModelState.AddModelError("showerror", "Delete failed. This is most likely due to related child information that needs to be deleted first."); Elmah.ErrorSignal.FromCurrentContext().Raise(dbUpdEx); } catch (DataException dataEx) { ModelState.AddModelError("hideerror", "Could not delete SystemSkillCategory."); Elmah.ErrorSignal.FromCurrentContext().Raise(dataEx); } return Json(ModelState.IsValid ? new object() : ModelState.ToDataSourceResult()); }
public ActionResult CreateSystemSkillCategory([DataSourceRequest] DataSourceRequest request, SystemSkillCategoryVM viewModel, int? SystemRuleId) { try { if (viewModel != null && ModelState.IsValid) { SystemSkillCategory newviewModel = new SystemSkillCategory(); newviewModel = Mapper.Map<SystemSkillCategoryVM, SystemSkillCategory>(viewModel, newviewModel); if (SystemRuleId.HasValue) { newviewModel.SystemRuleSystemRuleId = (int)SystemRuleId; viewModel.SystemRuleSystemRuleId = (int)SystemRuleId; } db.SystemSkillCategories.Add(newviewModel); db.SaveChanges(); viewModel.SystemSkillCategoryId = newviewModel.SystemSkillCategoryId; viewModel.SystemRuleSystemName = db.SystemRules.Find(viewModel.SystemRuleSystemRuleId).SystemName; } } catch (DataException dataEx) { ModelState.AddModelError(string.Empty, "Could not add SystemSkillCategory."); Elmah.ErrorSignal.FromCurrentContext().Raise(dataEx); } return Json(new[] { viewModel }.ToDataSourceResult(request, ModelState)); }
public ActionResult UpdateSystemSkillCategory([DataSourceRequest] DataSourceRequest request, SystemSkillCategoryVM viewModel) { try { if (ModelState.IsValid) { SystemSkillCategory newviewModel = new SystemSkillCategory(); newviewModel = Mapper.Map<SystemSkillCategoryVM, SystemSkillCategory>(viewModel, newviewModel); db.Entry(newviewModel).State = EntityState.Modified; db.SaveChanges(); viewModel.SystemRuleSystemName = db.SystemRules.Find(viewModel.SystemRuleSystemRuleId).SystemName; } } catch (DataException dataEx) { ModelState.AddModelError(string.Empty, "Could not update SystemSkillCategory."); Elmah.ErrorSignal.FromCurrentContext().Raise(dataEx); } return Json(new[] { viewModel }.ToDataSourceResult(request, ModelState)); }
// SpringGage public JsonResult SystemSkillCategoriesListing([DataSourceRequest]DataSourceRequest request, int? SystemRuleId, bool AddDefault = false) { IQueryable<SystemSkillCategory> tObj = null; if (SystemRuleId.HasValue) { tObj = db.SystemSkillCategories.Where(w => w.SystemRuleSystemRuleId == SystemRuleId).OrderBy(o => o.Name); } else { tObj = db.SystemSkillCategories.OrderBy(o => o.Name); } List<SystemSkillCategoryVM> resultList = new List<SystemSkillCategoryVM>(); SystemSkillCategoryVM firstItem = new SystemSkillCategoryVM(); if (AddDefault) { firstItem.SystemSkillCategoryId = -1; firstItem.Name = "None"; resultList.Add(firstItem); } foreach (var item in tObj) { SystemSkillCategoryVM newItem = new SystemSkillCategoryVM(); newItem.SystemSkillCategoryId = item.SystemSkillCategoryId; newItem.Name = item.Name; resultList.Add(newItem); } return Json(resultList, JsonRequestBehavior.AllowGet); }