USP_DATAFORMTEMPLATE_EDITLOAD_EVENTMANAGEMENTPROPERTYGROUP

The load procedure used by the edit dataform template "Event Management Property Group Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@HASREGISTRANTSANDOPTIONS	bit	INOUT	Registrants/Options
@HASSPEAKERS	bit	INOUT	Speakers
@HASEXPENSES	bit	INOUT	Expenses
@HASINVITATIONS	bit	INOUT	Invitations
@HASDOCUMENTATION	bit	INOUT	Documentation
@HASTASKS	bit	INOUT	Tasks
@HASLODGINGOPTIONS	bit	INOUT	Lodging options
@HASJOBOCCURRENCES	bit	INOUT	Job occurrences
@HASAPPEALS	bit	INOUT	Appeals
@DISABLEREGISTRANTSANDOPTIONS	bit	INOUT
@DISABLESPEAKERS	bit	INOUT
@DISABLEEXPENSES	bit	INOUT
@DISABLEINVITATIONS	bit	INOUT
@DISABLEDOCUMENTATION	bit	INOUT
@DISABLETASKS	bit	INOUT
@DISABLELODGINGOPTIONS	bit	INOUT
@DISABLEJOBOCCURRENCES	bit	INOUT
@DISABLEAPPEALS	bit	INOUT

Definition

Copy



                create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTMANAGEMENTPROPERTYGROUP(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @TSLONG bigint = 0 output,
                    @HASREGISTRANTSANDOPTIONS bit = null output,
                    @HASSPEAKERS bit = null output,
                    @HASEXPENSES bit = null output,
                    @HASINVITATIONS bit = null output,
                    @HASDOCUMENTATION bit = null output,
                    @HASTASKS bit = null output,
                    @HASLODGINGOPTIONS bit = null output,
                    @HASJOBOCCURRENCES bit = null output,
                    @HASAPPEALS bit = null output,
                    @DISABLEREGISTRANTSANDOPTIONS bit = null output,
                    @DISABLESPEAKERS bit = null output,
                    @DISABLEEXPENSES bit = null output,
                    @DISABLEINVITATIONS bit = null output,
                    @DISABLEDOCUMENTATION bit = null output,
                    @DISABLETASKS bit = null output,
                    @DISABLELODGINGOPTIONS bit = null output,
                    @DISABLEJOBOCCURRENCES bit = null output,
                    @DISABLEAPPEALS bit = null output
                )
                as

                    set nocount on;

                    set @DATALOADED = 0;
                    set @TSLONG = 0;

                    select
                        @DATALOADED = 1,
                        @TSLONG = EVENTMANAGEMENTPROPERTYGROUP.TSLONG,
                        @HASREGISTRANTSANDOPTIONS = EVENTMANAGEMENTPROPERTYGROUP.HASREGISTRANTSANDOPTIONS,
                        @HASSPEAKERS = EVENTMANAGEMENTPROPERTYGROUP.HASSPEAKERS,
                        @HASEXPENSES = EVENTMANAGEMENTPROPERTYGROUP.HASEXPENSES,
                        @HASINVITATIONS = EVENTMANAGEMENTPROPERTYGROUP.HASINVITATIONS,
                        @HASDOCUMENTATION = EVENTMANAGEMENTPROPERTYGROUP.HASDOCUMENTATION,
                        @HASTASKS = EVENTMANAGEMENTPROPERTYGROUP.HASTASKS,
                        @HASLODGINGOPTIONS = EVENTMANAGEMENTPROPERTYGROUP.HASLODGINGOPTIONS,
                        @HASJOBOCCURRENCES = EVENTMANAGEMENTPROPERTYGROUP.HASJOBOCCURRENCES,
                        @HASAPPEALS = EVENTMANAGEMENTPROPERTYGROUP.HASAPPEALS,
                        @DISABLEREGISTRANTSANDOPTIONS = 0,
                        @DISABLESPEAKERS = 0,
                        @DISABLEEXPENSES = 0,
                        @DISABLEINVITATIONS = 0,
                        @DISABLEDOCUMENTATION = 0,
                        @DISABLETASKS = 0,
                        @DISABLELODGINGOPTIONS = 0,
                        @DISABLEJOBOCCURRENCES = 0,
                        @DISABLEAPPEALS = 0
                    from dbo.EVENT
                        inner join dbo.EVENTMANAGEMENTPROPERTYGROUP on EVENTMANAGEMENTPROPERTYGROUP.EVENTID = EVENT.ID
                    where EVENT.ID = @ID

                    if @DATALOADED = 1
                    begin
                        if exists (select 1 from dbo.REGISTRANT where EVENTID = @ID)
                            or exists (select 1 from dbo.EVENTPRICE where EVENTID = @ID)
                            or exists (select 1 from dbo.EVENTPREFERENCEGROUP where EVENTID = @ID)
                        begin
                            set @DISABLEREGISTRANTSANDOPTIONS = 1;
                        end

                        if exists (select 1 from dbo.EVENTSPEAKER where EVENTID = @ID)
                            set @DISABLESPEAKERS = 1;

                        if exists (select 1 from dbo.EVENTEXPENSE where EVENTID = @ID)
                            set @DISABLEEXPENSES = 1;

                        if exists (select 1 from dbo.INVITATION where EVENTID = @ID)
                            set @DISABLEINVITATIONS = 1;

                        if exists (select 1 from dbo.EVENTNOTE where EVENTID = @ID)
                            set @DISABLEDOCUMENTATION = 1;

                        if exists (select 1 from dbo.EVENTTASK where EVENTID = @ID)
                            or exists (select 1 from dbo.EVENTCOORDINATOR where EVENTID = @ID)
                        begin
                            set @DISABLETASKS = 1;
                        end

                        if exists (select 1 from dbo.EVENTLODGING where EVENTID = @ID)
                            set @DISABLELODGINGOPTIONS = 1;

                        if exists (select 1 from dbo.JOBOCCURRENCE where EVENTID = @ID)
                            set @DISABLEJOBOCCURRENCES = 1;

                        if exists (select 1 from dbo.EVENTAPPEAL where EVENTID = @ID)
                            set @DISABLEAPPEALS = 1;
                    end

                    return 0;