spAddUpdate_DonationEReceipt

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@DonationTransactionsID	int	IN
@LinkKey	nvarchar(256)	IN
@PDF	varbinary	IN
@Stack	nvarchar(256)	IN
@Sequence	int	IN
Definition

Copy


            CREATE procedure [dbo].[spAddUpdate_DonationEReceipt](
                @PKID int output,
                @DonationTransactionsID int,
                @LinkKey nvarchar(256),
                @PDF varbinary(max),
                @Stack nvarchar(256),
                @Sequence int
            ) as
                if (@PKID<=0) begin
                    insert into dbo.DonationEReceipt
                    (
                        DonationTransactionsID,
                        LinkKey,
                        PDF,
                        Stack,
                        Sequence
                    )
                    values
                    (
                        @DonationTransactionsID,
                        @LinkKey,
                        @PDF,
                        @Stack,
                        @Sequence
                    );
                    select @PKID = @@Identity;
                end else begin
                    update dbo.DonationEReceipt set
                        DonationTransactionsID = @DonationTransactionsID,
                        LinkKey = @LinkKey,
                        PDF = @PDF,
                        Stack = @Stack,
                        Sequence = @Sequence
                    where
                        ID = @PKID;
                end