------------------------------------------------------------
-- Insert/Update/Delete Triggers to Invoke Windows service
------------------------------------------------------------

-----------------------------------------------------------------------------------
--If ISG integration has been done with HR previously, delete HR related triggers
-----------------------------------------------------------------------------------

--TBLISLETMELER
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLISLETMELER_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLISLETMELER_I
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLISLETMELER_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLISLETMELER_U
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLISLETMELER_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLISLETMELER_D
    END
GO

--TBLMESLEK
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLMESLEK_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLMESLEK_I
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLMESLEK_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLMESLEK_U
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLMESLEK_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLMESLEK_D
    END
GO

--TBLPOZISYON
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLPOZISYON_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLPOZISYON_I
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLPOZISYON_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLPOZISYON_U
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLPOZISYON_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLPOZISYON_D
    END
GO

--TBLDEPARTMAN
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLDEPARTMAN_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLDEPARTMAN_I
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLDEPARTMAN_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLDEPARTMAN_U
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLDEPARTMAN_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLDEPARTMAN_D
    END
GO

--TBLBIRIM
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLBIRIM_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLBIRIM_I
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLBIRIM_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLBIRIM_U
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLBIRIM_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLBIRIM_D
    END
GO

--TBLOZLUK
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLOZLUK_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLOZLUK_I
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLOZLUK_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLOZLUK_U
    END
GO

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLOZLUK_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLOZLUK_D
    END
GO

--TBLILETISIM
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLILETISIM_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLILETISIM_U
    END
GO

--TBLKIMLIK
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_TBLKIMLIK_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_TBLKIMLIK_U
    END
GO

-----------------------
--L_CAPIFIRM
-----------------------

--Insert
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIFIRM_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIFIRM_I
    END
GO

CREATE TRIGGER NTR_L_CAPIFIRM_I ON L_CAPIFIRM
    AFTER INSERT
AS
    BEGIN
	SET NOCOUNT ON;
        
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT CAST(NR AS varchar(50)),
					'COMPANYID',
					NR,
					'Company',
					'Insert',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM INSERTED
			)
		END

	SET NOCOUNT OFF;
    END
GO

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIFIRM_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIFIRM_U
    END
GO

CREATE TRIGGER NTR_L_CAPIFIRM_U ON L_CAPIFIRM
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
        
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT CAST(NR AS varchar(50)),
					'COMPANYID',
					NR,
					'Company',
					'Update',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM INSERTED
			)

		END

	SET NOCOUNT OFF;
    END
GO

--Delete
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIFIRM_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIFIRM_D
    END
GO

CREATE TRIGGER NTR_L_CAPIFIRM_D ON L_CAPIFIRM
    AFTER DELETE
AS
    BEGIN
	SET NOCOUNT ON;
        
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT CAST(NR AS varchar(50)),
					'COMPANYID',
					NR,
					'Company',
					'Delete',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM DELETED
			)

		END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--L_CAPIDIV
-----------------------

--Insert
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIDIV_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIDIV_I
    END
GO

CREATE TRIGGER NTR_L_CAPIDIV_I ON L_CAPIDIV
    AFTER INSERT
AS
    BEGIN
	SET NOCOUNT ON;
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
				([SOURCEFKID]
				,[SOURCEFKNAME]
				,[COMPANYID]
				,[ENTITYNAME]
				,[OPERATIONTYPE]
				,[LOADTYPE]
				,[INSERTDATE]
				,[SOURCETYPEID]
				,[TARGETTYPEID])
				( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
						'LOCATIONID',
						FIRMNR,
						'Location',
						'Insert',
						'S',--Standard
						GETDATE(),
						3,
						2
					FROM INSERTED
				)
		END

	SET NOCOUNT OFF;
    END
GO

--Update

IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIDIV_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIDIV_U
    END
GO

CREATE TRIGGER NTR_L_CAPIDIV_U ON L_CAPIDIV
    FOR UPDATE
AS
    BEGIN
	SET NOCOUNT ON;

		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

        INSERT INTO [dbo].[TRANSFORMCHANGE]
				([SOURCEFKID]
				,[SOURCEFKNAME]
				,[COMPANYID]
				,[ENTITYNAME]
				,[OPERATIONTYPE]
				,[LOADTYPE]
				,[INSERTDATE]
				,[SOURCETYPEID]
				,[TARGETTYPEID])
				( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
						'LOCATIONID',
						FIRMNR,
						'Location',
						'Update',
						'S',--Standard
						GETDATE(),
						3,
						2
					FROM INSERTED
				)
		END

	SET NOCOUNT OFF;
    END
