USP_DATAFORMTEMPLATE_VIEW_EVENTSUMMARY

The load procedure used by the view dataform template "Event Summary View"

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
@DESCRIPTION	nvarchar(255)	INOUT	Description
@LOCNAME	nvarchar(500)	INOUT	Location
@DATE	datetime	INOUT	Date
@STARTTIME	UDT_HOURMINUTE	INOUT	Time
@ENDTIME	UDT_HOURMINUTE	INOUT	End time
@ONSALEINFO	xml	INOUT	On-sale information
@CAPACITY	int	INOUT	Capacity
@PROGRAMID	uniqueidentifier	INOUT

Definition

Copy



      CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTSUMMARY
      (
        @ID uniqueidentifier,
        @DATALOADED bit = 0 output,
        @NAME nvarchar(100) = null output,
        @DESCRIPTION nvarchar(255) = null output,
        @LOCNAME nvarchar(500) = null output,
        @DATE datetime = null output,
        @STARTTIME dbo.UDT_HOURMINUTE = null output,
        @ENDTIME dbo.UDT_HOURMINUTE = null output,
        @ONSALEINFO xml = null output,
        @CAPACITY int = null output,
        @PROGRAMID uniqueidentifier = null output
      )
      as
          set nocount on;

          set @DATALOADED = 0;

          select 
              @DATALOADED = 1,
              @NAME = EVENT.NAME,
              @DESCRIPTION = EVENT.DESCRIPTION,
              @LOCNAME = dbo.UFN_EVENT_GETLOCATIONNAME(EVENT.ID),
              @DATE = EVENT.STARTDATE,
              @STARTTIME = EVENT.STARTTIME,
              @ENDTIME = EVENT.ENDTIME,
              @ONSALEINFO = dbo.UFN_EVENT_GETONSALEINFO_TOITEMLISTXML(@ID),
              @CAPACITY = EVENT.CAPACITY,
              @PROGRAMID = EVENT.PROGRAMID
          from dbo.EVENT
          where EVENT.ID = @ID

          return 0;