-- Return codes:
-- 0 = ok
-- 1 = excess already exists, not added
CREATE OR REPLACE FUNCTION LUM_MgtLiabConfig_sp_EditPremiumEmployees
(
	character varying(20),
	int,
	int,
	bigint,
	decimal (9,2),
	int
)
RETURNS INT
AS
$$
BEGIN
IF $1 = 'delete'
   THEN

	DELETE FROM
		LUM_MgtLiabConfig_tblPremiumEmployees
	WHERE
		PremiumEmployeesID = $2

		AND UWMConfigID = $6;

	RETURN;

ELSE

IF $1 = 'update'

 THEN

	IF	(SELECT COUNT(*)
		FROM LUM_MgtLiabConfig_tblPremiumEmployees
		WHERE Employees = $4 AND ClassOfBusinessID = $3 AND PremiumEmployeesID <> $2 AND UWMConfigID = $6)
	   <> 0

		THEN
		RETURN 1;
	ELSE

	UPDATE LUM_MgtLiabConfig_tblPremiumEmployees
	SET
		Employees = $4,
		Premium = $5

	WHERE
		PremiumEmployeesID = $2 AND UWMConfigID = $6;

	RETURN;

   END IF;

ELSE

IF $1 = 'add'

THEN

	IF
		(SELECT COUNT(*)

		FROM LUM_MgtLiabConfig_tblPremiumEmployees

		WHERE Employees = $4 AND ClassOfBusinessID = $3 AND UWMConfigID = $6)
	   <> 0
		THEN

		RETURN 1;

	ELSE

	INSERT INTO LUM_MgtLiabConfig_tblPremiumEmployees
		(ClassOfBusinessID,
		Employees,
		Premium,
		UWMConfigID)
	VALUES
		($3,
		$4,
		$5,
		$6);

	RETURN;

   END IF;
END IF;
END IF;
END IF;
END;
$$Language 'plpgsql';