GO

--Delete
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIDIV_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIDIV_D
    END
GO

CREATE TRIGGER NTR_L_CAPIDIV_D ON L_CAPIDIV
    AFTER DELETE
AS
    BEGIN
	SET NOCOUNT ON;
		
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
				([SOURCEFKID]
				,[SOURCEFKNAME]
				,[COMPANYID]
				,[ENTITYNAME]
				,[OPERATIONTYPE]
				,[LOADTYPE]
				,[INSERTDATE]
				,[SOURCETYPEID]
				,[TARGETTYPEID])
				( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
						'LOCATIONID',
						FIRMNR,
						'Location',
						'Delete',
						'S',--Initial Load					
						GETDATE(),
						3,
						2
					FROM DELETED
				)
		END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--LH_001_TYPEDEF
-----------------------

--Insert
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_TYPEDEF_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_TYPEDEF_I
    END
GO

CREATE TRIGGER NTR_LH_TYPEDEF_I ON LH_001_TYPEDEF
    AFTER INSERT
AS
    BEGIN
	SET NOCOUNT ON;
		
		DECLARE @TYP SMALLINT;
        SET @TYP =
        (
            SELECT TYP
            FROM INSERTED
        );

        IF @TYP = -44
		BEGIN
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN
				INSERT INTO [dbo].[TRANSFORMCHANGE]
						([SOURCEFKID]
						,[SOURCEFKNAME]
						--,[COMPANYID]
						,[ENTITYNAME]
						,[OPERATIONTYPE]
						,[LOADTYPE]
						,[INSERTDATE]
						,[SOURCETYPEID]
						,[TARGETTYPEID])
						( SELECT [EXP],
								'PERSONALJOBID',
								--ISLETME_KODU,
								'Profession',
								'Insert',
								'S',--Standard
								GETDATE(),
								3,
								2
							FROM INSERTED
						)
				END
			END

	SET NOCOUNT OFF;
    END
GO

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_TYPEDEF_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_TYPEDEF_U
    END
GO

CREATE TRIGGER NTR_LH_TYPEDEF_U ON LH_001_TYPEDEF
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
				
		DECLARE @TYP SMALLINT;
        SET @TYP =
        (
            SELECT TYP
            FROM INSERTED
        );

        IF @TYP = -44
		BEGIN
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN
			INSERT INTO [dbo].[TRANSFORMCHANGE]
					([SOURCEFKID]
					,[SOURCEFKNAME]
					--,[COMPANYID]
					,[ENTITYNAME]
					,[OPERATIONTYPE]
					,[LOADTYPE]
					,[INSERTDATE]
					,[SOURCETYPEID]
					,[TARGETTYPEID])
					( SELECT [EXP],
							'PERSONALJOBID',
							--ISLETME_KODU,
							'Profession',
							'Update',
							'S',--Standard
							GETDATE(),
							3,
							2
						FROM INSERTED
					)
			END
		END

	SET NOCOUNT OFF;
    END
GO

--Delete
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_TYPEDEF_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_TYPEDEF_D
    END
GO

CREATE TRIGGER NTR_LH_TYPEDEF_D ON LH_001_TYPEDEF
    AFTER DELETE
AS
    BEGIN
	SET NOCOUNT ON;
			
		DECLARE @TYP SMALLINT;
        SET @TYP =
        (
            SELECT TYP
            FROM DELETED
        );

        IF @TYP = -44
		BEGIN	
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN
			INSERT INTO [dbo].[TRANSFORMCHANGE]
					([SOURCEFKID]
					,[SOURCEFKNAME]
					--,[COMPANYID]
					,[ENTITYNAME]
					,[OPERATIONTYPE]
					,[LOADTYPE]
					,[INSERTDATE]
					,[SOURCETYPEID]
					,[TARGETTYPEID])
					( SELECT [EXP],
							'PERSONALJOBID',
							--ISLETME_KODU,
							'Profession',
							'Delete',
							'S',--Standard
							GETDATE(),
							3,
							2
						FROM DELETED
					)

			END
		END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--LH_001_QUALFDEF
-----------------------

--Insert
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_QUALFDEF_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_QUALFDEF_I
    END
