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()
}));
}
}
