spAddUpdate_ChapterEmail

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ChapterSiteID	int	IN
@EmailTEmplateID	int	IN
@DisplayName	nvarchar(255)	IN

Definition

Copy



CREATE    PROCEDURE dbo.spAddUpdate_ChapterEmail
(
    @PKID        int output,
    @ChapterSiteID    int,        
    @EmailTEmplateID    int,
    @DisplayName    nvarchar(255)
)
AS

    begin transaction
    if (@PKID<=0)
        begin

        INSERT INTO ChapterEmail
        (
            [ChapterSiteID],
            [EmailTEmplateID],
            [DisplayName]
        )VALUES(
            @ChapterSiteID,
            @EmailTEmplateID,
            @DisplayName
        )

        SELECT
            @PKID = @@Identity

    end else begin

        UPDATE chapterEmail SET
            [ChapterSiteID]    = @ChapterSiteID,
            [EmailTEmplateID]     = @EmailTemplateID,
            [UpdateDate]    = getutcdate(),
            [DisplayName]    = @DisplayName
        WHERE ID=@PKID

    end

    commit transaction