C# (CSharp) Game.Game.SetId Examples

Example #1

File: DBService.cs Project: drgreenland/OneHundredAndEighty

        public void GameSaveNew(Game.Game game, List <Player> players)
        {
            var newGameQuery = $"INSERT INTO [{Table.Games}] ({Column.StartTimestamp},{Column.EndTimestamp},{Column.Type})" +
                               $" VALUES ('{game.StartTimeStamp}','','{(int) game.Type}')";

            ExecuteNonQueryInternal(newGameQuery);

            var newGameId = Convert.ToInt32(ExecuteScalarInternal($"SELECT MAX({Column.Id}) FROM [{Table.Games}]"));

            game.SetId(newGameId);

            StatisticSaveNew(newGameId, players);
        }