USP_DATAFORMTEMPLATE_ADD_COPYPREVIOUS_PRELOAD

The load procedure used by the edit dataform template "Copy previous scheduling information"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@NUMBER_TOCOPY	int	INOUT	Number of classes to copy
@TO_ACADEMICYEAR	nvarchar(200)	INOUT	Academic year
@TO_ACADEMICYEARID	uniqueidentifier	INOUT
@TO_SESSION	nvarchar(200)	INOUT	Session
@TO_SCHOOL	nvarchar(200)	INOUT	School
@FROM_SCHOOL	nvarchar(200)	INOUT	School
@SCHOOLID	uniqueidentifier	INOUT	School

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_COPYPREVIOUS_PRELOAD
                    (
                        @CURRENTAPPUSERID uniqueidentifier,
                        @NUMBER_TOCOPY int = null output,
                        @TO_ACADEMICYEAR nvarchar(200) = null output,
                        @TO_ACADEMICYEARID uniqueidentifier = null output,
                        @TO_SESSION nvarchar(200) = null output,
                        @TO_SCHOOL nvarchar(200) = null output,
                        @FROM_SCHOOL nvarchar(200) = null output,
                        @SCHOOLID uniqueidentifier = null output
                    )
                    as
                        set nocount on;

                        SELECT
                        @TO_SESSION=s4.DESCRIPTION,
                        @TO_ACADEMICYEAR=A2.DESCRIPTION,
                        @TO_ACADEMICYEARID=A1.ID,
                        @TO_SCHOOL=DBO.UFN_SCHOOL_GETNAME(S1.SCHOOLID),
                        @FROM_SCHOOL=DBO.UFN_SCHOOL_GETNAME(S1.SCHOOLID),
                        @SCHOOLID=S1.SCHOOLID
                        FROM dbo.APPUSERSESSION S0
                        INNER JOIN DBO.UFN_APPUSERSESSION_GETHEADERTEXT(@CURRENTAPPUSERID) S1
                            ON S1.SESSIONID = S0.SESSIONID
                        INNER JOIN ACADEMICYEAR A1 ON A1.ID = S1.ACADEMICYEARID
                        INNER JOIN SESSION S2 ON S2.ID = S0.SESSIONID
                        INNER JOIN SESSIONNAMECODE S4 ON S4.ID = S2.SESSIONNAMECODEID
                        INNER JOIN ACADEMICYEARNAMECODE A2 ON A2.ID = A1.ACADEMICYEARNAMECODEID    
                        WHERE S0.ID = @CURRENTAPPUSERID

                        return 0;