public Wishlist GetById(int wishlistId)
{
using (var db = new NesCollectorDBContext())
{
return(db.Wishlists.Single(w => w.Id == wishlistId));
}
}
public AppUser GetById(string userId)
{
using (var db = new NesCollectorDBContext())
{
return(db.Users.Single(u => u.Id == userId));
}
}
public ICollection <AppUser> GetUsersByUserGameId(int userGameId)
{
using (var db = new NesCollectorDBContext())
{
return(db.Users.Where(u => u.UserGames.Any(ug => ug.Id == userGameId)).ToList());
}
}
public Game GetById(int gameId)
{
using (var db = new NesCollectorDBContext())
{
return(db.Games.Single(g => g.Id == gameId));
}
}
public UserGame GetById(int userGameId)
{
using (var db = new NesCollectorDBContext())
{
return(db.UserGames.Single(u => u.Id == userGameId));
}
}
public ICollection <AppUser> GetUsersByWishlistId(int wishlistId)
{
using (var db = new NesCollectorDBContext())
{
return(db.Users.Where(u => u.Wishlists.Any(w => w.Id == wishlistId)).ToList());
}
}
public ICollection <UserGame> GetUserGamesByGameId(int gameId)
{
using (var db = new NesCollectorDBContext())
{
return(db.UserGames
.Where(u => u.GameId == gameId)
.ToList());
}
}
public ICollection <UserGame> GetUserGamesByUserId(string userId)
{
using (var db = new NesCollectorDBContext())
{
return(db.UserGames
.Where(u => u.UserId == userId)
.ToList());
}
}
public ICollection <Wishlist> GetWishlistGamesByUserId(string userId)
{
using (var db = new NesCollectorDBContext())
{
return(db.Wishlists
.Where(w => w.UserId == userId)
.ToList());
}
}
public ICollection <Wishlist> GetWishlistGamesByGameId(int gameId)
{
using (var db = new NesCollectorDBContext())
{
return(db.Wishlists
.Where(w => w.GameId == gameId)
.ToList());
}
}
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 Create(Game newGame)
{
using (var db = new NesCollectorDBContext())
{
db.Games.Add(newGame);
db.SaveChanges();
return(newGame);
}
}
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 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 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 ICollection <Game> GetByGameConsoleId(int gameConsoleId)
{
using (var db = new NesCollectorDBContext())
{
var results = new List <Game>();
foreach (var g in db.Games)
{
if (g.GameConsoleId == gameConsoleId)
{
results.Add(g);
}
}
return(results);
}
}
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);
}
}
