USP_DATAFORMTEMPLATE_EDIT_SCHEDULE_CMSSCHEDULE

The save 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 indicating the ID of the record being edited.
@ENABLED	bit	IN	Enabled
@TYPECODE	tinyint	IN	Type code
@FREQUENCY	int	IN	Frequency
@SUBDAYFREQUENCYTYPECODE	tinyint	IN	Integer
@TIME	time	IN	Time
@SUBDAYFREQUENCY	tinyint	IN	Sub day frequency
@SUBDAYSTARTINGTIME	time	IN	Sub day starting time
@SUBDAYENDINGTIME	time	IN	Sub day ending time
@DAYSOFWEEK	tinyint	IN	Day of the week
@DAYOFMONTH	tinyint	IN	Day of the month
@WEEKCODE	tinyint	IN	Week code
@DAYOFWEEKCODE	tinyint	IN	Day of the week code
@MONTHCODE	tinyint	IN	Month code
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date

Definition

Copy



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

    set nocount on;

    begin try
        -- handle updating the data

        update dbo.SCHEDULE set
            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
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;