USP_TEAMFUNDRAISINGTEAM_PREPARETEAMFUNDRAISINGTEAMGROUP

Used to create the team fundraising team group records when necessary before adding a team fundraising team.

Parameters

Parameter	Parameter Type	Mode
@TEAMFUNDRAISINGTEAMGROUPID	uniqueidentifier	INOUT
@TEAMHISTORYTEAMS	xml	IN
@NAME	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_TEAMFUNDRAISINGTEAM_PREPARETEAMFUNDRAISINGTEAMGROUP
            (
                @TEAMFUNDRAISINGTEAMGROUPID uniqueidentifier output,
                @TEAMHISTORYTEAMS xml,
                @NAME nvarchar(100),
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTDATE datetime = null
            )
            as
                set nocount on;

                if @CHANGEAGENTID is null
                    exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                if @CURRENTDATE is null 
                    set @CURRENTDATE = getdate()

                if
                (
                    @TEAMFUNDRAISINGTEAMGROUPID is null
                    and
                    @TEAMHISTORYTEAMS.exist('/TEAMHISTORYTEAMS/ITEM/TEAMFUNDRAISINGTEAMID') = 1
                )
                    set @TEAMFUNDRAISINGTEAMGROUPID = newid();

                if
                (
                    @TEAMFUNDRAISINGTEAMGROUPID is not null
                    and
                    not exists(select ID from dbo.TEAMFUNDRAISINGTEAMGROUP where ID = @TEAMFUNDRAISINGTEAMGROUPID)
                )
                    insert into dbo.TEAMFUNDRAISINGTEAMGROUP
                        (ID,NAME,ADDEDBYID,CHANGEDBYID,DATEADDED,DATECHANGED)
                    values
                        (@TEAMFUNDRAISINGTEAMGROUPID,@NAME,@CHANGEAGENTID,@CHANGEAGENTID,@CURRENTDATE,@CURRENTDATE);

                return 0;