SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Asamco BV, Alex & René
-- Create date: 2023-02-21
-- Description:	Auto-allocates a client group if none.
-- =============================================
CREATE TRIGGER dbo._as_trClientGroup
   ON  dbo.Client
   AFTER INSERT,UPDATE
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- if there is a record that does NOT have a client class
	IF EXISTS (SELECT * FROM inserted I WHERE COALESCE(I.iClassID,0) = 0)
		BEGIN
		DECLARE @DefaultClientGroupId int = (SELECT TOP 1 IdCliClass FROM CliClass CC WHERE Code = 'TRT')
		UPDATE c
			SET c.iClassID = @DefaultClientGroupId
			FROM Client c 
			INNER JOIN inserted I on c.DCLink = I.DCLink

		END

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Asamco BV, Alex & René
-- Create date: 2023-02-21
-- Description:	Auto-allocates a client group if none.
-- =============================================
CREATE TRIGGER dbo._as_trVendorGroup
   ON  dbo.Vendor
   AFTER INSERT,UPDATE
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- if there is a record that does NOT have a client class
	IF EXISTS (SELECT * FROM inserted I WHERE COALESCE(I.iClassID,0) = 0)
		BEGIN
		DECLARE @DefaultVendorGroupId int = (SELECT TOP 1 IdVenClass FROM VenClass CC WHERE Code = 'TPTEUR')
		UPDATE c
			SET c.iClassID = @DefaultVendorGroupId
			FROM Vendor c 
			INNER JOIN inserted I on c.DCLink = I.DCLink

		END
		

END
GO