USP_EXCHANGECONTACTBATCH_EDITCONSTITUENT

Commits exchange contact batch constituent changes.

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@BIRTHDATE	UDT_FUZZYDATE	IN
@FIRSTNAME	nvarchar(50)	IN
@LASTNAME	nvarchar(100)	IN
@NICKNAME	nvarchar(50)	IN
@SUFFIXCODEID	uniqueidentifier	IN
@TITLECODEID	uniqueidentifier	IN
@WEBADDRESS	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MIDDLENAME	nvarchar(50)	IN

Definition

Copy



            CREATE procedure dbo.USP_EXCHANGECONTACTBATCH_EDITCONSTITUENT
            (
                @CONSTITUENTID uniqueidentifier = null,
                @BIRTHDATE dbo.udt_fuzzydate = null,
                @FIRSTNAME nvarchar(50) = null,
                @LASTNAME nvarchar(100) = null,
                @NICKNAME nvarchar(50) = null,
                @SUFFIXCODEID uniqueidentifier = null,
                @TITLECODEID uniqueidentifier = null,
                @WEBADDRESS nvarchar(100) = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @MIDDLENAME nvarchar(50) = null
            )
            as            
                set nocount on;

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

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

                if @TITLECODEID = '00000000-0000-0000-0000-000000000000' begin
                    set @TITLECODEID = null
                end

                if @SUFFIXCODEID = '00000000-0000-0000-0000-000000000000' begin
                    set @SUFFIXCODEID = null
                end

                update 
                    dbo.CONSTITUENT
                set
                    BIRTHDATE = @BIRTHDATE,
                    FIRSTNAME = @FIRSTNAME, 
                    KEYNAME = @LASTNAME, 
                    NICKNAME = @NICKNAME, 
                    WEBADDRESS = @WEBADDRESS, 
                    SUFFIXCODEID = @SUFFIXCODEID, 
                    TITLECODEID = @TITLECODEID,
                    DATECHANGED = @CHANGEDATE,
                    CHANGEDBYID = @CHANGEAGENTID,
                    MIDDLENAME = @MIDDLENAME
                where
                    CONSTITUENT.ID = @CONSTITUENTID;