USP_EVENTSALESMETHOD_INSERT

Inserts on sale information for an event.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@SALESMETHODID	uniqueidentifier	IN
@ONSALEDATE	date	IN
@ONSALETIME	UDT_HOURMINUTE	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



        create procedure dbo.USP_EVENTSALESMETHOD_INSERT
        (
            @ID uniqueidentifier,
            @EVENTID uniqueidentifier,
            @SALESMETHODID uniqueidentifier,
            @ONSALEDATE date,
            @ONSALETIME dbo.UDT_HOURMINUTE,
            @CHANGEAGENTID uniqueidentifier
        )
        as
        begin
            if @ID is null
                set @ID = newid()

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            begin try 
                insert into dbo.EVENTSALESMETHOD
                (
                    ID,
                    EVENTID,
                    SALESMETHODID,
                    ONSALEDATE,
                    ONSALETIME,
                    ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
                )
                values
                (
                    @ID,
                    @EVENTID,
                    @SALESMETHODID,
                    @ONSALEDATE,
                    @ONSALETIME,
                    @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
                )
            end try     
            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

            -- do work

        end