USP_SHOPPINGCARTSETTINGS_LOAD

The load procedure used by the edit dataform template "Shopping Cart Settings"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@MERCHANTACCOUNTID	uniqueidentifier	INOUT
@CONFIRMATIONBLOCK	nvarchar(max)	INOUT
@EMAILTEMPLATEID	int	INOUT
@ALLOWPLEDGE	bit	INOUT
@ALLOWDIRECTDEBIT	bit	INOUT
@ALLOWCREDITCARD	bit	INOUT
@DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES	int	INOUT
@REQUIREFIRSTNAME	bit	INOUT
@REQUIRETITLE	bit	INOUT
@REQUIREPHONE	bit	INOUT
@ALLOWINLINEREGISTRATION	bit	INOUT
@BBPAYTEMPLATEID	uniqueidentifier	INOUT
@REGISTERFORDONATION	bit	INOUT
@REGISTERFOREVENTREGISTRATION	bit	INOUT
@REGISTERFORMEMBERSHIP	bit	INOUT
@REGISTERFORSPONSORSHIP	bit	INOUT
@REGISTRATIONPAGEID	int	INOUT
@ENABLEFINDERNUMBER	bit	INOUT
@FINDERNUMBERIMAGEID	int	INOUT
@FINDERNUMBERHELPTEXT	nvarchar(250)	INOUT
@REQUIREMIDDLENAME	bit	INOUT
@INCLUDEMIDDLENAME	bit	INOUT
@REQUIRECONFIRMEMAIL	bit	INOUT
@INCLUDECONFIRMEMAIL	bit	INOUT
@REQUIRERECAPTCHA	bit	INOUT
@CONSENTPARTID	int	INOUT
@CONSENTPARTLAYOUTOPTION	bit	INOUT
@CHECKOUTTHEMEUSESITEDEFAULT	bit	INOUT
@CHECKOUTTHEMEPRIMARYCOLOR	nvarchar(100)	INOUT
@CHECKOUTTHEMESECONDARYCOLOR	nvarchar(100)	INOUT
@CHECKOUTTHEMEFONTTYPE	nvarchar(100)	INOUT
@CHECKOUTWALLETALLCHECKED	bit	INOUT
@CHECKOUTWALLETAPPLEPAY	bit	INOUT
@CHECKOUTWALLETUSEVISA	bit	INOUT
@CHECKOUTWALLETMASTERPASS	bit	INOUT
@CHECKOUTMERCHANTSONLY	bit	INOUT

Definition

Copy



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

          select 
            @DATALOADED = 1,
                  @ID = ID,
                  @MERCHANTACCOUNTID = MERCHANTACCOUNTID,
                  @CONFIRMATIONBLOCK = CONFIRMATIONBLOCK,
                  @EMAILTEMPLATEID = EMAILTEMPLATEID,
                  @ALLOWPLEDGE = ALLOWPLEDGE,
                  @ALLOWDIRECTDEBIT = ALLOWDIRECTDEBIT,
            @ALLOWCREDITCARD = ALLOWCREDITCARD,            
            @DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES = DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES,
            @REQUIREFIRSTNAME = REQUIREFIRSTNAME,
            @REQUIRETITLE = REQUIRETITLE,
            @REQUIREPHONE = REQUIREPHONE,
                  @ALLOWINLINEREGISTRATION = ALLOWINLINEREGISTRATION,
                  @BBPAYTEMPLATEID = BBPAYTEMPLATEID,
            @REGISTERFORDONATION = REGISTERFORDONATION,
            @REGISTERFOREVENTREGISTRATION = REGISTERFOREVENTREGISTRATION,
            @REGISTERFORMEMBERSHIP = REGISTERFORMEMBERSHIP,
            @REGISTERFORSPONSORSHIP = REGISTERFORSPONSORSHIP,
            @REGISTRATIONPAGEID = REGISTRATIONPAGEID,
            @ENABLEFINDERNUMBER = ENABLEFINDERNUMBER,
            @FINDERNUMBERIMAGEID = FINDERNUMBERIMAGEID,
            @FINDERNUMBERHELPTEXT = FINDERNUMBERHELPTEXT,
            @REQUIREMIDDLENAME = REQUIREMIDDLENAME,
            @INCLUDEMIDDLENAME = INCLUDEMIDDLENAME,
            @REQUIRECONFIRMEMAIL = REQUIRECONFIRMEMAIL,
            @INCLUDECONFIRMEMAIL = INCLUDECONFIRMEMAIL,
            @REQUIRERECAPTCHA = REQUIRERECAPTCHA,
            @CONSENTPARTID=CONSENTPARTID,
            @CONSENTPARTLAYOUTOPTION=CONSENTPARTLAYOUTOPTION,
            @CHECKOUTTHEMEUSESITEDEFAULT=CHECKOUTTHEMEUSESITEDEFAULT,
            @CHECKOUTTHEMEPRIMARYCOLOR=CHECKOUTTHEMEPRIMARYCOLOR,
            @CHECKOUTTHEMESECONDARYCOLOR=CHECKOUTTHEMESECONDARYCOLOR,
            @CHECKOUTTHEMEFONTTYPE=CHECKOUTTHEMEFONTTYPE,
            @CHECKOUTWALLETALLCHECKED=CHECKOUTWALLETALLCHECKED,
            @CHECKOUTWALLETAPPLEPAY=CHECKOUTWALLETAPPLEPAY,
            @CHECKOUTWALLETUSEVISA=CHECKOUTWALLETUSEVISA,
            @CHECKOUTWALLETMASTERPASS=CHECKOUTWALLETMASTERPASS,
                        @CHECKOUTMERCHANTSONLY=CHECKOUTMERCHANTSONLY
          from 
            dbo.SHOPPINGCARTSETTINGS
          where
            ID = @ID

              return 0;