public async Task <IEnumerable <GetCommentByCardIdResponseDTO> > GetCommentByCardId(GetCommentByCardIdRequestDTO getCommentByCardIdRequestDTO) { try { return(await _unitOfWokDapper.CommentQueries.GetCommentByCardId(getCommentByCardIdRequestDTO)); } catch (Exception ex) { _logger.LogExceptionError(ex.ToString()); throw ex; } }
public async Task <IEnumerable <GetCommentByCardIdResponseDTO> > GetCommentByCardId(GetCommentByCardIdRequestDTO getCommentByCardIdRequestDTO) { return(await _commentService.GetCommentByCardId(getCommentByCardIdRequestDTO)); }
public async Task <IEnumerable <GetCommentByCardIdResponseDTO> > GetCommentByCardId(GetCommentByCardIdRequestDTO getCommentByCardIdRequestDTO) { var query = @$ " SELECT C.*, A.*, CA.* FROM Comment C INNER JOIN Account A ON C.UserId = A.AccountId INNER JOIN Card CA ON C.CardId = CA.CardId WHERE C.CardId = @CardId AND C.IsActive = @IsActive"; DynamicParameters param = new DynamicParameters(); param.Add("@CardId", getCommentByCardIdRequestDTO.CardId); param.Add("@IsActive", true); return(await _db.QueryAsync <GetCommentByCardIdResponseDTO>(sql : query, param : param, commandType : CommandType.Text)); }