USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_4

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHILDDISPLAYHTML	nvarchar(max)	IN
@PROJECTDISPLAYHTML	nvarchar(max)	IN
@ATTRIBUTEITEMSLIST	xml	IN
@DESIGNATIONLIST	xml	IN
@DEFAULTDESIGNATIONID	uniqueidentifier	IN
@DEFAULTDESIGNATION	int	IN
@APPEALSLIST	xml	IN
@REQUIREAPPEAL	bit	IN
@SOLESPONSORSHIPENABLED	bit	IN
@GIFTSPONSORSHIPENABLED	bit	IN
@ECARDSENABLED	bit	IN
@ADDITIONALGIFTENABLED	bit	IN
@MULTIPLEGIFTSENABLED	bit	IN
@MINIMUMGIFTAMOUNT	decimal(20, 4)	IN
@CONSTITUENCYID	uniqueidentifier	IN
@GENERALRECURRENCEENABLED	bit	IN
@SCHEDULEDENDDATEENABLED	bit	IN
@RECURRENCEDATAIDLIST	xml	IN
@ITEMEXPIRATION	int	IN
@PAYMENTPARTPAGE	int	IN
@DIRECTDEBITENABLED	bit	IN
@CHECKENABLED	bit	IN
@FORMITEMEXPIRATION	int	IN
@ACKNOWLEDGEMENTHTML	nvarchar(max)	IN
@FORCESTARTDATE	bit	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@SUPPORTSCHECKOUTONLY	bit	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_4
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @CHILDDISPLAYHTML nvarchar(max),
  @PROJECTDISPLAYHTML nvarchar(max),
  @ATTRIBUTEITEMSLIST xml,
  @DESIGNATIONLIST xml,
  @DEFAULTDESIGNATIONID uniqueidentifier,
  @DEFAULTDESIGNATION int,
  @APPEALSLIST xml,
  @REQUIREAPPEAL bit,
  @SOLESPONSORSHIPENABLED bit,
  @GIFTSPONSORSHIPENABLED bit,
  @ECARDSENABLED bit,
  @ADDITIONALGIFTENABLED bit,
  @MULTIPLEGIFTSENABLED bit,
  @MINIMUMGIFTAMOUNT decimal(20,4),
  @CONSTITUENCYID uniqueidentifier,
  @GENERALRECURRENCEENABLED bit,
  @SCHEDULEDENDDATEENABLED bit,
  @RECURRENCEDATAIDLIST xml,
  @ITEMEXPIRATION int,
  @PAYMENTPARTPAGE int,
  @DIRECTDEBITENABLED bit,
  @CHECKENABLED bit,
  @FORMITEMEXPIRATION int,
  @ACKNOWLEDGEMENTHTML nvarchar(max),
  @FORCESTARTDATE bit,
  @PDACCOUNTSYSTEMID uniqueidentifier,
    @SUPPORTSCHECKOUTONLY bit
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    begin try
        -- handle updating the data

        update dbo.SPONSORSHIPFORMCMSSETTINGS set
            CHILDDISPLAYHTML = @CHILDDISPLAYHTML,
            PROJECTDISPLAYHTML = @PROJECTDISPLAYHTML,
            ATTRIBUTEITEMSLIST = @ATTRIBUTEITEMSLIST,
            DESIGNATIONLIST = @DESIGNATIONLIST,
            DEFAULTDESIGNATIONID = @DEFAULTDESIGNATIONID,
            DEFAULTDESIGNATION = @DEFAULTDESIGNATION,
            APPEALSLIST = @APPEALSLIST,
            REQUIREAPPEAL = @REQUIREAPPEAL,
            SOLESPONSORSHIPENABLED = @SOLESPONSORSHIPENABLED,
            GIFTSPONSORSHIPENABLED = @GIFTSPONSORSHIPENABLED,
            ECARDSENABLED = @ECARDSENABLED,
            ADDITIONALGIFTENABLED = @ADDITIONALGIFTENABLED,
            MULTIPLEGIFTSENABLED = @MULTIPLEGIFTSENABLED,
            MINIMUMGIFTAMOUNT = @MINIMUMGIFTAMOUNT,
            CONSTITUENCYID = @CONSTITUENCYID,
            GENERALRECURRENCEENABLED = @GENERALRECURRENCEENABLED,
            SCHEDULEDENDDATEENABLED = @SCHEDULEDENDDATEENABLED,
            RECURRENCEDATAIDLIST = @RECURRENCEDATAIDLIST,
            ITEMEXPIRATION = @ITEMEXPIRATION,
            PAYMENTPARTPAGE = @PAYMENTPARTPAGE,
            DIRECTDEBITENABLED = @DIRECTDEBITENABLED,
            CHECKENABLED = @CHECKENABLED,
            FORMITEMEXPIRATION = @FORMITEMEXPIRATION,
            ACKNOWLEDGEMENTHTML = @ACKNOWLEDGEMENTHTML,
                  CHANGEDBYID = @CHANGEAGENTID,
                  DATECHANGED = getdate(),
            FORCESTARTDATE = @FORCESTARTDATE,
            PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID,
                        SUPPORTSCHECKOUTONLY=@SUPPORTSCHECKOUTONLY
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;