USP_DATAFORMTEMPLATE_VIEW_BBPAYTRANSACTION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@BBPSUSERID	nvarchar(255)	INOUT
@ISO4217	nvarchar(3)	INOUT
@AMOUNT	money	INOUT
@DESCRIPTION	nvarchar(512)	INOUT
@DONORIP	nvarchar(64)	INOUT
@CLIENTIP	nvarchar(64)	INOUT
@MERCHANTACCOUNTID	uniqueidentifier	INOUT
@APPLICATION	nvarchar(64)	INOUT
@SOURCECODE	tinyint	INOUT
@DESTINATIONURI	nvarchar(256)	INOUT
@CARDTOKEN	uniqueidentifier	INOUT
@TEMPLATE	uniqueidentifier	INOUT
@USECAPTCHA	bit	INOUT
@CARDHOLDER	nvarchar(128)	INOUT
@BILLINGADDRESS	nvarchar(256)	INOUT
@BILLINGCITY	nvarchar(64)	INOUT
@BILLINGSTATE	nvarchar(3)	INOUT
@BILLINGPOSTCODE	nvarchar(20)	INOUT
@BILLINGCOUNTRY	nvarchar(3)	INOUT
@BILLINGPHONE	nvarchar(64)	INOUT
@BILLINGEMAIL	nvarchar(128)	INOUT
@KIOSKMODE	bit	INOUT
@PROXYVERSION	nvarchar(64)	INOUT
@AUTHTOKEN	nvarchar(2048)	INOUT
@DATEADDED	datetime	INOUT
@SHOWCPADDRESS	bit	INOUT
@MOBILEPAYTRANSACTION	bit	INOUT
@SHOULDSENDEMAILRECEIPT	bit	INOUT
@EMAILRECEIPTSUBJECT	nvarchar(100)	INOUT
@SMARTPOSID	nvarchar(20)	INOUT
@COUNTRYISO	nvarchar(2)	INOUT
@TERMINALID	nvarchar(8)	INOUT
@SECURITYCODE	nvarchar(64)	INOUT
@MOBILEPAYSERVICEVERSION	nvarchar(64)	INOUT
@MOBILEPAYAPPVERSION	nvarchar(64)	INOUT
@TERMINALLATITUDE	decimal(9, 6)	INOUT
@TERMINALLONGITUDE	decimal(9, 6)	INOUT
@NOTES	nvarchar(1024)	INOUT

Definition

