USP_DATAFORMTEMPLATE_EDIT_SCHEDULE_SIMPLECMSSCHEDULE

The save 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 indicating the ID of the record being edited.
@SCHEDULETYPE	tinyint	IN	Schedule Type
@FREQUENCY	int	IN	Frequency
@FREQUENCYTYPE	tinyint	IN	Frequency Type
@TIME	time	IN	Time

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SCHEDULE_SIMPLECMSSCHEDULE (
    @ID uniqueidentifier,
    @SCHEDULETYPE tinyint,
    @FREQUENCY int,
    @FREQUENCYTYPE tinyint,
    @TIME time(0)
)
as

    set nocount on;

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data


        if @SCHEDULETYPE = 0
        begin
            update dbo.SCHEDULE set
                ENABLED = 0
            where ID = @ID
        end
        else if @SCHEDULETYPE = 1
        begin
            update dbo.SCHEDULE set
                ENABLED = 1,
                TYPECODE =  4,
                FREQUENCY = 1,
                SUBDAYFREQUENCY = @FREQUENCY,
                SUBDAYFREQUENCYTYPECODE = @FREQUENCYTYPE,
                SUBDAYSTARTINGTIME = '00:00:00',
                SUBDAYENDINGTIME = '23:59:59',
                DAYSOFWEEK = 0,
                DAYOFMONTH = 0,
                WEEKCODE = 0,
                DAYOFWEEKCODE = 0,
                MONTHCODE = 0,
                STARTDATE = @CURRENTDATE,
                ENDDATE = null,
                TIME = NULL
            where ID = @ID            
        end
        else
        begin
            update dbo.SCHEDULE set
                ENABLED = 1,
                TYPECODE =  4,
                FREQUENCY = 1,
                SUBDAYFREQUENCY = 0,
                SUBDAYFREQUENCYTYPECODE = 0,
                SUBDAYSTARTINGTIME = null,
                SUBDAYENDINGTIME = null,
                DAYSOFWEEK = 0,
                DAYOFMONTH = 0,
                WEEKCODE = 0,
                DAYOFWEEKCODE = 0,
                MONTHCODE = 0,
                STARTDATE = @CURRENTDATE,
                ENDDATE = null,
                TIME = @TIME
            where ID = @ID  
        end

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;