static void DisplayHighScore() { //clear the console Console.Clear(); //Write the High Score Text Console.WriteLine("============================= DRAGON SLAYER HIGH SCORE ============================="); //create a new connection to the database TylerEntities db = new TylerEntities(); //get the HS list List <HighScore> highScoreList = db.HighScores.Where(x => x.Game == "Dragon Slayer2").OrderByDescending(x => x.Score).Take(10).ToList(); foreach (HighScore highScore in highScoreList) { Console.WriteLine("{0}, {1} - {2}", highScoreList.IndexOf(highScore) + 1, highScore.PlayerName, highScore.Score); } }
static void AddHighScore(int playerScore) { Console.WriteLine("Your Name: "); string playerName = Console.ReadLine(); //Create connection to database TylerEntities db = new TylerEntities(); //New HighScore Object must create new instance of an Object HighScore newHighScore = new HighScore(); //populate the object newHighScore.Date = DateTime.Now; newHighScore.Game = "Dragon Slayer2"; newHighScore.PlayerName = playerName; newHighScore.Score = playerScore; //add it to the database db.HighScores.Add(newHighScore); //now it's set up but not in the database yet //Nothing happens until you save db.SaveChanges(); }