USP_WPRELATIONSHIP_PF_ADD

Adds WealthPoint Private Foundation Relationship information.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@EIN	nvarchar(30)	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@EXECCOUNT	int	IN
Definition

Copy


            CREATE procedure dbo.USP_WPRELATIONSHIP_PF_ADD(
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @EIN nvarchar(30) = '',
                @CURRENTAPPUSERID uniqueidentifier = null,
        @EXECCOUNT int = 0
            ) as begin
                set nocount on;

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

                declare @CURRENTDATE datetime;    
                set @CURRENTDATE = getdate();

        declare @CURRENTEXECCOUNT int = 0;

                select @ID = ID, @CURRENTEXECCOUNT = EXECCOUNT from dbo.WPRELATIONSHIP_PF where EIN = @EIN;

                begin try
                    if @ID is null begin
                        set @ID = newid();

                        insert into dbo.WPRELATIONSHIP_PF (
                            ID,
                            EIN,
              EXECCOUNT,
                            CHANGEDBYID,
                            ADDEDBYID,
                            DATEADDED,
                            DATECHANGED
                        ) values (
                            @ID,
                            coalesce(@EIN, ''),
              @EXECCOUNT,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                        );
                    end
          else 
          begin
                      if @EXECCOUNT <> @CURRENTEXECCOUNT begin
                        update
                            dbo.WPRELATIONSHIP_PF
                        set
                            EXECCOUNT = @EXECCOUNT,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where
                            ID = @ID;
            end
          end
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                end catch

                return 0;
            end