spCustomFormPaymentSetting_AddUpdate

Parameters

Parameter	Parameter Type	Mode
@FormGUID	uniqueidentifier	INOUT
@AllowDirectDebit	bit	IN
@AllowPledge	bit	IN
@Amount	money	IN
@RequireFirstName	bit	IN
@RequireTitle	bit	IN
@RequirePhone	bit	IN
@MerchantAccountID	int	IN
@AllowWaive	bit	IN
@WaiveCode	nvarchar(1000)	IN
@AllowPaymentCollection	bit	IN
@DisplayReCAPTCHA	bit	IN
@PaymentPartPageID	int	IN
@AcknowledgementBlock	nvarchar(max)	IN
Definition

Copy

            CREATE PROCEDURE [dbo].[spCustomFormPaymentSetting_AddUpdate]
            (
                @FormGUID                    uniqueidentifier output,
                @AllowDirectDebit            bit,
                @AllowPledge                bit,
                @Amount                        money,
                @RequireFirstName            bit,
                @RequireTitle                bit,
                @RequirePhone                bit,
                @MerchantAccountID            int,
                @AllowWaive                    bit,
                @WaiveCode                    nvarchar(1000),
                @AllowPaymentCollection        bit,
                @DisplayReCAPTCHA            bit,
                @PaymentPartPageID            int = null,
                @AcknowledgementBlock        nvarchar(max) = null
            )
            as

            set nocount on
            begin transaction

                UPDATE dbo.CustomFormPaymentSetting
                SET
                    FormGUID = @FormGUID,
                    AllowDirectDebit = @AllowDirectDebit,
                    AllowPledge = @AllowPledge,
                    Amount = @Amount,
                    RequireFirstName = @RequireFirstName,
                    RequireTitle = @RequireTitle,
                    RequirePhone = @RequirePhone,
                    MerchantAccountID = @MerchantAccountID,
                    AllowWaive = @AllowWaive,
                    WaiveCode = @WaiveCode,
                    AllowPaymentCollection = @AllowPaymentCollection,
                    DisplayReCAPTCHA = @DisplayReCAPTCHA,
                    PaymentPartPageID = @PaymentPartPageID,
                    AcknowledgementBlock = @AcknowledgementBlock
                WHERE FormGUID = @FormGUID

                IF @@ROWCOUNT = 0 
                BEGIN
                    INSERT INTO dbo.CustomFormPaymentSetting
                    (
                        FormGUID,
                        AllowDirectDebit,
                        AllowPledge,
                        Amount,
                        RequireFirstName,
                        RequireTitle,
                        RequirePhone,
                        MerchantAccountID,
                        AllowWaive,
                        WaiveCode,
                        AllowPaymentCollection,
                        DisplayReCAPTCHA,
                        PaymentPartPageID,
                        AcknowledgementBlock
                    )
                    values
                    (
                        @FormGUID,
                        @AllowDirectDebit,
                        @AllowPledge,
                        @Amount,
                        @RequireFirstName,
                        @RequireTitle,
                        @RequirePhone,
                        @MerchantAccountID,
                        @AllowWaive,
                        @WaiveCode,
                        @AllowPaymentCollection,
                        @DisplayReCAPTCHA,
                        @PaymentPartPageID,
                        @AcknowledgementBlock
                    )
                END

            commit transaction