AMS - VB

DELETE AbpUserRoles WHERE UserId IN (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'thuhlm2600')

DELETE CM_EMPLOYEE_LOG WHERE USER_DOMAIN = 'thuhlm2600'

DELETE TL_USER WHERE TLNANME = 'thuhlm2600'

INSERT INTO TL_USER (TLID, TLNANME, Password, TLFullName, TLSUBBRID, BRANCH_NAME, BRANCH_TYPE, RoleName, EMAIL, ADDRESS, PHONE, AUTH_STATUS, MARKER_ID, AUTH_ID, APPROVE_DT, ISAPPROVE, Birthday, ISFIRSTTIME, SECUR_CODE, AccessFailedCount, AuthenticationSource, ConcurrencyStamp, CreatorUserId, DeleterUserId, EmailAddress, EmailConfirmationCode, IsActive, IsDeleted, IsEmailConfirmed, IsLockoutEnabled, IsPhoneNumberConfirmed, IsTwoFactorEnabled, LastModifierUserId, LockoutEndDateUtc, Name, NormalizedEmailAddress, NormalizedUserName, PasswordResetCode, PhoneNumber, ProfilePictureId, SecurityStamp, ShouldChangePasswordOnNextLogin, Surname, TenantId, SignInToken, SignInTokenExpireTimeUtc, GoogleAuthenticatorKey, SendActivationEmail, DEP_ID, CreationTime, UamFullName, UamEmployeeId, UamCompanyCode, UamWfDataId, UamCompanyName, UamJobTitle, UserCurrentLanguage, EMAILTEMP) VALUES

(NULL, N'thuhlm2600', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N' Hứa Lê Minh Thư', 'BRN000000000119', NULL, '', 'NVTT', 'huyhh@gsoft.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 10:47:31.517', 121), '1', CONVERT(DATETIME, '2023-04-04 10:47:31.517', 121), '1', NULL, 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'huuleminhthu@vietbank.com.vn', NULL, CONVERT(bit, 'True'), CONVERT(bit, 'False'), CONVERT(bit, 'True'), CONVERT(bit, 'False'), CONVERT(bit, 'True'), CONVERT(bit, 'False'), 259, NULL, NULL, N'huuleminhthu@vietbank.com.vn', N'thuhlm2600', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), NULL, CONVERT(DATETIME, '2023-04-04 10:47:31.517', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)

GO

INSERT INTO CM_EMPLOYEE_LOG (EMP_CODE, EMP_NAME, BRANCH_CODE, DEP_CODE, USER_DOMAIN, POS_CODE, POS_NAME, CREATE_DT) VALUES

('2020-06015', N' Hứa Lê Minh Thư', '2600', '', 'thuhlm2600', N'', N'', CONVERT(DATETIME, '2023-04-04 10:47:31.517', 121))

GO

INSERT INTO AbpUserRoles (CreationTime, CreatorUserId, RoleId, TenantId, UserId) VALUES

(CONVERT(DATETIME2, '2023-04-04 10:47:31.5191935', 121), 0, 69, 1, (SELECT TU.ID FROM TL_USER TU WHERE TU.TLNANME = 'thuhlm2600'))

SELECT A.TLNANME,A.TLFullName,B.BRANCH_NAME,b.BRANCH_CODE,C.DEP_NAME,c.DEP_CODE,E.DisplayName,E.[Desc]

FROM TL_USER A

LEFT JOIN CM_BRANCH B ON A.TLSUBBRID = B.BRANCH_ID

LEFT JOIN CM_DEPARTMENT C ON A.DEP_ID = C.DEP_ID

LEFT JOIN AbpUserRoles D ON A.ID = D.UserId

LEFT JOIN AbpRoles E ON D.RoleId = E.Id

WHERE A.TLSUBBRID <> 'DV0001'

ORDER BY B.BRANCH_NAME,C.DEP_NAME