public void DeleteGame(Game game)
{
using (var ctx = new ABStoreContext())
{
ctx.Games.Remove(game);
ctx.SaveChanges();
}
}
public void CreateGame(Game game)
{
using (var ctx = new ABStoreContext())
{
ctx.Games.Add(game);
ctx.SaveChanges();
}
}
public void RegisterUser(User user)
{
using (var ctx = new ABStoreContext())
{
ctx.Users.Add(user);
ctx.Entry(user).State = EntityState.Added;
ctx.SaveChanges();
}
}
public void UpdateGame(Game game)
{
using (var ctx = new ABStoreContext())
{
ctx.Games.Attach(game);
ctx.Entry(game).State = EntityState.Modified;
ctx.SaveChanges();
}
}
public void DeleteUser(int userId)
{
using (var ctx = new ABStoreContext())
{
User usr = ctx.Users.Include(x => x.UserLibrary).First(x => x.Id == userId);
ctx.Users.Remove(usr);
ctx.SaveChanges();
}
}
public void UpdateUser(User user)
{
using (var ctx = new ABStoreContext())
{
ctx.Users.Attach(user);
ctx.Entry(user).State = EntityState.Modified;
foreach (var libItem in user.UserLibrary)
{
if (libItem.Id == 0)
{
ctx.Entry(libItem).State = EntityState.Added;
}
}
ctx.SaveChanges();
}
}