USP_DATAFORMTEMPLATE_ADD_EVENTPRICE

The save procedure used by the add dataform template "Registration Option Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@EVENTREGISTRATIONTYPEID	uniqueidentifier	IN	Registration type
@AMOUNT	money	IN	Registration fee
@RECEIPTAMOUNT	money	IN	Receipt amount
@BENEFIT	xml	IN	Benefits
@COST	money	IN	Cost

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EVENTPRICE(
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,    
                        @EVENTID uniqueidentifier,
                        @EVENTREGISTRATIONTYPEID uniqueidentifier = null,
                        @AMOUNT money = 0,
                        @RECEIPTAMOUNT money = 0,
                        @BENEFIT xml = null,
                        @COST money = 0
                        --@DESIGNATIONAMOUNT money = 0,

                        --@DESIGNATION xml = null

                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;

                        begin try
                            if @ID is null
                                set @ID = newid();

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

                            set @CURRENTDATE = getdate();

                            -- Pull data from the registration type for the new EVENTPRICE fields added in BBEC v1.3

                            declare @NAME nvarchar(100);
                            declare @REGISTRATIONCOUNT int;
                            select
                                @NAME = EVENTREGISTRATIONTYPE.DESCRIPTION,
                                @REGISTRATIONCOUNT =
                                    case
                                        when EVENTREGISTRATIONTYPE.REGISTRATIONCOUNT = 0
                                            then 1
                                        else
                                            EVENTREGISTRATIONTYPE.REGISTRATIONCOUNT
                                    end
                            from
                                dbo.EVENTREGISTRATIONTYPE
                            where
                                EVENTREGISTRATIONTYPE.ID = @EVENTREGISTRATIONTYPEID;

                            insert into dbo.EVENTPRICE
                                (ID, EVENTID, EVENTREGISTRATIONTYPEID, AMOUNT, RECEIPTAMOUNT, COST, NAME, REGISTRATIONCOUNT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                            values
                                (@ID, @EVENTID, @EVENTREGISTRATIONTYPEID, @AMOUNT, @RECEIPTAMOUNT, @COST, @NAME, @REGISTRATIONCOUNT, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

                            exec dbo.USP_EVENTPRICE_GETBENEFITS_ADDFROMXML @ID, @BENEFIT, @CHANGEAGENTID;
                            --exec dbo.USP_EVENTPRICE_GETDESIGNATIONS_ADDFROMXML @ID, @DESIGNATION, @CHANGEAGENTID;


                            end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;