Advertisement
Guest User

Untitled

a guest
Jan 19th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.70 KB | None | 0 0
  1.  
  2.  
  3.  
  4. IQueryable<Trip> query = tripRepository.GetAll()
  5.                 .Include(t => t.Events.Select(e => e.Driver.Missions))
  6.                 .Include(t => t.FirstLoading)
  7.                 .Include(t => t.LastDelivery)
  8.                 .Include(t => t.Missions.Select(m => m.Resources))
  9.                 .Include(t => t.Tasks.Select(ta => ta.Location))
  10.                 .Where(t => t.Events.Any(e => e.TYPE_ID == (int)EBTEnum.EventType.activityStart || e.TYPE_ID == (int)EBTEnum.EventType.activityEnd))
  11.                 .Where(t => (fromDate == null || t.Events.Any(e => e.EVENT_DATE >= fromDate.Value)))
  12.                 .Where(t => (toDate == null || t.Events.Any(e => e.EVENT_DATE <= toDate.Value)));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement