spAddUpdate_FundraiserSolicitorContact

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@AddressbookContactsID	int	IN
@FundraiserSolicitorsID	int	IN
@EmailAddress	nvarchar(255)	IN
@Appeal	bit	IN
@Thanks	bit	IN
@Unsolicited	bit	IN

Definition

Copy



CREATE    PROCEDURE dbo.spAddUpdate_FundraiserSolicitorContact
(
    @PKID            int output,
    @AddressbookContactsID    int,
    @FundraiserSolicitorsID    int,        
    @EmailAddress        nvarchar(255),
    @Appeal            bit,
    @Thanks            bit,
    @Unsolicited        bit
)
AS

    begin transaction
    if (@PKID<=0)
        begin

        INSERT INTO FundraiserSolicitorContact
        (
            [AddressbookContactsID]    ,
            [FundraiserSolicitorsID],
            [EmailAddress],
            [Appeal],
            [Thanks],
            [Unsolicited]
        )VALUES(
            @AddressbookContactsID,
            @FundraiserSolicitorsID,
            @EmailAddress,
            @Appeal,
            @Thanks,
            @Unsolicited
        )

        SELECT
            @PKID = @@Identity

    end else begin

        UPDATE FundraiserSolicitorContact SET
            [AddressbookContactsID]    = @AddressbookContactsID,
            [FundraiserSolicitorsID]= @FundraiserSolicitorsID,
            [EmailAddress]        = @EmailAddress,
            [Appeal]        = @Appeal,
            [Thanks]        = @Thanks,
            [Unsolicited]        = @Unsolicited,
            [UpdateDate]        = getutcdate()
        WHERE ID=@PKID

    end

    commit transaction