public IEnumerable <LeftNav> GetLeftNavsWithPagingAndSorting(int pageSize, int pageNumber, string orderBy, bool sort, string search) { if (string.IsNullOrEmpty(orderBy)) { orderBy = "Id"; } IEnumerable <LeftNav> leftNavs = null; IOrderedQueryable <LeftNav> queryOrder = null; if (sort) { queryOrder = _utils.OrderBy(_context.LeftNavs, orderBy); } else { queryOrder = _utils.OrderByDescending(_context.LeftNavs, orderBy); } if (string.IsNullOrEmpty(search)) { leftNavs = queryOrder .Skip((pageNumber - 1) * pageSize) .Take(pageSize).Include(c => c.Childs).ToList(); } else { leftNavs = queryOrder .Where(p => p.Name.Contains(search) || p.Url.Contains(search)) .Skip((pageNumber - 1) * pageSize) .Take(pageSize).Include(c => c.Childs).ToList(); } return(leftNavs); }
public IEnumerable <Project> GetProjectsWithPaging(int pageSize, int pageNumber, string orderBy, bool sort, string search) { if (string.IsNullOrEmpty(orderBy)) { orderBy = "Id"; } IEnumerable <Project> projects = null; IOrderedQueryable <Project> queryOrder = null; if (sort) { queryOrder = _utils.OrderBy(_context.Projects, orderBy); } else { queryOrder = _utils.OrderByDescending(_context.Projects, orderBy); } if (string.IsNullOrEmpty(search)) { projects = queryOrder .Skip((pageNumber - 1) * pageSize) .Take(pageSize).ToList(); } else { projects = queryOrder .Where(p => p.Name.Contains(search)) .Skip((pageNumber - 1) * pageSize) .Take(pageSize).ToList(); } return(projects); }
public IEnumerable <ApplicationUser> GetUsersWithPagingAndSorting(int pageSize, int pageNumber, string orderBy, bool sort, string search) { if (string.IsNullOrEmpty(orderBy)) { orderBy = "Id"; } IEnumerable <ApplicationUser> users = null; IOrderedQueryable <ApplicationUser> queryOrder = null; if (sort) { queryOrder = _utils.OrderBy(_userManager.Users, orderBy); } else { queryOrder = _utils.OrderByDescending(_userManager.Users, orderBy); } if (string.IsNullOrEmpty(search)) { users = queryOrder .Skip((pageNumber - 1) * pageSize) .Take(pageSize).ToList(); } else { users = queryOrder .Where(p => p.UserName.Contains(search) || p.Email.Contains(search)) .Skip((pageNumber - 1) * pageSize) .Take(pageSize).ToList(); } return(users); }