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