GO

CREATE TRIGGER NTR_LH_QUALFDEF_I ON LH_001_QUALFDEF
    AFTER INSERT
AS
    BEGIN
	SET NOCOUNT ON;
		
		DECLARE @TYP SMALLINT;
        SET @TYP =
        (
            SELECT TYP
            FROM INSERTED
        );

        IF @TYP = 9
		BEGIN
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN

			INSERT INTO [dbo].[TRANSFORMCHANGE]
			   ([SOURCEFKID]
			   ,[SOURCEFKNAME]
			   --,[COMPANYID]
			   ,[ENTITYNAME]
			   ,[OPERATIONTYPE]
			   ,[LOADTYPE]
			   ,[INSERTDATE]
			   ,[SOURCETYPEID]
			   ,[TARGETTYPEID])
			   ( SELECT CODE,
						'PERSONELTITLEID',
						--ISLETME_KODU,
						'Position',
						'Insert',
						'S',--Standard
						GETDATE(),
						3,
						2
				 FROM INSERTED
				)
			END
		END

	SET NOCOUNT OFF;
    END
GO

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_QUALFDEF_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_QUALFDEF_U
    END
GO

CREATE TRIGGER NTR_LH_QUALFDEF_U ON LH_001_QUALFDEF
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
		
		DECLARE @TYP SMALLINT;
        SET @TYP =
        (
            SELECT TYP
            FROM INSERTED
        );

        IF @TYP = 9
		BEGIN
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN

			INSERT INTO [dbo].[TRANSFORMCHANGE]
			   ([SOURCEFKID]
			   ,[SOURCEFKNAME]
			   --,[COMPANYID]
			   ,[ENTITYNAME]
			   ,[OPERATIONTYPE]
			   ,[LOADTYPE]
			   ,[INSERTDATE]
			   ,[SOURCETYPEID]
			   ,[TARGETTYPEID])
			   ( SELECT CODE,
						'PERSONELTITLEID',
						--ISLETME_KODU,
						'Position',
						'Update',
						'S',--Standard
						GETDATE(),
						3,
						2
				 FROM INSERTED
				)
			END
		END

	SET NOCOUNT OFF;
    END
GO

--Delete
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_QUALFDEF_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_QUALFDEF_D
    END
GO

CREATE TRIGGER NTR_LH_QUALFDEF_D ON LH_001_QUALFDEF
    AFTER DELETE
AS
    BEGIN
	SET NOCOUNT ON;
		DECLARE @TYP SMALLINT;
        SET @TYP =
        (
            SELECT TYP
            FROM DELETED
        );

        IF @TYP = 9
		BEGIN
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN

			INSERT INTO [dbo].[TRANSFORMCHANGE]
			   ([SOURCEFKID]
			   ,[SOURCEFKNAME]
			   --,[COMPANYID]
			   ,[ENTITYNAME]
			   ,[OPERATIONTYPE]
			   ,[LOADTYPE]
			   ,[INSERTDATE]
			   ,[SOURCETYPEID]
			   ,[TARGETTYPEID])
			   ( SELECT CODE,
						'PERSONELTITLEID',
						--ISLETME_KODU,
						'Position',
						'Delete',
						'S',--Standard
						GETDATE(),
						3,
						2
				 FROM DELETED
				)
			END
		END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--L_CAPIDEPT
-----------------------

--Insert
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIDEPT_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIDEPT_I
    END
GO

CREATE TRIGGER NTR_L_CAPIDEPT_I ON L_CAPIDEPT
    AFTER INSERT
AS
    BEGIN
	SET NOCOUNT ON;
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN
		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
					'DEPARTMENTID',
					FIRMNR,
					'Department',
					'Insert',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM INSERTED
			)
		END

	SET NOCOUNT OFF;
    END
GO

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIDEPT_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIDEPT_U
    END
GO

CREATE TRIGGER NTR_L_CAPIDEPT_U ON L_CAPIDEPT
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN
		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
					'DEPARTMENTID',
					FIRMNR,
					'Department',
					'Update',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM INSERTED
			)

			END

	SET NOCOUNT OFF;
    END
GO

EXEC sp_settriggerorder @triggername = 'NTR_L_CAPIDEPT_U', 
@order = 'last', 
@stmttype = 'update', 
@namespace = null 

GO

--Delete
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIDEPT_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIDEPT_D
    END
