public async Task<ISiteRole> FetchRole(int siteId, string roleName)
{
SiteRole role = null;
using (DbDataReader reader = await dbRoles.GetByName(siteId, roleName))
{
if (reader.Read())
{
role = new SiteRole();
role.LoadFromReader(reader);
}
}
return role;
}
public async Task<IList<ISiteRole>> GetRolesBySite(
int siteId,
string searchInput,
int pageNumber,
int pageSize)
{
IList<ISiteRole> roles = new List<ISiteRole>();
using (DbDataReader reader = await dbRoles.GetPage(siteId, searchInput, pageNumber, pageSize))
{
while (reader.Read())
{
SiteRole role = new SiteRole();
role.LoadFromReader(reader);
role.MemberCount = Convert.ToInt32(reader["MemberCount"]);
roles.Add(role);
}
}
return roles;
}
public async Task<IList<ISiteRole>> GetRolesBySite(
int siteId,
string searchInput,
int pageNumber,
int pageSize,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
IList<ISiteRole> roles = new List<ISiteRole>();
using (DbDataReader reader = await dbRoles.GetPage(
siteId,
searchInput,
pageNumber,
pageSize,
cancellationToken))
{
while (reader.Read())
{
SiteRole role = new SiteRole();
role.LoadFromReader(reader);
role.MemberCount = Convert.ToInt32(reader["MemberCount"]);
roles.Add(role);
}
}
return roles;
}
//public int GetRoleMemberCount(int roleId)
//{
// // TODO: implement actual select count from db
// // this is works but is not ideal
// int count = 0;
// using (DbDataReader reader = dbRoles.GetRoleMembers(roleId))
// {
// while (reader.Read())
// {
// count += 1;
// }
// }
// return count;
//}
public async Task<ISiteRole> FetchRole(int roleId)
{
using (DbDataReader reader = await dbRoles.GetById(roleId))
{
if (reader.Read())
{
SiteRole role = new SiteRole();
role.LoadFromReader(reader);
return role;
}
}
return null;
}
public async Task<ISiteRole> FetchRole(
int siteId,
string roleName,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
SiteRole role = null;
using (DbDataReader reader = await dbRoles.GetByName(
siteId,
roleName,
cancellationToken))
{
if (reader.Read())
{
role = new SiteRole();
role.LoadFromReader(reader);
}
}
return role;
}
public async Task<ISiteRole> FetchRole(
int roleId,
CancellationToken cancellationToken = default(CancellationToken))
{
cancellationToken.ThrowIfCancellationRequested();
using (DbDataReader reader = await dbRoles.GetById(roleId, cancellationToken))
{
if (reader.Read())
{
SiteRole role = new SiteRole();
role.LoadFromReader(reader);
return role;
}
}
return null;
}
public async Task<ISiteRole> FetchRole(int siteId, string roleName)
{
if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
SiteRole role = null;
using (DbDataReader reader = await dbRoles.GetByName(siteId, roleName))
{
while (reader.Read())
{
role = new SiteRole();
role.LoadFromReader(reader);
}
}
return role;
}
public IList<ISiteRole> GetRolesUserIsNotIn(
int siteId,
int userId)
{
if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
IList<ISiteRole> roles = new List<ISiteRole>();
using (DbDataReader reader = dbRoles.GetRolesUserIsNotIn(siteId, userId))
{
SiteRole role = new SiteRole();
role.LoadFromReader(reader);
roles.Add(role);
}
return roles;
}
public async Task<IList<ISiteRole>> GetRolesBySite(
int siteId,
string searchInput,
int pageNumber,
int pageSize)
{
if (multiTenantOptions.UseRelatedSitesMode) { siteId = multiTenantOptions.RelatedSiteId; }
IList<ISiteRole> roles = new List<ISiteRole>();
using (DbDataReader reader = dbRoles.GetPage(siteId, searchInput, pageNumber, pageSize))
{
while (reader.Read())
{
SiteRole role = new SiteRole();
role.LoadFromReader(reader);
role.MemberCount = Convert.ToInt32(reader["MemberCount"]);
roles.Add(role);
}
}
return roles;
}
