static void DisplayHighScores() { Console.Clear(); Console.WriteLine("DragonSlayer2"); Console.WriteLine("-------------"); //create a new connection to the database OwenEntities db = new OwenEntities(); //get highscore list List <HighScore> highScoreList = db.HighScores.Where(x => x.Game == "DragonSlayer2").OrderByDescending(x => x.Score).Take(10).ToList(); foreach (HighScore highScore in highScoreList) { Console.WriteLine("{0}, {1} - {2} on {3}", highScoreList.IndexOf(highScore) + 1, highScore.Name, highScore.Score); } }
static void AddHighScore(int playerScore) { Console.WriteLine("Your Name:"); string playerName = Console.ReadLine(); //gateway to database OwenEntities db = new OwenEntities(); //new high score HighScore newHighScore = new HighScore(); //show date created newHighScore.DateCreated = DateTime.Now; newHighScore.Game = "DragonSlayer2"; newHighScore.Name = playerName; newHighScore.Score = playerScore; //add to database db.HighScores.Add(newHighScore); //save changes db.SaveChanges(); }