List <Users> IUserRepository.GetAll(SearchAndSortModel searchAndSortModel) { var userList = _context.Users.Include(t => t.UserRoles).ThenInclude(r => r.Role).Where(x => (x.IsActive && !x.IsDeleted)).ToList(); if (searchAndSortModel.SearchString != null) { userList = userList.Where(x => x.FirstName.ToLower().Contains(searchAndSortModel.SearchString.ToLower()) || x.LastName.ToLower().Contains(searchAndSortModel.SearchString.ToLower()) || x.Email.ToLower().Contains(searchAndSortModel.SearchString.ToLower()) || x.UserRoles.Where(y => y.Role.Name.ToLower() .Contains(searchAndSortModel.SearchString.ToLower())).Any() ).ToList(); } if (searchAndSortModel.Property != null) { if (searchAndSortModel.Direction == 1) { userList = userList.OrderBy(x => x.GetType().GetProperty(searchAndSortModel.Property).GetValue(x, null)).ToList(); } else { userList = userList.OrderByDescending(x => x.GetType().GetProperty(searchAndSortModel.Property).GetValue(x, null)).ToList(); } } return(userList); }
//public IResult UpdateUserProfile(UserViewModel user) //{ // var result = new Result // { // Operation = Operation.Update, // Status = Status.Success // }; // try // { // var userId = GenericHelper.GetUserClaimDetails((ClaimsIdentity)_principal.Identity).UserId; // var duplicateUserName = _userRepository.GetFirstOrDefault(x => (x.IsActive && !x.IsDeleted) && (x.UserName == user.UserName) && (x.UserId != userId)); // if (duplicateUserName != null) // { // result.Status = Status.Fail; // result.Message = UserStatusNotification.DuplicateUserName; // result.Body = null; // return result; // } // var duplicateEmail = _userRepository.GetFirstOrDefault(x => (x.IsActive && !x.IsDeleted) && (x.Email == user.Email) && (x.UserId != userId)); // if (duplicateEmail != null) // { // result.Status = Status.Fail; // result.Message = UserStatusNotification.DuplicateEmail; // result.Body = null; // return result; // } // var userModel = _userRepository.GetByID(userId); // userModel.UserId = userId; // userModel.MapFromViewModel((ClaimsIdentity)_principal.Identity); // userModel.FirstName = user.FirstName; // userModel.LastName = user.LastName; // userModel.Email = user.Email; // userModel.UserName = user.UserName; // _userRepository.UpdateUser(userModel); // result.Body = userModel; // } // catch (Exception e) // { // result.Message = e.Message; // result.Status = Status.Error; // } // return result; //} public IResult GetUsersResults(SearchAndSortModel searchAndSortModel) { var result = new Result { Operation = Operation.Read, Status = Status.Success }; try { var userList = _userRepository.GetAll(searchAndSortModel).ToList(); result.Body = userList.Select(user => { var getUserRole = user.UserRoles.FirstOrDefault(x => (x.IsActive && !x.IsDeleted)); var userViewModel = new UserViewModel(); if (getUserRole != null) { userViewModel.RoleId = getUserRole.RoleId; userViewModel.Role = getUserRole.Role.Name; } return(userViewModel.MapFromModel(user)); }).ToList(); } catch (Exception e) { result.Message = e.Message; result.Status = Status.Fail; } return(result); }
List <Skills> ISkillRepository.GetAll(SearchAndSortModel searchAndSortModel) { var skillList = _context.Skills.Where(x => (x.IsActive && !x.IsDeleted)); if (searchAndSortModel.SearchString != null) { skillList = skillList.Where(x => x.Name.ToLower().Contains(searchAndSortModel.SearchString.ToLower())); } if (searchAndSortModel.Property != null) { if (searchAndSortModel.Direction == 1) { skillList = skillList.OrderBy(x => x.GetType().GetProperty(searchAndSortModel.Property).GetValue(x, null)); } else { skillList = skillList.OrderByDescending(x => x.GetType().GetProperty(searchAndSortModel.Property).GetValue(x, null)); } } return(skillList.ToList()); }
List <Qualifications> IQualificationRepository.GetAll(SearchAndSortModel searchAndSortModel) { var qualificationList = _context.Qualifications.Where(x => (x.IsActive && !x.IsDeleted)); if (searchAndSortModel.SearchString != null) { qualificationList = qualificationList.Where(x => x.Name.ToLower().Contains(searchAndSortModel.SearchString.ToLower())); } if (searchAndSortModel.Property != null) { if (searchAndSortModel.Direction == 1) { qualificationList = qualificationList.OrderBy(x => x.GetType().GetProperty(searchAndSortModel.Property).GetValue(x, null)); } else { qualificationList = qualificationList.OrderByDescending(x => x.GetType().GetProperty(searchAndSortModel.Property).GetValue(x, null)); } } return(qualificationList.ToList()); }
public IResult GetQualificationsResults(SearchAndSortModel searchAndSortModel) { var result = new Result { Operation = Operation.Read, Status = Status.Success }; try { List <QualificationViewModel> qualificationModelList = new List <QualificationViewModel>(); var qualificationList = _qualificationRepository.GetAll(searchAndSortModel).ToList(); var qualificationViewModelLists = qualificationModelList.MapFromModel <Qualifications, QualificationViewModel>(qualificationList); result.Body = qualificationViewModelLists; } catch (Exception e) { result.Message = e.Message; result.Status = Status.Fail; } return(result); }
public IResult GetSkillsResults(SearchAndSortModel searchAndSortModel) { var result = new Result { Operation = Operation.Read, Status = Status.Success }; try { List <SkillViewModel> skillModelList = new List <SkillViewModel>(); var skillList = _skillRepository.GetAll(searchAndSortModel).ToList(); var skillViewModelLists = skillModelList.MapFromModel <Skills, SkillViewModel>(skillList); result.Body = skillViewModelLists; } catch (Exception e) { result.Message = e.Message; result.Status = Status.Fail; } return(result); }
public IResult GetQualificationsResults([FromBody] SearchAndSortModel searchAndSortModel) { var quaificationList = _qualificationService.GetQualificationsResults(searchAndSortModel); return(quaificationList); }
public IResult GetSkillsResults([FromBody] SearchAndSortModel searchAndSortModel) { var skillList = _skillService.GetSkillsResults(searchAndSortModel); return(skillList); }
public IResult GetUsersResults([FromBody] SearchAndSortModel searchAndSortModel) { var userList = _userService.GetUsersResults(searchAndSortModel); return(userList); }