Beispiel #1
0
        public IActionResult Index(CountryListViewModel model)
        {
            model.Categories = context.Categories.ToList();
            model.Games      = context.Games.ToList();

            var session = new CountrySession(HttpContext.Session);

            session.SetActiveCat(model.ActiveCat);
            session.SetActiveGam(model.ActiveGam);

            // if no count value in session, use data in cookie to restore fave teams in session
            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(t => t.Category)
                                  .Include(t => t.Game)
                                  .Where(t => ids.Contains(t.CountryID)).ToList();
                }
                session.SetMyCountries(mycountries);
            }


            IQueryable <Country> query = context.Countries;

            if (model.ActiveCat != "all")
            {
                query = query.Where(
                    t => t.Category.CategoryID.ToLower() == model.ActiveCat.ToLower());
            }
            if (model.ActiveGam != "all")
            {
                query = query.Where(
                    t => t.Game.GameID.ToLower() == model.ActiveGam.ToLower());
            }
            model.Countries = query.ToList();

            return(View(model));
        }
Beispiel #2
0
        public ViewResult Index(string activeGame = "0", string activeCat = "0")
        {
            var session = new CountrySession(HttpContext.Session);

            session.SetActiveGame(activeGame);
            session.SetActiveCat(activeCat);

            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(t => t.GameType).Include(t => t.Category).Where(t => ids.Contains(t.CountryId)).ToList();
                }
                session.SetMyCountries(mycountries);
            }

            var model = new CountryListViewModel
            {
                ActiveGame = activeGame,
                ActiveCat  = activeCat,
                Games      = context.GameTypes.ToList(),
                Categories = context.Categories.ToList()
            };
            IQueryable <Country> query = context.Countries;

            if (activeGame != "0")
            {
                query = query.Where(t => t.GameType.GameTypeId.ToString() == activeGame);
            }
            if (activeCat != "0")
            {
                query = query.Where(t => t.Category.CategoryId.ToString() == activeCat);
            }
            model.Countries = query.ToList();
            return(View(model));
        }