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
});
}
