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 }); }