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)); }
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)); }