USP_EMAILJOBEXTENSION_ADD_EDIT

CREATE procedure dbo.USP_EMAILJOBEXTENSION_ADD_EDIT
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @EMAILJOBID int = null,
  @EMAILBODY nvarchar(max) = '',
  @TOADDRESS nvarchar(510) = '',
  @TODISPLAYNAME nvarchar(510) = '',
  @CONSTITUENTID uniqueidentifier = null,
  @EVENTID uniqueidentifier = null,
  @REVENUEID uniqueidentifier = null,
  @TEAMID uniqueidentifier = null
)
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 @EMAILJOBID IS NOT NULL AND EXISTS (SELECT * FROM dbo.EMAILJOBEXTENSION (NOLOCK) WHERE EMAILJOBID = @EMAILJOBID)    
      UPDATE dbo.EMAILJOBEXTENSION 
      SET EMAILBODY = @EMAILBODY,
          TOADDRESS = @TOADDRESS,
          TODISPLAYNAME = @TODISPLAYNAME,
          CONSTITUENTID = @CONSTITUENTID,
          EVENTID = @EVENTID,
          REVENUEID = @REVENUEID,
          TEAMID = @TEAMID

      WHERE EMAILJOBID = @EMAILJOBID
    ELSE
      INSERT INTO dbo.EMAILJOBEXTENSION    
      (    ID,
        EMAILJOBID,
        EMAILBODY,
        TOADDRESS,
        TODISPLAYNAME,
        CONSTITUENTID,
        EVENTID,
        REVENUEID,
        TEAMID,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED
      )    
      VALUES    
      (@ID, @EMAILJOBID, @EMAILBODY, @TOADDRESS, @TODISPLAYNAME, @CONSTITUENTID, @EVENTID, @REVENUEID, @TEAMID, 
       @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    

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

return 0;