USP_DATAFORMTEMPLATE_EDIT_EVENT_FAF_CONFIG

Used for adding Event Faf Config

Parameters

Parameter	Parameter Type	Mode
@CHANGEAGENTID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@GOALISSET	bit	IN
@SOCIALNETWORKISSET	bit	IN
@LABELISSET	bit	IN
@TEAMHIERARCHYISSET	bit	IN
@MERCHANTACCOUNTSET	bit	IN
@INCENTIVEOPTIONISSET	bit	IN
@DONATIONOPTIONSISSET	bit	IN
@FUNDRAISINGCOACHISSET	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENT_FAF_CONFIG
(
  @CHANGEAGENTID uniqueidentifier = null,
  @EVENTID uniqueidentifier,
  @GOALISSET bit =NULL,
  @SOCIALNETWORKISSET bit= NULL,
  @LABELISSET bit= NULL,
  @TEAMHIERARCHYISSET bit= NULL,
  @MERCHANTACCOUNTSET bit= NULL,
  @INCENTIVEOPTIONISSET bit =NULL,
  @DONATIONOPTIONSISSET bit = NULL,
  @FUNDRAISINGCOACHISSET bit = NULL


)
as

    set nocount on;

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

    begin try

        -- handle updating the data

        update dbo.EVENTFAFCONFIG 
    set
        EVENTID = @EVENTID,
        GOALISSET=  ISNULL(@GOALISSET, GOALISSET), 
        SOCIALNETWORKISSET=  ISNULL(@SOCIALNETWORKISSET, SOCIALNETWORKISSET),
        LABELISSET= ISNULL(@LABELISSET, LABELISSET),
        TEAMHIERARCHYISSET =  ISNULL(@TEAMHIERARCHYISSET, TEAMHIERARCHYISSET),
        MERCHANTACCOUNTSET=  ISNULL(@MERCHANTACCOUNTSET, MERCHANTACCOUNTSET),
    INCENTIVEOPTIONISSET=  ISNULL(@INCENTIVEOPTIONISSET, INCENTIVEOPTIONISSET), 
    DONATIONOPTIONSISSET = ISNULL(@DONATIONOPTIONSISSET, DONATIONOPTIONSISSET),
    FUNDRAISINGCOACHISSET= ISNULL(@FUNDRAISINGCOACHISSET, FUNDRAISINGCOACHISSET), 
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()

        from dbo.EVENTFAFCONFIG (NOLOCK)
        where EVENTID = @EVENTID

    exec dbo.USP_FAFDATACACHE_CLEAR @EVENTID=@EVENTID

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;