UFN_EVENT_VALIDBASECURRENCYID_REGISTRATIONPACKAGESHAVEONECURRENCY

Validates that any packages using registration options from this event will continue to have a homogeneous currency.

Return

Return Type
bit

Parameters

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

Definition

Copy



CREATE function dbo.UFN_EVENT_VALIDBASECURRENCYID_REGISTRATIONPACKAGESHAVEONECURRENCY
(
    @EVENTID uniqueidentifier = null,
    @BASECURRENCYID uniqueidentifier = null
)
returns bit
with execute as caller
as
begin
    if exists
    (
        select top 1
            1
        from
            dbo.EVENTPRICE
            inner join dbo.REGISTRATIONPACKAGEPRICE on EVENTPRICE.ID = REGISTRATIONPACKAGEPRICE.EVENTPRICEID
            inner join dbo.REGISTRATIONPACKAGEPRICE [PACKAGEPRICEFROMSAMEPACKAGE] on REGISTRATIONPACKAGEPRICE.REGISTRATIONPACKAGEID = [PACKAGEPRICEFROMSAMEPACKAGE].REGISTRATIONPACKAGEID
            inner join dbo.EVENTPRICE [EVENTPRICEFROMSAMEPACKAGE] on [PACKAGEPRICEFROMSAMEPACKAGE].EVENTPRICEID = [EVENTPRICEFROMSAMEPACKAGE].ID
            inner join dbo.EVENT on [EVENTPRICEFROMSAMEPACKAGE].EVENTID = EVENT.ID
        where
            EVENTPRICE.EVENTID = @EVENTID
            and EVENT.BASECURRENCYID <> @BASECURRENCYID
    )
        return 0;

    return 1;
end