USP_BBNC_ASSIGNSITE

Assigns a site to a newly created constituent.

Parameters

Parameter	Parameter Type	Mode
@CONSTITUENTID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_BBNC_ASSIGNSITE
            (
                @CONSTITUENTID uniqueidentifier,
                @SITEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            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 @CONSTITUENTID is null and @SITEID is null
                    raiserror('ERR_NULL_CONSTITUENT_AND_SITE_ID', 13, 1);

                if @CONSTITUENTID is null
                    raiserror('ERR_NULL_CONSTITUENT_ID', 13, 1);

                if @SITEID is null
                    raiserror('ERR_NULL_SITE_ID', 13, 1);

                if (select count(ID) from dbo.CONSTITUENTSITE where CONSTITUENTID = @CONSTITUENTID and SITEID = @SITEID) = 0
                    insert into dbo.CONSTITUENTSITE(CONSTITUENTID, SITEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values(@CONSTITUENTID, @SITEID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;