spAddUpdate_FundraiserSolicitorContactAction

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@FundraiserSolicitorContactID	int	IN
@AddressbookContactsID	int	IN
@FundraiserSolicitorsID	int	IN
@Type	tinyint	IN
@Status	tinyint	IN
@StatusReport	ntext	IN
@FundRaiserDonationsID	int	IN
@FundRaiserSolicitorEmailID	int	IN
@EmailJobRecipientID	int	IN
@EmailRecipientID	int	IN
@ForwardEmailJobRecipientID	int	IN
@ForwardingContactActionID	int	IN

Definition

Copy



CREATE      PROCEDURE dbo.spAddUpdate_FundraiserSolicitorContactAction
(
    @PKID                            int output,
    @FundraiserSolicitorContactID    int,        
    @AddressbookContactsID            int,
    @FundraiserSolicitorsID            int,
    @Type                            tinyint,
    @Status                            tinyint,
    @StatusReport                    ntext,
    @FundRaiserDonationsID            int,
    @FundRaiserSolicitorEmailID        int,
    @EmailJobRecipientID            int,
    @EmailRecipientID                int,
    @ForwardEmailJobRecipientID        int,
    @ForwardingContactActionID        int

)
AS

    begin transaction
    if (@PKID<=0)
        begin

        INSERT INTO FundraiserSolicitorContactAction
        (
            [FundraiserSolicitorContactID],
            [AddressbookContactsID]    ,
            [FundraiserSolicitorsID],
            [Type],
            [Status],
            [StatusReport],
            [FundRaiserDonationsID],
            [FundRaiserSolicitorEmailID],
            [EmailJobRecipientID],
            [EmailRecipientID],
            [ForwardEmailJobRecipientID],
            [ForwardingContactActionID]

        )VALUES(
            @FundraiserSolicitorContactID,
            @AddressbookContactsID,
            @FundraiserSolicitorsID,
            @Type,
            @Status,
            @StatusReport,
            @FundRaiserDonationsID,
            @FundRaiserSolicitorEmailID,
            @EmailJobRecipientID,
            @EmailRecipientID,
            @ForwardEmailJobRecipientID,
            @ForwardingContactActionID
        )

        SELECT
            @PKID = @@Identity

    end else begin

        UPDATE FundraiserSolicitorContactAction SET
            [FundraiserSolicitorContactID]    = @FundraiserSolicitorContactID,
            [AddressbookContactsID]         = @AddressbookContactsID,
            [FundraiserSolicitorsID]         = @FundraiserSolicitorsID,
            [Type]                             = @Type,
            [Status]                         = @Status,
            [StatusReport]                     = @StatusReport,
            [UpdateDate]                    = getutcdate(),
            [FundRaiserDonationsID]            = @FundRaiserDonationsID,
            [FundRaiserSolicitorEmailID]     = @FundRaiserSolicitorEmailID,
            [EmailJobRecipientID]             = @EmailJobRecipientID,
            [EmailRecipientID]                = @EmailRecipientID,
            [ForwardEmailJobRecipientID]    = @ForwardEmailJobRecipientID,
            [ForwardingContactActionID]        = @ForwardingContactActionID

        WHERE ID=@PKID

    end

    commit transaction