AMS - VB

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'nguyenamk', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Ân Minh Khôi Nguyên ', 'DV0001', NULL, '', 'GDDV', 'anminhkhoinguyen@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', 'DEP000000000027', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'anminhkhoinguyen@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'anminhkhoinguyen@vietbank.com.vn', N'nguyenamk', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000027', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(NULL, N'toannh', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Nguyễn Hải Toàn ', 'DV0001', NULL, '', 'GDDV', 'nguyenhaitoan@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', 'DEP000000000027', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'nguyenhaitoan@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'nguyenhaitoan@vietbank.com.vn', N'toannh', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000027', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(NULL, N'phongnt', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Nguyễn Tuấn Phong ', 'DV0001', NULL, '', 'DVCM', 'nguyentuanphong@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', 'DEP000000000027', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'nguyentuanphong@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'nguyentuanphong@vietbank.com.vn', N'phongnt', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000027', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(NULL, N'hach', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Chiêu Hồng Hà ', 'DV0001', NULL, '', 'DVCM', 'chieuhongha@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), '1', 'DEP000000000027', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'chieuhongha@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'chieuhongha@vietbank.com.vn', N'hach', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000027', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

(NULL, N'thangnm', N'AQAAAAEAACcQAAAAEMF7sJx/2L/X7bkO6YmSRfr8d7Na/RURfT4tDZYFIDMaik/cy+y7PSfq48Btaka28A==', N'Nguyễn Minh Thắng', 'DV0001', NULL, '', 'DVCM', 'nguyenminhthang@vietbank.com.vn', N'', '', 'A', 'bichnn', NULL, CONVERT(DATETIME, '2023-04-04 10:12:14.953', 121), '1', CONVERT(DATETIME, '2023-04-04 10:12:14.953', 121), '1', 'DEP000000000027', 0, NULL, N'fd2b0a93-3081-460d-b969-b5a75f96c0de', NULL, NULL, N'nguyenminhthang@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'nguyenminhthang@vietbank.com.vn', N'thangnm', NULL, NULL, NULL, N'QSTE4B7VTYWRQON4JZTJST6QN4PEVVLB', CONVERT(bit, 'False'), NULL, 1, NULL, NULL, NULL, CONVERT(bit, 'False'), N'DEP000000000027', CONVERT(DATETIME, '2023-04-04 10:12:14.953', 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

('2018-03038', N'Ân Minh Khôi Nguyên ', '0500', '05J03', 'nguyenamk', '', N'', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121)),

('0000-11049', N'Nguyễn Hải Toàn ', '0500', '05J03', 'toannh', '', N'', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121)),

('0000-14057', N'Nguyễn Tuấn Phong ', '0500', '05J03', 'phongnt', '', N'', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121)),

('2019-08063', N'Chiêu Hồng Hà ', '0500', '05J03', 'hach', '', N'', CONVERT(DATETIME, '2023-04-04 10:12:14.950', 121)),

('2021-03017', N'Nguyễn Minh Thắng', '0500', '05J03', 'thangnm', '', N'', CONVERT(DATETIME, '2023-04-04 10:12:14.953', 121))

GO

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

(CONVERT(DATETIME2, '2023-04-04 10:12:14.9517545', 121), 0, 51, 1, (SELECT tu.ID FROM TL_USER tu where tu.TLNANME = 'nguyenamk')),

(CONVERT(DATETIME2, '2023-04-04 10:12:14.9527569', 121), 0, 51, 1, (SELECT tu.ID FROM TL_USER tu where tu.TLNANME = 'toannh')),

(CONVERT(DATETIME2, '2023-04-04 10:12:14.9537567', 121), 0, 2084, 1, (SELECT tu.ID FROM TL_USER tu where tu.TLNANME = 'phongnt')),

(CONVERT(DATETIME2, '2023-04-04 10:12:14.9537567', 121), 0, 2084, 1, (SELECT tu.ID FROM TL_USER tu where tu.TLNANME = 'hach')),

(CONVERT(DATETIME2, '2023-04-04 10:12:14.9547541', 121), 0, 2084, 1, (SELECT tu.ID FROM TL_USER tu where tu.TLNANME = 'thangnm'))

GO