GO

CREATE TRIGGER NTR_L_CAPIDEPT_D ON L_CAPIDEPT
    AFTER DELETE
AS
    BEGIN
	SET NOCOUNT ON;
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
					'DEPARTMENTID',
					FIRMNR,
					'Department',
					'Delete',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM DELETED
			)

			END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--L_CAPIUNIT
-----------------------

--Insert
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIUNIT_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIUNIT_I
    END
GO

CREATE TRIGGER NTR_L_CAPIUNIT_I ON L_CAPIUNIT
    AFTER INSERT
AS
    BEGIN
	SET NOCOUNT ON;
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
					'DEPARTMENTUNITID',
					FIRMNR,
					'DepartmentUnit',
					'Insert',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM INSERTED
			)
		END

	SET NOCOUNT OFF;
    END
GO

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIUNIT_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIUNIT_U
    END
GO

CREATE TRIGGER NTR_L_CAPIUNIT_U ON L_CAPIUNIT
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
		
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
					'DEPARTMENTUNITID',
					FIRMNR,
					'DepartmentUnit',
					'Update',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM INSERTED
			)
		END

	SET NOCOUNT OFF;
    END

GO

EXEC sp_settriggerorder @triggername = 'NTR_L_CAPIUNIT_U', 
@order = 'last', 
@stmttype = 'update', 
@namespace = null 

GO

--Delete
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_L_CAPIUNIT_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_L_CAPIUNIT_D
    END
GO

CREATE TRIGGER NTR_L_CAPIUNIT_D ON L_CAPIUNIT
    AFTER DELETE
AS
    BEGIN
	SET NOCOUNT ON;
		
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
           ([SOURCEFKID]
           ,[SOURCEFKNAME]
           ,[COMPANYID]
           ,[ENTITYNAME]
           ,[OPERATIONTYPE]
           ,[LOADTYPE]
           ,[INSERTDATE]
           ,[SOURCETYPEID]
           ,[TARGETTYPEID])
           ( SELECT ISNULL(CAST(FIRMNR AS VARCHAR(20)),'') + '_' + ISNULL(CAST(NR AS VARCHAR(20)),''),
					'DEPARTMENTUNITID',
					FIRMNR,
					'DepartmentUnit',
					'Delete',
					'S',--Standard
					GETDATE(),
					3,
					2
		     FROM DELETED
			)

		END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--LH_001_PERSON
-----------------------

--Insert
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_PERSON_I')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_PERSON_I
    END
GO

CREATE TRIGGER NTR_LH_PERSON_I ON LH_001_PERSON
    AFTER INSERT
AS
    BEGIN
	SET NOCOUNT ON;
			
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN
		INSERT INTO [dbo].[TRANSFORMCHANGE]
				([SOURCEFKID]
				,[SOURCEFKNAME]
				,[COMPANYID]
				,[ENTITYNAME]
				,[OPERATIONTYPE]
				,[LOADTYPE]
				,[INSERTDATE]
				,[SOURCETYPEID]
				,[TARGETTYPEID])
				( SELECT CAST(LREF AS VARCHAR(50)),
						'PERSONELID',
						FIRMNR,
						'Employee',
						'Insert',
						'S',--Standard
						GETDATE(),
						3,
						2
					FROM INSERTED
					WHERE TYP = 1 --Sadece aktifler
				)
		END

	SET NOCOUNT OFF;
    END
GO

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_PERSON_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_PERSON_U
    END
GO

CREATE TRIGGER NTR_LH_PERSON_U ON LH_001_PERSON
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
				
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
				([SOURCEFKID]
				,[SOURCEFKNAME]
				,[COMPANYID]
				,[ENTITYNAME]
				,[OPERATIONTYPE]
				,[LOADTYPE]
				,[INSERTDATE]
				,[SOURCETYPEID]
				,[TARGETTYPEID])
				( SELECT CAST(LREF AS VARCHAR(50)),
						'PERSONELID',
						FIRMNR,
						'Employee',
						'Update',
						'S',--Standard
						GETDATE(),
						3,
						2
					FROM INSERTED
					WHERE TYP = 1 --Sadece aktifler
				)
		END

	SET NOCOUNT OFF;
    END
GO

EXEC sp_settriggerorder @triggername = 'NTR_LH_PERSON_U', 
@order = 'last', 
@stmttype = 'update', 
@namespace = null 

