public IAsyncEnumerable <PermissionIdentityViewModel> AsyncEnumerateGrantedPermissionIdentities(
ulong userId)
{
UsersLogMessages.GrantedPermissionIdentitiesEnumerating(_logger, userId);
var result = _context.Set <PermissionEntity>()
.AsQueryable()
.Where(p => _context.Set <UserPermissionMappingEntity>()
.AsQueryable()
.Where(upm => upm.UserId == userId)
.Where(upm => !upm.IsDenied)
.Where(upm => upm.DeletionId == null)
.Any(upm => upm.PermissionId == p.PermissionId) ||
_context.Set <RolePermissionMappingEntity>()
.AsQueryable()
.Where(rpm => _context.Set <UserRoleMappingEntity>()
.AsQueryable()
.Where(urm => urm.DeletionId == null)
.Where(urm => urm.UserId == userId)
.Any(urm => urm.RoleId == rpm.RoleId))
.Where(x => x.DeletionId == null)
.Any(rpm => rpm.PermissionId == p.PermissionId))
.Where(p => !_context.Set <UserPermissionMappingEntity>()
.AsQueryable()
.Where(upm => upm.UserId == userId)
.Where(upm => upm.IsDenied)
.Where(upm => upm.DeletionId == null)
.Any(upm => upm.PermissionId == p.PermissionId))
.Select(PermissionIdentityViewModel.FromEntityProjection)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <UserRoleMappingIdentityViewModel> AsyncEnumerateRoleMappingIdentities(
ulong userId,
Optional <bool> isDeleted = default)
{
UsersLogMessages.UserRoleMappingIdentitiesEnumerating(_logger, userId, isDeleted);
var query = _context.Set <UserRoleMappingEntity>()
.AsQueryable()
.Where(x => x.UserId == userId);
RepositoryLogMessages.QueryInitializing(_logger, query);
if (isDeleted.IsSpecified)
{
RepositoryLogMessages.QueryAddingWhereClause(_logger, nameof(isDeleted));
query = isDeleted.Value
? query.Where(x => x.DeletionId != null)
: query.Where(x => x.DeletionId == null);
}
RepositoryLogMessages.QueryTerminating(_logger);
var result = query
.Select(UserRoleMappingIdentityViewModel.FromEntityProjection)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <ulong> AsyncEnumerateIds(
Optional <long> roleId = default)
{
UsersLogMessages.UserIdsEnumerating(_logger, roleId);
var query = _context.Set <UserEntity>()
.AsQueryable();
RepositoryLogMessages.QueryInitializing(_logger, query);
if (roleId.IsSpecified)
{
RepositoryLogMessages.QueryAddingWhereClause(_logger, nameof(roleId));
query = query.Where(u => u.RoleMappings.Any(urm =>
(urm.DeletionId == null) &&
(urm.RoleId == roleId.Value)));
}
RepositoryLogMessages.QueryTerminating(_logger);
var result = query
.Select(u => u.Id)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <AuthenticationTicketIdentityViewModel> AsyncEnumerateIdentities(
Optional <bool> isDeleted = default)
{
AuthenticationLogMessages.IdentitiesEnumerating(_logger, isDeleted);
var query = _context.Set <AuthenticationTicketEntity>()
.AsQueryable();
RepositoryLogMessages.QueryInitializing(_logger, query);
if (isDeleted.IsSpecified)
{
RepositoryLogMessages.QueryAddingWhereClause(_logger, nameof(isDeleted));
query = isDeleted.Value
? query.Where(x => x.DeletionId != null)
: query.Where(x => x.DeletionId == null);
}
RepositoryLogMessages.QueryTerminating(_logger);
var result = query
.Select(AuthenticationTicketIdentityViewModel.FromEntityProjection)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <CharacterGuildIdentityViewModel> AsyncEnumerateIdentities(
Optional <bool> isDeleted = default)
{
CharactersLogMessages.CharacterGuildIdentitiesEnumerating(_logger, isDeleted);
var query = _context.Set <CharacterGuildVersionEntity>()
.AsQueryable()
.Where(x => x.NextVersionId == null);
RepositoryLogMessages.QueryInitializing(_logger, query);
if (isDeleted.IsSpecified)
{
RepositoryLogMessages.QueryAddingWhereClause(_logger, nameof(isDeleted));
query = query.Where(x => x.IsDeleted == isDeleted.Value);
}
RepositoryLogMessages.QueryTerminating(_logger);
var result = query
.Select(CharacterGuildIdentityViewModel.FromVersionEntityProjection)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <UserOverviewViewModel> AsyncEnumerateOverviews()
{
UsersLogMessages.UserOverviewsEnumerating(_logger);
var result = _context.Set <UserEntity>()
.Select(UserOverviewViewModel.FromEntityProjection)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <PermissionIdentityViewModel> AsyncEnumerateIdentities()
{
PermissionsLogMessages.PermissionIdentitiesEnumerating(_logger);
var result = _context
.Set <PermissionEntity>()
.Select(PermissionIdentityViewModel.FromEntityProjection)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <long> AsyncEnumerateDefaultRoleIds()
{
UsersLogMessages.DefaultRoleIdsEnumerating(_logger);
var result = _context.Set <DefaultRoleMappingEntity>()
.AsQueryable()
.Where(x => x.DeletionId == null)
.Select(x => x.RoleId)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}
public IAsyncEnumerable <int> AsyncEnumeratePermissionIds(
Optional <IReadOnlyCollection <int> > permissionIds = default)
{
PermissionsLogMessages.PermissionIdsEnumerating(_logger, permissionIds);
var query = _context.Set <PermissionEntity>()
.AsQueryable();
RepositoryLogMessages.QueryInitializing(_logger, query);
if (permissionIds.IsSpecified)
{
RepositoryLogMessages.QueryAddingWhereClause(_logger, nameof(permissionIds));
query = query.Where(x => permissionIds.Value.Contains(x.PermissionId));
}
RepositoryLogMessages.QueryTerminating(_logger);
var result = query
.Select(x => x.PermissionId)
.AsAsyncEnumerable();
RepositoryLogMessages.QueryBuilt(_logger);
return(result);
}