USP_BBNC_INSERTPAGEMAPPING

Inserts a new Blackbaud Internet Solutions page mapping into the system.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@PAGEID	int	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_INSERTPAGEMAPPING
            (
                @ID uniqueidentifier,
                @PAGEID int,
                @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
                insert into dbo.NETCOMMUNITYPAGEMAPPING(ID, PAGEID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values(@ID, @PAGEID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;