USP_EXCHANGECONTACTBATCH_ADDEDITPHONE

Commits Exchange contact batch phone changes.
Parameters

Parameter	Parameter Type	Mode
@PHONEID	uniqueidentifier	IN
@NUMBER	nvarchar(100)	IN
@PHONETYPECODEID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@INFOSOURCECODEID	uniqueidentifier	IN
Definition

Copy


            CREATE procedure dbo.USP_EXCHANGECONTACTBATCH_ADDEDITPHONE
            (
                @PHONEID uniqueidentifier = null,
                @NUMBER nvarchar(100) = null,
                @PHONETYPECODEID uniqueidentifier = null,
                @CONSTITUENTID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @INFOSOURCECODEID uniqueidentifier = null
            )
            as            
                set nocount on;

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

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

                if @PHONEID is null
                    begin
                        set @PHONEID = newid();

                        declare @ISPRIMARY bit;
                        if exists(select ID from dbo.PHONE where CONSTITUENTID = @CONSTITUENTID and ISPRIMARY = 1)
                            begin
                                set @ISPRIMARY = 0;
                            end
                        else
                            begin
                                set @ISPRIMARY = 1;
                            end

                        insert into dbo.PHONE
                            (ID, NUMBER, PHONETYPECODEID, CONSTITUENTID, ISPRIMARY, INFOSOURCECODEID, DATEADDED, DATECHANGED, ADDEDBYID, CHANGEDBYID)
                        values
                            (@PHONEID, @NUMBER, @PHONETYPECODEID, @CONSTITUENTID, @ISPRIMARY, @INFOSOURCECODEID, @CHANGEDATE, @CHANGEDATE, @CHANGEAGENTID, @CHANGEAGENTID);
                    end
                else
                    begin
                        update
                            dbo.PHONE
                        set
                            NUMBER = @NUMBER,
                            INFOSOURCECODEID = @INFOSOURCECODEID,
                            DATECHANGED = @CHANGEDATE,
                            CHANGEDBYID = @CHANGEAGENTID
                        where
                            PHONE.ID = @PHONEID;
                    end