USP_PROGRAMEVENTPRICE_INSERT

Inserts a price related to an event

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@PRICETYPECODEID	uniqueidentifier	IN
@FACEPRICE	money	IN
@SEQUENCE	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



        create procedure dbo.USP_PROGRAMEVENTPRICE_INSERT
        (
            @ID uniqueidentifier,
            @EVENTID uniqueidentifier,
            @PRICETYPECODEID uniqueidentifier,
            @FACEPRICE money,
            @SEQUENCE int,
            @CHANGEAGENTID uniqueidentifier
        )
        as
        begin
            if @ID is null
                set @ID = newid();


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

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            begin try
            insert into dbo.PROGRAMEVENTPRICE
            (
                ID,
                EVENTID,
                PRICETYPECODEID,
                FACEPRICE,
                SEQUENCE,
                ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
            )
            values
            (
                @ID,
                @EVENTID,
                @PRICETYPECODEID,
                @FACEPRICE,
                @SEQUENCE,
                @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
            )
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

        end