Advertisement
evilbloodydemon

Untitled

Jun 18th, 2015
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.70 KB | None | 0 0
  1.                 var query = db.Preenrolments
  2.                     .Where(p => (id == null || p.Id == id) &&
  3.                         (dateFrom == null || p.DateOfBirth >= dateFrom) &&
  4.                         (dateTo == null || p.DateOfBirth <= dateTo) &&
  5.                         (crmState == null || p.CrmState == crmState));
  6.  
  7.                 if (broker != null)
  8.                 {
  9.                     query = query.Where(p => p.Broker.Name.Contains(broker));
  10.                 }
  11.  
  12.                 var totalItemCount = query.Count();
  13.                 var subset = query
  14.                     .Select(p => p.Build(p.Broker))
  15.                     .Skip((page - 1)*pageSize)
  16.                     .Take(pageSize);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement