USP_DATAFORMTEMPLATE_EDIT_PREPROCESS_ADDREQUESTSFORMULTIPLESTUDENTSBUSINESS

The save procedure used by the edit dataform template "Globally Add Requests Business Preprocess Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CREATESTUDENTSIDSET	bit	IN	Create selection from results
@STUDENTSSELECTIONNAME	nvarchar(100)	IN	Selection name
@OVERWRITESTUDENTSSELECTION	bit	IN	Overwrite existing selection
@SESSIONNAMECODEID	uniqueidentifier	IN	Session
@SCHOOLID	uniqueidentifier	IN	School
@ACADEMICYEARID	uniqueidentifier	IN	Academic year
@COURSES	xml	IN	Courses

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PREPROCESS_ADDREQUESTSFORMULTIPLESTUDENTSBUSINESS(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CREATESTUDENTSIDSET bit,
    @STUDENTSSELECTIONNAME nvarchar(100),
    @OVERWRITESTUDENTSSELECTION bit,
    @SESSIONNAMECODEID uniqueidentifier,
    @SCHOOLID uniqueidentifier,
    @ACADEMICYEARID uniqueidentifier,
    @COURSES xml
)
as

set nocount on

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

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

declare @SELECTIONTYPEID uniqueidentifier
select @SELECTIONTYPEID = CASE @CREATESTUDENTSIDSET WHEN 1 THEN ID ELSE NULL END 
    from dbo.RECORDTYPE where upper(NAME) = 'STUDENT'

begin try
    update dbo.ADDREQUESTSFORMULTIPLESTUDENTSPROCESS set
        CREATESTUDENTSIDSET = @CREATESTUDENTSIDSET,
        SELECTIONTYPEID = @SELECTIONTYPEID,
        STUDENTSSELECTIONNAME = @STUDENTSSELECTIONNAME,
        OVERWRITESTUDENTSSELECTION = @OVERWRITESTUDENTSSELECTION,
        SESSIONNAMECODEID = @SESSIONNAMECODEID,
        SCHOOLID = @SCHOOLID,
        ACADEMICYEARID = @ACADEMICYEARID,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CURRENTDATE
    where ID = @ID

    exec dbo.USP_ADDREQUESTSFORMULTIPLESTUDENTS_GETCOURSES_UPDATEFROMXML @ID, @COURSES, @CHANGEAGENTID
end try

begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
end catch

return 0