Example #1
0
    public void UpateGameStatus(GameUpdateRequests request)
    {
        string        connectionString = "Server=localhost;Database=TeamWorld;Trusted_Connection=True;";
        SqlConnection conn             = new SqlConnection(connectionString);

        conn.Open();
        string     sqlExpression = $"INSERT INTO User_games VALUES (NEWID(),'{request.UserId}','{request.GameId}')";
        SqlCommand cmd           = new SqlCommand(sqlExpression, conn);

        cmd.ExecuteNonQuery();
        conn.Close();
    }
Example #2
0
 public void UpateGameStatus(GameUpdateRequests request)
 {
     new SQLHelper().UpateGameStatus(request.UserId, request.GameId);
 }