USP_DATAFORMTEMPLATE_EDIT_SCHEDULINGEXCEPTION

The save procedure used by the edit dataform template "Scheduling Exceptions Edit Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DIFFERENTGENDER	bit	IN	Assigned different gender than course
@DIFFERENTSCHOOL	bit	IN	Assigned different school than course
@DIFFERENTGRADELEVEL	bit	IN	Assigned different grade level than course
@ALREADYTAKEN	bit	IN	Has already taken course
@ALREADYREQUESTED	bit	IN	Has already requested course

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SCHEDULINGEXCEPTION (
    @CHANGEAGENTID uniqueidentifier = null,
    @DIFFERENTGENDER bit,
    @DIFFERENTSCHOOL bit,
    @DIFFERENTGRADELEVEL bit,
    @ALREADYTAKEN bit,
    @ALREADYREQUESTED bit
)
as

    set nocount on

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data

        update dbo.SCHEDULINGEXCEPTION set
            DIFFERENTGENDER = @DIFFERENTGENDER,
            DIFFERENTSCHOOL = @DIFFERENTSCHOOL,
            DIFFERENTGRADELEVEL = @DIFFERENTGRADELEVEL,
            ALREADYTAKEN = @ALREADYTAKEN,
            ALREADYREQUESTED = @ALREADYREQUESTED,    
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0