Guest User

Untitled

a guest
Jun 21st, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. public IQueryable<Item> FindItemsByDescription(string description)
  2. {
  3. return from item in _dc.Items
  4. where item.Description.Contains(description);
  5. }
  6.  
  7. public IQueryable<Item> FindItemsByDescription(string description, int pageIndex, int pageSize)
  8. {
  9. return from item in _dc.Items
  10. where item.Description.
  11. Contains(description).
  12. Skip((pageIndex - 1) * pageSize).
  13. Take(pageSize);
  14. }
  15.  
  16. int totalCount = from item in _dc.Items
  17. where item.Description.
  18. Contains(description).Count();
  19.  
  20. int numberOfPages = (int)(totalCount/pageSize);
  21.  
  22. public IQueryable<Item> FindItemsByDescription(string description, int resultAmount)
  23. {
  24. return from item in _dc.Items
  25. where item.Description.Contains(description).Take(resultAmount);
  26. }
  27.  
  28. public IQueryable<Item> FindItemsByDescription(string description, int resultAmount, int page)
  29. {
  30. return from item in _dc.Items
  31. where item.Description.Contains(description).Skip(resultAmount * page).Take(resultAmount);
  32. }
Add Comment
Please, Sign In to add comment