internal static ResultOption GetResultOption(MatchResultEnum matchResultEnum) { using (var db = new FifaRankingsEntities()) { return(db.ResultOptions.First(x => x.Id == (int)matchResultEnum)); } }
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() })); } }