public async override Task <IEnumerable <TestEntity> > GetAllAsync()
{
var result = await Query <TestEntity>
.Collection()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_GetAll]")
.ExecuteAsync();
return(result.Records);
}
protected override Command CreateDeleteCommand(TestEntity entity, IAuthenticatedUser user, string selector)
{
return(Command
.NonQuery()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_Delete]")
.Parameters(
p => p.Name("testEntityId").Value(entity.Id)
));
}
public async override Task <(int, IEnumerable <TestEntity>)> GetAsync(CollectionQueryParameters queryParameters)
{
var result = await Query <TestEntity>
.Collection()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_Get]")
.QueryParameters(queryParameters)
.Parameters(p => p.Name("count").Count())
.ExecuteAsync();
return(result.Count, result.Records);
}
public async override Task <TestEntity> GetByIdAsync(int testEntityId)
{
var result = await Query <TestEntity>
.Single()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_GetById]")
.Parameters(
p => p.Name("testEntityId").Value(testEntityId)
)
.ExecuteAsync();
return(result.Record);
}
public async override Task <IEnumerable <TypeValue> > GetAllAsync(int testEntityId)
{
var result = await Query <TypeValue>
.Collection()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_GetAllTypeValues1]")
.Parameters(
p => p.Name("testEntityId").Value(testEntityId)
)
.ExecuteAsync();
return(result.Records);
}
protected override Command CreateUpdateCommand(TestEntity entity, IAuthenticatedUser user, string selector)
{
if (user != null)
{
entity.UpdatedBy = (int)user.Id;
}
return(Command
.NonQuery()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_Update]")
.Parameters(
p => p.Name("testEntityId").Value(entity.Id),
p => p.Name("text").Value(entity.Text),
p => p.Name("updatedBy").Value(entity.UpdatedBy)
));
}
protected override Command CreateDeleteLinksCommand(IAuthenticatedUser user)
{
return(Command
.NonQuery()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_DeleteTypeValues1]")
.ThrowWhenNoRecordIsUpdated(false)
.OnBeforeCommandExecuted(cmd =>
{
var dependencies = Dependencies();
var entity = (TestEntity)dependencies.Single().Entity;
cmd.Parameters(
p => p.Name("testEntityId").Value(entity.Id)
);
}));
}
protected override Command CreateInsertCommand(TypeValue valueObject, IAuthenticatedUser user)
{
return(Command
.NonQuery()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_AddTypeValues1]")
.Parameters(
p => p.Name("dataType").Value(valueObject.DataType),
p => p.Name("data").Value(valueObject.Data)
)
.OnBeforeCommandExecuted(cmd =>
{
var dependencies = Dependencies();
var entity = (TestEntity)dependencies.Single().Entity;
cmd.Parameters(
p => p.Name("testEntityId").Value(entity.Id)
);
}));
}
protected override Command CreateInsertCommand(TestEntity entity, IAuthenticatedUser user, string selector)
{
if (user != null)
{
entity.CreatedBy = (int)user.Id;
}
var command = Query <TestEntity>
.Single()
.Connection(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName())
.StoredProcedure("[pTestEntity_Insert]")
.Parameters(
p => p.Name("text").Value(entity.Text),
p => p.Name("createdBy").Value(entity.CreatedBy)
)
.RecordInstance(entity)
.MapProperties(
p => p.Name("Id").Index(0)
);
return(command);
}
public AddTypeValue1CommandAggregate() : base(new DomainFramework.DataAccess.RepositoryContext(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName()))
{
}
public AddTypeValue1CommandAggregate(AddTypeValues1InputDto typeValue, EntityDependency[] dependencies = null) : base(new DomainFramework.DataAccess.RepositoryContext(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName()))
{
Initialize(typeValue, dependencies);
}
public GetTestEntitiesQueryAggregate() : base(new DomainFramework.DataAccess.RepositoryContext(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName()))
{
var context = (DomainFramework.DataAccess.RepositoryContext)RepositoryContext;
TestEntityQueryRepository.Register(context);
TestEntity_TypeValues1_QueryRepository.Register(context);
}
public SaveTestEntityCommandAggregate(SaveTestEntityInputDto entity, EntityDependency[] dependencies = null) : base(new DomainFramework.DataAccess.RepositoryContext(EntityWithMultiValuedValueObjectConnectionClass.GetConnectionName()))
{
Initialize(entity, dependencies);
}
