spAddUpdate_EventItemCapacity

Parameters

Parameter	Parameter Type	Mode
@EventTransactionsID	int	IN
@EventItemPriceBackOfficeID	int	IN
@NumRegistrants	int	IN
@GiftAmount	money	IN
@NumberOfUnits	int	IN

Definition

Copy



CREATE     procedure dbo.spAddUpdate_EventItemCapacity(@EventTransactionsID int,@EventItemPriceBackOfficeID int, @NumRegistrants int, @GiftAmount money, @NumberOfUnits int)
    as
    if not exists (select null from dbo.EventItemCapacity 
        where EventTransactionsID=@EventTransactionsID
        and EventItemPriceBackOfficeID=@EventItemPriceBackOfficeID)
    begin
        insert into dbo.EventItemCapacity
        (EventTransactionsID,EventItemPriceBackOfficeID,NumRegistrants,GiftAmount,NumberOfUnits) 
        values
        (@EventTransactionsID,@EventItemPriceBackOfficeID,@NumRegistrants,@GiftAmount,@NumberOfUnits) 
    end
    else
    begin
        update dbo.EventItemCapacity
        set NumRegistrants=NumRegistrants+@NumRegistrants, GiftAmount = GiftAmount + @GiftAmount, NumberOfUnits = NumberOfUnits + @NumberOfUnits
        where EventTransactionsID=@EventTransactionsID
        and EventItemPriceBackOfficeID=@EventItemPriceBackOfficeID
    end