USP_DATAFORMTEMPLATE_EDITLOAD_EVENTMANAGEMENTOPTIONS

The load procedure used by the edit dataform template "Event Management Options 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.
@HASTASKSANDCOORDINATORS	bit	INOUT	Tasks/Coordinators
@HASREGISTRANTSANDOPTIONS	bit	INOUT	Registrants/Options
@HASSPEAKERS	bit	INOUT	Speakers
@HASEXPENSES	bit	INOUT	Expenses
@HASINVITATIONS	bit	INOUT	Invitations
@HASAPPEALS	bit	INOUT	Appeals
@HASDOCUMENTATION	bit	INOUT	Documentation
@HASJOBOCCURRENCES	bit	INOUT	Job occurrences
@HASLODGINGOPTIONS	bit	INOUT	Lodging options
@HASCAMPAIGNS	bit	INOUT	Campaigns
@DISABLETASKSANDCOORDINATORS	bit	INOUT
@DISABLEREGISTRANTSANDOPTIONS	bit	INOUT
@DISABLESPEAKERS	bit	INOUT
@DISABLEEXPENSES	bit	INOUT
@DISABLEINVITATIONS	bit	INOUT
@DISABLEAPPEALS	bit	INOUT
@DISABLEDOCUMENTATION	bit	INOUT
@DISABLEJOBOCCURRENCES	bit	INOUT
@DISABLELODGINGOPTIONS	bit	INOUT
@DISABLECAMPAIGNS	bit	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTMANAGEMENTOPTIONS(
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @TSLONG bigint = 0 output,
                    @HASTASKSANDCOORDINATORS bit = null output,
                    @HASREGISTRANTSANDOPTIONS bit = null output,
                    @HASSPEAKERS bit = null output,
                    @HASEXPENSES bit = null output,
                    @HASINVITATIONS bit = null output,
                    @HASAPPEALS bit = null output,
                    @HASDOCUMENTATION bit = null output,
                    @HASJOBOCCURRENCES bit = null output,
                    @HASLODGINGOPTIONS bit = null output,
                    @HASCAMPAIGNS    bit = null output,
                    @DISABLETASKSANDCOORDINATORS bit = null output,
                    @DISABLEREGISTRANTSANDOPTIONS bit = null output,
                    @DISABLESPEAKERS bit = null output,
                    @DISABLEEXPENSES bit = null output,
                    @DISABLEINVITATIONS bit = null output,
                    @DISABLEAPPEALS bit = null output,
                    @DISABLEDOCUMENTATION bit = null output,
                    @DISABLEJOBOCCURRENCES bit = null output,
                    @DISABLELODGINGOPTIONS bit = null output,
                    @DISABLECAMPAIGNS bit = null output
                )
                as

                    set nocount on;

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

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

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

                        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.EVENTAPPEAL where EVENTID = @ID)
                            set @DISABLEAPPEALS = 1;

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

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

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

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

                    return 0;