USP_BBNC_ASSIGNCONSTITUENTSECURITYATTRIBUTE

Adds a constituent security attribute to a constituent.

Parameters

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

Definition

Copy



            create procedure dbo.USP_BBNC_ASSIGNCONSTITUENTSECURITYATTRIBUTE
            (
                @CONSTITUENTID uniqueidentifier,
                @CONSTIT_SECURITY_ATTRIBUTEID 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 @CONSTIT_SECURITY_ATTRIBUTEID is null
                    raiserror('ERR_NULL_CONSTITUENT_AND_SECURITYATTRIBUTE_ID', 13, 1);

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

                if @CONSTIT_SECURITY_ATTRIBUTEID is null
                    raiserror('ERR_NULL_SECURITYATTRIBUTE_ID', 13, 1);

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

            return 0;