public void gamesGrid_DeleteItem(int gameID)
{
using (PetanqueContext db = new PetanqueContext())
{
var item = new Game {
GameID = gameID
};
db.Entry(item).State = EntityState.Deleted;
try { db.SaveChanges(); }
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Item with id {0} no longer exists in the database.", gameID));
}
}
}
public void usersGrid_DeleteItem(int userId)
{
using (PetanqueContext db = new PetanqueContext())
{
// Change any games that reference this user to reference a dummy user instead
List <Game> refGames = GetGamesByUserReference(userId);
int dummyUserId = GetUserIdByName("[Deleted]");
foreach (Game game in refGames)
{
if (game.Winner1Id == userId)
{
game.Winner1Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Winner2Id == userId)
{
game.Winner2Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Winner3Id == userId)
{
game.Winner3Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Loser1Id == userId)
{
game.Loser1Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Loser2Id == userId)
{
game.Loser2Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
if (game.Loser3Id == userId)
{
game.Loser3Id = dummyUserId; db.Entry(game).State = EntityState.Modified;
}
}
db.SaveChanges();
var item = new User {
UserID = userId
};
db.Entry(item).State = EntityState.Deleted;
try { db.SaveChanges(); }
catch (DbUpdateConcurrencyException)
{
ModelState.AddModelError("",
String.Format("Item with id {0} no longer exists in the database.", userId));
}
}
}