public async Task <bool> BuyAsync(Purchases purchases)
{
if (purchases == null)
{
throw new ArgumentNullException();
}
await using var db = new GameCatalogContext();
await db.Purchaseses.AddAsync(purchases);
await db.SaveChangesAsync();
return(true);
}
public async Task <bool> UpdateGameAsync(Game game)
{
if (game == null)
{
throw new ArgumentNullException();
}
await using var db = new GameCatalogContext();
db.Games.Update(game);
await db.SaveChangesAsync();
return(true);
}
public async Task <bool> UpdateUserAsync(User user)
{
if (user == null)
{
throw new ArgumentNullException();
}
await using var db = new GameCatalogContext();
db.Users.Update(user);
await db.SaveChangesAsync();
return(true);
}
public async Task <bool> RemoveGameAsync(int id)
{
await using var db = new GameCatalogContext();
var needGame = db.Games.FirstOrDefault(game => game.Id == id);
if (needGame == null)
{
return(false);
}
db.Games.Remove(needGame);
await db.SaveChangesAsync();
return(true);
}
public async Task <bool> AddCommentAsync(Comment comment)
{
if (comment == null)
{
throw new ArgumentNullException();
}
await using var db = new GameCatalogContext();
await db.Comments.AddAsync(comment);
await db.SaveChangesAsync();
return(true);
}
public async Task <bool> RemoveCommentAsync(int id)
{
await using var db = new GameCatalogContext();
var needComment = db.Comments.FirstOrDefault(comment => comment.Id == id);
if (needComment == null)
{
return(false);
}
db.Comments.Remove(needComment);
db.Games.FirstOrDefault(game => game.Id == needComment.GameId)?.Comments.Remove(needComment);
db.Users.FirstOrDefault(user => user.Id == needComment.UserId)?.Comments.Remove(needComment);
await db.SaveChangesAsync();
return(true);
}
public async Task <IEnumerable <User> > GetAllUsersAsync()
{
await using var db = new GameCatalogContext();
return(await db.Users.AsNoTracking().ToListAsync());
}
public async Task <IEnumerable <Game> > GetAllGamesAsync()
{
await using var db = new GameCatalogContext();
return(await db.Games.Include(game => game.Comments).AsNoTracking().ToListAsync());
}
