Email is blank because the store proc "GetUserRolesByUsername" does not have field Email selected. If you add the email column the store proc (see field in red), the email will have value in it. However, this is equipvalent to CORE change.
Maybe you want to try the code below where LookupUserId = UserRoleInfo.UserID
Dim objUserController As New UserController
Dim objUserInfo As UserInfo = objUserController.GetUser(PortalId, LookupUserId)
=============================================
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER procedure [dbo].[GetUserRolesByUsername]
@PortalId int,
@Username nvarchar(100),
@Rolename nvarchar(50)
as
SELECT R.*,
'FullName' = U.FirstName + ' ' + U.LastName,
U.Email,
UR.UserRoleID,
UR.UserID,
UR.ExpiryDate,
UR.IsTrialUsed
FROM UserRoles UR
INNER JOIN Users U ON UR.UserID = U.UserID
INNER JOIN Roles R ON R.RoleID = UR.RoleID
WHERE R.PortalId = @PortalId
AND (U.Username = @Username or @Username is NULL)
AND (R.Rolename = @Rolename or @RoleName is NULL)
=============================================
Advanced User/Role Manager Module for DotNetNuke