USP_DATAFORMTEMPLATE_ADD_EMAILTESTADDRESSES

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EMAILTESTADDRESSES
(
    @ID uniqueidentifier = null output,
      @CHANGEAGENTID uniqueidentifier = null,
    @EMAILID int,
    @EMAILADDRESSES nvarchar(600),
    @ADDINACTIVESTATUS bit =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()

declare @INACTIVE  bit =0

if(@ADDINACTIVESTATUS =1)
begin
  if exists (select 1 from dbo.EMAIL_INACTIVERECIPIENT as EIR
              inner join dbo.Email as E on E.ID =@EMAILID and E.INACTIVERECIPIENTFROMMONTHS >0
                where EIR.INACTIVEFROMMONTHS >=E.INACTIVERECIPIENTFROMMONTHS and EIR.EMAILADDRESS =  @EMAILADDRESSES)
  begin
    set @INACTIVE = 1;
  end
end

begin try
    -- handle inserting the data

    insert into dbo.EMAILTESTADDRESSES
        (ID, EMAILID, EMAILADDRESSES, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, INACTIVE)
    values
        (@ID, @EMAILID, @EMAILADDRESSES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, isnull(@INACTIVE,0))

end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0