public ActionResult ManageLevel(ManageLevel model) { try { var LevelName = model.LevelName.Trim(); var LevelDescription = model.LevelDescription.Trim(); var temp = db.ActivityLevels.Where(r => r.ActivityLevel1 == LevelName && r.IsActive == true).Select(f => f.ActivityLevel1); foreach (var check in temp) { if (check == LevelName) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } } { var Assignobj = db.ActivityLevels.CreateObject(); Assignobj.ActivityLevel1 = LevelName; Assignobj.LevelDescription = LevelDescription; db.ActivityLevels.AddObject(Assignobj); db.SaveChanges(); } } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(Json("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult AddLevel(ManageLevel model) { try { var LevelName = model.LevelName.Trim(); var LevelDescription = ""; if (model.LevelDescription != null) { LevelDescription = model.LevelDescription.Trim(); } var temp = db.ActivityLevels.Where(r => r.ActivityLevel1 == LevelName && r.IsActive == true).Select(f => f.ActivityLevelID).FirstOrDefault(); //foreach (var check in temp) //{ if (temp != 0) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } //} { var count = db.ActivityLevels.Where(x => x.IsActive == true).Select(o => o).Count(); var Assignobj = db.ActivityLevels.CreateObject(); Assignobj.ActivityLevel1 = LevelName; Assignobj.IsActive = true; Assignobj.LevelDescription = LevelDescription; Assignobj.LevelOrder = count + 1; db.ActivityLevels.AddObject(Assignobj); db.SaveChanges(); } } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(Json("Success", JsonRequestBehavior.AllowGet)); }
public ActionResult EditLevel(ManageLevel Model) { try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); int LevelId = Model.LevelId; string LevelName = Model.LevelName.Trim(); string LevelDescription = ""; if (Model.LevelDescription != null) { LevelDescription = Model.LevelDescription.Trim(); } var data = db.ActivityLevels.Where(o => o.ActivityLevelID != LevelId && o.IsActive == true).Select(o => o.ActivityLevel1); foreach (var check in data) { if (check.ToLower() == LevelName.ToLower()) { return(Json("Warning", JsonRequestBehavior.AllowGet)); } } var datas = db.ActivityLevels.Where(o => o.ActivityLevelID == LevelId).Select(o => o).FirstOrDefault(); { datas.ActivityLevel1 = LevelName; datas.LevelDescription = LevelDescription; db.SaveChanges(); } } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(Json("Success1", JsonRequestBehavior.AllowGet)); }