USP_DATAFORMTEMPLATE_EDITLOAD_SCHEDULE_CMSSCHEDULE

The load procedure used by the edit dataform template "CMS Schedule Edit Data 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.
@ENABLED	bit	INOUT	Enabled
@TYPECODE	tinyint	INOUT	Type code
@FREQUENCY	int	INOUT	Frequency
@SUBDAYFREQUENCYTYPECODE	tinyint	INOUT	Integer
@TIME	time	INOUT	Time
@SUBDAYFREQUENCY	tinyint	INOUT	Sub day frequency
@SUBDAYSTARTINGTIME	time	INOUT	Sub day starting time
@SUBDAYENDINGTIME	time	INOUT	Sub day ending time
@DAYSOFWEEK	tinyint	INOUT	Day of the week
@DAYOFMONTH	tinyint	INOUT	Day of the month
@WEEKCODE	tinyint	INOUT	Week code
@DAYOFWEEKCODE	tinyint	INOUT	Day of the week code
@MONTHCODE	tinyint	INOUT	Month code
@STARTDATE	date	INOUT	Start date
@ENDDATE	date	INOUT	End date

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SCHEDULE_CMSSCHEDULE(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @ENABLED bit = null output,
    @TYPECODE tinyint= null output,
    @FREQUENCY int = null output,
    @SUBDAYFREQUENCYTYPECODE tinyint = null output,
    @TIME time(0) = null output,
    @SUBDAYFREQUENCY tinyint = null output,
    @SUBDAYSTARTINGTIME time(0)  = null output,
    @SUBDAYENDINGTIME time(0)  = null output,
    @DAYSOFWEEK tinyint = null output,
    @DAYOFMONTH tinyint = null output,
    @WEEKCODE tinyint = null output,
    @DAYOFWEEKCODE tinyint = null output,
    @MONTHCODE tinyint = null output,
    @STARTDATE date = null output,
    @ENDDATE date = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows

    set @DATALOADED = 0

    select
        @DATALOADED = 1,
        @ENABLED = ENABLED,
        @TYPECODE = TYPECODE,
        @FREQUENCY = FREQUENCY,
        @SUBDAYFREQUENCYTYPECODE = SUBDAYFREQUENCYTYPECODE,
        @TIME = TIME,
        @SUBDAYFREQUENCY = SUBDAYFREQUENCY,
        @SUBDAYSTARTINGTIME = SUBDAYSTARTINGTIME,
        @SUBDAYENDINGTIME = SUBDAYENDINGTIME,
        @DAYSOFWEEK = DAYSOFWEEK,
        @DAYOFMONTH = DAYOFMONTH,
        @WEEKCODE = WEEKCODE,
        @DAYOFWEEKCODE = DAYOFWEEKCODE,    
        @MONTHCODE = MONTHCODE,    
        @STARTDATE = STARTDATE,    
        @ENDDATE = ENDDATE
    from dbo.SCHEDULE
    where ID = @ID

    return 0;