UFN_REGISTRANT_GETDONATIONAMOUNT

Get donation amount for a registrant or a team registrant

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode
@REGISTRANTID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@TEAMFUNDRAISINGTEAMID	uniqueidentifier	IN
@ROLETYPE	tinyint	IN
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



    CREATE function dbo.UFN_REGISTRANT_GETDONATIONAMOUNT
   (  
    @REGISTRANTID uniqueidentifier = NULL
    ,@EVENTID uniqueidentifier = NULL  
    ,@TEAMFUNDRAISINGTEAMID uniqueidentifier = NULL
    ,@ROLETYPE tinyint = 0 -- 0:Ind, 1:Team, 2:Company, 3:Household  

    ,@CONSTITUENTID uniqueidentifier = NULL
   )   
   returns money   
   with execute as caller  
   as  
   begin  

    DECLARE @DonationAmount money

    IF @ROLETYPE = 0 AND @REGISTRANTID IS NOT NULL
    BEGIN
        SELECT @DonationAmount= DBO.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL (@REGISTRANTID, @EVENTID)
    END

    IF (@ROLETYPE = 1 OR @ROLETYPE = 2 OR @ROLETYPE = 3) AND @TEAMFUNDRAISINGTEAMID IS NOT NULL
    BEGIN
        select @DonationAmount = AMOUNTRAISED from dbo.UFN_FAF_GROUPTOTALSROLLUP(@EVENTID, @TEAMFUNDRAISINGTEAMID)        
    END

    IF @DonationAmount IS NULL 
        SET    @DonationAmount = 0

return @DonationAmount
end