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