public IActionResult CalculateWins(int id) { List <MatchupWinner> matchupWinnerList = new List <MatchupWinner>(); string week = HttpDataHelper.Get_Current_Week(); int scoreCount = 0; var player = _context.Players.Where(p => p.Id == id).FirstOrDefault(); List <string> winners = ScoresDataHelper.Get_Matchup_Winners("1"); var picks = _context.PlayerPicks.Where(p => p.PlayerId == id && p.Week == "1").FirstOrDefault(); string[] playerPicks = new string[] { picks.Pick1, picks.Pick2, picks.Pick3, picks.Pick4, picks.Pick5, picks.Pick6, picks.Pick7, picks.Pick8, picks.Pick9, picks.Pick10, picks.Pick11, picks.Pick12, picks.Pick13, picks.Pick14, picks.Pick15, picks.Pick16 }; int index = 0; foreach (var pick in playerPicks) { string winner = winners[index].Trim(); if (winner.Equals(pick.Trim())) { matchupWinnerList.Add(new MatchupWinner(player.Username, winner, pick, true, week)); scoreCount++; } else { matchupWinnerList.Add(new MatchupWinner(player.Username, winner, pick, false, week)); } index++; } ViewBag.scorecount = scoreCount; return(View(matchupWinnerList)); }
public IActionResult ViewPicks(int id) { var week = HttpDataHelper.Get_Current_Week(); var picks = _context.PlayerPicks.Where(p => p.PlayerId == id && p.Week == week).FirstOrDefault(); var player = ""; try { player = _context.Players.Where(n => n.Id == picks.PlayerId).Select(n => n.Username).FirstOrDefault(); } catch (Exception ex) { player = ""; } if (player != null) { ViewBag.player = player; } if (picks != null) { ViewBag.week = picks.Week; ViewBag.player = player; return(View(picks)); } else { return(View()); } }
public IActionResult ViewPicks(int id) { var week = HttpDataHelper.Get_Current_Week(); var picks = _context.PlayerPicks.Where(p => p.PlayerId == id && p.Week == week).FirstOrDefault(); var player = _context.Players.Where(p => p.Id == id).FirstOrDefault(); ViewBag.player = player; return(View(picks)); }
public IActionResult SavePicks(string[] teams, int id) { var week = HttpDataHelper.Get_Current_Week(); PlayerPicks picks = new PlayerPicks(id, teams[0], teams[1], teams[2], teams[3], teams[4], teams[5], teams[6], teams[7], teams[8], teams[9], teams[10], teams[11], teams[12], teams[13], teams[14], teams[15], "2019", week); _context.Add(picks); _context.SaveChanges(); return(View()); }
public IActionResult EditPicks(int id) { List <Matchup> matchups = null; var player = _context.Players.Where(p => p.Id == id).FirstOrDefault(); var week = HttpDataHelper.Get_Current_Week(); var picks = _context.PlayerPicks.Where(p => p.PlayerId == id && p.Week == week).FirstOrDefault(); if (picks != null) { ViewBag.player = player; matchups = HttpDataHelper.Load_Matchups(HttpDataHelper.Get_Current_Week()); ViewBag.week = week; return(View(matchups)); } else { ViewBag.player = player; ViewBag.week = week; return(View(matchups)); } }
public ScoresController(ApplicationDbContext context) { _context = context; week = HttpDataHelper.Get_Current_Week(); }