Solved

PayPal api, database inserts/updated and atomicity

Posted on 2013-01-05

1 solution

466 Views

Last Modified: 2016-03-24

I am designing a subscription-based website and am using the PayflowNETAPI API for PayPal, c#(dot.net). Here is my issue, there are several times when I have to perform database inserts and updates after I create or update a recurring billing profile. I know that I can run database inserts and updates within a transaction scope and rollbacks will be performed provided TransactionScope.Complete is never reached. The problem is how do I rollback the PayPal transaction so everything either completes or fails including the PayPal transaction? I am using the service layer and repository patterns. Any help would be greatly appreciated.

Comment

Question by:rawcoder

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

1 Comment

LVL 18

Accepted Solution

by:Gary Davis

Gary Davis earned 500 total points

ID: 387491432013-01-06

The PayPal transaction is not part of your database transaction so will not be automatically rolled back. If a rollback occurs, you will have to do a reverse transaction to PayPal like voiding an auth, refunding a capture, etc.

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

5 Lessons Enterprise Solutions Can Learn From Consumer Applications

Article by: Highfive

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…

Creating Art with Digital Media Forms: Where to Begin

Article by: Faith

All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.

Downloading and Installing SARDU on Windows 8

Video by: Thomas

The viewer will learn how to successfully download and install the SARDU utility on Windows 8, without downloading adware.

How to turn on large system cache

Video by: Justin

This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…