Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var userRoleChangeRequestList = await UnitOfWork.UserRoleChangeRequestRepository
- .Get(x => x.IsActive && !x.IsDeleted).ToListAsync();
- var userList = await UnitOfWork.UserRepository
- .Get(x => x.IsActive && !x.IsDeleted && (x.RoleID==(int)EnumUserRole.Learner || x.RoleID==(int)EnumUserRole.Instructor)).ToListAsync();
- var roleList= await UnitOfWork.RoleRepository
- .Get(x => x.IsActive && !x.IsDeleted).ToListAsync();
- var res = from userRoleChangeRequest in userRoleChangeRequestList
- join user in userList
- on userRoleChangeRequest.UserID equals user.UserID
- join role in roleList
- on user.RoleID equals role.RoleID
- select new
- {
- UserRoleChangeRequestID= userRoleChangeRequest.UserRoleChangeRequestID,
- UserID= userRoleChangeRequest.UserID,
- RoleID= userRoleChangeRequest.RoleID,
- Remarks= userRoleChangeRequest.Remarks,
- DocumentURL= userRoleChangeRequest.DocumentURL,
- StatusID= userRoleChangeRequest.StatusID,
- Email=user.Email,
- Role= role.RoleName
- };
Advertisement
Add Comment
Please, Sign In to add comment