public long GetCount(PagingParameters param) { if (_context.Routes == null || _context.Routes.Count() == 0) { return(0); } return(_context.Routes.Where(o => o.Route.StartsWith(param.filter.ToString())).Count()); }
public long GetOwnCount(PagingParameters param) { if (_context.Routes == null || _context.Routes.Count() == 0) { return(0); } var count = _context.RelRouteUser.Where(x => x.IdUser == param.user).Count(); return(count); }
public IEnumerable <UsersByRoutes> GetOwnPaged(PagingParameters param) { if (_context.Routes == null || _context.Routes.Count() == 0) { return(null); } var routesByUser = (from r in _context.Routes.Include("RouteVisit").Include("RelRouteUser") join rr in _context.RelRouteUser on r.Id equals rr.IdRoute where rr.IdUser == param.user select r).Skip(param.pageIndex * param.pageSize).Take(param.pageSize).ToList(); List <UsersByRoutes> usersByRoutes = new List <UsersByRoutes>(); foreach (var item in routesByUser) { var flagUser = false; var usersByRoute = (from rr in _context.RelRouteUser join u in _context.AspNetUsers on rr.IdUser equals u.Id where rr.IdRoute == item.Id select new User { Id = rr.IdUser, UserName = u.UserName }).ToList(); var favoritesUserFlag = _context.Favorites.Where(x => x.IdUser == param.user && item.Id == x.IdRoute).FirstOrDefault(); if (favoritesUserFlag != null) { flagUser = favoritesUserFlag.isFavorite; } var usersByRoutesModel = new UsersByRoutes { Id = item.Id, PageTitle = item.PageTitle, isFavorite = flagUser, Users = usersByRoute, RedirectUrl = item.RedirectUrl, Route = item.Route, RelRouteUser = item.RelRouteUser, RouteVisit = item.RouteVisit, Status = item.Status }; usersByRoutesModel.Exists = true; usersByRoutes.Add(usersByRoutesModel); } var usersByRoutesQuery = usersByRoutes.AsQueryable(); if (!string.IsNullOrEmpty(param.sortOrder)) { if (param.sortOrder == "VisitCount") { if (param.sortAsc) { usersByRoutesQuery = usersByRoutesQuery.OrderBy(x => x.RouteVisit.Count); } else { usersByRoutesQuery = usersByRoutesQuery.OrderByDescending(x => x.RouteVisit.Count); } } } return(usersByRoutes); }
public IEnumerable <ApplicationUser> GetUsersPaged(PagingParameters param) { if (_context.Users == null || _context.Users.Count() == 0) { return(null); } List <ApplicationUser> users = _context.Users.OrderBy(x => x.UserName).ToList(); IQueryable <ApplicationUser> usersQuery = users.AsQueryable().Where(u => u.UserName.StartsWith(param.filter.ToString())).Skip(param.pageIndex * param.pageSize).Take(param.pageSize); return(usersQuery); }
public long GetOthersCount(PagingParameters param) { if (_context.Routes == null || _context.Routes.Count() == 0) { return(0); } var count = GetCount(param); var own = GetOwnCount(param); count = count - own; return(count); }
public IEnumerable <UsersByRoutes> GetPaged(PagingParameters param) { if (_context.Routes == null || _context.Routes.Count() == 0) { return(null); } IQueryable <Routes> routes = _context.Routes.Include("RouteVisit").Where(o => !string.IsNullOrEmpty(param.filter) ? o.Route.StartsWith(param.filter) : true).Skip(param.pageIndex * param.pageSize).Take(param.pageSize); List <UsersByRoutes> usersByRoutes = new List <UsersByRoutes>(); try { foreach (var item in routes) { var usersByRoute = (from rr in _context.RelRouteUser join u in _context.AspNetUsers on rr.IdUser equals u.Id where rr.IdRoute == item.Id select new User { Id = rr.IdUser, UserName = u.UserName }).ToList(); var usersByRoutesModel = new UsersByRoutes { Id = item.Id, PageTitle = item.PageTitle, isFavorite = null, Users = usersByRoute, RedirectUrl = item.RedirectUrl, Route = item.Route, RelRouteUser = item.RelRouteUser, RouteVisit = item.RouteVisit, Status = item.Status }; if (param.role == "Admin") { usersByRoutesModel.Exists = true; usersByRoutes.Add(usersByRoutesModel); } else { if (usersByRoutesModel.Users.Exists(x => x.Id == param.user)) { usersByRoutesModel.Exists = true; } else { usersByRoutesModel.Exists = false; } usersByRoutes.Add(usersByRoutesModel); } } } catch (Exception) { throw; } var usersByRoutesQuery = usersByRoutes.AsQueryable(); if (!string.IsNullOrEmpty(param.sortOrder)) { if (param.sortOrder == "VisitCount") { if (param.sortAsc) { usersByRoutesQuery = usersByRoutesQuery.OrderBy(x => x.RouteVisit.Count); } else { usersByRoutesQuery = usersByRoutesQuery.OrderByDescending(x => x.RouteVisit.Count); } } } return(usersByRoutesQuery); }
public long GetCount(PagingParameters param) { return((_context.Users == null || _context.Users.Count() == 0)? 0 : _context.Users.Count()); }