public ActionResult GetSelect(string searchTerm, int pageSize, int pageNum) { IQueryable <UserViewModel> queryLanguageList = UserService.GetAll(true).AsQueryable(); var languages = new List <UserViewModel>(); int languagesCount = 0; if (searchTerm != null) { searchTerm = searchTerm.ToLower(); } queryLanguageList = queryLanguageList.Where(x => x.Username.Like(searchTerm) || x.Id.Equals(searchTerm)); languagesCount = queryLanguageList.Count(); languages = queryLanguageList.Skip(pageSize * (pageNum - 1)) .Take(pageSize) .ToList(); SelectPageResult pagedUsers = SelectGenerator.UsersToSelectPageResult(languages, languagesCount); return(new JsonResult { Data = pagedUsers, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult GetSelect(string searchTerm, int pageSize, int pageNum) { IQueryable <RoleViewModel> queryRoleList = RoleService.GetAll(true).AsQueryable(); var roles = new List <RoleViewModel>(); int roleCount = 0; if (searchTerm != null) { searchTerm = searchTerm.ToLower(); } queryRoleList = queryRoleList.Where(x => x.Name.Like(searchTerm)); roleCount = queryRoleList.Count(); roles = queryRoleList.Skip(pageSize * (pageNum - 1)) .Take(pageSize) .ToList(); SelectPageResult pagedUsers = SelectGenerator.RolesToSelectPageResult(roles, roleCount); return(new JsonResult { Data = pagedUsers, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult GetSelect(string searchTerm, int pageSize, int pageNum) { IQueryable <BookViewModel> queryBookList = BookService.GetAll(true).AsQueryable(); var books = new List <BookViewModel>(); int booksCount = 0; if (searchTerm != null) { searchTerm = searchTerm.ToLower(); } queryBookList = queryBookList.Where(x => x.AuthorAndTitle.Like(searchTerm)); booksCount = queryBookList.Count(); books = queryBookList.Skip(pageSize * (pageNum - 1)) .Take(pageSize) .ToList(); SelectPageResult pagedUsers = SelectGenerator.BooksToSelectPageResult(books, booksCount); return(new JsonResult { Data = pagedUsers, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }