public Player GetPlayerFromDb(string PlayerName)
{
Player getPlayer = null;
// Holding Entity Object
PlayerDb holdPlayer = new PlayerDb();
// Get data from database
// Get a context to the db
using (var db = new PlayerDbContext())
{
foreach (PlayerDb findPlayer in db.PlayersDb)
{
if (findPlayer.PlayerName == PlayerName)
{
getPlayer = new Player();
getPlayer.PlayerName = findPlayer.PlayerName;
getPlayer.GameStatus = findPlayer.GameStatus;
// Set number of scores to 0, and let value be built when loading
getPlayer.NumberOfScores = 0;
// If there are scores, need to load up player
// Get a context to the DB
using (var db1 = new PlayerDbContext())
{
if (findPlayer.NumScores > 0)
{
foreach (PlayerScore findScore in db.PlayerScores)
{
if (findScore.PlayerDbID == findPlayer.PlayerDbID)
{
getPlayer.AddScore(findScore.Score);
}
}
}
// Close DB
db1.Dispose();
}
}
}
// Close DB
db.Dispose();
}
// Check to see if player was loaded, and if not throw exception
if (getPlayer == null)
{
throw new PlayerNotFoundException("Player not found in DB");
}
return getPlayer;
}
protected void Application_Start(object sender, EventArgs e)
{
// Create database if it is not there
using (var dbContext = new PlayerDbContext())
{
if (!dbContext.Database.Exists())
{
dbContext.Database.Create();
}
dbContext.Dispose();
}
// Use to seed database for testing
Database.SetInitializer(new PlayerDbInitializer());
}
public bool DeletePlayer(string playerName)
{
bool DeleteGood = false;
using (var db = new PlayerDbContext())
{
foreach (PlayerDb checkDb in db.PlayersDb)
{
// Search through DB for player
if (checkDb.PlayerName == playerName)
{
// If there are scores, remove them first
if (checkDb.NumScores > 0)
{
using (var db1 = new PlayerDbContext())
{
foreach (PlayerScore remScore in db1.PlayerScores)
{
if (checkDb.PlayerDbID == remScore.PlayerDbID)
{
db1.PlayerScores.Remove(remScore);
}
}
db1.SaveChanges();
db1.Dispose();
}
}
db.PlayersDb.Remove(checkDb);
}
}
db.SaveChanges();
db.Dispose();
DeleteGood = true;
}
return DeleteGood;
}
public bool SavePlayerToDb(Player player)
{
bool SaveGood = false,
NewPlayer = true;
PlayerDb AddPlayer = null;
int HoldPlayerDbID = 0;
try
{
// If a player exisits in db, find and attach to a context to update
// Get a context to the DB and save the passed object
using (var db = new PlayerDbContext())
{
foreach (PlayerDb findPlayer in db.PlayersDb)
{
if (findPlayer.PlayerName == player.PlayerName)
{
NewPlayer = false;
// Copy values to object
HoldPlayerDbID = findPlayer.PlayerDbID;
findPlayer.PlayerName = player.PlayerName;
findPlayer.GameStatus = player.GameStatus;
findPlayer.NumScores = player.NumberOfScores;
}
}
// If new player, add to DB
if (NewPlayer)
{
AddPlayer = new PlayerDb();
AddPlayer.PlayerName = player.PlayerName;
AddPlayer.GameStatus = player.GameStatus;
AddPlayer.NumScores = player.NumberOfScores;
db.PlayersDb.Add(AddPlayer);
db.SaveChanges();
HoldPlayerDbID = AddPlayer.PlayerDbID;
}
// Close DB
db.Dispose();
}
// If there are scores, update PlayerScores object
// Get a context to the DB and save the passed object
using (var db = new PlayerDbContext())
{
if (player.NumberOfScores > 0)
{
// Remove Scores first to compensate for score
// auto-sorting in domain object
// otherwise database would have to be sorted and a
// comparison done to insert new scores
// this is simpiler :-)
foreach (PlayerScore checkScore in db.PlayerScores)
{
if (checkScore.PlayerDbID == HoldPlayerDbID)
db.PlayerScores.Remove(checkScore);
}
PlayerScore SaveScores = new PlayerScore();
for (int i = 0; i < player.NumberOfScores; i++)
{
SaveScores.PlayerDbID = HoldPlayerDbID;
SaveScores.Score = player.ScoreList[i];
db.PlayerScores.Add(SaveScores);
// Start next entry
SaveScores = new PlayerScore();
}
}
db.SaveChanges();
db.Dispose();
// No errors, set return value
SaveGood = true;
}
}
catch (Exception e)
{
Console.WriteLine("DB store exception" + e.Message);
SaveGood = false;
}
return SaveGood;
}