USP_PEOPLELINKORGANIZATION_ADD

Adds Prospect Wealth securities information for a prospect.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@WEALTHID	uniqueidentifier	IN
@SOURCE	nvarchar(150)	IN
@ORGNAME	nvarchar(150)	IN
@LINE1	nvarchar(150)	IN
@CITY	nvarchar(50)	IN
@STATE	nvarchar(2)	IN
@ZIP	nvarchar(10)	IN
@TICKER	nvarchar(50)	IN
@CONTACTS	xml	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@FULLHASH	nvarchar(32)	IN

Definition

Copy



            CREATE procedure dbo.USP_PEOPLELINKORGANIZATION_ADD (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @WEALTHID uniqueidentifier,
                @SOURCE nvarchar(150),
                @ORGNAME nvarchar(150) = '',
                @LINE1 nvarchar(150) = '',
                @CITY nvarchar(50) = '',
                @STATE nvarchar(2) = '',
                @ZIP nvarchar(10) = '',
                @TICKER nvarchar(50) = '',
                @CONTACTS xml = null,
                @CURRENTAPPUSERID uniqueidentifier = null,
                @FULLHASH nvarchar(32) = ''
            ) as begin
                set nocount on;

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

                begin try
                    if exists(select 1 from dbo.PEOPLELINKORGANIZATION where WEALTHID=@WEALTHID and FULLHASH=@FULLHASH) 

                        set @ID = null;

                    else begin

                    if @ID is null
                        set @ID = newid()

                    insert into dbo.PEOPLELINKORGANIZATION (
                        ID,ADDEDBYID,CHANGEDBYID,
                        WEALTHID,
                        SOURCE,
                        ORGNAME,
                        LINE1,
                        CITY,
                        STATE,
                        ZIP,
                        TICKER,
                        FULLHASH
                    ) values (
                        @ID,@CHANGEAGENTID,@CHANGEAGENTID,
                        @WEALTHID,
                        @SOURCE,
                        @ORGNAME,
                        @LINE1,
                        @CITY,
                        @STATE,
                        @ZIP,
                        @TICKER,
                        @FULLHASH
                    )

                    exec dbo.USP_PEOPLELINKORGANIZATION_CONTACTS_ADDFROMXML @ID, @CONTACTS, @CHANGEAGENTID
                    end;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                end catch

                return 0
            end