// Eventresults code public IActionResult CreateTourResult() { var players = (from player in _context.Users where player.UserTours.Any(ut => ut.UserId.Equals(player.Id) && ut.TourId == HttpContext.Session.GetInt32("ChosenTourId")) select player).ToList(); ViewData["UserId"] = new SelectList(players, "UserId", "DisplayName"); ViewBag.Members = new SelectList(players, "UserId", "DisplayName"); ViewBag.Memberss = players; List <SelectListItem> playerlist = new List <SelectListItem>(); foreach (ApplicationUser player in players) { playerlist.Add( new SelectListItem { Text = player.DisplayName, Value = player.Id }); } ViewBag.List = playerlist; Debug.WriteLine("Members Size: " + players.Count); NewTourResultViewModel ntrvm = new NewTourResultViewModel(); ntrvm.EventId = (int)HttpContext.Session.GetInt32("ChosenEventId"); return(View(ntrvm)); }
public async Task <IActionResult> CreateTourResult( [Bind("UserId,Place")] NewTourResultViewModel ntrvm) { TourEvent tourevent = _context.TourEvents.Where(t => t.TourEventId.Equals( HttpContext.Session.GetInt32("ChosenEventId"))).Include(t => t.TourResults).FirstOrDefault(); ApplicationUser user = _context.Users.Where(u => u.Id.Equals(ntrvm.UserId)).FirstOrDefault(); Debug.WriteLine("Result Test (UID): " + ntrvm.UserId); Debug.WriteLine("Result Test (PLACE): " + ntrvm.Place); TourResult tr = new TourResult(); tr.User = user; tr.Place = ntrvm.Place; tourevent.TourResults.Add(tr); _context.SaveChanges(); return(RedirectToAction("TourResults", new { id = HttpContext.Session.GetInt32("ChosenEventId") })); }