gistfile1.cs

[WebMethod(true)]
public void EndGroundTransportationTrip(int tripId)
{
    var commandText = @"GT_EndTrip";

    using (TransactionScope scope = new TransactionScope())
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            connection.Open();

            using (SqlCommand command = new SqlCommand(commandText, connection))
            {
                command.CommandType = System.Data.CommandType.StoredProcedure;

                command.Parameters.AddWithValue("@TripId", tripId);

                command.ExecuteNonQuery();
            }
        }

        scope.Complete();
    }
}