spAddUpdate_FundRaiserDonations

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SolicitorID	int	IN
@Amount	money	IN
@IsOffline	bit	IN
@DonationTransactionsID	int	IN
@CurrencyType	int	IN
@IsAthon	bit	IN
@InvoiceDate	datetime	IN
@InvoicePaid	bit	IN
@PledgeID	int	IN
@GiftBackOfficeID	int	IN
@IsChangeBucket	bit	IN
Definition

Copy


            CREATE       PROCEDURE [dbo].[spAddUpdate_FundRaiserDonations]
            (
            @PKID            int output,
            @SolicitorID        int,
            @Amount            money,
            @IsOffline           bit,
            @DonationTransactionsID    int,
            @CurrencyType        int,
            @IsAthon        bit,
            @InvoiceDate        datetime,
            @InvoicePaid        bit,
            @PledgeID        int,
            @GiftBackOfficeID    int,
            @IsChangeBucket bit
            )
            AS

            begin transaction
            if (@PKID<=0)
            begin

            INSERT INTO FundRaiserDonations
            (
            SolicitorID    ,
            Amount        ,
            IsOffline    ,
            DonationTransactionsID,
            CurrencyType    ,
            IsAthon        ,
            InvoiceDate    ,
            InvoicePaid    ,
            PledgeID    ,
            GiftBackOfficeID,
            IsChangeBucket
            )VALUES(
            @SolicitorID    ,
            @Amount        ,
            @IsOffline    ,
            @DonationTransactionsID,
            @CurrencyType    ,
            @IsAthon    ,
            @InvoiceDate    ,
            @InvoicePaid    ,
            @PledgeID    ,
            @GiftBackOfficeID,
            @IsChangeBucket
            )

            SELECT
            @PKID = @@Identity

            end else begin

            UPDATE FundRaiserDonations SET
            [SolicitorID]        =@SolicitorID,
            [Amount]        =@Amount,
            [IsOffline]        =@IsOffline,
            [DonationTransactionsID]=@DonationTransactionsID,
            [CurrencyType]        =@CurrencyType,
            [IsAthon]        =@IsAthon,
            [InvoiceDate]        =@InvoiceDate,
            [InvoicePaid]        =@InvoicePaid,
            [PledgeID]        =@PledgeID,
            [GiftBackOfficeID]    =@GiftBackOfficeID,
            [IsChangeBucket]    = @IsChangeBucket
            WHERE ID=@PKID

            end

            commit transaction