yuvarajupadhyaya

innerjoin

Oct 20th, 2022
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. var userRoleChangeRequestList = await UnitOfWork.UserRoleChangeRequestRepository
  2. .Get(x => x.IsActive && !x.IsDeleted).ToListAsync();
  3.  
  4.  
  5. var userList = await UnitOfWork.UserRepository
  6. .Get(x => x.IsActive && !x.IsDeleted && (x.RoleID==(int)EnumUserRole.Learner || x.RoleID==(int)EnumUserRole.Instructor)).ToListAsync();
  7.  
  8. var roleList= await UnitOfWork.RoleRepository
  9. .Get(x => x.IsActive && !x.IsDeleted).ToListAsync();
  10.  
  11. var res = from userRoleChangeRequest in userRoleChangeRequestList
  12. join user in userList
  13. on userRoleChangeRequest.UserID equals user.UserID
  14. join role in roleList
  15. on user.RoleID equals role.RoleID
  16. select new
  17. {
  18. UserRoleChangeRequestID= userRoleChangeRequest.UserRoleChangeRequestID,
  19. UserID= userRoleChangeRequest.UserID,
  20. RoleID= userRoleChangeRequest.RoleID,
  21. Remarks= userRoleChangeRequest.Remarks,
  22. DocumentURL= userRoleChangeRequest.DocumentURL,
  23. StatusID= userRoleChangeRequest.StatusID,
  24. Email=user.Email,
  25. Role= role.RoleName
  26. };
Advertisement
Add Comment
Please, Sign In to add comment