public async Task <ISiteUser> FetchByConfirmationGuid(
int siteId,
Guid confirmGuid,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
using (DbDataReader reader = await dbSiteUser.GetUserByRegistrationGuid(
siteId,
confirmGuid,
cancellationToken))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
if (user.SiteId == siteId)
{
return(user);
}
}
}
return(null);
}
public async Task <IList <ISiteUser> > GetUsersInRole(
int siteId,
string roleName)
{
IList <ISiteUser> users = new List <ISiteUser>();
if (multiTenantOptions.UseRelatedSitesMode)
{
siteId = multiTenantOptions.RelatedSiteId;
}
ISiteRole role = await FetchRole(siteId, roleName);
int roleId = -3;
if (role != null)
{
roleId = role.RoleId;
}
using (DbDataReader reader = dbRoles.GetUsersInRole(siteId, roleId, string.Empty, 1, 100000))
{
while (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
users.Add(user);
}
}
return(users);
}
public async Task<IList<ISiteUser>> GetUsersInRole(
int siteId,
string roleName)
{
IList<ISiteUser> users = new List<ISiteUser>();
ISiteRole role = await FetchRole(siteId, roleName);
int roleId = -3;
if(role != null)
{
roleId = role.RoleId;
}
using (DbDataReader reader = await dbRoles.GetUsersInRole(siteId, roleId, string.Empty, 1, 100000))
{
while (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
users.Add(user);
}
}
return users;
}
public async Task <IList <ISiteUser> > GetUsersInRole(
int siteId,
string roleName,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
IList <ISiteUser> users = new List <ISiteUser>();
ISiteRole role = await FetchRole(siteId, roleName);
int roleId = -3;
if (role != null)
{
roleId = role.RoleId;
}
using (DbDataReader reader = await dbRoles.GetUsersInRole(siteId, roleId, string.Empty, 1, 100000))
{
while (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
users.Add(user);
}
}
return(users);
}
public async Task <ISiteUser> FetchByLoginName(
int siteId,
string userName,
bool allowEmailFallback,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
using (DbDataReader reader = await dbSiteUser.GetSingleUserByLoginName(
siteId,
userName,
allowEmailFallback,
cancellationToken))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
return(user);
}
}
return(null);
}
public async Task <IList <ISiteUser> > GetUsersForClaim(
int siteId,
string claimType,
string claimValue,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
IList <ISiteUser> users = new List <ISiteUser>();
using (DbDataReader reader = await dbUserClaims.GetUsersByClaim(
siteId,
claimType,
claimValue,
cancellationToken))
{
while (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
users.Add(user);
}
}
return(users);
}
public async Task <ISiteUser> FetchByLoginName(int siteId, string userName, bool allowEmailFallback)
{
using (DbDataReader reader = await dbSiteUser.GetSingleUserByLoginName(siteId, userName, allowEmailFallback))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
return(user);
}
}
return(null);
}
public async Task <ISiteUser> Fetch(int siteId, string email)
{
using (DbDataReader reader = await dbSiteUser.GetSingleUser(siteId, email))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
return(user);
}
}
return(null);
}
public async Task<ISiteUser> FetchByConfirmationGuid(int siteId, Guid confirmGuid)
{
using (DbDataReader reader = await dbSiteUser.GetUserByRegistrationGuid(siteId, confirmGuid))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
if (user.SiteId == siteId) { return user; }
}
}
return null;
}
public async Task<ISiteUser> Fetch(int siteId, Guid userGuid)
{
using (DbDataReader reader = await dbSiteUser.GetSingleUser(userGuid))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
if (user.SiteId == siteId) { return user; }
}
}
return null;
}
public async Task <ISiteUser> Fetch(int siteId, string email, CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
using (DbDataReader reader = await dbSiteUser.GetSingleUser(siteId, email))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
return(user);
}
}
return(null);
}
public async Task <IList <ISiteUser> > GetUsersForClaim(
int siteId,
string claimType,
string claimValue)
{
IList <ISiteUser> users = new List <ISiteUser>();
using (DbDataReader reader = await dbUserClaims.GetUsersByClaim(siteId, claimType, claimValue))
{
while (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
users.Add(user);
}
}
return(users);
}
//public int UserCount(int siteId, String userNameBeginsWith)
//{
// //if (AppSettings.UseRelatedSiteMode) { siteId = AppSettings.RelatedSiteId; }
// return DBSiteUser.UserCount(siteId, userNameBeginsWith);
//}
//public int UsersOnlineSinceCount(int siteId, DateTime sinceTime)
//{
// if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
// return dbSiteUser.CountOnlineSince(siteId, sinceTime);
//}
//public async Task<ISiteUser> FetchNewest(int siteId)
//{
// if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
// int newestUserId = await GetNewestUserId(siteId);
// return await Fetch(siteId, newestUserId);
//}
public async Task <ISiteUser> Fetch(int siteId, int userId)
{
using (DbDataReader reader = dbSiteUser.GetSingleUser(userId))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
if (user.SiteId == siteId)
{
return(user);
}
}
}
return(null);
}
//public int UserCount(int siteId, String userNameBeginsWith)
//{
// if (config.UseRelatedSiteMode()) { siteId = config.RelatedSiteId(); }
// return DBSiteUser.UserCount(siteId, userNameBeginsWith);
//}
//public int UsersOnlineSinceCount(int siteId, DateTime sinceTime)
//{
// if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
// return dbSiteUser.CountOnlineSince(siteId, sinceTime);
//}
//public async Task<ISiteUser> FetchNewest(int siteId)
//{
// if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
// int newestUserId = await GetNewestUserId(siteId);
// return await Fetch(siteId, newestUserId);
//}
public async Task <ISiteUser> Fetch(int siteId, int userId, CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
using (DbDataReader reader = dbSiteUser.GetSingleUser(userId))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
if (user.SiteId == siteId)
{
return(user);
}
}
}
return(null);
}
public async Task <ISiteUser> FetchByLoginName(int siteId, string userName, bool allowEmailFallback)
{
if (multiTenantOptions.UseRelatedSitesMode)
{
siteId = multiTenantOptions.RelatedSiteId;
}
using (DbDataReader reader = dbSiteUser.GetSingleUserByLoginName(siteId, userName, allowEmailFallback))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
return(user);
}
}
return(null);
}
public async Task <ISiteUser> Fetch(int siteId, string email)
{
if (multiTenantOptions.UseRelatedSitesMode)
{
siteId = multiTenantOptions.RelatedSiteId;
}
using (DbDataReader reader = dbSiteUser.GetSingleUser(siteId, email))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
return(user);
}
}
return(null);
}
public async Task <ISiteUser> FetchByConfirmationGuid(int siteId, Guid confirmGuid)
{
if (multiTenantOptions.UseRelatedSitesMode)
{
siteId = multiTenantOptions.RelatedSiteId;
}
using (DbDataReader reader = dbSiteUser.GetUserByRegistrationGuid(siteId, confirmGuid))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
if (user.SiteId == siteId)
{
return(user);
}
}
}
return(null);
}
public async Task <IList <ISiteUser> > GetUsersForClaim(
int siteId,
string claimType,
string claimValue)
{
IList <ISiteUser> users = new List <ISiteUser>();
if (multiTenantOptions.UseRelatedSitesMode)
{
siteId = multiTenantOptions.RelatedSiteId;
}
using (DbDataReader reader = dbUserClaims.GetUsersByClaim(siteId, claimType, claimValue))
{
while (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
users.Add(user);
}
}
return(users);
}
public async Task <ISiteUser> Fetch(int siteId, Guid userGuid)
{
if (multiTenantOptions.UseRelatedSitesMode)
{
siteId = multiTenantOptions.RelatedSiteId;
}
using (DbDataReader reader = await dbSiteUser.GetSingleUser(userGuid))
{
if (reader.Read())
{
SiteUser user = new SiteUser();
user.LoadFromReader(reader);
if (user.SiteId == siteId)
{
return(user);
}
}
}
return(null);
}
