Example #1
0
        public async Task <Page <Vehicle> > GetByCustomerId(int customerId, SearchVehicleStatus vehicleStatus, PagingOptions pagingOptions)
        {
            IQueryable <Vehicle> query;

            using (IDbConnection connection = _vehiclesRepository.Connection)
            {
                query = (await _vehiclesRepository.GetByCustomerId(customerId, vehicleStatus)).AsQueryable();
            }

            var size = query.Count();

            var items = query
                        .Skip(pagingOptions.Offset.Value)
                        .Take(pagingOptions.Limit.Value)
                        .ToArray();

            return(new Page <Vehicle>
            {
                Items = items,
                TotalSize = size
            });
        }