protected override Command CreateDeleteLinksCommand(Role entity, IAuthenticatedUser user, string selector) { return(Command .NonQuery() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pRole_UnlinkUsers]") .Parameters( p => p.Name("roleId").Value(entity.Id) )); }
protected override Command CreateDeleteCommand(IdentityProvider entity, IAuthenticatedUser user, string selector) { return(Command .NonQuery() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pIdentityProvider_Delete]") .Parameters( p => p.Name("identityProviderId").Value(entity.Id) )); }
public async Task <IEnumerable <Role> > GetAllRolesForUserAsync(int userId) { var result = await Query <Role> .Collection() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_GetAllRoles]") .Parameters( p => p.Name("userId").Value(userId) ) .ExecuteAsync(); return(result.Data); }
public async override Task <Role> GetByIdAsync(int roleId) { var result = await Query <Role> .Single() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pRole_GetById]") .Parameters( p => p.Name("roleId").Value(roleId) ) .ExecuteAsync(); return(result.Data); }
public override IdentityProvider GetById(int identityProviderId) { var result = Query <IdentityProvider> .Single() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pIdentityProvider_GetById]") .Parameters( p => p.Name("identityProviderId").Value(identityProviderId) ) .Execute(); return(result.Data); }
public async Task <User> GetUserByNormalizedEmailAsync(string email) { var result = await Query <User> .Single() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_GetByNormalizedEmail]") .Parameters( p => p.Name("email").Value(email) ) .ExecuteAsync(); return(result.Data); }
public IEnumerable <User> GetAllUsersForRole(int roleId) { var result = Query <User> .Collection() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pRole_GetAllUsers]") .Parameters( p => p.Name("roleId").Value(roleId) ) .Execute(); return(result.Data); }
public override IEnumerable <UserLogin> GetAll(int userId) { var result = Query <UserLogin> .Collection() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_GetAllUserLogins]") .Parameters( p => p.Name("userId").Value(userId) ) .Execute(); return(result.Data); }
public async Task <User> GetUserByUserLoginAsync(string provider, string userKey) { var result = await Query <User> .Single() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_GetByUserLogin]") .Parameters( p => p.Name("provider").Value(provider), p => p.Name("userKey").Value(userKey) ) .ExecuteAsync(); return(result.Data); }
public async override Task <(int, IEnumerable <User>)> GetAsync(CollectionQueryParameters queryParameters) { var result = await Query <User> .Collection() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_Get]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Size(20).Output()) .ExecuteAsync(); var count = (string)result.GetParameter("count").Value; return(int.Parse(count), result.Data); }
protected override Command CreateInsertCommand(Role entity, IAuthenticatedUser user, string selector) { var command = Query <Role> .Single() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pRole_Insert]") .Parameters( p => p.Name("name").Value(entity.Name) ) .Instance(entity) .MapProperties( p => p.Name("Id").Index(0) ); return(command); }
protected override Command CreateDeleteLinksCommand(IAuthenticatedUser user) { return(Command .NonQuery() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_DeleteUserLogins]") .OnBeforeCommandExecuted(cmd => { var dependencies = Dependencies(); var entity = (User)dependencies.Single().Entity; cmd.Parameters( p => p.Name("userId").Value(entity.Id) ); })); }
public (int, IEnumerable <User>) GetUsersForRole(int roleId, CollectionQueryParameters queryParameters) { var result = Query <User> .Collection() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pRole_GetUsers]") .QueryParameters(queryParameters) .Parameters(p => p.Name("count").Size(20).Output()) .Parameters( p => p.Name("roleId").Value(roleId) ) .Execute(); var count = (string)result.GetParameter("count").Value; return(int.Parse(count), result.Data); }
protected override Command CreateUpdateCommand(UserRole entity, IAuthenticatedUser user, string selector) { if (user != null) { entity.UpdatedBy = (int)user.Id; } return(Command .NonQuery() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUserRole_Update]") .Parameters( p => p.Name("roleId").Value(entity.Id.RoleId), p => p.Name("userId").Value(entity.Id.UserId), p => p.Name("updatedBy").Value(entity.UpdatedBy) )); }
protected override Command CreateInsertCommand(IdentityProvider entity, IAuthenticatedUser user, string selector) { if (user != null) { entity.CreatedBy = (int)user.Id; } var command = Query <IdentityProvider> .Single() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pIdentityProvider_Insert]") .Parameters( p => p.Name("name").Value(entity.Name), p => p.Name("uri").Value(entity.Uri), p => p.Name("createdBy").Value(entity.CreatedBy) ) .Instance(entity) .MapProperties( p => p.Name("Id").Index(0) ); return(command); }
protected override Command CreateDeleteLinksCommand(User entity, IAuthenticatedUser user, string selector) { switch (selector) { case "UnlinkRolesFromUser": return(Command .NonQuery() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_UnlinkRoles]") .Parameters( p => p.Name("userId").Value(entity.Id) )); case "DeleteUserLoginsFromUser": return(Command .NonQuery() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUser_DeleteUserLogins]") .Parameters( p => p.Name("userId").Value(entity.Id) )); default: throw new InvalidOperationException(); } }
public CreateRoleCommandAggregate() : base(new DomainFramework.DataAccess.RepositoryContext(AuthorizationConnectionClass.GetConnectionName())) { }
public CreateRoleCommandAggregate(CreateRoleInputDto role, EntityDependency[] dependencies = null) : base(new DomainFramework.DataAccess.RepositoryContext(AuthorizationConnectionClass.GetConnectionName())) { Initialize(role, dependencies); }
public GetUserByNormalizedEmailQueryAggregate() : base(new DomainFramework.DataAccess.RepositoryContext(AuthorizationConnectionClass.GetConnectionName())) { var context = (DomainFramework.DataAccess.RepositoryContext)RepositoryContext; UserQueryRepository.Register(context); RoleQueryRepository.Register(context); User_UserLogins_QueryRepository.Register(context); GetUserLoginsOperation = new GetCollectionLinkedValueObjectQueryOperation <User, UserLogin, User_UserLogins_QueryRepository.RepositoryKey> { GetLinkedValueObjects = (repository, entity, user) => ((User_UserLogins_QueryRepository)repository).GetAll(RootEntity.Id).ToList(), GetLinkedValueObjectsAsync = async(repository, entity, user) => { var items = await((User_UserLogins_QueryRepository)repository).GetAllAsync(RootEntity.Id); return(items.ToList()); } }; QueryOperations.Enqueue(GetUserLoginsOperation); GetAllRolesLinkedAggregateQueryOperation = new GetAllLinkedAggregateQueryCollectionOperation <int, Role, RoleOutputDto> { GetAllLinkedEntities = (repository, entity, user) => ((RoleQueryRepository)repository).GetAllRolesForUser(RootEntity.Id).ToList(), GetAllLinkedEntitiesAsync = async(repository, entity, user) => { var entities = await((RoleQueryRepository)repository).GetAllRolesForUserAsync(RootEntity.Id); return(entities.ToList()); }, CreateLinkedQueryAggregate = entity => { if (entity is Role) { return(new GetRoleByIdQueryAggregate()); } else { throw new InvalidOperationException(); } } }; QueryOperations.Enqueue(GetAllRolesLinkedAggregateQueryOperation); }
protected override Command CreateInsertCommand(UserRole entity, IAuthenticatedUser user, string selector) { if (user != null) { entity.CreatedBy = (int)user.Id; } var command = Command .NonQuery() .Connection(AuthorizationConnectionClass.GetConnectionName()) .StoredProcedure("[AccessControl].[pUserRole_Insert]") .Parameters( p => p.Name("createdBy").Value(entity.CreatedBy) ) .OnBeforeCommandExecuted(cmd => { var dependencies = Dependencies(); if (!dependencies.Any()) { cmd.Parameters( p => p.Name("roleId").Value(entity.Id.RoleId), p => p.Name("userId").Value(entity.Id.UserId) ); } else { switch (selector) { case "Roles": { var user_ = (User)dependencies.ElementAt(0).Entity; cmd.Parameters( p => p.Name("roleId").Value(entity.Id.RoleId), p => p.Name("userId").Value(user_.Id) ); } break; case "Users": { var role = (Role)dependencies.ElementAt(0).Entity; cmd.Parameters( p => p.Name("roleId").Value(role.Id), p => p.Name("userId").Value(entity.Id.UserId) ); } break; default: { var role = (Role)dependencies.Single(d => d.Selector == "Roles").Entity; var user_ = (User)dependencies.Single(d => d.Selector == "Users").Entity; entity.Id = new UserRoleId { RoleId = role.Id, UserId = user_.Id }; cmd.Parameters( p => p.Name("roleId").Value(role.Id), p => p.Name("userId").Value(user_.Id) ); } break; } } }); return(command); }
public AddUserLoginCommandAggregate(AddUserLoginsInputDto user, EntityDependency[] dependencies = null) : base(new DomainFramework.DataAccess.RepositoryContext(AuthorizationConnectionClass.GetConnectionName())) { Initialize(user, dependencies); }