USP_PROSPECTPLANASSIGNEDALERT_SEND

Sends a prospect plan assigned alert.

Parameters

Parameter	Parameter Type	Mode
@PREVIOUSPRIMARYFUNDRAISERID	uniqueidentifier	IN
@PREVIOUSSECONDARYFUNDRAISERID	uniqueidentifier	IN
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_PROSPECTPLANASSIGNEDALERT_SEND (
                @PREVIOUSPRIMARYFUNDRAISERID uniqueidentifier,
                @PREVIOUSSECONDARYFUNDRAISERID uniqueidentifier,
                @PROSPECTPLANID uniqueidentifier
            ) as begin

                declare @PRIMARYFUNDRAISERID uniqueidentifier;
                declare @SECONDARYFUNDRAISERID uniqueidentifier;        

                select 
                    @PRIMARYFUNDRAISERID = PROSPECTPLAN.PRIMARYMANAGERFUNDRAISERID,
                    @SECONDARYFUNDRAISERID = PROSPECTPLAN.SECONDARYMANAGERFUNDRAISERID
                from 
                    dbo.PROSPECTPLAN 
                where 
                    PROSPECTPLAN.ID = @PROSPECTPLANID;

                declare @PRIMARYFUNDRAISERAPPUSERID uniqueidentifier;
                declare @SECONDARYFUNDRAISERAPPUSERID uniqueidentifier;

                select @PRIMARYFUNDRAISERAPPUSERID = ID from dbo.APPUSER where CONSTITUENTID = @PRIMARYFUNDRAISERID;
                select @SECONDARYFUNDRAISERAPPUSERID = ID from dbo.APPUSER where CONSTITUENTID = @SECONDARYFUNDRAISERID;

                if (@PREVIOUSPRIMARYFUNDRAISERID is null) or (@PRIMARYFUNDRAISERID <> @PREVIOUSPRIMARYFUNDRAISERID)    
                    exec dbo.USP_ALERTTYPE_SENDTOAPPUSER 'F1E2E54C-6DCD-4577-B856-D1AB6433BC50', @PRIMARYFUNDRAISERAPPUSERID, @PROSPECTPLANID;

                if (@PREVIOUSSECONDARYFUNDRAISERID is null) or (@SECONDARYFUNDRAISERID <> @PREVIOUSSECONDARYFUNDRAISERID)
                    exec dbo.USP_ALERTTYPE_SENDTOAPPUSER '292C23D1-B226-4600-8295-B45A5B3C072E', @SECONDARYFUNDRAISERAPPUSERID, @PROSPECTPLANID;

                return 0;
            end