public override async Task <int> HandleCommand(DeleteCategoryCommand request, CancellationToken cancellationToken)
{
Category category = null;
if (request.Model == 0)
{
throw new BusinessException("Category.NotSelected");
}
else
{
category = await categoryQueries.GetByIdAsync(request.Model);
if (category == null)
{
throw new BusinessException("Category.NotSelected");
}
}
var rs = -1;
using (var conn = DALHelper.GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
category.IsDeleted = true;
category.ModifiedDate = DateTime.Now;
category.ModifiedBy = request.LoginSession.Id;
if (await categoryRepository.UpdateAsync(category) > 0)
{
rs = 0;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (rs == 0)
{
trans.Commit();
}
else
{
try { trans.Rollback(); } catch { }
}
}
}
}
return(rs);
}
public async Task <APIResult> GetById(int id)
{
var rs = await categoryQueries.GetByIdAsync(id);
return(new APIResult()
{
Result = 0,
Data = rs
});
}