Advertisement
Guest User

Untitled

a guest
May 26th, 2017
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 0.63 KB | None | 0 0
  1. public SearchResults<Qualification> Search(SearchCriteria criteria)
  2.     {
  3.       SearchResults<Qualification> results = new SearchResults<Qualification>();
  4.       using (ASL_Entities ent = new ASL_Entities())
  5.       {
  6.         ObjectQuery<Qualification> query = ent.Qualifications.Include("AwardingBody");
  7.  
  8.         if (criteria.keywords != null)
  9.         {
  10.           query.Where(q => q.Title.Contains(criteria.keywords));
  11.         }
  12.  
  13.         results.totalCount = query.Count();
  14.         results.data = query.OrderBy(q => q.QualificationID).Skip(criteria.startRecord).Take(criteria.pageSize).ToList();
  15.       }
  16.       return results;
  17.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement