protected override Command CreateInsertCommand(ApplicationLog entity, IAuthenticatedUser user, string selector)
{
var command = Query <ApplicationLog>
.Single()
.Connection(ApplicationLogsConnectionClass.GetConnectionName())
.StoredProcedure("[Logs].[pApplicationLog_Insert]")
.Parameters(
p => p.Name("type").Value(entity.Type),
p => p.Name("userId").Value(entity.UserId),
p => p.Name("source").Value(entity.Source),
p => p.Name("message").Value(entity.Message),
p => p.Name("data").Value(entity.Data),
p => p.Name("url").Value(entity.Url),
p => p.Name("stackTrace").Value(entity.StackTrace),
p => p.Name("hostIpAddress").Value(entity.HostIpAddress),
p => p.Name("userIpAddress").Value(entity.UserIpAddress),
p => p.Name("userAgent").Value(entity.UserAgent)
)
.Instance(entity)
.MapProperties(
p => p.Name("Id").Index(0),
p => p.Name("When").Index(1)
);
return(command);
}
public async override Task <ApplicationLog> GetByIdAsync(int?applicationLogId)
{
var result = await Query <ApplicationLog>
.Single()
.Connection(ApplicationLogsConnectionClass.GetConnectionName())
.StoredProcedure("[Logs].[pApplicationLog_GetById]")
.Parameters(
p => p.Name("applicationLogId").Value(applicationLogId.Value)
)
.ExecuteAsync();
return(result.Data);
}
public async override Task <(int, IEnumerable <ApplicationLog>)> GetAsync(CollectionQueryParameters queryParameters)
{
var result = await Query <ApplicationLog>
.Collection()
.Connection(ApplicationLogsConnectionClass.GetConnectionName())
.StoredProcedure("[Logs].[pApplicationLog_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 CreateDeleteCommand(ApplicationLog entity, IAuthenticatedUser user, string selector)
{
switch (selector)
{
case "DeleteOlderLogs": return(Command
.NonQuery()
.Connection(ApplicationLogsConnectionClass.GetConnectionName())
.StoredProcedure("[Logs].[pApplicationLog_DeleteOlderLogs]")
.Parameters(
p => p.Name("when").Value(entity.When)
));
default: return(Command
.NonQuery()
.Connection(ApplicationLogsConnectionClass.GetConnectionName())
.StoredProcedure("[Logs].[pApplicationLog_Delete]")
.Parameters(
p => p.Name("applicationLogId").Value(entity.Id)
));
}
}
public GetApplicationLogsQueryAggregate() : base(new DomainFramework.DataAccess.RepositoryContext(ApplicationLogsConnectionClass.GetConnectionName()))
{
var context = (DomainFramework.DataAccess.RepositoryContext)RepositoryContext;
ApplicationLogQueryRepository.Register(context);
}
public CreateApplicationLogCommandAggregate() : base(new DomainFramework.DataAccess.RepositoryContext(ApplicationLogsConnectionClass.GetConnectionName()))
{
}
public CreateApplicationLogCommandAggregate(CreateApplicationLogInputDto log, EntityDependency[] dependencies = null) : base(new DomainFramework.DataAccess.RepositoryContext(ApplicationLogsConnectionClass.GetConnectionName()))
{
Initialize(log, dependencies);
}