public Game Create(Game newGame)
{
using (var db = new NesCollectorDBContext())
{
db.Games.Add(newGame);
db.SaveChanges();
return(newGame);
}
}
public AppUser Create(AppUser newUser)
{
using (var db = new NesCollectorDBContext())
{
db.Users.Add(newUser);
db.SaveChanges();
return(newUser);
}
}
public Wishlist Create(Wishlist newWishlist)
{
using (var db = new NesCollectorDBContext())
{
db.Wishlists.Add(newWishlist);
db.SaveChanges();
return(newWishlist);
}
}
public Game Update(Game updatedGame)
{
using (var db = new NesCollectorDBContext())
{
var existingGame = GetById(updatedGame.Id);
db.Entry(existingGame).CurrentValues.SetValues(updatedGame);
db.SaveChanges();
return(existingGame);
}
}
public AppUser Update(AppUser updatedUser)
{
using (var db = new NesCollectorDBContext())
{
var existingUser = GetById(updatedUser.Id);
db.Entry(existingUser).CurrentValues.SetValues(updatedUser);
db.SaveChanges();
return(existingUser);
}
}
public Wishlist Update(Wishlist updatedWishlist)
{
using (var db = new NesCollectorDBContext())
{
var existingWishlist = GetById(updatedWishlist.Id);
db.Entry(existingWishlist).CurrentValues.SetValues(updatedWishlist);
db.SaveChanges();
return(existingWishlist);
}
}
public bool DeleteById(int gameId)
{
using (var db = new NesCollectorDBContext())
{
var gameToDelete = GetById(gameId);
db.Remove(gameToDelete);
db.SaveChanges();
if (GetById(gameId) == null)
{
return(true);
}
return(false);
}
}
public bool DeleteById(string userId)
{
using (var db = new NesCollectorDBContext())
{
var userToDelete = GetById(userId);
db.Remove(userToDelete);
db.SaveChanges();
if (GetById(userId) == null)
{
return(true);
}
return(false);
}
}