internal static ResultOption GetResultOption(MatchResultEnum matchResultEnum) { using (var db = new FifaRankingsEntities()) { return db.ResultOptions.First(x => x.Id == (int)matchResultEnum); } }
// GET: Results public ActionResult Index() { var dbContext = new FifaRankings.Data.FifaRankingsEntities(); var model = dbContext.MatchResults.OrderByDescending(r => r.MatchDate).ToList(); return(View(model)); }
internal static void LogRankingScore(RankingScoreLog homeRankingScore) { using (var db = new FifaRankingsEntities()) { db.RankingScoreLogs.Add(homeRankingScore); db.SaveChanges(); } }
public static void LogMatchResult(MatchResultLog matchResult) { using (var db = new FifaRankingsEntities()) { db.MatchResultLogs.Add(matchResult); db.SaveChanges(); } }
public ActionResult Rankings() { ViewBag.Message = "The latest rankings are below."; using (var db = new FifaRankingsEntities()) { ViewBag.RankingsLeaderboard = db.RankingLeaderboards.OrderByDescending(p => p.RankingPoints).ToList(); } return View(); }
public ActionResult Index() { ViewBag.Message = "The latest rankings are below."; using (var db = new FifaRankingsEntities()) { ViewBag.RankingsLeaderboard = db.RankingLeaderboards.OrderByDescending(p => p.RankingPoints).ToList(); ViewBag.PlayerHandicaps = db.Handicaps.OrderByDescending(p => p.PerformanceIndicator).ToList(); ViewBag.HandicapThresholds = db.HandicapThresholds.OrderBy(h => h.Stars).ToList(); } return View(); }
public static IEnumerable<SelectListItem> PlayersSelectList() { using (var db = new FifaRankingsEntities()) { return db.Players.OrderBy(p => p.Firstname).ThenBy(p => p.Lastname).ToList(). Select(p => new SelectListItem() { Text = string.Format("{0} {1}", p.Firstname, p.Lastname), Value = p.Id.ToString() }); } }
public static IEnumerable<SelectListItem> MatchStatusesSelectList() { using (var db = new FifaRankingsEntities()) { return db.MatchStatus.OrderBy(x => x.StatusName).ToList(). Select(x => new SelectListItem() { Text = x.StatusName, Value = x.Id.ToString() }); } }
// GET: Results public ActionResult Index() { var dbContext = new FifaRankings.Data.FifaRankingsEntities(); var model = dbContext.MatchResults.OrderByDescending(r => r.MatchDate).ToList(); return View(model); }