public Tuple <IQueryable <StudentRequestsViewModel>, int, int> GetAanvragen(int start, int length, string searchValue, string sortColumnName, string sortDirection)
{
var qry = lectorService.GetStudentRequests().AsQueryable();
int recordsTotal = qry.Count();
int filtered = recordsTotal;
if (!string.IsNullOrEmpty(searchValue))
{
qry = GetStudentRequestsWithSearch(searchValue).AsQueryable();
filtered = qry.Count();
}
if (!string.IsNullOrEmpty(sortColumnName))
{
qry = qry.OrderBy(sortColumnName + " " + sortDirection);
}
qry = qry.Skip(start).Take(length);
return(Tuple.Create(qry, recordsTotal, filtered));
}
public ActionResult Index()
{
var studentRequests = service.GetStudentRequests();
return(View(studentRequests));
}