public async Task <PaginatedList <TicketDto> > Handle(GetTicketsWithPaginationQuery request, CancellationToken cancellationToken)
        {
            try
            {
                var tickets = await _dbContext.Tickets
                              .OrderBy(x => x.Title)
                              .ProjectTo <TicketDto>(_mapper.ConfigurationProvider)
                              .PaginatedListAsync(request.PageNumber, request.PageSize);

                return(tickets);
            }
            catch (Exception ex)
            {
                throw new Exception("There was an error getting the tickets with pagination", ex);
            }
        }
        public async Task <ActionResult <PaginatedList <TicketDto> > > GetTicketsWithPagination([FromQuery] GetTicketsWithPaginationQuery ticket)
        {
            var result = await Mediator.Send(ticket);

            return(Ok(result));
        }