USP_SHOPPINGCARTSETTINGS_SAVE_9

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@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_SHOPPINGCARTSETTINGS_SAVE_9
        (
                @ID uniqueidentifier,
                @MERCHANTACCOUNTID uniqueidentifier,
                @CONFIRMATIONBLOCK nvarchar(max),
                @EMAILTEMPLATEID int,
                @ALLOWPLEDGE bit,
                @ALLOWDIRECTDEBIT bit,
          @ALLOWCREDITCARD bit,          
          @DAYSUNTILANONYMOUSUSERCOOKIEEXPIRES int,
          @REQUIREFIRSTNAME bit,
          @REQUIRETITLE bit,
          @REQUIREPHONE bit,
              @ALLOWINLINEREGISTRATION bit,
              @BBPAYTEMPLATEID uniqueidentifier,
          @REGISTERFORDONATION bit,
          @REGISTERFOREVENTREGISTRATION bit,
          @REGISTERFORMEMBERSHIP bit,
          @REGISTERFORSPONSORSHIP bit,
          @REGISTRATIONPAGEID int,
          @ENABLEFINDERNUMBER bit,
          @FINDERNUMBERIMAGEID int,
          @FINDERNUMBERHELPTEXT nvarchar(250),
          @REQUIREMIDDLENAME bit,
          @INCLUDEMIDDLENAME bit,
          @REQUIRECONFIRMEMAIL bit,
          @INCLUDECONFIRMEMAIL bit,
          @REQUIRERECAPTCHA bit,
          @CONSENTPARTID int,
          @CONSENTPARTLAYOUTOPTION bit,
          @CHECKOUTTHEMEUSESITEDEFAULT bit,
          @CHECKOUTTHEMEPRIMARYCOLOR nvarchar(100),
          @CHECKOUTTHEMESECONDARYCOLOR nvarchar(100),
          @CHECKOUTTHEMEFONTTYPE nvarchar(100),
          @CHECKOUTWALLETALLCHECKED bit,
          @CHECKOUTWALLETAPPLEPAY bit,
          @CHECKOUTWALLETUSEVISA bit,
          @CHECKOUTWALLETMASTERPASS bit,
                    @CHECKOUTMERCHANTSONLY bit
        )
        as
        set nocount on

        declare @CHANGEAGENTID uniqueidentifier
              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

        declare @CURRENTDATE datetime
        set @CURRENTDATE = getdate()

            begin try
            update dbo.SHOPPINGCARTSETTINGS 
            set
                      CHANGEDBYID = @CHANGEAGENTID,
                      DATECHANGED = @CURRENTDATE,
                      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 = coalesce(@REGISTRATIONPAGEID, 0),
              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
            where ID = @ID
             end try
             begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
             end catch