USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVELCAMPAIGNS

The save procedure used by the edit dataform template "Membership Level Campaign Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@OVERRIDECAMPAIGNS	bit	IN	Override membership program defaults
@CAMPAIGNS	xml	IN	Campaigns
@PROGRAMID	uniqueidentifier	IN	Program Id

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVELCAMPAIGNS (
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier = null,
        @OVERRIDECAMPAIGNS bit,
        @CAMPAIGNS xml,
        @PROGRAMID    uniqueidentifier
        ) as 
                    begin
                        set nocount on;

                        begin try


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

                            if @OVERRIDECAMPAIGNS = 1
                            begin
                                    exec dbo.USP_MEMBERSHIPLEVEL_CAMPAIGNS_UPDATEFROMXML @ID, @CAMPAIGNS, @CHANGEAGENTID;
                            end

                            update    dbo.MEMBERSHIPLEVEL 
                            set            OVERRIDECAMPAIGNS = @OVERRIDECAMPAIGNS
                            where        ID = @ID

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

                        return 0;
                    end