USP_DATAFORMTEMPLATE_ADD_EVENTJOBOCCURRENCE_PRELOAD

The load procedure used by the edit dataform template "Event Job Occurrence Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@STARTMONTHDAY	UDT_MONTHDAY	INOUT	Start date
@ENDMONTHDAY	UDT_MONTHDAY	INOUT	End date
@ONESTARTTIME	UDT_HOURMINUTE	INOUT	Start time
@ONEENDTIME	UDT_HOURMINUTE	INOUT	End time
@RECSTARTTIME	UDT_HOURMINUTE	INOUT	Start time
@RECENDTIME	UDT_HOURMINUTE	INOUT	End time
@SITEREQUIRED	bit	INOUT	Site required
@SITEID	uniqueidentifier	INOUT	Site
@SELECTEDEVENTID	uniqueidentifier	INOUT	Event
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@RECURRENCESTARTDATE	datetime	INOUT
@RECURRENCEENDDATE	datetime	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_EVENTJOBOCCURRENCE_PRELOAD]
(
  @EVENTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @STARTDATE datetime = null output,
  @ENDDATE datetime = null output,
  @STARTMONTHDAY dbo.[UDT_MONTHDAY] = null output,
  @ENDMONTHDAY dbo.[UDT_MONTHDAY] = null output,
  @ONESTARTTIME dbo.[UDT_HOURMINUTE] = null output,
  @ONEENDTIME dbo.[UDT_HOURMINUTE] = null output,
  @RECSTARTTIME dbo.[UDT_HOURMINUTE] = null output,
  @RECENDTIME dbo.[UDT_HOURMINUTE] = null output,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output,
  @SELECTEDEVENTID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @RECURRENCESTARTDATE datetime = null output,
  @RECURRENCEENDDATE datetime = null output
)
as
  set nocount on;

  select
    @STARTDATE = dbo.UFN_DATE_GETEARLIESTTIME([STARTDATE]),
    @ENDDATE = dbo.UFN_DATE_GETEARLIESTTIME([ENDDATE]),
    @STARTMONTHDAY = right('0' + cast(month([STARTDATE]) as nvarchar(2)), 2) + right('0' + cast(day([STARTDATE]) as nvarchar(2)), 2),
    @ENDMONTHDAY = right('0' + cast(month([ENDDATE]) as nvarchar(2)), 2) + right('0' + cast(day([ENDDATE]) as nvarchar(2)), 2), 
    @ONESTARTTIME = [STARTTIME],
    @ONEENDTIME = [ENDTIME],
    @RECSTARTTIME = [STARTTIME],
    @RECENDTIME = [ENDTIME],
    @RECURRENCESTARTDATE = dbo.UFN_DATE_GETEARLIESTTIME([STARTDATE]),
    @RECURRENCEENDDATE = dbo.UFN_DATE_GETEARLIESTTIME([ENDDATE]),
    @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSER](@CURRENTAPPUSERID),
    @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID),
    @BASECURRENCYID = [BASECURRENCYID]
  from dbo.[EVENT]
  where [ID] = @EVENTID;

  set @SELECTEDEVENTID = @EVENTID;

  return 0;