USP_EMAILTEMPLATE_DELETE

Executes the "Email Template Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



CREATE procedure dbo.USP_EMAILTEMPLATE_DELETE
(
    @ID int,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    BEGIN
        declare @EmailListID as int
        declare @oldname as nvarchar(92)
        declare @newname as nvarchar(92)

        SELECT @oldname = [Name]
        FROM [dbo].EmailTemplate 
        where id=@ID

        exec spUniqueName @oldname, @newname OUTPUT

        BEGIN TRAN
            UPDATE [dbo].EmailTemplate 
            SET [Name] = @newname,
            [deleted] = 1
            where id=@ID

            SET @EmailListID = (Select [EmailListID] FROM dbo.EmailTemplate_EmailList WHERE EmailTemplateID = @ID)

            delete from [dbo].EmailList where id=@EmailListID

        IF @@ERROR = 0
        BEGIN
            COMMIT TRAN
        END
        ELSE
        BEGIN
            ROLLBACK TRAN
        END
    END


    return 0;

end