spFundRaiserSetInvoiceStatus

Parameters

Parameter	Parameter Type	Mode	Description
@FundRaiserDonationID	int	IN
@Action	int	IN

Definition

Copy



CREATE  PROCEDURE dbo.spFundRaiserSetInvoiceStatus(@FundRaiserDonationID int, @Action int)

AS
    BEGIN
        if @Action=14 
            begin
                UPDATE dbo.FundRaiserDonations
                SET [InvoiceDate] = getutcdate()
                WHERE
                ID = @FundRaiserDonationID
            end
        else if @Action=15
            begin
                UPDATE dbo.FundRaiserDonations
                SET [InvoicePaid] = 1
                WHERE
                ID = @FundRaiserDonationID
            end

    END