spAddUpdate_FundRaiserEventRegistrations

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SolicitorID	int	IN
@Amount	money	IN
@EventTransactionsID	int	IN
@CurrencyType	int	IN

Definition

Copy



CREATE  PROCEDURE dbo.spAddUpdate_FundRaiserEventRegistrations
    (
        @PKID            int output,
        @SolicitorID        int,    
        @Amount            money,     
        @EventTransactionsID    int,
        @CurrencyType        int
    )
    AS

        begin transaction
        if (@PKID<=0)
            begin

            INSERT INTO FundRaiserEventRegistrations
            (
                SolicitorID    ,
                Amount        ,
                EventTransactionsID,
                CurrencyType
            )VALUES(
                @SolicitorID    ,
                @Amount        ,
                @EventTransactionsID,
                @CurrencyType
            )

            SELECT
                @PKID = @@Identity

        end else begin

            UPDATE FundRaiserEventRegistrations SET
                [SolicitorID]        =@SolicitorID,
                [Amount]        =@Amount,
                [EventTransactionsID]    =@EventTransactionsID,
                [CurrencyType]        =@CurrencyType
            WHERE ID=@PKID

        end

        commit transaction