public ActionResult Create(DTOGame currentGame) { if (ModelState.IsValid) { db.Games.Add(currentGame.GameRound); db.SaveChanges(); db.Database.ExecuteSqlCommand( "DECLARE @publicIDdb nvarchar(5)" + " DECLARE @publicIDrand nvarchar(5)" + " SET @publicIDrand = ROUND(((9999 - 1000 + 1) * RAND() + 1000), 0)" + " WHILE EXISTS (SELECT PublicId FROM dbo.Games WHERE PublicId = @publicIDrand)" + " BEGIN" + " SET @publicIDrand = ROUND(((9999 - 1000 + 1) * RAND() + 1000), 0)" + " END" + " UPDATE Games SET PublicId = @publicIDrand WHERE ID =" + currentGame.GameRound.ID ); currentGame.CurrentPlayer.Game_Id = currentGame.GameRound.ID; db.Players.Add(currentGame.CurrentPlayer); db.SaveChanges(); } return(View()); }
public void UpdateGame(DTOGame game) { var parameters = new List <SqlParameter>(); parameters.Add(CreateSqlParameter("@GameID", System.Data.SqlDbType.Int, game.ID)); parameters.Add(CreateSqlParameter("@GameDate", System.Data.SqlDbType.DateTime, game.GameDate)); parameters.Add(CreateSqlParameter("@Team1ID", System.Data.SqlDbType.Int, game.Team1ID)); parameters.Add(CreateSqlParameter("@Team2ID", System.Data.SqlDbType.Int, game.Team2ID)); SQLExecuteCommandParam("UpdateGame", parameters); }
public static Game ConvertType(DTOGame o) { return(new Game() { GameDate = o.GameDate, Team1ID = o.Team1ID, Team2ID = o.Team2ID, ID = o.ID, SportID = o.SportID, LeagueID = o.LeagueID }); }
public ActionResult Create(DTOGame currentGame) { if (ModelState.IsValid) { db.Games.Add(currentGame.GameRound); db.SaveChanges(); currentGame.CurrentPlayer.Game_Id = currentGame.GameRound.ID; db.Players.Add(currentGame.CurrentPlayer); db.SaveChanges(); //string publicId = currentGame.GameRound.PublicId; DTOGameSession session = new DTOGameSession(currentGame); return(View("~/Views/GameSession/index.cshtml", session)); } else { return(new HttpStatusCodeResult(404)); } }
public async Task <IActionResult> GetGame([FromRoute] int id) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var game = await _context.Games.Include(g => g.Categories) .FirstOrDefaultAsync(m => m.Id == id); DTOGame dTOGame = new DTOGame() { Titulo = game.Titulo, Price = game.Precio, CategoriesString = game.Categories.Name }; if (game == null) { return(NotFound()); } return(Ok(dTOGame)); }