USP_DATAFORMTEMPLATE_EDITLOAD_SCHEDULE_SIMPLECMSSCHEDULE

The load procedure used by the edit dataform template "Simple 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.
@SCHEDULETYPE	tinyint	INOUT	Schedule Type
@FREQUENCY	int	INOUT	Frequency
@FREQUENCYTYPE	tinyint	INOUT	Frequency Type
@TIME	time	INOUT	Time

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SCHEDULE_SIMPLECMSSCHEDULE(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @SCHEDULETYPE tinyint = null output,
    @FREQUENCY int = null output,
    @FREQUENCYTYPE tinyint = null output,
    @TIME time(0) = null output
)
as

    set nocount on;

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

    set @DATALOADED = 0

    declare @TYPECODE tinyint    
    declare @ENABLED bit = 0
    select         
        @DATALOADED = 1,
        @TYPECODE = TYPECODE,
        @ENABLED = ENABLED,
        @FREQUENCYTYPE = SUBDAYFREQUENCYTYPECODE,
        @FREQUENCY = SUBDAYFREQUENCY,
        @TIME = TIME
    from dbo.SCHEDULE
    where ID = @ID

    if @DATALOADED = 1
    begin
        --The schedule isnt enabled, or its not a valid "simple" schedule

        if @ENABLED = 0 or @TYPECODE <> 4
        begin
            set @SCHEDULETYPE = 0;
            set @FREQUENCYTYPE = 0;            
            set @TIME = null;
            Set @FREQUENCY = 0;
        end
        else if @FREQUENCYTYPE = 0 --Enabled daily schedule with None for subday frequency

        begin 
            set @SCHEDULETYPE = 2
        end
        else --Enabled daily schedule with a for subday frequency

        begin
            set @SCHEDULETYPE = 1
        end
    end

    return 0;