USP_EVENT_GETRELATEDEVENTINFO

Get readonly info re: event and any related events

Parameters

Parameter	Parameter Type	Mode
@EVENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@PACKAGESPRICES	xml	INOUT
@EVENTSWITHPRICES	xml	INOUT
@EVENTPRICEBENEFITS	xml	INOUT
@EVENTPREFERENCEGROUPS	xml	INOUT
@EVENTAPPEALS	xml	INOUT
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT
@EVENTSCHEDULES	xml	INOUT
@SINGLEEVENTLIST	xml	INOUT
@EVENTCURRENCY	xml	INOUT

Definition

Copy



CREATE procedure dbo.USP_EVENT_GETRELATEDEVENTINFO
(
    @EVENTID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @PACKAGESPRICES xml = null output,
    @EVENTSWITHPRICES xml = null output,
    @EVENTPRICEBENEFITS xml = null output,
    @EVENTPREFERENCEGROUPS xml = null output,
    @EVENTAPPEALS xml = null output,
    @CONSTITUENTRECORDTYPEID uniqueidentifier = null output,
    @EVENTSCHEDULES xml = null output,
    @SINGLEEVENTLIST xml = null output,
    @EVENTCURRENCY xml = null output
)
as 
begin

    declare @relatedEvents UDT_GENERICID
    insert into @relatedEvents
        select ID from dbo.UFN_EVENT_GETRELATEDEVENTS(@EVENTID)

    set @PACKAGESPRICES = dbo.UFN_REGISTRATIONPACKAGE_GETPKGPRICES_TOITEMLISTXML(@relatedEvents);

    insert into @relatedEvents
        select distinct T.c.value('(EVENTPRICEEVENTID)[1]','uniqueidentifier') 
        from @PACKAGESPRICES.nodes('/PACKAGESPRICES/ITEM') T(c)
        where T.c.value('(EVENTPRICEEVENTID)[1]','uniqueidentifier') not in (select ID from @relatedEvents)

    set @EVENTSWITHPRICES = dbo.UFN_EVENTPRICE_GETRELATEDEVENTSWITHPRICES_TOITEMLISTXML(@relatedEvents);
    set @EVENTPRICEBENEFITS = dbo.UFN_EVENTPRICEBENEFIT_GETRELATEDEVENTPRICEBENEFITS_TOITEMLISTXML(@relatedEvents);
    set @EVENTPREFERENCEGROUPS = dbo.UFN_EVENTPREFERENCEGROUP_GETRELATEDEVENTPREFERENCEGROUPS_TOITEMLISTXML(@relatedEvents);
    set @EVENTAPPEALS = dbo.UFN_EVENT_GETRELATEDEVENTAPPEALS_TOITEMLISTXML(@relatedEvents);
    set @CONSTITUENTRECORDTYPEID=dbo.UFN_RECORDTYPE_GETIDBYNAME('Constituent');
    set @EVENTSCHEDULES = dbo.UFN_EVENT_GETRELATEDEVENTSCHEDULES_TOITEMLISTXML(@EVENTID);
    set @SINGLEEVENTLIST = (select ID from dbo.UFN_CHILDEVENTSWITHSITEACCESS(@EVENTID, @CURRENTAPPUSERID) for xml raw('ITEM'),type,elements,root('SINGLEEVENTLIST'),BINARY BASE64)
    set @EVENTCURRENCY = dbo.UFN_EVENT_GETRELATEDEVENTCURRENCIES_TOITEMLISTXML(@PACKAGESPRICES, @EVENTSWITHPRICES);

end