GO

--Delete
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_PERSON_D')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_PERSON_D
    END
GO

CREATE TRIGGER NTR_LH_PERSON_D ON LH_001_PERSON
    AFTER DELETE
AS
    BEGIN
	SET NOCOUNT ON;
				
		IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
                    AND TYPE IN ( N'U' ) )
		BEGIN

		INSERT INTO [dbo].[TRANSFORMCHANGE]
				([SOURCEFKID]
				,[SOURCEFKNAME]
				,[COMPANYID]
				,[ENTITYNAME]
				,[OPERATIONTYPE]
				,[LOADTYPE]
				,[INSERTDATE]
				,[SOURCETYPEID]
				,[TARGETTYPEID])
				( SELECT CAST(LREF AS VARCHAR(50)),
						'PERSONELID',
						FIRMNR,
						'Employee',
						'Delete',
						'S',--Standard
						GETDATE(),
						3,
						2
					FROM DELETED
					WHERE TYP = 1 --Sadece aktifler
				)

		END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--LH_001_CONTACT
-----------------------

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_CONTACT_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_CONTACT_U
    END
GO

CREATE TRIGGER NTR_LH_CONTACT_U ON LH_001_CONTACT
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
			
		DECLARE @TYP SMALLINT;
		DECLARE @LNNR SMALLINT;

		SELECT @TYP = TYP, @LNNR = LNNR
		FROM INSERTED

		IF ((@TYP=3 AND @LNNR=2) OR (@TYP=3 AND @LNNR=1) OR (@TYP=2 AND @LNNR=1) OR (@TYP=6 AND @LNNR=1) OR (@TYP=1 AND @LNNR=1) OR (@TYP=6 AND @LNNR=2) ) --UPDATE(SAHSICEPTEL) OR UPDATE(ISCEPTEL) OR UPDATE(EVTEL) OR UPDATE(ISMAIL) OR UPDATE(EVADRESI) OR UPDATE(SAHSIMAIL)
		BEGIN
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN

			INSERT INTO [dbo].[TRANSFORMCHANGE]
					([SOURCEFKID]
					,[SOURCEFKNAME]
					,[ENTITYNAME]
					,[OPERATIONTYPE]
					,[LOADTYPE]
					,[INSERTDATE]
					,[SOURCETYPEID]
					,[TARGETTYPEID])
					( SELECT CAST(CARDREF AS VARCHAR(50)),
							'PERSONELID',
							'Employee',
							'Update',
							'S',--Standard
							GETDATE(),
							3,
							2
						FROM INSERTED
					)
			END
		END

	SET NOCOUNT OFF;
    END
GO

-----------------------
--LH_001_PERIDINF
-----------------------

--Update
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   object_id = OBJECT_ID(N'NTR_LH_PERIDINF_U')
                    AND TYPE IN ( N'TR' ) )
    BEGIN
        DROP TRIGGER NTR_LH_PERIDINF_U
    END
GO

CREATE TRIGGER NTR_LH_PERIDINF_U ON LH_001_PERIDINF
    AFTER UPDATE
AS
    BEGIN
	SET NOCOUNT ON;
			
		
		IF UPDATE(IDTCNO) OR UPDATE(BIRTHPLACE) OR UPDATE([STATUS]) OR UPDATE(BLOODGROUP)
		BEGIN
			IF EXISTS ( SELECT  *
				FROM    sys.objects
				WHERE   object_id = OBJECT_ID(N'TRANSFORMCHANGE')
						AND TYPE IN ( N'U' ) )
			BEGIN

			INSERT INTO [dbo].[TRANSFORMCHANGE]
					([SOURCEFKID]
					,[SOURCEFKNAME]
					,[ENTITYNAME]
					,[OPERATIONTYPE]
					,[LOADTYPE]
					,[INSERTDATE]
					,[SOURCETYPEID]
					,[TARGETTYPEID])
					( SELECT CAST(F.PERREF AS VARCHAR(50)),	--OZLUKID
							'PERSONELID',
							'Employee',
							'Update',
							'S',--Standard
							GETDATE(),
							3,
							2
						FROM INSERTED I
							INNER JOIN LH_001_FAMILY F WITH(NOLOCK)
								ON I.LREF = F.IDREF
									AND F.RELATION = 0
					)
			END
		END

	SET NOCOUNT OFF;
    END
GO