USP_EMAILTEMPLATEEXTENSION_ADD_EDIT

create procedure dbo.USP_EMAILTEMPLATEEXTENSION_ADD_EDIT
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @EMAILTEMPLATEID int = null,
  @CCEMAILADDRESSES nvarchar(4000) = ''    
)
as

    set nocount on;
    if @ID is null
        set @ID = newid()

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime    
    set @CURRENTDATE = getdate()    

    begin try

    IF @EMAILTEMPLATEID IS NOT NULL AND EXISTS (SELECT * FROM dbo.EMAILTEMPLATEEXTENSION (NOLOCK) WHERE EMAILTEMPLATEID = @EMAILTEMPLATEID)    
      UPDATE dbo.EMAILTEMPLATEEXTENSION SET CCEMAILADDRESSES = @CCEMAILADDRESSES WHERE EMAILTEMPLATEID = @EMAILTEMPLATEID
    ELSE
      INSERT INTO dbo.EMAILTEMPLATEEXTENSION    
       (ID, EMAILTEMPLATEID, CCEMAILADDRESSES, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)    
      VALUES    
       (@ID, @EMAILTEMPLATEID, @CCEMAILADDRESSES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;