USP_BBNC_COMMITCONSTITUENCYADDIFNEW

Adds a constituent constituency if it doesn't already exist from a Blackbaud Internet Solutions transaction to the system from a given batch.

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@CONSTITUENCYCODEID	uniqueidentifier	IN
@DATEFROM	datetime	IN
@DATETO	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITCONSTITUENCYADDIFNEW
            (
                @CONSTITUENTID uniqueidentifier,
                @CONSTITUENCYCODEID uniqueidentifier,
                @DATEFROM datetime = null,
                @DATETO 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
                    if not exists
                    (
                        select
                            ID
                        from
                            dbo.CONSTITUENCY
                        where
                            CONSTITUENTID = @CONSTITUENTID
                            and CONSTITUENCYCODEID = @CONSTITUENCYCODEID
                    )
                        insert into dbo.CONSTITUENCY
                        (
                            [CONSTITUENTID],
                            [CONSTITUENCYCODEID],
                            [DATEFROM],
                            [DATETO],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED]
                        )
                        values
                        (
                            @CONSTITUENTID,
                            @CONSTITUENCYCODEID,
                            @DATEFROM,
                            @DATETO,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CHANGEDATE,
                            @CHANGEDATE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;