Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IQueryable<Trip> query = tripRepository.GetAll()
- .Include(t => t.Events.Select(e => e.Driver.Missions))
- .Include(t => t.FirstLoading)
- .Include(t => t.LastDelivery)
- .Include(t => t.Missions.Select(m => m.Resources))
- .Include(t => t.Tasks.Select(ta => ta.Location))
- .Where(t => t.Events.Any(e => e.TYPE_ID == (int)EBTEnum.EventType.activityStart || e.TYPE_ID == (int)EBTEnum.EventType.activityEnd))
- .Where(t => (fromDate == null || t.Events.Any(e => e.EVENT_DATE >= fromDate.Value)))
- .Where(t => (toDate == null || t.Events.Any(e => e.EVENT_DATE <= toDate.Value)));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement