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);
}