Copy



                create  procedure [dbo].[USP_DATAFORMTEMPLATE_VIEW_BBPAYTRANSACTION]
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @BBPSUSERID nvarchar(255) = null output,
                    @ISO4217 nvarchar(3) = null output,
                    @AMOUNT money = null output,
                    @DESCRIPTION nvarchar(512) = null output,
                    @DONORIP nvarchar(64) = null output,
                    @CLIENTIP nvarchar(64) = null output,
                    @MERCHANTACCOUNTID uniqueidentifier = null output,
                    @APPLICATION nvarchar(64) = null output,
                    @SOURCECODE tinyint = null output,
                    @DESTINATIONURI nvarchar(256) = null output,
                    @CARDTOKEN uniqueidentifier = null output,
                    @TEMPLATE uniqueidentifier = null output,
                    @USECAPTCHA bit = null output,
                    @CARDHOLDER nvarchar(128) = null output,
                    @BILLINGADDRESS nvarchar(256) = null output,
                    @BILLINGCITY nvarchar(64) = null output,
                    @BILLINGSTATE nvarchar(3) = null output,
                    @BILLINGPOSTCODE nvarchar(20) = null output,
                    @BILLINGCOUNTRY nvarchar(3) = null output,
                    @BILLINGPHONE nvarchar(64) = null output,
                    @BILLINGEMAIL nvarchar(128) = null output,
                    @KIOSKMODE as bit = null output,
                    @PROXYVERSION nvarchar(64) = null output,
                    @AUTHTOKEN nvarchar(2048) = null output,
                    @DATEADDED datetime = null output,
                    @SHOWCPADDRESS as bit = null output,
                    @MOBILEPAYTRANSACTION as bit = null output,
                    @SHOULDSENDEMAILRECEIPT as bit = null output,
                    @EMAILRECEIPTSUBJECT as nvarchar(100) = null output,
                    @SMARTPOSID as nvarchar(20) = null output,
                    @COUNTRYISO as nvarchar(2) = null output,
                    @TERMINALID as nvarchar(8) = null output,
                    @SECURITYCODE as nvarchar(64) = null output,
                    @MOBILEPAYSERVICEVERSION as nvarchar(64) = null output,
                    @MOBILEPAYAPPVERSION as nvarchar(64) = null output,
                    @TERMINALLATITUDE decimal(9,6) = null output,
                    @TERMINALLONGITUDE decimal(9,6) = null output,
                    @NOTES nvarchar(1024) = null output
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    exec dbo.USP_GET_KEY_ACCESS

                    select top 1
                        @DATALOADED = 1,
                        @BBPSUSERID = BBPAYTRANSACTION.BBPSUSERID,
                        @ISO4217 = BBPAYTRANSACTION.ISO4217,
                        @AMOUNT = BBPAYTRANSACTION.AMOUNT,
                        @DESCRIPTION = BBPAYTRANSACTION.DESCRIPTION,
                        @DONORIP = BBPAYTRANSACTION.DONORIP,
                        @CLIENTIP = BBPAYTRANSACTION.CLIENTIP,
                        @MERCHANTACCOUNTID = BBPAYTRANSACTION.MERCHANTACCOUNTID,
                        @APPLICATION = BBPAYTRANSACTION.APPLICATION,
                        @SOURCECODE = BBPAYTRANSACTION.SOURCECODE,
                        @DESTINATIONURI = BBPAYTRANSACTION.DESTINATIONURI,
                        @CARDTOKEN = BBPAYTRANSACTION.CARDTOKEN,
                        @TEMPLATE = BBPAYTRANSACTION.TEMPLATE,
                        @USECAPTCHA = (
                                        CASE
                                            -- Card Not Present, DD

                                            WHEN (BBPAYTRANSACTION.SOURCECODE = 0) or (BBPAYTRANSACTION.SOURCECODE = 9) THEN
                                                (BBPAYTRANSACTION.USECAPTCHA | ISNULL(CLIENTDATA.FORCECAPTCHA, 0))
                                            ELSE
                                                0
                                            END
                                       ),
                        @CARDHOLDER = BBPAYTRANSACTION.CARDHOLDER,
                        @BILLINGADDRESS = BBPAYTRANSACTION.BILLINGADDRESS,
                        @BILLINGCITY = BBPAYTRANSACTION.BILLINGCITY,
                        @BILLINGSTATE = BBPAYTRANSACTION.BILLINGSTATE,
                        @BILLINGPOSTCODE = BBPAYTRANSACTION.BILLINGPOSTCODE,
                        @BILLINGCOUNTRY = BBPAYTRANSACTION.BILLINGCOUNTRY,
                        @BILLINGPHONE = BBPAYTRANSACTION.BILLINGPHONE,
                        @BILLINGEMAIL = BBPAYTRANSACTION.BILLINGEMAIL,
                        @KIOSKMODE = BBPAYTRANSACTION.KIOSKMODE,
                        @PROXYVERSION = BBPAYTRANSACTION.PROXYVERSION,
                        @AUTHTOKEN = cast(DecryptByKey(BBPAYTRANSACTION.AUTHTOKEN) as nvarchar(2048)),
                        @DATEADDED = BBPAYTRANSACTION.DATEADDED,
                        @SHOWCPADDRESS = BBPAYTRANSACTION.SHOWCPADDRESS,
                        @MOBILEPAYTRANSACTION = BBPAYTRANSACTION.MOBILEPAYTRANSACTION,
                        @SHOULDSENDEMAILRECEIPT = BBPAYTRANSACTION.SHOULDSENDEMAILRECEIPT,
                        @EMAILRECEIPTSUBJECT = BBPAYTRANSACTION.EMAILRECEIPTSUBJECT,
                        @SMARTPOSID = BBPAYTRANSACTION.SMARTPOSID,
                        @COUNTRYISO = BBPAYTRANSACTION.COUNTRYISO,
                        @TERMINALID = BBPAYTRANSACTION.TERMINALID,
                        @SECURITYCODE = BBPAYTRANSACTION.SECURITYCODE,
                        @MOBILEPAYSERVICEVERSION = BBPAYTRANSACTION.MOBILEPAYSERVICEVERSION,
                        @MOBILEPAYAPPVERSION = BBPAYTRANSACTION.MOBILEPAYAPPVERSION,
                        @TERMINALLATITUDE = BBPAYTRANSACTION.TERMINALLATITUDE,
                        @TERMINALLONGITUDE = BBPAYTRANSACTION.TERMINALLONGITUDE,
                        @NOTES = BBPAYTRANSACTION.NOTES
                    from
                        dbo.BBPAYTRANSACTION(nolock)
                    left outer join
                        dbo.CONSTITUENT(nolock)
                            on
                                BBPAYTRANSACTION.BBPSUSERID = CONSTITUENT.KEYNAME
                    left outer join
                        dbo.CLIENTDATA(nolock)
                            on
                                CONSTITUENT.ID = CLIENTDATA.ID
                    where
                        BBPAYTRANSACTION.ID = @ID

                    close symmetric key sym_BBInfinity

                    return 0;