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)); }