public async System.Threading.Tasks.Task DeletePlayerTestAsync() { DbContextOptions <GamesDbContext> options = new DbContextOptionsBuilder <GamesDbContext>().UseInMemoryDatabase("DeletePlayer").Options; using (GamesDbContext context = new GamesDbContext(options)) { Player newPlayer = new Player() { ID = "1", RoomID = "1", Name = "Farkus", Score = 500, Toad = true }; context.Add(newPlayer); await context.SaveChangesAsync(); Player foundPlayer = await context.Players.FirstOrDefaultAsync(player => player.ID == "1"); foundPlayer.Score = 250; context.Remove(foundPlayer); await context.SaveChangesAsync(); Player deletedPlayer = await context.Players.FirstOrDefaultAsync(player => player.ID == "1"); Assert.True(deletedPlayer == null); } }
public async Task <IHttpActionResult> PostUser([FromBody] User user, [FromUri] int bestScore = 0) { Guid userId; using (var dbContext = new GamesDbContext()) { var currentUser = await dbContext.User.Where(x => x.Email == user.Email).FirstOrDefaultAsync(); if (currentUser == null) { userId = Guid.NewGuid(); user.Id = userId; await dbContext.Add(user); } else { currentUser.Email = user.Email; currentUser.Name = user.Name; userId = currentUser.Id; await dbContext.Edit(currentUser); } if (bestScore > 0) { var currentGameScore = await dbContext.Score.Where(x => x.UserId == userId && x.ScorePoint == bestScore).FirstOrDefaultAsync(); if (currentGameScore == null) { await dbContext.Add(new Score { UserId = userId, GameId = 1, Id = Guid.NewGuid(), ScorePoint = bestScore }); } } await dbContext.SaveChangesAsync(); return(Ok()); } }
public async Task PostUser([FromBody] User user) { using (var dbContext = new GamesDbContext()) { var currentUser = await dbContext.User.Where(x => x.Email == user.Email).FirstOrDefaultAsync(); if (currentUser == null) { user.Id = Guid.NewGuid(); await dbContext.Add(user); } else { currentUser.Email = user.Email; currentUser.Name = user.Name; await dbContext.Edit(currentUser); } await dbContext.SaveChangesAsync(); } }
public IActionResult Post([FromBody] GameDto value) { if (!ModelState.IsValid) { return(BadRequest()); } try { var game = new Game { Console = value.Console, Name = value.Name, Type = value.Type }; _context.Add(game); _context.SaveChanges(); return(Ok()); } catch (DbException e) { return(BadRequest()); } }
public void CreateCredential(Credential credential) { _context.Add(credential); }