/*
CAR_MAINTAIN_Del '' 
*/
ALTER PROCEDURE dbo.CM_EMPLOYEE_Del
@EMP_ID	varchar(15)
AS
	DECLARE @ERRORSYS NVARCHAR(15) = '' 
	IF ( NOT EXISTS ( SELECT * FROM CM_EMPLOYEE WHERE  EMP_ID= @EMP_ID))
		SET @ERRORSYS = ''

--	IF( EXISTS (SELECT * FROM CM_EMPLOYEE WHERE RECORD_STATUS = '1' AND AUTH_STATUS = 'A' AND [EMP_ID] = @EMP_ID))
--		SET @ERRORSYS = '241'

	IF @ERRORSYS <> ''
	BEGIN
		SELECT ErrorCode Result, ErrorDesc ErrorDesc FROM SYS_ERROR WHERE ErrorCode = @ERRORSYS 
		RETURN '0'
	END
BEGIN TRANSACTION
	--LUCTV: 24-06-2019 : KHONG KIEM TRA AUTH_STATUS MA TIEN HANH KIEM TRA CHECKER_ID
	--IF( (SELECT AUTH_STATUS FROM CM_EMPLOYEE WHERE  EMP_ID= @EMP_ID) = 'A')
--	IF( (SELECT CHECKER_ID FROM CM_EMPLOYEE WHERE  EMP_ID= @EMP_ID) IS NOT NULL)
--	BEGIN
--		UPDATE CM_EMPLOYEE SET RECORD_STATUS = '0' WHERE  EMP_ID= @EMP_ID
--		IF @@Error <> 0 GOTO ABORT
--	END
--	ELSE
--	BEGIN
		Delete FROM CM_EMPLOYEE WHERE EMP_ID= @EMP_ID
		IF @@Error <> 0 GOTO ABORT
--	END
COMMIT TRANSACTION
SELECT '0' as Result, '' ErrorDesc
RETURN '0'

ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' as Result, '' ErrorDesc
		RETURN '-1'
End