public async Task <PagedResultDto <UserProfileListDto> > GetUserProfiles(GetUsersInput input)
{
var query = GetUsersFilteredQuery(input);
var userCount = await query.CountAsync();
var users = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
var userProfileListDtos = ObjectMapper.Map <List <UserProfileListDto> >(users);
foreach (var userProfileListDto in userProfileListDtos)
{
if (userProfileListDto.ProfilePictureId != null)
{
userProfileListDto.ProfilePicture = await _profileAppService.GetProfilePictureByIdString(userProfileListDto.ProfilePictureId);
}
;
}
await FillRoleProfileNames(userProfileListDtos);
return(new PagedResultDto <UserProfileListDto>(
userCount,
userProfileListDtos
));
}
public async Task <PagedResultDto <UserProfileListDto> > GetUserTeamProfiles(GetUsersTeamInput input)
{
var query = GetUsersTeamFilteredQuery(input, input.TeamId, input.isSelected);
var userCount = await query.CountAsync();
var users = await query
.OrderBy(input.Sorting)
.ToListAsync();
var userProfileListDtos = ObjectMapper.Map <List <UserProfileListDto> >(users);
foreach (var userProfileListDto in userProfileListDtos)
{
if (userProfileListDto.ProfilePictureId != null)
{
userProfileListDto.ProfilePicture = await _profileAppService.GetProfilePictureByIdString(userProfileListDto.ProfilePictureId);
var teamMemberQuery = _teamMemberRepository.GetAll()
.Where(e => e.TeamId == input.TeamId && e.UserId == userProfileListDto.Id);
var memberquery = from o in teamMemberQuery
select new GetTeamMemberForViewDto()
{
TeamMember = new TeamMemberDto
{
Id = o.Id,
SysRefId = o.SysRefId,
ReportingTeamMemberId = o.ReportingTeamMemberId,
RoleOrderNumber = o.SysRefFk.OrderNumber
},
};
var teamMemberListDtos = await memberquery
.ToListAsync();
foreach (var teamMember in teamMemberListDtos)
{
userProfileListDto.TeamMemberId = teamMember.TeamMember.Id;
userProfileListDto.SelectedRole = teamMember.TeamMember.SysRefId;
userProfileListDto.ReportingTo = teamMember.TeamMember.ReportingTeamMemberId;
userProfileListDto.RoleOrderNumber = teamMember.TeamMember.RoleOrderNumber;
}
}
;
}
await FillRoleProfileNames(userProfileListDtos);
return(new PagedResultDto <UserProfileListDto>(
userCount,
userProfileListDtos
));
}
public async Task <PagedResultDto <GetApprovalRequestForViewDto> > GetApprovalRequest(GetCustomApprovalRequestsInput input)
{
var filteredApprovalRequests = _approvalRequestRepository.GetAll()
.Include(e => e.SysRefFk)
.Include(e => e.SysStatusFk)
.Include(e => e.UserFk)
.WhereIf(input.ReferenceId != null, e => e.ReferenceId == input.ReferenceId)
.WhereIf(input.SysRefId != null, e => e.ReferenceId == input.SysRefId)
.WhereIf(input.SysStatusId != null, e => e.OrderNo == input.SysStatusId);
var pagedAndFilteredApprovalRequests = filteredApprovalRequests
.OrderBy("OrderNo, RankNo, Amount asc");
var approvalRequests = from o in pagedAndFilteredApprovalRequests
join o1 in _lookup_sysRefRepository.GetAll() on o.SysRefId equals o1.Id into j1
from s1 in j1.DefaultIfEmpty()
join o2 in _lookup_sysStatusRepository.GetAll() on o.SysStatusId equals o2.Id into j2
from s2 in j2.DefaultIfEmpty()
join o3 in _lookup_userRepository.GetAll() on o.UserId equals o3.Id into j3
from s3 in j3.DefaultIfEmpty()
select new GetApprovalRequestForViewDto()
{
ApprovalRequest = new ApprovalRequestDto
{
ReferenceId = o.ReferenceId,
OrderNo = o.OrderNo,
UserId = o.UserId,
RankNo = o.RankNo,
Amount = o.Amount,
Remark = o.Remark,
Id = o.Id,
SysStatusId = o.SysStatusId,
SysStatusName = s2.Name.ToString()
},
SysRefTenantId = s1 == null ? "" : s1.TenantId.ToString(),
SysStatusName = s2 == null ? "" : s2.Name.ToString(),
UserName = s3 == null ? "" : s3.UserName.ToString(),
FullName = s3 == null ? "" : s3.FullName.ToString(),
EmailAddress = s3 == null ? "" : s3.EmailAddress.ToString(),
ProfilePictureId = s3 == null ? Guid.Empty : s3.ProfilePictureId,
ProfilePicture = ""
};
var totalCount = await filteredApprovalRequests.CountAsync();
var approvalRequestsListDtos = await approvalRequests.ToListAsync();
int orderNo = 0;
foreach (var approvalRequest in approvalRequestsListDtos)
{
orderNo += 1;
Guid profilePictureId = approvalRequest.ProfilePictureId.Value;
approvalRequest.ProfilePicture = await _profileAppService.GetProfilePictureByIdString(profilePictureId);
approvalRequest.ApprovalRequest.OrderNo = orderNo;
}
return(new PagedResultDto <GetApprovalRequestForViewDto>(
totalCount,
approvalRequestsListDtos
));
}
public async Task <PagedResultDto <GetTeamMemberForViewDto> > GetTeamMembers(GetAllTeamMembersInput input)
{
var filteredTeamMembers = _teamMemberRepository.GetAll()
.Include(e => e.TeamFk)
.Include(e => e.UserFk)
.Include(e => e.SysRefFk)
.Include(e => e.SysStatusFk)
.WhereIf(!string.IsNullOrWhiteSpace(input.Filter), e => false || e.Remark.Contains(input.Filter))
.WhereIf(!string.IsNullOrWhiteSpace(input.RemarkFilter), e => e.Remark == input.RemarkFilter)
.WhereIf(!string.IsNullOrWhiteSpace(input.TeamNameFilter), e => e.TeamFk != null && e.TeamFk.Name == input.TeamNameFilter)
.WhereIf(!string.IsNullOrWhiteSpace(input.UserNameFilter), e => e.UserFk != null && e.UserFk.Name == input.UserNameFilter)
.WhereIf(input.ReportingTeamMemberIdFilter != null, e => e.ReportingTeamMemberId == input.ReportingTeamMemberIdFilter)
.WhereIf(input.TeamIdFilter != null, e => e.TeamFk.Id == input.TeamIdFilter)
.WhereIf(!string.IsNullOrWhiteSpace(input.SysStatusNameFilter), e => e.SysStatusFk != null && e.SysStatusFk.Name == input.SysStatusNameFilter);
var pagedAndFilteredTeamMembers = filteredTeamMembers
.OrderBy(input.Sorting ?? "id asc")
.PageBy(input);
var teamMembers = from o in pagedAndFilteredTeamMembers
join o1 in _lookup_teamRepository.GetAll() on o.TeamId equals o1.Id into j1
from s1 in j1.DefaultIfEmpty()
join o2 in _lookup_userRepository.GetAll() on o.UserId equals o2.Id into j2
from s2 in j2.DefaultIfEmpty()
join o3 in _lookup_sysRefRepository.GetAll() on o.SysRefId equals o3.Id into j3
from s3 in j3.DefaultIfEmpty()
join o4 in _lookup_sysStatusRepository.GetAll() on o.SysStatusId equals o4.Id into j4
from s4 in j4.DefaultIfEmpty()
orderby o.SysRefFk.OrderNumber
select new GetTeamMemberForViewDto()
{
TeamMember = new TeamMemberDto
{
Remark = o.Remark,
ReportingTeamMemberId = o.ReportingTeamMemberId,
Id = o.Id
},
TeamName = s1 == null ? "" : s1.Name.ToString(),
UserName = s2 == null ? "" : s2.Name.ToString(),
SysRefTenantId = s3 == null ? "" : s3.TenantId.ToString(),
SysStatusName = s4 == null ? "" : s4.Name.ToString(),
FullName = s2 == null ? "" : s2.FullName.ToString(),
EmailAddress = s2 == null ? "" : s2.EmailAddress.ToString(),
SelectedRoleName = s3 == null ? "" : s3.RefCode.ToString(),
ProfilePictureId = s2 == null ? Guid.Empty : s2.ProfilePictureId,
ProfilePicture = ""
};
var teamMemberListDtos = await teamMembers.ToListAsync();
foreach (var teamMember in teamMemberListDtos)
{
Guid profilePictureId = teamMember.ProfilePictureId.Value;
teamMember.ProfilePicture = await _profileAppService.GetProfilePictureByIdString(profilePictureId);
}
var totalCount = await filteredTeamMembers.CountAsync();
return(new PagedResultDto <GetTeamMemberForViewDto>(
totalCount,
teamMemberListDtos
));
}