public IEnumerable <UserInfoModel> SearchPagingDivisionManager(UserOrgFilterModelDTO filter, List <string> users)
{
var userQ = this._repo.SelectWhere(x => users.Any(t => t == x.UserName));
var query = _viewUsrRepo.SelectWhere(x => ((x.UserFullName.Contains(filter.Name) && filter.Name != null) || filter.Name == null || filter.Name.Trim() == "") &&
(x.OrgId == filter.orgId || filter.orgId == null || filter.orgId < 0))
.Join(userQ, v => v.Id, u => u.Id, (v, u) => v);
var res = query.OrderBy(x => x.Id)
.Select(x => new UserInfoModel
{
Id = x.Id,
JobTitle = x.JobTitle,
UserName = x.UserName,
UserFullName = x.UserFullName,
UserEmail = x.UserEmail,
OrgId = x.OrgId,
OrgName = x.OrgName,
Status = x.Status,
Level1ManagerFullName = x.Level1ManagerName,
Level2ManagerFullName = x.Level2ManagerName,
FirstKpiDate = x.FirstKpiDate,
DOB = x.DOB,
StartWorkDate = x.StartWorkDate,
Code = x.Code
}).ToList();
return(res);
}
public IEnumerable <UserInfoModel> SearchPagingDivisionManager(UserOrgFilterModelDTO model, List <string> users)
{
return(this._gridRepository.SearchPagingDivisionManager(model, users));
}
