spAddUpdate_EventItemPrices

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@CurrentUsersID	int	IN
@EventItemsID	int	IN
@BackOfficeID	int	IN
@Description	nvarchar(120)	IN
@NumParticipants	int	IN
@Publish	bit	IN
@AllowAnonRegistrants	bit	IN
@MaxUnitsPerTxn	int	IN
@DisplayOrder	int	IN
@EarlybirdEnabled	bit	IN
@EarlybirdStart	datetime	IN
@EarlybirdEnd	datetime	IN

Definition

Copy


            CREATE  PROCEDURE [dbo].[spAddUpdate_EventItemPrices]
(
    @PKID    int output,
    @CurrentUsersID    int,
    @EventItemsID    int,
    @BackOfficeID    int,
    @Description    nvarchar(120),
    @NumParticipants    int,
    @Publish    bit,
    @AllowAnonRegistrants    bit,
    @MaxUnitsPerTxn    int,
    @DisplayOrder    int = 0,
    @EarlybirdEnabled bit = 0,
    @EarlybirdStart    datetime = null,
    @EarlybirdEnd    datetime = null
)
AS

if (@PKID<=0) begin

INSERT INTO EventItemPrices
(
    EventItemsID,
    BackOfficeID,
    Description,
    NumParticipants,
    Publish,
    AllowAnonRegistrants,
    MaxUnitsPerTxn,
    DisplayOrder,
    EarlybirdEnabled,
    EarlybirdStart,
    EarlybirdEnd
)

VALUES
(
    @EventItemsID,
    @BackOfficeID,
    @Description,
    @NumParticipants,
    @Publish,
    @AllowAnonRegistrants,
    @MaxUnitsPerTxn,
    @DisplayOrder,
    @EarlybirdEnabled,
    @EarlybirdStart,
    @EarlybirdEnd
)

SELECT
    @PKID = @@Identity

/*    exec spAuditThis @CurrentUsersID, 1, @Guid, 16*/

end else begin

    UPDATE EventItemPrices SET
        EventItemsID=@EventItemsID,
        BackOfficeID=@BackOfficeID,
        Description=@Description,
        NumParticipants=@NumParticipants,
        Publish=@Publish,
        AllowAnonRegistrants=@AllowAnonRegistrants,
        MaxUnitsPerTxn=@MaxUnitsPerTxn,
        DisplayOrder=@DisplayOrder,
        EarlybirdEnabled=@EarlybirdEnabled,
        EarlybirdStart=@EarlybirdStart,
        EarlybirdEnd=@EarlybirdEnd

    WHERE ID=@PKID

/*    exec spAuditThis @CurrentUsersID, 2, @Guid, 16*/

end