USP_DATAFORMTEMPLATE_EDIT_EVENTMANAGEMENTOPTIONS_2

The save 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 indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@HASTASKSANDCOORDINATORS	bit	IN	Tasks/Coordinators
@HASREGISTRANTSANDOPTIONS	bit	IN	Registrants/Options
@HASSPEAKERS	bit	IN	Speakers
@HASEXPENSES	bit	IN	Expenses
@HASINVITATIONS	bit	IN	Invitations
@HASAPPEALS	bit	IN	Appeals
@HASDOCUMENTATION	bit	IN	Documentation
@HASJOBOCCURRENCES	bit	IN	Job occurrences
@HASLODGINGOPTIONS	bit	IN	Lodging options
@HASCAMPAIGNS	bit	IN	Campaigns
Definition

Copy


                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTMANAGEMENTOPTIONS_2 (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @HASTASKSANDCOORDINATORS bit,
                        @HASREGISTRANTSANDOPTIONS bit,
                        @HASSPEAKERS bit,
                        @HASEXPENSES bit,
                        @HASINVITATIONS bit,
                        @HASAPPEALS bit,
                        @HASDOCUMENTATION bit,
                        @HASJOBOCCURRENCES bit,
                        @HASLODGINGOPTIONS bit,
                        @HASCAMPAIGNS bit
                    )
                    as

                        set nocount on;

                        if @CHANGEAGENTID is null  
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        declare @EVENTMANAGEMENTOPTIONSID uniqueidentifier;
                        select @EVENTMANAGEMENTOPTIONSID = ID
                        from dbo.EVENTMANAGEMENTOPTIONS
                        where EVENTID = @ID

                        begin try
                            if @HASTASKSANDCOORDINATORS = 0
                                if exists (select 1 from dbo.EVENTTASK where EVENTID = @ID)
                                    raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASTASKSANDCOORDINATORS_EVENTTASK', 13, 1);
                                else if exists (select 1 from dbo.EVENTCOORDINATOR where EVENTID = @ID)
                                    raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASTASKSANDCOORDINATORS_EVENTCOORDINATOR', 13, 1);

                            if @HASREGISTRANTSANDOPTIONS = 0
                                if exists (select 1 from dbo.REGISTRANT where EVENTID = @ID)
                                    raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASREGISTRANTSANDOPTIONS_REGISTRANT', 13, 1);
                                else if exists (select 1 from dbo.EVENTPRICE where EVENTID = @ID)
                                    raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASREGISTRANTSANDOPTIONS_EVENTPRICE', 13, 1);
                                else if exists (select 1 from dbo.EVENTPREFERENCEGROUP where EVENTID = @ID)
                                    raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASREGISTRANTSANDOPTIONS_EVENTPREFERENCEGROUP', 13, 1);

                            if @HASSPEAKERS = 0
                                and exists (select 1 from dbo.EVENTSPEAKER where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASSPEAKERS', 13, 1);
                            end

                            if @HASEXPENSES = 0
                                and exists (select 1 from dbo.EVENTEXPENSE where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASEXPENSES', 13, 1);
                            end

                            if @HASINVITATIONS = 0
                                and exists (select 1 from dbo.INVITATION where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASINVITATIONS', 13, 1);
                            end

                            if @HASAPPEALS = 0
                                and exists (select 1 from dbo.EVENTAPPEAL where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASAPPEALS', 13, 1);
                            end

                            if @HASDOCUMENTATION = 0
                                and exists (select 1 from dbo.EVENTNOTE where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASDOCUMENTATION', 13, 1);
                            end

                            if @HASJOBOCCURRENCES = 0
                                and exists (select 1 from dbo.JOBOCCURRENCE where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASJOBOCCURRENCES', 13, 1);
                            end

                            if @HASLODGINGOPTIONS = 0
                                and exists (select 1 from dbo.EVENTLODGING where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASLODGINGOPTIONS', 13, 1);
                            end

                            if @HASCAMPAIGNS = 0
                                and exists (select 1 from dbo.EVENTCAMPAIGN where EVENTID = @ID)
                            begin
                                raiserror('ERR_EVENTMANAGEMENTOPTIONS_HASCAMPAIGNS', 13, 1);
                            end

                            update dbo.EVENTMANAGEMENTOPTIONS set
                                HASTASKSANDCOORDINATORS = @HASTASKSANDCOORDINATORS,
                                HASREGISTRANTSANDOPTIONS = @HASREGISTRANTSANDOPTIONS,
                                HASSPEAKERS = @HASSPEAKERS,
                                HASEXPENSES = @HASEXPENSES,
                                HASINVITATIONS = @HASINVITATIONS,
                                HASAPPEALS = @HASAPPEALS,
                                HASDOCUMENTATION = @HASDOCUMENTATION,
                                HASJOBOCCURRENCES = @HASJOBOCCURRENCES,
                                HASLODGINGOPTIONS = @HASLODGINGOPTIONS,
                                HASCAMPAIGNS = @HASCAMPAIGNS,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                            where ID = @EVENTMANAGEMENTOPTIONSID
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR
                            return 1
                        end catch

                    return 0;