USP_BBNC_COMMITFUNDRAISERTEAMFUNDRAISINGTEAMADD

Adds a team's information from a fundraiser Blackbaud Internet Solutions transaction to the system from a given batch.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@BBNCMAPID	int	INOUT
@APPEALID	uniqueidentifier	IN
@PARENTTEAMID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@GOAL	money	IN
@CAPTAINCONSTITUENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITFUNDRAISERTEAMFUNDRAISINGTEAMADD
            (
                @ID uniqueidentifier = null output,
                @BBNCMAPID int = null output,
                @APPEALID uniqueidentifier,
                @PARENTTEAMID uniqueidentifier = null,
                @NAME nvarchar(100),
                @GOAL money = 0,
                @CAPTAINCONSTITUENTID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

                if @ID is null
                    set @ID = newid();

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

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

                begin try
                    insert into dbo.TEAMFUNDRAISINGTEAM
                        (ID,APPEALID,NAME,GOAL,PARENTTEAMID,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
                    values
                        (@ID,@APPEALID,@NAME,@GOAL,@PARENTTEAMID,@CHANGEAGENTID,@CHANGEAGENTID,@CHANGEDATE,@CHANGEDATE);

                    if @CAPTAINCONSTITUENTID is not null
                        insert into dbo.TEAMFUNDRAISINGTEAMCAPTAIN
                            (TEAMFUNDRAISINGTEAMID, CONSTITUENTID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values
                            (@ID, @CAPTAINCONSTITUENTID, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);

                    select
                        @BBNCMAPID = [ID]
                    from
                        dbo.BBNCTEAMFUNDRAISINGTEAMIDMAP
                    where
                        TEAMFUNDRAISINGTEAMID = @ID;

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;