USP_EVENTCONFLICTEVENTDETAIL2_VIEW

The load procedure used by the view dataform template "Event Conflict Event Details View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@PROGRAMID	uniqueidentifier	INOUT	Guid
@CAPACITY	int	INOUT	Capacity
@DESCRIPTION	nvarchar(500)	INOUT	Description
@STARTDATE	datetime	INOUT	Date
@ENDDATE	datetime	INOUT	Date
@STARTTIME	UDT_HOURMINUTE	INOUT	Start time
@ENDTIME	UDT_HOURMINUTE	INOUT	End time
@LOCATIONS	xml	INOUT	Locations
@RESOURCES	xml	INOUT	Resources
@EVENTSTAFFRESOURCES	xml	INOUT	Staff resources
@CONFLICTS	xml	INOUT	Conflicting Events
@SUPERCEDESPROGRAMPUBLICDESCRIPTION	bit	INOUT
@PUBLICDESCRIPTIONTEXT	nvarchar(max)	INOUT
@PUBLICDESCRIPTIONHTML	nvarchar(max)	INOUT
@HASITINERARYPERMISSION	bit	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_EVENTCONFLICTEVENTDETAIL2_VIEW
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @NAME nvarchar(100) = null output,
    @PROGRAMID uniqueidentifier = null output,
    @CAPACITY int = null output,
    @DESCRIPTION nvarchar(500) = null output,
    @STARTDATE datetime = null output,
    @ENDDATE datetime = null output,
    @STARTTIME UDT_HOURMINUTE = null output,
    @ENDTIME UDT_HOURMINUTE = null output,
    @LOCATIONS xml = null output,
    @RESOURCES xml = null output,
    @EVENTSTAFFRESOURCES xml = null output,
    @CONFLICTS xml = null output,
    @SUPERCEDESPROGRAMPUBLICDESCRIPTION bit = null output,
    @PUBLICDESCRIPTIONTEXT nvarchar(max) = null output,
    @PUBLICDESCRIPTIONHTML nvarchar(max) = null output,
    @HASITINERARYPERMISSION bit = null output,
    @CURRENTAPPUSERID uniqueidentifier = null
)
as 
    set nocount on;
    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,
        @NAME = NAME,
        @PROGRAMID = PROGRAMID,
        @CAPACITY = CAPACITY,
        @DESCRIPTION = DESCRIPTION,
        @STARTDATE = STARTDATE,
        @ENDDATE = ENDDATE,
        @STARTTIME = STARTTIME,
        @ENDTIME = ENDTIME,
        @LOCATIONS = dbo.UFN_EVENTCONFLICT_GETSEQUENCEDLOCATIONS_TOITEMLISTXML(@ID),
        @RESOURCES = dbo.UFN_EVENTCONFLICT_GETRESOURCES_TOITEMLISTXML(@ID),
        @EVENTSTAFFRESOURCES = dbo.UFN_EVENTCONFLICT_GETSTAFFRESOURCES_TOITEMLISTXML(@ID),
        @CONFLICTS=dbo.UFN_EVENTCONFLICT_GETEVENTINFOFORLIST_TOITEMLISTXML(@ID),
        @SUPERCEDESPROGRAMPUBLICDESCRIPTION = SUPERCEDESPROGRAMPUBLICDESCRIPTION,
        @PUBLICDESCRIPTIONTEXT = PUBLICDESCRIPTIONTEXT,
        @PUBLICDESCRIPTIONHTML = PUBLICDESCRIPTIONHTML
    from 
        dbo.EVENTCONFLICT
    where 
        ID = @ID

    if @CURRENTAPPUSERID is not null and 
        (
            (dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@CURRENTAPPUSERID, '3112468c-854d-4938-8890-41dc23f16fe1') = 1) 
            or (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1)
        )
        set @HASITINERARYPERMISSION = 1
    else
        set @HASITINERARYPERMISSION = 0

    return 0;