USP_DATAFORMTEMPLATE_VIEW_SCHEDULEDATEADJUSTMENT

The load procedure used by the view dataform template "Date adjustment view"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nchar	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TIMETABLEDAY	varchar(60)	INOUT	TIMETABLEDAY
@NEXTTIMETABLEDAYID	uniqueidentifier	INOUT	NEXTTIMETABLEDAYID
@ADJUSTEDTIMETABLEDAYID	uniqueidentifier	INOUT	ADJUSTEDTIMETABLEDAYID
@DESCRIPTION	varchar(255)	INOUT	DESCRIPTION

Definition

Copy



                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SCHEDULEDATEADJUSTMENT
                (
                    @ID nchar(46),
                    @DATALOADED bit = 0 output,
                    @TIMETABLEDAY varchar(60) = null output,
                    @NEXTTIMETABLEDAYID uniqueidentifier = null output,
                    @ADJUSTEDTIMETABLEDAYID uniqueidentifier = null output,
                    @DESCRIPTION varchar(255) = null output
                )
                as
                    set nocount on

                    declare @SESSIONID uniqueidentifier
                    declare @DATE date

                    set @SESSIONID = convert(uniqueidentifier,substring(@ID,0,37))
                    set @DATE = convert(date,substring(@ID,37,10))

                    set @DATALOADED = 1

                    select
                        @TIMETABLEDAY = 
                            (select CYCLEDAY.DESCRIPTION 
                             from CYCLEDAY 
                             inner join TIMETABLEDAY 
                                on TIMETABLEDAY.CYCLEDAYID = CYCLEDAY.ID 
                             where TIMETABLEDAY.ID = SCHEDULEDATE.TIMETABLEDAYID),
                        @NEXTTIMETABLEDAYID = NEXTTIMETABLEDAYID,
                        @ADJUSTEDTIMETABLEDAYID = ADJUSTEDTIMETABLEDAYID,
                        @DESCRIPTION = DESCRIPTION
                    from 
                        dbo.SCHEDULEDATE
                    left join SCHEDULEDATEADJUSTMENT 
                        on SCHEDULEDATE.DATE = SCHEDULEDATEADJUSTMENT.DATE AND SCHEDULEDATE.SCHOOLID = SCHEDULEDATEADJUSTMENT.SCHOOLID
                    where SCHEDULEDATE.DATE = @DATE AND 
                        SCHEDULEDATE.SCHOOLID = 
                            (select SCHOOLID 
                             from 
                                SESSION 
                             inner join ACADEMICYEAR 
                                on SESSION.ACADEMICYEARID = ACADEMICYEAR.ID 
                             where SESSION.ID = @SESSIONID) AND
                         SCHEDULEDATE.INSESSION = 1

                    return 0