public ActionResult Destroy([DataSourceRequest] DataSourceRequest request, SystemRuleVM viewModel) { try { if (viewModel != null) { ModelState.Clear(); SystemRule delviewModel = db.SystemRules.Find(viewModel.SystemRuleId); if (delviewModel != null) { db.SystemRules.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(new Exception("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", "Data error"); Elmah.ErrorSignal.FromCurrentContext().Raise(dataEx); } return Json(ModelState.IsValid ? new object() : ModelState.ToDataSourceResult()); }
public JsonResult AvailableSystemsListing([DataSourceRequest]DataSourceRequest request, bool AddDefault = false) { IQueryable<SystemRule> tObj = null; int iUserId = ((UserSessionVM)HttpContext.Session["UserSession"]).UserId; tObj = db.SystemRules.Where( w => w.Campaigns.Any(wc => wc.UserUserId == iUserId)).OrderBy(o => o.SystemName); List<SystemRuleVM> resultList = new List<SystemRuleVM>(); SystemRuleVM firstItem = new SystemRuleVM(); if (AddDefault) { firstItem.SystemRuleId = -1; firstItem.SystemName = "None"; resultList.Add(firstItem); } foreach (var item in tObj) { SystemRuleVM newItem = new SystemRuleVM(); newItem.SystemRuleId = item.SystemRuleId; newItem.SystemName = item.SystemName; resultList.Add(newItem); } return Json(resultList, JsonRequestBehavior.AllowGet); }
public ActionResult Create([DataSourceRequest] DataSourceRequest request, SystemRuleVM viewModel) { try { if (viewModel != null && ModelState.IsValid) { SystemRule newviewModel = new SystemRule(); newviewModel.SystemName = viewModel.SystemName; newviewModel.Description = viewModel.Description; db.SystemRules.Add(newviewModel); db.SaveChanges(); viewModel.SystemRuleId = newviewModel.SystemRuleId; } } catch (DataException dataEx) { ModelState.AddModelError(string.Empty, "Data error"); Elmah.ErrorSignal.FromCurrentContext().Raise(dataEx); } return Json(new[] { viewModel }.ToDataSourceResult(request, ModelState)); }
public JsonResult SystemsListing([DataSourceRequest]DataSourceRequest request, bool AddDefault = false) { IQueryable<SystemRule> tObj = null; tObj = db.SystemRules.OrderBy(o => o.SystemName); List<SystemRuleVM> resultList = new List<SystemRuleVM>(); SystemRuleVM firstItem = new SystemRuleVM(); if (AddDefault) { firstItem.SystemRuleId = -1; firstItem.SystemName = "None"; resultList.Add(firstItem); } foreach (var item in tObj) { SystemRuleVM newItem = new SystemRuleVM(); newItem.SystemRuleId = item.SystemRuleId; newItem.SystemName = item.SystemName; resultList.Add(newItem); } return Json(resultList, JsonRequestBehavior.AllowGet); }