UFN_EVENT_TEAMFUNDRAISINGAPPEAL_VALIDCURRENCY

Returns true if a team fundraising appeal's base currency matches the event's.

Return

Return Type
bit

Parameters

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

Definition

Copy


            CREATE function dbo.UFN_EVENT_TEAMFUNDRAISINGAPPEAL_VALIDCURRENCY
            (
                @EVENTID uniqueidentifier,
                @APPEALID uniqueidentifier
            )
            returns bit
            as
            begin
                -- Ignore this validation if we're in a single currency system.

                if dbo.UFN_CONDITIONSETTING_EVALUATEEXISTSCONDITION('Multicurrency') = 0
                    return 1;

                declare @EVENTCURRENCYID uniqueidentifier = null;
                declare @APPEALCURRENCYID uniqueidentifier = null;

                select @EVENTCURRENCYID = BASECURRENCYID from dbo.EVENT where EVENT.ID = @EVENTID;
                select @APPEALCURRENCYID = BASECURRENCYID from dbo.APPEAL where APPEAL.ID = @APPEALID;

                if @EVENTCURRENCYID is null and @APPEALCURRENCYID is null    
                    return 1;

                if @EVENTCURRENCYID <> @APPEALCURRENCYID
                    return 0;

                return 1;
            end