public async Task <ExecutionStatus> Run(CategoryUniqueId categoryId)
{
using var connection = new SqliteConnection(_geekLemonContext.ConnectionString);
var q = @"DELETE FROM Categories WHERE UniqueId=@UniqueId;";
try
{
var result = await connection.QueryAsync <int>(q,
new
{
@UniqueId = categoryId.Value.ToString()
});
}
catch (Exception ex)
{
if (ExecutionFlow.Options.ThrowExceptions)
{
throw;
}
return(ExecutionStatus.DbError(ex));
}
return(ExecutionStatus.DbOk());
}
public async Task <ExecutionStatus <Category> > Run(CategoryUniqueId categoryId)
{
using var connection = new SqliteConnection
(_geekLemonContext.ConnectionString);
var q = @"SELECT Id, DisplayName, Name,
WhatWeAreLookingFor,UniqueId ,Version FROM Categories
Where UniqueId = @UniqueId";
try
{
var r = await connection.
QueryFirstOrDefaultAsync <CategoryTemp>
(q, new
{
@UniqueId = categoryId.Value.ToString(),
});
var rmaped = _mapper.Map <Category>(r);
return(ExecutionStatus <Category> .
DbIfDefaultThenError(rmaped));
}
catch (Exception ex)
{
return(ExecutionStatus <Category> .DbError(ex));
}
}
private void Apply(CategoryUpdatedEvent e)
{
Version = e.Version++;
Name = e.Name;
DisplayName = e.DisplayName;
UniqueId = e.UniqueId;
WhatWeAreLookingFor = e.WhatWeAreLookingFor;
this.Key = e.UniqueId.GetAggregateKey();
}
public ESCreateCategoryCommand()
{
UniqueId = CategoryUniqueId.NewUniqueId();
Version = 0;
}
public Task <ExecutionStatus <Category> > GetByIdAsync(CategoryUniqueId id)
{
return(_categoryGetByIdDoer.Run(id));
}
public Task <ExecutionStatus> DeleteAsync(CategoryUniqueId categoryId)
{
return(_categoryDeleteDoer.Run(categoryId));
}
public CategoryBuilder WithUniqueId(Guid guid)
{
categoryUniqueId = new CategoryUniqueId(guid);
return(this);
}
