Esempio n. 1
0
        public IActionResult Index(CountryListViewModel model)
        {
            var session = new CountrySession(HttpContext.Session);

            session.SetActiveGame(model.ActiveGame);
            session.SetActiveSport(model.ActiveSport);
            session.SetActiveCategory(model.ActiveCategory);

            // if no count value in session, use data in cookie to restore fave Countries in session
            int?count = session.GetMyCountryCount();

            if (count == null)
            {
                var      cookies = new CountryCookies(HttpContext.Request.Cookies);
                string[] ids     = cookies.GetMyCountryIds();

                List <Country> myCountries = new List <Country>();
                if (ids.Length > 0)
                {
                    myCountries = context.Countries.Include(c => c.Game)
                                  .Include(c => c.Sport)
                                  .Include(c => c.Category)
                                  .Where(c => ids.Contains(c.CountryId)).ToList();
                }
                session.SetMyCountries(myCountries);
            }


            model.Games      = context.Games.ToList();
            model.Sports     = context.Sports.ToList();
            model.Categories = context.Categories.ToList();


            IQueryable <Country> query = context.Countries;

            if (model.ActiveGame != "all")
            {
                query = query.Where(
                    c => c.Game.GameId.ToLower() == model.ActiveGame.ToLower());
            }
            if (model.ActiveSport != "all")
            {
                query = query.Where(
                    c => c.Sport.SportId.ToLower() == model.ActiveSport.ToLower());
            }
            if (model.ActiveCategory != "all")
            {
                query = query.Where(
                    c => c.Category.CategoryId.ToLower() == model.ActiveCategory.ToLower());
            }
            model.Countries = query.ToList();

            return(View(model));
        }
Esempio n. 2
0
        public IActionResult Index(OlympicListViewModel model, string activeGame = "all", string activeSport = "all")
        {
            var session = new CountrySession(HttpContext.Session);

            session.SetActiveGame(activeGame);
            session.SetActiveSport(activeSport);


            int?count = session.GetMyCountryCount();

            if (count == null)
            {
                var      cookies = new CountryCookies(Request.Cookies);
                string[] ids     = cookies.GetMyCountryIds();

                List <Country> mycountries = new List <Country>();
                if (ids.Length > 0)
                {
                    mycountries = context.Countries.Include(testc => testc.Game)
                                  .Include(t => t.Sport)
                                  .Where(t => ids.Contains(t.CountryID)).ToList();
                }
                session.SetMyCountries(mycountries);
            }


            model.Games  = context.Games.ToList();
            model.Sports = context.Sports.ToList();

            IQueryable <Country> query = context.Countries;

            if (activeGame != "all")
            {
                query = query.Where(t => t.Game.GameID.ToLower() == activeGame.ToLower());
            }
            if (activeSport != "all")
            {
                query = query.Where(t => t.Sport.SportID.ToLower() == activeSport.ToLower());
            }
            model.Countries = query.ToList();
            return(View(model));
        }