ALTER trigger [dbo].[OtomatikFaturaEmri] on [dbo].[STOKHARDETBAG] AFTER INSERT ,DELETE 
as
begin
  --Param='eFaturaOtomatikTip' Mobil için 5 değerini alıyor. Parametre tablosunda var ise otomatikfatura kayıt yapacak
  if(exists(select 1 from OtomatikFatura with(nolock) where IslemNo=(select IslemNo from inserted)))
  begin
    if(not exists (select 1  from inserted, Parametre where Param='eFaturaOtomatikTip' and  Deger =inserted.FaturaTipi ) )
	begin 
	  delete from OtomatikFatura where IslemNo=(select IslemNo from inserted)
	end
  end
  if(   exists(select 1 from inserted i , Parametre p where Param='eFaturaOtomatikTip'
  and p.Deger<>-1 and p.Deger=i.FaturaTipi ))
  begin 
   if (not exists (select 1 from OtomatikFatura o,inserted i where o.IslemNo=i.IslemNo))
      insert into OtomatikFatura(IslemNo) select IslemNo from inserted
  end
  --if(exists (select 1 from OtomatikFatura where IslemNo=(select IslemNo from deleted) ))
  --begin
  --  delete from OtomatikFatura where IslemNo=(select IslemNo from deleted)
  --end
end