public async Task<List<IUserInfo>> GetPage(
int siteId,
int pageNumber,
int pageSize,
string userNameBeginsWith,
int sortMode)
{
//sortMode: 0 = DisplayName asc, 1 = JoinDate desc, 2 = Last, First
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetUserListPage(
siteId, pageNumber, pageSize, userNameBeginsWith, sortMode))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
//totalPages = Convert.ToInt32(reader["TotalPages"]);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetUserAdminSearchPage(
int siteId,
int pageNumber,
int pageSize,
string searchInput,
int sortMode)
{
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetUserAdminSearchPage(
siteId,
pageNumber,
pageSize,
searchInput,
sortMode))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetByIPAddress(Guid siteGuid, string ipv4Address)
{
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbUserLocation.GetUsersByIPAddress(siteGuid, ipv4Address))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetCrossSiteUserListByEmail(string email)
{
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetCrossSiteUserListByEmail(email))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetUserAdminSearchPage(
int siteId,
int pageNumber,
int pageSize,
string searchInput,
int sortMode,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetUserAdminSearchPage(
siteId,
pageNumber,
pageSize,
searchInput,
sortMode,
cancellationToken))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetNotApprovedUsers(
int siteId,
int pageNumber,
int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetPageNotApprovedUsers(
siteId,
pageNumber,
pageSize,
cancellationToken))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetByIPAddress(
Guid siteGuid,
string ipv4Address,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbUserLocation.GetUsersByIPAddress(
siteGuid,
ipv4Address,
cancellationToken))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetPage(
int siteId,
int pageNumber,
int pageSize,
string userNameBeginsWith,
int sortMode,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
//sortMode: 0 = DisplayName asc, 1 = JoinDate desc, 2 = Last, First
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader
= await dbSiteUser.GetUserListPage(
siteId,
pageNumber,
pageSize,
userNameBeginsWith,
sortMode,
cancellationToken))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetNotApprovedUsers(
int siteId,
int pageNumber,
int pageSize)
{
if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetPageNotApprovedUsers(
siteId,
pageNumber,
pageSize))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<IList<IUserInfo>> GetUsersNotInRole(
int siteId,
int roleId,
string searchInput,
int pageNumber,
int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
IList<IUserInfo> users = new List<IUserInfo>();
using (DbDataReader reader = await dbRoles.GetUsersNotInRole(
siteId,
roleId,
searchInput,
pageNumber,
pageSize,
cancellationToken))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
users.Add(user);
}
}
return users;
}
public async Task<List<IUserInfo>> GetUserSearchPage(
int siteId,
int pageNumber,
int pageSize,
string searchInput,
int sortMode)
{
if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
//sortMode: 0 = DisplayName asc, 1 = JoinDate desc, 2 = Last, First
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetUserSearchPage(
siteId,
pageNumber,
pageSize,
searchInput,
sortMode))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetByIPAddress(Guid siteGuid, string ipv4Address)
{
List<IUserInfo> userList = new List<IUserInfo>();
if (multiTenantOptions.UseRelatedSitesMode) { siteGuid = Guid.Empty; }
using (DbDataReader reader = await dbUserLocation.GetUsersByIPAddress(siteGuid, ipv4Address))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<IList<IUserInfo>> GetUsersNotInRole(
int siteId,
int roleId,
string searchInput,
int pageNumber,
int pageSize)
{
IList<IUserInfo> users = new List<IUserInfo>();
if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
using (DbDataReader reader = await dbRoles.GetUsersNotInRole(siteId, roleId, searchInput, pageNumber, pageSize))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
users.Add(user);
}
}
return users;
}
public async Task<List<IUserInfo>> GetNotApprovedUsers(
int siteId,
int pageNumber,
int pageSize)
{
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetPageNotApprovedUsers(
siteId,
pageNumber,
pageSize))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<List<IUserInfo>> GetCrossSiteUserListByEmail(
string email,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = await dbSiteUser.GetCrossSiteUserListByEmail(
email,
cancellationToken))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
public async Task<IList<IUserInfo>> GetUsersInRole(
int siteId,
int roleId,
string searchInput,
int pageNumber,
int pageSize)
{
IList<IUserInfo> users = new List<IUserInfo>();
using (DbDataReader reader = await dbRoles.GetUsersInRole(siteId, roleId, searchInput, pageNumber, pageSize))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
users.Add(user);
}
}
return users;
}
public async Task<List<IUserInfo>> GetUserAdminSearchPage(
int siteId,
int pageNumber,
int pageSize,
string searchInput,
int sortMode)
{
if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
List<IUserInfo> userList = new List<IUserInfo>();
using (DbDataReader reader = dbSiteUser.GetUserAdminSearchPage(
siteId,
pageNumber,
pageSize,
searchInput,
sortMode))
{
while (reader.Read())
{
UserInfo user = new UserInfo();
user.LoadFromReader(reader);
userList.Add(user);
}
}
return userList;
}
