public async Task <APIResult> GetAlls() { return(new APIResult() { Result = 0, Data = await categoryQueries.GetAll(LoginSession.LanguageCode) }); }
public override async Task <int> HandleCommand(DeleteCommand request, CancellationToken cancellationToken) { var category = await categoryQueries.GetById(request.CategoryId); if (category == null) { throw new BusinessException("Category.NotExisted"); } var rs = -1; using (var conn = DALHelper.GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { try { var categories = (await categoryQueries.GetAll()).Where(x => x.ParentId == category.Id).ToList(); for (int i = 0; i < categories.Count; i++) { categories[i].ParentId = null; categories[i] = UpdateBuild(categories[i], request.LoginSession); await categoryRepository.Update(categories[i]); } category.IsDeleted = true; category = UpdateBuild(category, request.LoginSession); if (await categoryRepository.Update(category) > 0) { rs = 0; } } finally { if (rs == 0) { trans.Commit(); } else { try { trans.Rollback(); } catch { } } } } } return(rs); }
public async Task <IActionResult> GetAll() { var result = await _categoryQueries.GetAll(); return(Ok(result)); }