Esempio n. 1
0
        public IActionResult Get(VacationQueryParamaters vacationQueryParamater)
        {
            _logger.LogInformation("Get All Vacation Called");
            var allVacationRequest   = _repo.GetAll(vacationQueryParamater).ToList();
            var allvactionRequestDTO = allVacationRequest.Select(x => Mapper.Map <VacationRequestDTO>(x));

            Response.Headers.Add("X-Pagination", JsonConvert.SerializeObject(new { totalCount = _repo.Count() }));

            return(Ok(allvactionRequestDTO));
        }
        public IQueryable <VacationRequest> GetAll(VacationQueryParamaters vacationQueryParrameter)
        {
            IQueryable <VacationRequest> _allVactionRequest = _Context.VacationRequest.OrderBy(vacationQueryParrameter.OrderBy, vacationQueryParrameter.Descending);

            if (vacationQueryParrameter.HasQuery)
            {
                // I am using request ID for the now
                _allVactionRequest = _allVactionRequest.Where(x => x.RequestID.ToString().ToLowerInvariant().Contains(vacationQueryParrameter.Query.ToLowerInvariant()) || x.ApprovalID.ToString().ToLowerInvariant().Contains(vacationQueryParrameter.Query.ToLowerInvariant()));
            }
            return(_Context.VacationRequest.OrderBy(x => x.ApprovalID)
                   .Skip(vacationQueryParrameter.PageCount * (vacationQueryParrameter.Page - 1))
                   .Take(vacationQueryParrameter.PageCount));
        }