public IActionResult Search() { if (HttpContext.Session.GetInt32("LoggedInUserId") is null) { return(RedirectToAction("Index", "LoginReg")); } List <Commute> AllCommutes = dbContext.Commutes .Include(c => c.startLocation) .Include(c => c.endLocation) .Include(c => c.carpool) .ThenInclude(c => c.user) .Include(c => c.carpool) .ThenInclude(c => c.riderships) .ThenInclude(r => r.user) .Where(c => (c.carpool.user.Id != HttpContext.Session.GetInt32("LoggedInUserId")) && (!(c.carpool.riderships.Any(r => r.user.Id == HttpContext.Session.GetInt32("LoggedInUserId"))))) .OrderBy(c => c.Day) .ThenBy(c => c.ArriveBy.Hour) .ToList(); bool idValid = Int32.TryParse(RouteData.Values["mappedCommuteId"].ToString(), out int comId); Commute clickedCommute = dbContext.Commutes .Include(c => c.startLocation) .Include(c => c.endLocation) .FirstOrDefault(c => c.Id == comId); ViewPools Data = new ViewPools() { ClickedCommute = clickedCommute, AllCommutes = AllCommutes }; return(View(Data)); }
public IActionResult SearchDefault() { if (HttpContext.Session.GetInt32("LoggedInUserId") is null) { return(RedirectToAction("Index", "LoginReg")); } List <Commute> AllCommutes = dbContext.Commutes .Include(c => c.startLocation) .Include(c => c.endLocation) .Include(c => c.carpool) .ThenInclude(c => c.user) .Include(c => c.carpool) .ThenInclude(c => c.riderships) .ThenInclude(r => r.user) .Where(c => (c.carpool.user.Id != HttpContext.Session.GetInt32("LoggedInUserId")) && (!(c.carpool.riderships.Any(r => r.user.Id == HttpContext.Session.GetInt32("LoggedInUserId"))))) .OrderBy(c => c.Day) .ThenBy(c => c.ArriveBy.Hour) .ToList(); Commute defaultCommute = dbContext.Commutes .Include(c => c.startLocation) .Include(c => c.endLocation) .FirstOrDefault(); ViewPools Data = new ViewPools() { ClickedCommute = defaultCommute, AllCommutes = AllCommutes }; return(View("Search", Data)); }