public static void PrintAllScores() { using (var db = new PoolManagerModel()) { foreach (var account in db.PoolPlayerAccounts) { Console.WriteLine($"Player Name: {account.PoolPlayerName}, Score: {account.ScoreDifferential}"); } } }
public static void PrintPlayerAccount(string emailAddress) { using (var db = new PoolManagerModel()) { foreach (var account in db.PoolPlayerAccounts.Where(a => a.EmailAddress == emailAddress)) { Console.WriteLine($"Player Name: {account.PoolPlayerName}, Devils: {account.PredictedDevils}, Islanders: {account.PredictedIslanders}, Rangers: {account.PredictedRangers}, Flyers: {account.PredictedFlyers},"); } } }
public static PoolPlayerAccount CreateAccount(string poolPlayerName, string emailAddress, int predictedDevils, int predictedIslanders, int predictedRangers, int predictedFlyers) { using (var db = new PoolManagerModel()) { var poolplayerAccount = new PoolPlayerAccount(); poolplayerAccount.PoolPlayerName = poolPlayerName; poolplayerAccount.EmailAddress = emailAddress; poolplayerAccount.PredictedDevils = predictedDevils; poolplayerAccount.PredictedIslanders = predictedIslanders; poolplayerAccount.PredictedRangers = predictedRangers; poolplayerAccount.PredictedFlyers = predictedFlyers; ///poolplayerAccount.PredictedPenguins = predictedPenguins; ///poolplayerAccount.PredictedBruins = predictedBruins; ///poolplayerAccount.PredictedSabres = predictedSabres; ///poolplayerAccount.PredictedCanadiens = predictedCanadiens; ///poolplayerAccount.PredictedSenators = predictedSenators; ///poolplayerAccount.PredictedLeafs = predictedLeafs; ///poolplayerAccount.PredictedThrashers = predictedThrashers; /// poolplayerAccount.PredictedHurricanes = predictedHurricanes; ///poolplayerAccount.PredictedPanthers = predictedPanthers; ///poolplayerAccount.PredictedLightning = predictedLightning; ///poolplayerAccount.PredictedCapitals = predictedCapitals; ///poolplayerAccount.PredictedBlackhawks = predictedBlackhawks; ///poolplayerAccount.PredictedBJackets = predictedBJackets; ///poolplayerAccount.PredictedRWings = predictedRWings; ///poolplayerAccount.PredictedPredators = predictedPredators; ///poolplayerAccount.PredictedBlues = predictedBlues; ///poolplayerAccount.PredictedFlames = predictedFlames; ///poolplayerAccount.PredictedAvalanche = predictedAvalanche; ///poolplayerAccount.PredictedOilers = predictedOilers; ///poolplayerAccount.PredictedWild = predictedWild; ///poolplayerAccount.PredictedCanucks = predictedCanucks; ///poolplayerAccount.PredictedDucks = predictedDucks; ///poolplayerAccount.PredictedStars = predictedStars; ///poolplayerAccount.PredictedKings = predictedKings; ///poolplayerAccount.PredictedCoyotes = predictedCoyotes; ///poolplayerAccount.PredictedSharks = predictedSharks; db.PoolPlayerAccounts.Add(poolplayerAccount); db.SaveChanges(); return(poolplayerAccount); } }