public async Task <IActionResult> DeleteQPlayer([FromRoute] string playername) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tblplayersv2 player = await _context.Tblplayersv2.SingleOrDefaultAsync(p => p.Playername == playername); Tblboardsquaresv2 boardsquare = await _context.Tblboardsquaresv2.SingleOrDefaultAsync(bs => bs.Playerid == player.Id); if (player == null) { return(NotFound()); } boardsquare.Playerid = null; boardsquare.Player = null; _context.Tblplayersv2.Remove(player); await _context.SaveChangesAsync(); return(Ok(player)); }
public async Task <IActionResult> PutTblplayersv2([FromRoute] int id, [FromBody] Tblplayersv2 tblplayersv2) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblplayersv2.Id) { return(BadRequest()); } _context.Entry(tblplayersv2).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Tblplayersv2Exists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PostTblplayersv2([FromBody] Tblplayersv2 tblplayersv2) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Tblplayersv2.Add(tblplayersv2); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblplayersv2", new { id = tblplayersv2.Id }, tblplayersv2)); }
public async Task <IActionResult> PutQBoardSquare([FromRoute] int col, [FromRoute] int row, [FromBody] QBoardSquare qboardsquare) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tblboardsquaresv2 boardsquare = await _context.Tblboardsquaresv2.SingleOrDefaultAsync(bs => (bs.Colposition == col) && (bs.Rowposition == row)); Tblplayersv2 player = await _context.Tblplayersv2.SingleOrDefaultAsync(p => p.Id == boardsquare.Playerid); if (boardsquare != null) { boardsquare.Northwall = qboardsquare.Northwall; boardsquare.Southwall = qboardsquare.Southwall; boardsquare.Westwall = qboardsquare.Westwall; boardsquare.Eastwall = qboardsquare.Eastwall; boardsquare.Colposition = col; boardsquare.Rowposition = row; if (player != null) { boardsquare.Playerid = player.Id; } else { boardsquare.Playerid = null; } } else { return(NotFound()); } try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Tblboardsquaresv2Exists(boardsquare.Id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PutQPlayer([FromRoute] string playername, [FromBody] QPlayer qplayer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tblplayersv2 player = await _context.Tblplayersv2.SingleOrDefaultAsync(p => p.Playername == playername); Tblboardsquaresv2 boardsquare = await _context.Tblboardsquaresv2.SingleOrDefaultAsync(bs => bs.Playerid == player.Id); if (player != null) { player.Playername = qplayer.Playername; player.Facingdirection = qplayer.Facingdirection; /* Has Player Moved ?*/ if ((boardsquare.Colposition == qplayer.Colposition) && (boardsquare.Rowposition == qplayer.Rowposition)) { /* Player has NOT moved */ } else { boardsquare.Playerid = null; boardsquare.Player = null; Tblboardsquaresv2 newboardsquare = await _context.Tblboardsquaresv2.SingleOrDefaultAsync((bs => (bs.Colposition == qplayer.Colposition) && (bs.Rowposition == qplayer.Rowposition))); newboardsquare.Player = player; } try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Tblplayersv2Exists(player.Id)) { return(NotFound()); } else { throw; } } } return(NoContent()); }
public async Task <IActionResult> PostQBoardSquare([FromBody] QBoardSquare qboardsquare) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tblboardsquaresv2 boardsquare = new Tblboardsquaresv2 { Northwall = qboardsquare.Northwall, Southwall = qboardsquare.Southwall, Westwall = qboardsquare.Westwall, Eastwall = qboardsquare.Eastwall }; Tblplayersv2 player = await _context.Tblplayersv2.SingleOrDefaultAsync(p => (p.Id == boardsquare.Playerid)); _context.Tblboardsquaresv2.Add(boardsquare); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblboardsquaresv2", new { id = boardsquare.Id }, boardsquare)); }
public async Task <IActionResult> PostQPlayer([FromBody] QPlayer qplayer) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Tblplayersv2 player = new Tblplayersv2 { Playername = qplayer.Playername, Facingdirection = qplayer.Facingdirection }; Tblboardsquaresv2 boardsquare = await _context.Tblboardsquaresv2.SingleOrDefaultAsync((bs => (bs.Colposition == qplayer.Colposition) && (bs.Rowposition == qplayer.Rowposition))); boardsquare.Player = player; _context.Tblplayersv2.Add(player); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblplayersv2", new { id = player.Id }, player)); }