// GET: VideoGames public async Task <IActionResult> Index(string searchString, string videogamepublisher) { var VideoGameList = from v in _context.VideoGame select v; if (!String.IsNullOrEmpty(searchString)) { VideoGameList = VideoGameList.Where(v => v.Title.Contains(searchString)); } IQueryable <string> publisherQuery = from v in _context.VideoGame orderby v.Publisher select v.Publisher; if (!String.IsNullOrEmpty(videogamepublisher)) { VideoGameList = VideoGameList.Where(v => v.Publisher == videogamepublisher ); } var videogamepublisherVM = new VideoGameViewModel(); videogamepublisherVM.publisher = new SelectList(await publisherQuery.Distinct().ToListAsync()); videogamepublisherVM.videoGames = await VideoGameList.ToListAsync(); return(View(videogamepublisherVM)); }
public JsonResult Search(string searchString) { var vms = new List <VideoGameViewModel>(); var foundGames = VideoGameService.GetVideoGameByName(searchString); foreach (var game in foundGames) { var vm = new VideoGameViewModel(game); vm.PlatformName = PlatformService.Get(game.PlatformId).Name; vm.RatingName = RatingService.Get(game.RatingId).Name; vms.Add(vm); } return(Json(vms, JsonRequestBehavior.AllowGet)); }
// GET: VideoGames public ActionResult Index() { VideoGameViewModel videoGame = new VideoGameViewModel(db.VideoGames.ToList()); return(View(videoGame)); }