spTransactions_FailDonationTransaction
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @Status | int | IN | |
| @FailureData | varchar(max) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spTransactions_FailDonationTransaction]
( @PKID int, @Status int, @FailureData varchar(max)) AS
UPDATE [dbo].[DonationTransactions] SET [FailureData] = @FailureData, [Status] = @Status WHERE [DonationTransactionsID] = @PKID
DELETE FROM [dbo].[Transactions] WHERE TransactionID=@PKID AND TransactionType='{5705B543-4033-4a3a-BBCD-A731403EE1E6}'