/// <summary> /// Save Results /// </summary> /// <param name="playerName">Player Name</param> /// <param name="score">Player score</param> public static void SaveResult(string playerName, int score) { using (UserScoreEntities db = new UserScoreEntities()) { var newScore = new Score() { UserName = playerName, MyScore = score, DateAdded = DateTime.Now }; db.Users.Add(newScore); db.SaveChanges(); } }
/// <summary> /// Get 10 top results /// </summary> /// <returns></returns> public static List <Score> GetTopResult() { using (UserScoreEntities db = new UserScoreEntities()) { var resList = db.Users.OrderByDescending(x => x.MyScore).ToList(); if (resList.Count > 10) { resList = resList.Take(10).ToList(); } else { resList = resList.Take(resList.Count).ToList(); } return(resList); } }