UFN_REGISTRANT_GETFUNDRAISINGMINIMUMREMAINING

Get fundraising minimum remaining for a registrant

Return

Return Type
money

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN

Definition

Copy



       CREATE function dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUMREMAINING
       (  
        @ID uniqueidentifier,  
        @EVENTID uniqueidentifier
       )   
       returns money   
       with execute as caller  
       as  
       begin  
        declare @returnRemaining money  
        declare @FundraisingMinimun money
        declare @AmountRaised money

        set @FundraisingMinimun = coalesce(dbo.UFN_REGISTRANT_GETFUNDRAISINGMINIMUM(@ID), 0)
        --set @AmountRaised = coalesce(dbo.UFN_REGISTRANT_GETFUNDRAISINGAMOUNTRAISED(@ID,@EVENTID), 0)

    set @AmountRaised = coalesce(dbo.UFN_REVENUE_GETPARTICIPANTRAISEDTOTAL(@ID,@EVENTID), 0)
        set @returnRemaining = 0

        IF (@FundraisingMinimun > @AmountRaised) 
            SET    @returnRemaining = @FundraisingMinimun - @AmountRaised
        ELSE
            SET    @returnRemaining = 0

        return @returnRemaining
       end