예제 #1
0
파일: ValueController.cs 프로젝트: Leerd/TW
    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();
    }
예제 #2
0
 public void UpateGameStatus(GameUpdateRequests request)
 {
     new SQLHelper().UpateGameStatus(request.UserId, request.GameId);
 }