USP_BBNC_COMMITSIGNUPCLIENTUSERADDUPDATE

Adds a constituent's NetCommunity user information from a NetCommunity signup transaction to the system.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@BBNCUSERID	int	IN
@SIGNUPTRANSACTIONDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
Definition

Copy


            CREATE procedure dbo.USP_BBNC_COMMITSIGNUPCLIENTUSERADDUPDATE
            (
                @ID uniqueidentifier,
                @BBNCUSERID int,
                @SIGNUPTRANSACTIONDATE datetime = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

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

                if @CHANGEDATE is null
                    set @CHANGEDATE  = getdate();

                begin try
                    update dbo.NETCOMMUNITYCLIENTUSER
                    set
                        [CONSTITUENTID] = @ID,
                        [SIGNUPTRANSACTIONDATE] = @SIGNUPTRANSACTIONDATE,
                        [CHANGEDBYID] = @CHANGEAGENTID,
                        [DATECHANGED] = @CHANGEDATE
                    where
                        [BBNCUSERID] = @BBNCUSERID;

                    if @@ROWCOUNT = 0 AND @BBNCUSERID > -1
                        insert into dbo.NETCOMMUNITYCLIENTUSER
                        (
                            [CONSTITUENTID],
                            [BBNCUSERID],
                            [SIGNUPTRANSACTIONDATE],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED]
                        )
                        values
                        (
                            @ID,
                            @BBNCUSERID,
                            @SIGNUPTRANSACTIONDATE,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CHANGEDATE,
                            @CHANGEDATE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;