private List <UserRole_VM> ConnectGetDataProcedure(UserRole_VM VM) { List <UserRole_VM> query = new List <UserRole_VM>(); using (var db = new WebPortalEntities()) { var config = new MapperConfiguration(cfg => cfg.CreateMap <GetUserRole_Result, UserRole_VM>()); var mapper = config.CreateMapper(); List <GetUserRole_Result> data = db.GetUserRole(VM.UserRoleID, VM.UserRoleName).ToList(); return(mapper.Map <List <GetUserRole_Result>, List <UserRole_VM> >(data, query)); } }
public bool Update(UserRole_VM Model) { try { using (var db = new WebPortalEntities()) { int returnResult = db.UpdateUserRole(Model.UserRoleID, Model.UserRoleName, Model.CurrentEndUserID, Model.CurrentScreenID, Model.AccessPoint); db.SaveChanges(); return(returnResult > 0); } } catch (Exception ex) { logger.Error("Error: ", ex); throw; } }
public bool Add(UserRole_VM Model) { try { using (var db = new WebPortalEntities()) { var returnResult = new ObjectParameter("p_UserRoleID", 0); db.AddUserRole(Model.UserRoleName, Model.CurrentEndUserID, Model.CurrentScreenID, Model.AccessPoint, returnResult); db.SaveChanges(); return(Convert.ToInt32(returnResult.Value) > 0); } } catch (Exception ex) { logger.Error("UserRoleRepository_Add: ", ex); throw; } }
public JsonResult AddUpdateData(UserRole_VM Model) { if (Model != null) { if (ModelState.IsValid) { try { GetUserInfo(Model); if (Model.UserRoleID == null || Model.UserRoleID == 0) { var data = _RoleRepo.Add(Model); if (data) { return(Json(new JsonResponse("Success", saveMessage, data), JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResponse("Error", saveErrorMessage, data), JsonRequestBehavior.AllowGet)); } } else if (Model.UserRoleID > 0) { var data = _RoleRepo.Update(Model); if (data) { return(Json(new JsonResponse("Success", updateMessage, data), JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResponse("Error", updateErrorMessage, data), JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { //Log the error logger.Error("UserRoleController_AddUpdateData Error: ", ex); if (ex.InnerException != null) { return(Json(new JsonResponse("Error", ex.InnerException.Message.ToString(), null), JsonRequestBehavior.AllowGet)); } else { return(Json(new JsonResponse("Error", ex.Message.ToString(), null), JsonRequestBehavior.AllowGet)); } } } else { string ErrorMessage = string.Empty; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { ErrorMessage += error.ErrorMessage + "<br/>"; } } return(Json(new JsonResponse("Error", ErrorMessage, null), JsonRequestBehavior.AllowGet)); } } return(Json(new JsonResponse("Error", "Data can not be null.", null), JsonRequestBehavior.AllowGet)); }