USP_BBNC_INTEGRATIONTEAMFUNDRAISEREMAILADDUPDATE

Adds an email job recipient from the Blackbaud Internet Solutions integration service.
Parameters

Parameter	Parameter Type	Mode
@BBNCUSERID	int	IN
@APPEALMAPID	int	IN
@EMAILRECIPIENTMAPID	int	IN
@UPDATEDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
Definition

Copy


            CREATE procedure dbo.USP_BBNC_INTEGRATIONTEAMFUNDRAISEREMAILADDUPDATE
            (
                @BBNCUSERID int,
                @APPEALMAPID int,
                @EMAILRECIPIENTMAPID int,
                @UPDATEDATE datetime,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            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 not (@BBNCUSERID > 0)
                        raiserror('ERR_BBNCUSERID_REQUIRED',16,1);

                    if not (@APPEALMAPID > 0)
                        raiserror('ERR_APPEALMAPID_REQUIRED',16,1);

                    declare @NETCOMMUNITYCLIENTUSERID uniqueidentifier;
                    select
                        @NETCOMMUNITYCLIENTUSERID = NETCOMMUNITYCLIENTUSER.ID
                    from
                        dbo.NETCOMMUNITYCLIENTUSER
                    where
                        BBNCUSERID = @BBNCUSERID;

                    if @NETCOMMUNITYCLIENTUSERID is null
                        raiserror('ERR_BBNCUSERID_DOESNOTEXIST',16,1);

                    declare @APPEALID uniqueidentifier;
                    select
                        @APPEALID = APPEALID
                    from
                        dbo.BBNCAPPEALIDMAP
                    where
                        ID = @APPEALMAPID;

                    -- Skip records for which the appeal does not exist.

                    --  The appeal must have been deleted and raising an error

                    --  will prevent other team fundraiser email records from

                    --  being processed.

                    if @APPEALID is not null
                        insert into dbo.NETCOMMUNITYTEAMFUNDRAISEREMAIL
                        (
                            [NETCOMMUNITYCLIENTUSERID],
                            [APPEALID],
                            [EMAILRECIPIENTMAPID],
                            [UPDATEDATE],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED]
                        )
                        values
                        (
                            @NETCOMMUNITYCLIENTUSERID,
                            @APPEALID,
                            @EMAILRECIPIENTMAPID,
                            @UPDATEDATE,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CHANGEDATE,
                            @CHANGEDATE
                        );
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;