USP_DATAFORMTEMPLATE_EDITLOAD_EVENTJOBOCCURRENCE

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@JOBID	uniqueidentifier	INOUT	Job
@DESCRIPTION	nvarchar(30)	INOUT	Occurrence name
@DEPARTMENTCODEID	uniqueidentifier	INOUT	Department
@LOCATIONCODEID	uniqueidentifier	INOUT	Location
@TYPECODE	tinyint	INOUT	Type
@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
@DAYOFWEEKCODE	tinyint	INOUT	Day of week
@VOLUNTEERSNEEDED	int	INOUT	Volunteers needed
@COMMENTS	nvarchar(max)	INOUT	Comment
@SITEREQUIRED	bit	INOUT	Site required
@SITEID	uniqueidentifier	INOUT	Site
@ESTIMATEDVALUE	money	INOUT	Estimated value
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@RECURRENCESTARTDATE	datetime	INOUT
@RECURRENCEENDDATE	datetime	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_EVENTJOBOCCURRENCE]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @JOBID uniqueidentifier = null output,
  @DESCRIPTION nvarchar(30) = null output,
  @DEPARTMENTCODEID uniqueidentifier = null output,
  @LOCATIONCODEID uniqueidentifier = null output,
  @TYPECODE tinyint = null output,
  @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,
  @DAYOFWEEKCODE tinyint = null output,
  @VOLUNTEERSNEEDED integer = null output,
  @COMMENTS nvarchar(max) = null output,
  @SITEREQUIRED bit = null output,
  @SITEID uniqueidentifier = null output,
  @ESTIMATEDVALUE money = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @RECURRENCESTARTDATE datetime = null output,
  @RECURRENCEENDDATE datetime = null output
)
as

  set nocount on;

  set @DATALOADED = 0
  set @TSLONG = 0

  select
    @DATALOADED = 1,
    @JOBID = [JOBID],
    @DESCRIPTION = [DESCRIPTION],
    @DEPARTMENTCODEID = [DEPARTMENTCODEID],
    @LOCATIONCODEID = [LOCATIONCODEID],
    @TYPECODE = [TYPECODE],
    @STARTDATE = [STARTDATE],
    @ENDDATE = [ENDDATE],
    @STARTMONTHDAY = [STARTMONTHDAY],
    @ENDMONTHDAY = [ENDMONTHDAY],
    @ONESTARTTIME = case when [TYPECODE] = 0 then [STARTTIME] else '' end,
    @ONEENDTIME = case when [TYPECODE] = 0 then [ENDTIME] else '' end,
    @RECSTARTTIME = case when [TYPECODE] <> 0 then [STARTTIME] else '' end,
    @RECENDTIME = case when [TYPECODE] <> 0 then [ENDTIME] else '' end,
    @DAYOFWEEKCODE = [DAYOFWEEKCODE],
    @VOLUNTEERSNEEDED = [VOLUNTEERSNEEDED],
    @COMMENTS = [COMMENTS],
    @BASECURRENCYID = [BASECURRENCYID],
    @ESTIMATEDVALUE = [ESTIMATEDVALUE],
    @SITEID = [SITEID],
    @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSER](@CURRENTAPPUSERID),
    @TSLONG = [TSLONG],
    @RECURRENCESTARTDATE = [RECURRENCESTARTDATE],
    @RECURRENCEENDDATE = [RECURRENCEENDDATE]
  from dbo.[JOBOCCURRENCE]
  where [ID] = @ID

  return 0;