-- Mapping AbpUserRoles -> TL_SYS_ROLE_MAPPING
ALTER PROCEDURE dbo.TL_SYS_ROLE_MAPPING_Sync
@p_TLNAME varchar(20) = NULL,
@p_USER_LOGIN varchar(20) = NULL
AS
--Validation is here
BEGIN TRANSACTION
   DELETE TL_SYS_ROLE_MAPPING WHERE TLNAME = @p_TLNAME AND IS_MAIN = 0
   INSERT INTO TL_SYS_ROLE_MAPPING (ROLE_OLD, ROLE_NEW, TLNAME, DEP_ID, BRANCH_ID, EFF_DATE, EXP_DATE, NOTES, AUTH_STATUS, RECORD_STATUS, MAKER_ID, CHECKER_ID, IS_MAIN)
   SELECT A.RoleName,C.DisplayName,@p_TLNAME AS TLNAME,A.DEP_ID,A.TLSUBBRID, 'Jan  1 1900 12:00AM','Jan  1 2300 12:00AM','' AS NOTES,'A' AS AUTH_STATUS, 1 AS RECORD_STATUS,@p_USER_LOGIN AS MAKER_ID,@p_USER_LOGIN AS CHECKER_ID,0 AS IS_MAIN
   FROM (SELECT ID,A.RoleName,A.TLSUBBRID,A.DEP_ID FROM TL_USER A  WHERE TLNANME =@p_TLNAME) A
   JOIN AbpUserRoles B ON B.UserId = A.ID 
   JOIN AbpRoles C ON C.Id=B.RoleId 
--   WHERE C.DisplayName NOT IN (SELECT tsrm.ROLE_NEW FROM TL_SYS_ROLE_MAPPING tsrm WHERE tsrm.IS_MAIN=0 AND tsrm.TLNAME=@p_TLNAME)
   IF @@Error <> 0 GOTO ABORT
    
COMMIT TRANSACTION
SELECT '0' as Result, '' ErrorDesc
RETURN '0'
ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' as Result, '' ErrorDesc
		RETURN '-1'
END