USP_DATAFORMTEMPLATE_EDIT_ADDREQUESTSFORMULTIPLESTUDENTSBUSINESS

The save procedure used by the edit dataform template "Globally Add Requests Business Process 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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@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
@CORECURRICULUM	xml	IN
@COURSES	xml	IN	Courses

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ADDREQUESTSFORMULTIPLESTUDENTSBUSINESS
(
        @ID uniqueidentifier,
        @CHANGEAGENTID uniqueidentifier = null,
        @NAME nvarchar(100),
        @DESCRIPTION nvarchar(255),
        @IDSETREGISTERID uniqueidentifier,
        @CREATESTUDENTSIDSET bit,
        @STUDENTSSELECTIONNAME nvarchar(100),
        @OVERWRITESTUDENTSSELECTION bit,
        @SESSIONNAMECODEID uniqueidentifier,
        @SCHOOLID uniqueidentifier,
        @ACADEMICYEARID uniqueidentifier,
        @CORECURRICULUM xml,
        @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
        NAME = @NAME,
        DESCRIPTION = @DESCRIPTION,
        IDSETREGISTERID = @IDSETREGISTERID,
        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_GETCORE_UPDATEFROMXML @ID, @CORECURRICULUM, @CHANGEAGENTID
    exec dbo.USP_ADDREQUESTSFORMULTIPLESTUDENTS_GETCOURSES_UPDATEFROMXML @ID, @COURSES, @CHANGEAGENTID
end try

begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
end catch

return 0