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