USP_DATAFORMTEMPLATE_ADD_SHOPPINGCARTSETTINGS

The save procedure used by the add dataform template "ShoppingCartSettings Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@MERCHANTACCOUNTID	uniqueidentifier	IN
@CONFIRMATIONBLOCK	nvarchar(max)	IN
@EMAILTEMPLATEID	int	IN
@ALLOWPLEDGE	bit	IN
@ALLOWDIRECTDEBIT	bit	IN
@ALLOWCREDITCARD	bit	IN
@DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES	int	IN
@REQUIREFIRSTNAME	bit	IN
@REQUIRETITLE	bit	IN
@REQUIREPHONE	bit	IN
@ALLOWINLINEREGISTRATION	bit	IN
@BBPAYTEMPLATEID	uniqueidentifier	IN
@REGISTERFORDONATION	bit	IN
@REGISTERFOREVENTREGISTRATION	bit	IN
@REGISTERFORMEMBERSHIP	bit	IN
@REGISTERFORSPONSORSHIP	bit	IN
@REGISTRATIONPAGEID	int	IN
@ENABLEFINDERNUMBER	bit	IN
@FINDERNUMBERIMAGEID	int	IN
@FINDERNUMBERHELPTEXT	nvarchar(250)	IN
@REQUIREMIDDLENAME	bit	IN
@INCLUDEMIDDLENAME	bit	IN
@REQUIRECONFIRMEMAIL	bit	IN
@INCLUDECONFIRMEMAIL	bit	IN
@REQUIRERECAPTCHA	bit	IN
@CONSENTPARTID	int	IN
@CONSENTPARTLAYOUTOPTION	bit	IN
@CHECKOUTTHEMEUSESITEDEFAULT	bit	IN
@CHECKOUTTHEMEPRIMARYCOLOR	nvarchar(100)	IN
@CHECKOUTTHEMESECONDARYCOLOR	nvarchar(100)	IN
@CHECKOUTTHEMEFONTTYPE	nvarchar(100)	IN
@CHECKOUTWALLETALLCHECKED	bit	IN
@CHECKOUTWALLETAPPLEPAY	bit	IN
@CHECKOUTWALLETUSEVISA	bit	IN
@CHECKOUTWALLETMASTERPASS	bit	IN
@CHECKOUTMERCHANTSONLY	bit	IN

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SHOPPINGCARTSETTINGS
                    (
                        @ID uniqueidentifier output,
                        @MERCHANTACCOUNTID uniqueidentifier = null,
                        @CONFIRMATIONBLOCK nvarchar(max) = null,
                        @EMAILTEMPLATEID int = null,
                        @ALLOWPLEDGE bit = null,
                        @ALLOWDIRECTDEBIT bit = null,
                        @ALLOWCREDITCARD bit = null,            
                        @DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES int = null,
                        @REQUIREFIRSTNAME bit = null,
                        @REQUIRETITLE bit = null,
                        @REQUIREPHONE bit = null,
                        @ALLOWINLINEREGISTRATION bit = null,
                        @BBPAYTEMPLATEID uniqueidentifier = null,
            @REGISTERFORDONATION bit = 0,
            @REGISTERFOREVENTREGISTRATION bit = 0,
            @REGISTERFORMEMBERSHIP bit = 0,
            @REGISTERFORSPONSORSHIP bit = 0,
            @REGISTRATIONPAGEID int = 0,
            @ENABLEFINDERNUMBER bit = 0,
            @FINDERNUMBERIMAGEID int = 0,
            @FINDERNUMBERHELPTEXT nvarchar(250) = null,
            @REQUIREMIDDLENAME bit = null,
            @INCLUDEMIDDLENAME bit = null,
            @REQUIRECONFIRMEMAIL bit = null,
            @INCLUDECONFIRMEMAIL bit = null,
            @REQUIRERECAPTCHA bit = null,
            @CONSENTPARTID int = 0,
            @CONSENTPARTLAYOUTOPTION bit = 0,
            @CHECKOUTTHEMEUSESITEDEFAULT bit = 0,
            @CHECKOUTTHEMEPRIMARYCOLOR nvarchar(100) = null,
            @CHECKOUTTHEMESECONDARYCOLOR nvarchar(100) = null,
            @CHECKOUTTHEMEFONTTYPE nvarchar(100) = null,
            @CHECKOUTWALLETALLCHECKED bit = 0,
            @CHECKOUTWALLETAPPLEPAY bit = 0,
            @CHECKOUTWALLETUSEVISA bit = 0,
            @CHECKOUTWALLETMASTERPASS bit = 0,
                        @CHECKOUTMERCHANTSONLY bit=0
                    )
                    as
                    set nocount on

                    declare @CHANGEAGENTID uniqueidentifier
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    begin try                        
                          insert into dbo.SHOPPINGCARTSETTINGS
                          (
                              ID,
                                MERCHANTACCOUNTID,
                                ADDEDBYID,
                                CHANGEDBYID,
                                DATEADDED,
                                DATECHANGED,
                                CONFIRMATIONBLOCK,
                                EMAILTEMPLATEID,
                                ALLOWPLEDGE,
                                ALLOWDIRECTDEBIT,
                                ALLOWCREDITCARD,
                                DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES,
                                REQUIREFIRSTNAME,
                                REQUIRETITLE,
                                REQUIREPHONE,
                                ALLOWINLINEREGISTRATION,
                                BBPAYTEMPLATEID,
                REGISTERFORDONATION,
                REGISTERFOREVENTREGISTRATION,
                REGISTERFORMEMBERSHIP,
                REGISTERFORSPONSORSHIP,
                REGISTRATIONPAGEID,
                ENABLEFINDERNUMBER,
                FINDERNUMBERIMAGEID,
                FINDERNUMBERHELPTEXT,
                REQUIREMIDDLENAME,
                INCLUDEMIDDLENAME,
                REQUIRECONFIRMEMAIL,
                INCLUDECONFIRMEMAIL,
                REQUIRERECAPTCHA,
                ConsentPartId,
                ConsentPartLayoutOption,
                CHECKOUTTHEMEUSESITEDEFAULT,
                CHECKOUTTHEMEPRIMARYCOLOR,
                CHECKOUTTHEMESECONDARYCOLOR,
                CHECKOUTTHEMEFONTTYPE,
                CHECKOUTWALLETALLCHECKED,
                CHECKOUTWALLETAPPLEPAY,
                CHECKOUTWALLETUSEVISA,
                CHECKOUTWALLETMASTERPASS,
                                CHECKOUTMERCHANTSONLY
                          )
                          values(
                              @ID,
                                @MERCHANTACCOUNTID,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE,
                                @CONFIRMATIONBLOCK,
                                @EMAILTEMPLATEID,
                                @ALLOWPLEDGE,
                                @ALLOWDIRECTDEBIT,
                                @ALLOWCREDITCARD,                
                                @DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES,
                                @REQUIREFIRSTNAME,
                                @REQUIRETITLE,
                                @REQUIREPHONE,
                                @ALLOWINLINEREGISTRATION,
                                @BBPAYTEMPLATEID,
                @REGISTERFORDONATION,
                @REGISTERFOREVENTREGISTRATION,
                @REGISTERFORMEMBERSHIP,
                @REGISTERFORSPONSORSHIP,
                coalesce(@REGISTRATIONPAGEID, 0),
                @ENABLEFINDERNUMBER,
                @FINDERNUMBERIMAGEID,
                @FINDERNUMBERHELPTEXT,
                @REQUIREMIDDLENAME,
                @INCLUDEMIDDLENAME,
                @REQUIRECONFIRMEMAIL,
                @INCLUDECONFIRMEMAIL,
                @REQUIRERECAPTCHA,
                @ConsentPartId,
                @ConsentPartLayoutOption,
                @CHECKOUTTHEMEUSESITEDEFAULT,
                @CHECKOUTTHEMEPRIMARYCOLOR,
                @CHECKOUTTHEMESECONDARYCOLOR,
                @CHECKOUTTHEMEFONTTYPE,
                @CHECKOUTWALLETALLCHECKED,
                @CHECKOUTWALLETAPPLEPAY,
                @CHECKOUTWALLETUSEVISA,
                @CHECKOUTWALLETMASTERPASS,
                                @CHECKOUTMERCHANTSONLY
                          );
                     end try
                     begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                     end catch

                     return 0