//[TypeFilter(typeof(ActionFilters.RolesValidate), Arguments = new object[] { "User_Role", EnumPermission.Edit })] public async Task <IActionResult> Edit(User_RoleView user_Role) { ResponseHelper objHelper = new ResponseHelper(); if (!ModelState.IsValid) { objHelper.Status = StatusCodes.Status424FailedDependency; objHelper.Message = ModelException.Errors(ModelState); return(BadRequest(objHelper)); } try { if (user_RoleRepository.Exists(user_Role)) { objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Data already available"; return(Ok(objHelper)); } await user_RoleRepository.Update(user_Role); objHelper.Status = StatusCodes.Status200OK; objHelper.Message = "Saved Successfully"; objHelper.Data = user_Role; return(Ok(objHelper)); } catch (Exception ex) { objHelper.Status = StatusCodes.Status500InternalServerError; objHelper.Message = ex.Message; return(StatusCode(StatusCodes.Status500InternalServerError, objHelper)); } }
public bool Exists(User_RoleView entity) { int intCount = 0; if (entity.Id > 0) { intCount = adbContext.user_role.Where(w => w.Id != entity.Id && (w.User_Id == entity.User_Id && w.Role_Id == entity.Role_Id)).Count(); } else { intCount = adbContext.user_role.Where(w => w.User_Id == entity.User_Id && w.Role_Id == entity.Role_Id).Count(); } return(intCount > 0 ? true : false); }
public async Task Insert(User_RoleView entity) { try { //Insert New Zone var vList = new User_Role { User_Id = entity.User_Id, Role_Id = entity.Role_Id, isActive = entity.isActive, AddedBy = entity.AddedBy, AddedOn = DateTime.Now }; adbContext.user_role.Add(vList); await Task.FromResult(adbContext.SaveChanges()); } catch (Exception ex) { throw ex; } }
public async Task Update(User_RoleView entity) { try { var vList = adbContext.user_role.Where(x => x.Id == entity.Id).FirstOrDefault(); if (vList != null) { vList.User_Id = entity.User_Id; vList.Role_Id = entity.Role_Id; vList.isActive = entity.isActive; adbContext.user_role.Update(vList); await Task.FromResult(adbContext.SaveChanges()); } else { throw new Exception("Data Not Available"); } } catch (Exception ex) { throw ex; } }