コード例 #1
0
        public async Task <PagingResult <LeaveDto> > GetAllLeaves(int page, int pageSize, int employeeId, DateTime fromDate, DateTime toDate, bool?isApproved)
        {
            try
            {
                Expression <Func <Leave, bool> > filter = x => x.EmployeeId == employeeId &&
                                                          fromDate.Date <= x.FromDate &&
                                                          x.ToDate <= toDate &&
                                                          (isApproved == null || x.IsApproved == isApproved);

                IOrderedQueryable <Leave> OrderBy(IQueryable <Leave> x)
                {
                    return(x.OrderByDescending(y => y.FromDate));
                }

                IIncludableQueryable <Leave, object> Includes(IQueryable <Leave> x)
                {
                    return(x.Include(y => y.Employee).Include(y => y.LeaveType));
                }

                int skip = (page - 1) * pageSize;


                int totalData = await _leaveRepository.CountAsync(filter);

                List <Leave> leaves = new List <Leave>();

                if (totalData > 0)
                {
                    leaves = await _leaveRepository.GetAllAsync(filter, Includes, OrderBy, skip, pageSize, true);
                }

                return(new PagingResult <LeaveDto>
                {
                    Data = leaves.Select(LeaveMapper.Map).ToList(),
                    TotalCount = totalData
                });
            }
            catch (Exception ex)
            {
                _logger.LogError(ex, "Error when get all leaves");
                throw;
            }
        }