コード例 #1
0
        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));
        }
コード例 #2
0
        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));
        }