[20221228 12:53:28.096][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/store/CheckStoreNameExist [20221228 12:53:28.195][INF] [DecryptionMiddleware][Invoke] RawBody p6xS3LeWVgHEocFJlG5t6HD7b0EnBc/jhXcaQMZ073u4lONBr4rRX1AkYDyhZPGJqnXM7hJbczrYyk6DsZ3TzpDVYNS+o19DStYCg/wNOhUhWD1PHpPvsW256fA1YP9ML8Amm74LBIh4YTi85Yo1VP8mWvre4A5Jrv5iIsTydC3dQHsx/NqKolIr7J7Mke7TAZbAYBnHSdGtk3xlSirZf3wAag05nPMNUda4Qha2UjtRlG0f2RVrB6BX5b9s2FidUNXDamNPd7/Ehr3voYBwK9fIjXs6u/UipbzT8WjxHLlWPO/+XVzrq65q86VR4DSspxnGCGQGjwOJpay7ebmL1lvKgUa0OiNjp+sMZRj24FvfC+hep4Q5MQMHGdYy8vCK5RH6IwlXC8ok2RHwWwTD9rLPzk1u9ZWWxqIgk4ZgQL5T9dr7+BB+roFzUWBFW76AvFiJEy55V2hRCG75u5x4p5sYRiBiyWPhAEetYvgF8dPMNj1MPFQyO8MUEBBzfsg1StXKDAtBtbCrfFoNA1ozJq/WcSKfqU/dceH4mFtHi7Op2Qy954ZIAvqNHJIxkJcU [20221228 12:53:28.200][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"CheckStoreNameExist","SeqNo":"710acdbf-f5fe-414f-b61c-5f5c24a746ac","TimeSpan":1672203209,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"e5A7n7TPLG8JW7s6nvf39dL86ywFa/tjLofX55ly5Wk=","AppVersion":"V1.0.0.2022092601","StoreName":"test"} [20221228 12:53:28.351][INF] [StoreController][CheckStoreNameExist] {"StoreName":"test","Cmd":"CheckStoreNameExist","SeqNo":"710acdbf-f5fe-414f-b61c-5f5c24a746ac","TimeSpan":1672203209,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"e5A7n7TPLG8JW7s6nvf39dL86ywFa/tjLofX55ly5Wk=","AppVersion":"V1.0.0.2022092601"} [20221228 12:53:28.650][INF] [RepositoryContext][OnLogExecuting] SELECT COUNT(1) FROM `TblStore` WHERE ( `Name` = @Name0 ) Param: test [20221228 12:53:29.177][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 00000000-0000-0000-0000-000000000000, 201, CheckStoreNameExist, {"StoreName":"test","Cmd":"CheckStoreNameExist","SeqNo":"710acdbf-f5fe-414f-b61c-5f5c24a746ac","TimeSpan":1672203209,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"e5A7n7TPLG8JW7s6nvf39dL86ywFa/tjLofX55ly5Wk=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, 93c8db2d-52cd-4ae2-8664-dbb73f432ea8, True, 12/28/2022 4:53:29 AM, 1/1/0001 12:00:00 AM, [20221228 12:53:29.194][INF] [StoreController][CheckStoreNameExist] {"Data":false,"Status":200} [20221228 12:53:58.969][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/store/CheckStoreNameExist [20221228 12:53:58.971][INF] [DecryptionMiddleware][Invoke] RawBody p6xS3LeWVgHEocFJlG5t6HD7b0EnBc/jhXcaQMZ073voAPI4JKlYTLoFZkgJiIiFpJ83pjWm6jPpSZEyjPiBJYTBxDLCGOzdXJ6BDSoZNLnY0FyBwn1gZ9HCub3ryIWlBJfr8lb7nf6ZxDTe30P63MiZ2UgXQ2OdydPm7wHXE5EizCfLjV7B4EumKyDe5SxIAqicFl+GVR/4ozqAj8ia4AvXAKp4j5n+o0zro8iQXXMK0BW6VfJM4YcURGdTZz/lssyfsFVqfLcWx89Z4zflxo+4mQcwaa8VsxL+G+r58RlInPrcxucziCkPjbbXiYxF2bqpNQUwmaxGKP/58bUWIc9fxReRKZ1tS9gBbgI5WIl53vbxy0pPouJhg9JNYBVd61Vd08b6nRxXWQ64IIn2BK2tSEcIWYKTKfad2DpxpK3oMhfzCDX2ljWTYrZ3F0plVer8GqB2EubJms+Z2pz5ESCsaA8Oru/4nXXF5RhQfvTXqbrtQxCgpbb8AmXh2DyCcMS09Fdk7reOgJ+cxiDCX73I7mQzqRqYTdHidtuOR5zfF7U+FOWvWKXe4aIITsRl [20221228 12:53:58.972][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"CheckStoreNameExist","SeqNo":"2d8ad403-b094-4b0b-a9c1-6f085f3aecb6","TimeSpan":1672203239,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"ku5nzQOr4v4IdIN0c4B4x8ZsFGacI26ubTckq6GYz0I=","AppVersion":"V1.0.0.2022092601","StoreName":"test"} [20221228 12:53:58.976][INF] [StoreController][CheckStoreNameExist] {"StoreName":"test","Cmd":"CheckStoreNameExist","SeqNo":"2d8ad403-b094-4b0b-a9c1-6f085f3aecb6","TimeSpan":1672203239,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"ku5nzQOr4v4IdIN0c4B4x8ZsFGacI26ubTckq6GYz0I=","AppVersion":"V1.0.0.2022092601"} [20221228 12:53:58.981][INF] [RepositoryContext][OnLogExecuting] SELECT COUNT(1) FROM `TblStore` WHERE ( `Name` = @Name0 ) Param: test [20221228 12:53:58.986][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 00000000-0000-0000-0000-000000000000, 201, CheckStoreNameExist, {"StoreName":"test","Cmd":"CheckStoreNameExist","SeqNo":"2d8ad403-b094-4b0b-a9c1-6f085f3aecb6","TimeSpan":1672203239,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"ku5nzQOr4v4IdIN0c4B4x8ZsFGacI26ubTckq6GYz0I=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, 83c609b7-b296-421b-adbc-44b617378fe2, True, 12/28/2022 4:53:58 AM, 1/1/0001 12:00:00 AM, [20221228 12:53:58.993][INF] [StoreController][CheckStoreNameExist] {"Data":false,"Status":200} [20221228 12:54:18.854][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/auth/StoreRegister [20221228 12:54:18.854][INF] [DecryptionMiddleware][Invoke] RawBody AA4zx5f0eUZYSEM5w9U/sVNjoEs2SfO2ABN5I/VjgMWs6HkFeb3CcYZmInBXghazgDK8T2HDVQEdHbVpbto28NTPmIMT+OmZzuqOtl3FIMinUEL+US3WRHfM9prYsYJww5g42BRs8XRV6YgeL91eIZ4ycxlx7ZDnVV+rRnVZzAKs7/B0zIBbzR1NEQKS4R6t+VmJPMn8B+cQUDXSdZ3Qo5EcNNDC5Bgjper672GNhgMYwf6o2PJTmrD5/rIhMf2OftXByr1raAvPMFlEZnsTDyb2JdOe5cSQlNuibuH5VyCkf2E/+D20BV+mD3bn6FfT0DF9qhKDR128k6hw02hsFV2g3zFHnQeFnSLZnmOsbvL2TC00SNDkYOvLl3s/F8YCx5GY9ljdhZOXnPImmtDwFh+8ewo+E8u+o6avvoIIz2O13twFlWNjmpKPt7HTOf1OC3GcfWtCtTQwdEpc+dCSP9lVjtwJVDfStwr523iEJGeSgpxzqUKZPcYfJToQ4OByGWS0Zzy0lWKgkXoIKA2QkU6Pi0rIN6leMX0JQpZQ5rhTdIX+3gNV+qxc7i85n++6SXcibHjfWxrIn0xa2H3w7l2Qs8uOiFqQqg3Ximi035X+kjrKW/vtexVirrSef14x1SFeai8JJlmeIExJxqVs2OxC6gtjAz94gHPkAWyWi1+1PDbmM+6lEMNsCao2MA+H+z1qhtF0E/vMVfmI98FSOsa58d/Eu6pwulgs2OjcXjcpsJ9Tz2rPQBPMsbsTtzMHi665HxihkwqP5uyjnObH4hXVl4x0syiDBRkzV4Qc1e4n+DKygIBNWFPUVJ6Xf5zC [20221228 12:54:18.854][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"UserStoreRegister","SeqNo":"540e2d7c-fe2f-486a-8705-fe7182b13895","TimeSpan":1672203259,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"1lXa7+t9o1eT9Nfmrg1dDrn+/u7prr2FvSd/NjeaX7U=","AppVersion":"V1.0.0.2022092601","Email":"kelvin.voon@techworkstudio.com","FirstName":"Kelvin","LastName":"Voon","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Store":{"Country":0,"StoreBackground":0,"Name":"test","StorePlatform":[]}} [20221228 12:54:18.937][INF] [AuthController][StoreRegister] {"Email":"kelvin.voon@techworkstudio.com","FirstName":"Kelvin","LastName":"Voon","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Store":{"Name":"test","Country":0,"StoreBackground":0,"StorePlatform":[]},"Cmd":"UserStoreRegister","SeqNo":"540e2d7c-fe2f-486a-8705-fe7182b13895","TimeSpan":1672203259,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"1lXa7+t9o1eT9Nfmrg1dDrn+/u7prr2FvSd/NjeaX7U=","AppVersion":"V1.0.0.2022092601"} [20221228 12:54:19.013][INF] [BaseController][CheckValidation][UserRegisterRequestModel] validationResult: true model: {"Email":"kelvin.voon@techworkstudio.com","FirstName":"Kelvin","LastName":"Voon","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Store":{"Name":"test","Country":0,"StoreBackground":0,"StorePlatform":[]},"Cmd":"UserStoreRegister","SeqNo":"540e2d7c-fe2f-486a-8705-fe7182b13895","TimeSpan":1672203259,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"1lXa7+t9o1eT9Nfmrg1dDrn+/u7prr2FvSd/NjeaX7U=","AppVersion":"V1.0.0.2022092601"} [20221228 12:54:19.038][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE ( `Email` = @Email0 ) Param: kelvin.voon@techworkstudio.com [20221228 12:54:19.090][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `Name` = @Name0 ) Param: test [20221228 12:54:19.134][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUser` (`FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`RefreshToken`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@FirstName,@LastName,@Email,@Password,@ContactNo,@Picture,@DefaultAuthScheme,@DefaultLang,@LastLoginIP,@RefreshToken,@StoreId,@OAuthId,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: Kelvin, Voon, kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ, , , 0, 0, , , , , 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, kelvin.voon@techworkstudio.com [20221228 12:54:19.180][INF] [RepositoryContext][OnLogExecuting] SELECT COUNT(1) FROM `TblDomain` WHERE ( `SubDomain` = @SubDomain0 ) Param: test [20221228 12:54:19.263][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.319][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblStore` (`Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@Name,@AddressId,@SEOId,@BrandId,@PreferenceId,@PolicyId,@SurveyId,@DomainId,@OrderReferenceNoId,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: test, 00000000-0000-0000-0000-000000000000, , 00000000-0000-0000-0000-000000000000, 00000000-0000-0000-0000-000000000000, 00000000-0000-0000-0000-000000000000, 00000000-0000-0000-0000-000000000000, 00000000-0000-0000-0000-000000000000, 00000000-0000-0000-0000-000000000000, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, kelvin.voon@techworkstudio.com [20221228 12:54:19.328][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE ( `GUID` = @ConditGUID1000 ) Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2 [20221228 12:54:19.363][INF] [RepositoryContext][OnLogExecuting] DELETE FROM `TblUserStoreMapping` WHERE `StoreId` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:54:19.367][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserStoreMapping` (`StoreId`,`UserId`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`GUID`) VALUES (@StoreId,@UserId,@Status,@CreateDate,@ModifiedDate,@CreatedBy,@GUID) ; Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce, 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, False, 12/28/2022 12:54:19 PM, 12/28/2022 12:54:19 PM, , bdeb6ecc-0526-49be-ae5c-80ee325c7c1d [20221228 12:54:19.371][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.381][INF] [RepositoryContext][OnLogExecuting] SELECT `Address`,`Postcode`,`City`,`State`,`Country`,`CountryName`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblAddress` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.388][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblAddress` (`Address`,`Postcode`,`City`,`State`,`Country`,`CountryName`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@Address,@Postcode,@City,@State,@Country,@CountryName,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: , , , , 0, Singapore, ad2a2335-b909-499a-a783-c2fb34fd3791, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.412][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblStore` SET `AddressId`=@Const0 WHERE GUID = @GUID0 Param: ad2a2335-b909-499a-a783-c2fb34fd3791, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.414][INF] [RepositoryContext][OnLogExecuting] SELECT `Address`,`Postcode`,`City`,`State`,`Country`,`CountryName`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblAddress` WHERE ( `GUID` = @ConditGUID1000 ) Param: ad2a2335-b909-499a-a783-c2fb34fd3791 [20221228 12:54:19.418][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.421][INF] [RepositoryContext][OnLogExecuting] SELECT `SubDomain`,`Domain`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblDomain` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.425][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblDomain` (`SubDomain`,`Domain`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@SubDomain,@Domain,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: test, , 356ab978-1b98-48f4-ace6-3064d2a923f7, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.426][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblStore` SET `DomainId`=@Const0 WHERE GUID = @GUID0 Param: 356ab978-1b98-48f4-ace6-3064d2a923f7, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.427][INF] [RepositoryContext][OnLogExecuting] SELECT `SubDomain`,`Domain`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblDomain` WHERE ( `GUID` = @ConditGUID1000 ) Param: 356ab978-1b98-48f4-ace6-3064d2a923f7 [20221228 12:54:19.430][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.434][INF] [RepositoryContext][OnLogExecuting] SELECT `DefaultLogoId`,`CoverImage`,`PrimaryColor`,`SecondaryColor`,`Description`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStoreBrand` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.441][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblStoreBrand` (`DefaultLogoId`,`CoverImage`,`PrimaryColor`,`SecondaryColor`,`Description`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@DefaultLogoId,@CoverImage,@PrimaryColor,@SecondaryColor,@Description,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: , , #0000FF, #5F9EA0, , 0d29ac01-90f7-474d-9bf8-6476f665745a, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.443][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblStore` SET `BrandId`=@Const0 WHERE GUID = @GUID0 Param: 0d29ac01-90f7-474d-9bf8-6476f665745a, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.444][INF] [RepositoryContext][OnLogExecuting] SELECT `DefaultLogoId`,`CoverImage`,`PrimaryColor`,`SecondaryColor`,`Description`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStoreBrand` WHERE ( `GUID` = @ConditGUID1000 ) Param: 0d29ac01-90f7-474d-9bf8-6476f665745a [20221228 12:54:19.448][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.453][INF] [RepositoryContext][OnLogExecuting] SELECT `StoreBackground`,`StorePlatform`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStoreSurvey` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.458][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblStoreSurvey` (`StoreBackground`,`StorePlatform`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@StoreBackground,@StorePlatform,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 0, [], d1969fb5-4135-4302-89c2-bdcde84d019d, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.460][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblStore` SET `SurveyId`=@Const0 WHERE GUID = @GUID0 Param: d1969fb5-4135-4302-89c2-bdcde84d019d, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.461][INF] [RepositoryContext][OnLogExecuting] SELECT `StoreBackground`,`StorePlatform`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStoreSurvey` WHERE ( `GUID` = @ConditGUID1000 ) Param: d1969fb5-4135-4302-89c2-bdcde84d019d [20221228 12:54:19.465][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.470][INF] [RepositoryContext][OnLogExecuting] SELECT `RefundPolicy`,`PrivacyPolicy`,`TermOfService`,`ShippingPolicy`,`ContactInformation`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblPolicy` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.476][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblPolicy` (`RefundPolicy`,`PrivacyPolicy`,`TermOfService`,`ShippingPolicy`,`ContactInformation`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@RefundPolicy,@PrivacyPolicy,@TermOfService,@ShippingPolicy,@ContactInformation,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: , , , , , fe55caca-d676-47cc-9f1d-253bd500e6e5, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.479][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblStore` SET `PolicyId`=@Const0 WHERE GUID = @GUID0 Param: fe55caca-d676-47cc-9f1d-253bd500e6e5, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.480][INF] [RepositoryContext][OnLogExecuting] SELECT `RefundPolicy`,`PrivacyPolicy`,`TermOfService`,`ShippingPolicy`,`ContactInformation`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblPolicy` WHERE ( `GUID` = @ConditGUID1000 ) Param: fe55caca-d676-47cc-9f1d-253bd500e6e5 [20221228 12:54:19.483][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.487][INF] [RepositoryContext][OnLogExecuting] SELECT `MetaTitle`,`MetaDescription`,`SocialSharingImage`,`IsEnableReCAPTCHA1`,`IsEnableReCAPTCHA2`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblPreference` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.493][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblPreference` (`MetaTitle`,`MetaDescription`,`SocialSharingImage`,`IsEnableReCAPTCHA1`,`IsEnableReCAPTCHA2`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@MetaTitle,@MetaDescription,@SocialSharingImage,@IsEnableReCAPTCHA1,@IsEnableReCAPTCHA2,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: test, , , True, True, f5cf651c-0dec-4bc4-b1e6-dce4e5497f79, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.495][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblStore` SET `PreferenceId`=@Const0 WHERE GUID = @GUID0 Param: f5cf651c-0dec-4bc4-b1e6-dce4e5497f79, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.496][INF] [RepositoryContext][OnLogExecuting] SELECT `MetaTitle`,`MetaDescription`,`SocialSharingImage`,`IsEnableReCAPTCHA1`,`IsEnableReCAPTCHA2`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblPreference` WHERE ( `GUID` = @ConditGUID1000 ) Param: f5cf651c-0dec-4bc4-b1e6-dce4e5497f79 [20221228 12:54:19.499][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.507][INF] [RepositoryContext][OnLogExecuting] SELECT `Currency`,`CurrencyName`,`Rate`,`IsBaseRate`,`StoreId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblCurrency` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.515][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblCurrency` (`Currency`,`CurrencyName`,`Rate`,`IsBaseRate`,`StoreId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@Currency,@CurrencyName,@Rate,@IsBaseRate,@StoreId,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1, SGD, 1, True, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce, eccee33a-d968-46a3-9726-df1e068ac9c4, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.519][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.523][INF] [RepositoryContext][OnLogExecuting] SELECT `Prefix`,`StartNumber`,`RunningNumber`,`LeadingZero`,`IsLeadZero`,`Step`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblOrderReferenceNo` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.530][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblOrderReferenceNo` (`Prefix`,`StartNumber`,`RunningNumber`,`LeadingZero`,`IsLeadZero`,`Step`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@Prefix,@StartNumber,@RunningNumber,@LeadingZero,@IsLeadZero,@Step,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: #, 100000, 100000, 5, True, 1, b4eef56f-22dd-4252-a9be-ef90b628ac1e, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.534][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblStore` SET `OrderReferenceNoId`=@Const0 WHERE GUID = @GUID0 Param: b4eef56f-22dd-4252-a9be-ef90b628ac1e, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.535][INF] [RepositoryContext][OnLogExecuting] SELECT `Prefix`,`StartNumber`,`RunningNumber`,`LeadingZero`,`IsLeadZero`,`Step`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblOrderReferenceNo` WHERE ( `GUID` = @ConditGUID1000 ) Param: b4eef56f-22dd-4252-a9be-ef90b628ac1e [20221228 12:54:19.538][INF] [RepositoryContext][OnLogExecuting] SELECT `Name`,`AddressId`,`SEOId`,`BrandId`,`PreferenceId`,`PolicyId`,`SurveyId`,`DomainId`,`OrderReferenceNoId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblStore` WHERE ( `GUID` = @ConditGUID1000 ) Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce [20221228 12:54:19.545][INF] [RepositoryContext][OnLogExecuting] SELECT `CountryTax`,`StoreId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblTax` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.549][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblTax` (`CountryTax`,`StoreId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@CountryTax,@StoreId,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 0, ac702b8e-97d3-4a3a-936e-6e36a9ed82ce, e58cb6fd-ba86-45c5-a8eb-72c28108a1ee, False, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.556][INF] [RepositoryContext][OnLogExecuting] SELECT `StoreId`,`Key`,`Title`,`PageTitle`,`Description`,`Tags`,`IsPages`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblPageContent` WHERE ( `GUID` = @ConditGUID1000 ) Param: 00000000-0000-0000-0000-000000000000 [20221228 12:54:19.563][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblPageContent` (`StoreId`,`Key`,`Title`,`PageTitle`,`Description`,`Tags`,`IsPages`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@StoreId,@Key,@Title,@PageTitle,@Description,@Tags,@IsPages,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: ac702b8e-97d3-4a3a-936e-6e36a9ed82ce, layout, , , , , False, cd926f99-7cea-4ee4-a183-a38d224aebaa, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:19.574][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 2, StoreRegister, {"Email":"kelvin.voon@techworkstudio.com","FirstName":"Kelvin","LastName":"Voon","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Store":{"Name":"test","Country":0,"StoreBackground":0,"StorePlatform":[]},"Cmd":"UserStoreRegister","SeqNo":"540e2d7c-fe2f-486a-8705-fe7182b13895","TimeSpan":1672203259,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"1lXa7+t9o1eT9Nfmrg1dDrn+/u7prr2FvSd/NjeaX7U=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, efc5a04b-ebdb-462a-8779-507f8b531aac, True, 12/28/2022 4:54:19 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:26.421][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE (( `Email` = @Email0 ) AND ( `Password` = @Password1 )) Param: kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ [20221228 12:54:26.442][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:54:26.451][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:54:26.464][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 1, EmailLogin, {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserLogin","SeqNo":"52b15527-89ff-4060-9d3b-409f7b4fe457","TimeSpan":0,"IP":"61.6.137.137"}, 61.6.137.137, 6af7173c-b3da-4257-a570-e9a329625730, True, 12/28/2022 4:54:26 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:26.476][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE `GUID` = @InPara0 Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2 [20221228 12:54:26.479][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:54:26.481][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:54:26.491][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblUser` SET `FirstName`=@FirstName,`LastName`=@LastName,`Email`=@Email,`Password`=@Password,`ContactNo`=@ContactNo,`Picture`=@Picture,`DefaultAuthScheme`=@DefaultAuthScheme,`DefaultLang`=@DefaultLang,`LastLoginIP`=@LastLoginIP,`LastLoginDate`=@LastLoginDate,`RefreshToken`=@RefreshToken,`RefreshTokenExpiry`=@RefreshTokenExpiry,`StoreId`=@StoreId,`OAuthId`=@OAuthId,`Status`=@Status,`ModifiedDate`=@ModifiedDate,`ModifiedBy`=@ModifiedBy WHERE `GUID`=@GUID Param: Kelvin, Voon, kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ, , , 0, 0, 61.6.137.137, 12/28/2022 4:54:26 AM, k+3vff+wqUScGoq6w4y8bnacn6AmtGS0IDZ5mK808MuwojAiihjA7sSpcOBTroL9JYJ44IyE/YYhkaq+sn87DQ==, 1/4/2023 4:54:26 AM, , , 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, True, 12/28/2022 4:54:26 AM, kelvin.voon@techworkstudio.com [20221228 12:54:26.556][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 0, Login, {"FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","Password":"tzulv3JMUMJQPtAEIPVx4b\u002BW5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ","ContactNo":null,"Picture":null,"DefaultAuthScheme":0,"DefaultLang":0,"LastLoginIP":"61.6.137.137","LastLoginDate":"2022-12-28T04:54:26.4848337Z","RefreshToken":"k\u002B3vff\u002BwqUScGoq6w4y8bnacn6AmtGS0IDZ5mK808MuwojAiihjA7sSpcOBTroL9JYJ44IyE/YYhkaq\u002Bsn87DQ==","RefreshTokenExpiry":"2023-01-04T04:54:26.4853079Z","StoreId":null,"OAuthId":null,"Stores":[{"Name":"test","AddressId":"ad2a2335-b909-499a-a783-c2fb34fd3791","Address":null,"Users":null,"Staffs":null,"SEOId":null,"SEO":null,"BrandId":"0d29ac01-90f7-474d-9bf8-6476f665745a","Brand":null,"PreferenceId":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Preference":null,"PolicyId":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Policy":null,"SurveyId":"d1969fb5-4135-4302-89c2-bdcde84d019d","Survey":null,"DomainId":"356ab978-1b98-48f4-ace6-3064d2a923f7","Domain":null,"OrderReferenceNoId":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","OrderReferenceNo":null,"Taxes":null,"Customers":null,"Tags":null,"Carts":null,"Orders":null,"Collections":null,"Products":null,"Blogs":null,"Suppliers":null,"PageContents":null,"Currencies":null,"PaymentMethods":null,"DeliveryMethods":null,"Reviews":null,"Discounts":null,"GUID":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null}],"Permissions":null,"GUID":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"2022-12-28T04:54:26.485358Z","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":"kelvin.voon@techworkstudio.com"}, 61.6.137.137, 96241ceb-4063-4b9e-b59b-b07906d7e820, True, 12/28/2022 4:54:26 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:26.742][INF] [AuthService][StoreRegister] Initialize New Store, userId "1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2", {"Name":"test","AddressId":"ad2a2335-b909-499a-a783-c2fb34fd3791","Address":{"Address":null,"Postcode":null,"City":null,"State":null,"Country":0,"CountryName":"Singapore","GUID":"ad2a2335-b909-499a-a783-c2fb34fd3791","Status":true,"CreateDate":"2022-12-28T04:54:19.138151Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null},"Users":[{"FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","Password":"tzulv3JMUMJQPtAEIPVx4b\u002BW5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ","ContactNo":null,"Picture":null,"DefaultAuthScheme":0,"DefaultLang":0,"LastLoginIP":null,"LastLoginDate":"0001-01-01T00:00:00","RefreshToken":null,"RefreshTokenExpiry":"0001-01-01T00:00:00","StoreId":null,"OAuthId":null,"Stores":null,"Permissions":null,"GUID":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","Status":true,"CreateDate":"2022-12-28T04:54:19.1235699Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null}],"Staffs":null,"SEOId":null,"SEO":null,"BrandId":"0d29ac01-90f7-474d-9bf8-6476f665745a","Brand":{"DefaultLogoId":null,"DefaultLogo":null,"CoverImage":null,"PrimaryColor":"#0000FF","SecondaryColor":"#5F9EA0","Description":null,"SocialLinks":null,"GUID":"0d29ac01-90f7-474d-9bf8-6476f665745a","Status":true,"CreateDate":"2022-12-28T04:54:19.1886561Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null},"PreferenceId":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Preference":{"MetaTitle":"test","MetaDescription":null,"SocialSharingImage":null,"IsEnableReCAPTCHA1":true,"IsEnableReCAPTCHA2":true,"GUID":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Status":true,"CreateDate":"2022-12-28T04:54:19.1888267Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null},"PolicyId":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Policy":{"RefundPolicy":null,"PrivacyPolicy":null,"TermOfService":null,"ShippingPolicy":null,"ContactInformation":null,"GUID":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Status":true,"CreateDate":"2022-12-28T04:54:19.1887343Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null},"SurveyId":"d1969fb5-4135-4302-89c2-bdcde84d019d","Survey":{"StoreBackground":0,"StorePlatform":"[]","GUID":"d1969fb5-4135-4302-89c2-bdcde84d019d","Status":true,"CreateDate":"2022-12-28T04:54:19.1383732Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null},"DomainId":"356ab978-1b98-48f4-ace6-3064d2a923f7","Domain":{"SubDomain":"test","Domain":null,"GUID":"356ab978-1b98-48f4-ace6-3064d2a923f7","Status":true,"CreateDate":"2022-12-28T04:54:19.1713922Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null},"OrderReferenceNoId":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","OrderReferenceNo":{"Prefix":"#","StartNumber":100000,"RunningNumber":100000,"LeadingZero":5,"IsLeadZero":true,"Step":1,"GUID":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","Status":true,"CreateDate":"2022-12-28T04:54:19.1891645Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null},"Taxes":[{"CountryTax":0,"StoreId":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Store":null,"GUID":"e58cb6fd-ba86-45c5-a8eb-72c28108a1ee","Status":false,"CreateDate":"2022-12-28T04:54:19.1892994Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null}],"Customers":null,"Tags":null,"Carts":null,"Orders":null,"Collections":null,"Products":null,"Blogs":null,"Suppliers":null,"PageContents":null,"Currencies":[{"Currency":1,"CurrencyName":"SGD","Rate":1,"IsBaseRate":true,"StoreId":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Store":null,"GUID":"eccee33a-d968-46a3-9726-df1e068ac9c4","Status":true,"CreateDate":"2022-12-28T04:54:19.1890117Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":null,"ModifiedBy":null}],"PaymentMethods":null,"DeliveryMethods":null,"Reviews":null,"Discounts":null,"GUID":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Status":true,"CreateDate":"2022-12-28T04:54:19.1379665Z","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null} [20221228 12:54:26.753][INF] [AuthController][StoreRegister] {"Id":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","DefaultAuthScheme":0,"DefaultLang":0,"Stores":["ac702b8e-97d3-4a3a-936e-6e36a9ed82ce"],"RefreshToken":"k+3vff+wqUScGoq6w4y8bnacn6AmtGS0IDZ5mK808MuwojAiihjA7sSpcOBTroL9JYJ44IyE/YYhkaq+sn87DQ==","RefreshTokenExpiry":1672808066681,"Status":200,"Token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiIxYjNiNzJiMi0wMWJiLTRiMjQtOWIwYS1jOTQwM2VlYmEyYTIiLCJnaXZlbl9uYW1lIjoiS2VsdmluIiwiZmFtaWx5X25hbWUiOiJWb29uIiwibmFtZSI6IlZvb24gS2VsdmluIiwiZW1haWwiOiJrZWx2aW4udm9vbkB0ZWNod29ya3N0dWRpby5jb20iLCJhdXRobWV0aG9kIjoiRW1haWwiLCJyb2xlIjoiVXNlciIsIm5iZiI6MTY3MjIwMzI2NiwiZXhwIjoxNjcyMjAzNTY2LCJpYXQiOjE2NzIyMDMyNjYsImlzcyI6InRoZXNob3BiaXQuY29tIiwiYXVkIjoiZmUifQ.a7j91-ib1g26C29E7iNdAUavLc4gMi1NBdR4oR8n0iY"} [20221228 12:54:32.762][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/auth/EmailLogin [20221228 12:54:32.762][INF] [DecryptionMiddleware][Invoke] RawBody EwQ3COQG4NqeHiXbbQSThP2Xm/yfkgsoc7Dr7LiBJoZZx0xLn7nJbVJGTHvHR1owGETaudJ63ISk3hCH0eYvKmrmkrjL05hu5vArXYIaSL+t6u5rPw9zKgut2vZwpNCrtehBOGYOQX6nw0g4EqkmYwwasTUmPpQwlJIqHJJ3wEOdg6ycFUdoJ3EOLgDchZdwUmoomreA+aYMYqJOkv5ru7x0BzkYjTP8V1wt9bbtAa9Zz7b45AEv9Kww62KUz0HwRHzAAB5fHzKc/uJj66QKlHpH6HM88AiXk9kQmRR1BqL583LbCdTPZEbdH+0UETgduhgwSEAxwzTRv1eL4FBPnRv8CyC3cYJUdWDfOapOOglIrtopc/aSjD84pRfOUy9HXXeGWr3TOjUQ0jaZBsKpHH08qE85xcOXcewk6xQmL0OZ8KS23cpq3bnixktLbq8Z6cWEsWLSopw7ENI3G4DFJiasWL0LIseAgJv0cJqOVBjvxWJwcBI0j65ygvpsl13JHWVfaTiWqiMMh+8ZVNXojgqbEECRC9h+l/g/ghBHmvjvzBBcZoPrF4hQ0An9Ql5g6u3giX7be1ZjAlzH7kORYA0Yn0a6SJyeDou7xWxduzRHn/MBCee0XQ9Awve1JmJIwlakP/NDCDg9gmrq3Lmy88ZAqYyiAFN7/raXO2LrZn0= [20221228 12:54:32.762][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"UserEmailLogin","SeqNo":"e3386182-126d-41e5-8e32-e13d12eb643e","TimeSpan":1672203273,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"D1gI81ez7tRYOf4u6gmvxnD1yK8AmD1QGua7HbcBnS8=","AppVersion":"V1.0.0.2022092601","Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA="} [20221228 12:54:32.780][INF] [AuthController][EmailLogin] {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"e3386182-126d-41e5-8e32-e13d12eb643e","TimeSpan":1672203273,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"D1gI81ez7tRYOf4u6gmvxnD1yK8AmD1QGua7HbcBnS8=","AppVersion":"V1.0.0.2022092601"} [20221228 12:54:32.781][INF] [BaseController][CheckValidation][UserLoginRequestModel] validationResult: true model: {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"e3386182-126d-41e5-8e32-e13d12eb643e","TimeSpan":1672203273,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"D1gI81ez7tRYOf4u6gmvxnD1yK8AmD1QGua7HbcBnS8=","AppVersion":"V1.0.0.2022092601"} [20221228 12:54:32.782][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE (( `Email` = @Email0 ) AND ( `Password` = @Password1 )) Param: kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ [20221228 12:54:32.787][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:54:32.788][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:54:32.791][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 1, EmailLogin, {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"e3386182-126d-41e5-8e32-e13d12eb643e","TimeSpan":1672203273,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"D1gI81ez7tRYOf4u6gmvxnD1yK8AmD1QGua7HbcBnS8=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, 3cb50c1b-d809-408e-b2f5-148bae98ec5a, True, 12/28/2022 4:54:32 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:32.795][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE `GUID` = @InPara0 Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2 [20221228 12:54:32.798][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:54:32.802][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:54:32.804][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblUser` SET `FirstName`=@FirstName,`LastName`=@LastName,`Email`=@Email,`Password`=@Password,`ContactNo`=@ContactNo,`Picture`=@Picture,`DefaultAuthScheme`=@DefaultAuthScheme,`DefaultLang`=@DefaultLang,`LastLoginIP`=@LastLoginIP,`LastLoginDate`=@LastLoginDate,`RefreshToken`=@RefreshToken,`RefreshTokenExpiry`=@RefreshTokenExpiry,`StoreId`=@StoreId,`OAuthId`=@OAuthId,`Status`=@Status,`ModifiedDate`=@ModifiedDate,`ModifiedBy`=@ModifiedBy WHERE `GUID`=@GUID Param: Kelvin, Voon, kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ, , , 0, 0, 61.6.137.137, 12/28/2022 4:54:32 AM, hbWt7RTepAWnxrI+g05k7F9jOnIzPJMWH+Lc+azQ/WDcbOU/eSe2gmnpyNbQeILg6P5VyRjJ5Vj630TsE1dHfQ==, 1/4/2023 4:54:32 AM, , , 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, True, 12/28/2022 4:54:32 AM, kelvin.voon@techworkstudio.com [20221228 12:54:32.820][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 0, Login, {"FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","Password":"tzulv3JMUMJQPtAEIPVx4b\u002BW5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ","ContactNo":null,"Picture":null,"DefaultAuthScheme":0,"DefaultLang":0,"LastLoginIP":"61.6.137.137","LastLoginDate":"2022-12-28T04:54:32.8033177Z","RefreshToken":"hbWt7RTepAWnxrI\u002Bg05k7F9jOnIzPJMWH\u002BLc\u002BazQ/WDcbOU/eSe2gmnpyNbQeILg6P5VyRjJ5Vj630TsE1dHfQ==","RefreshTokenExpiry":"2023-01-04T04:54:32.8033743Z","StoreId":null,"OAuthId":null,"Stores":[{"Name":"test","AddressId":"ad2a2335-b909-499a-a783-c2fb34fd3791","Address":null,"Users":null,"Staffs":null,"SEOId":null,"SEO":null,"BrandId":"0d29ac01-90f7-474d-9bf8-6476f665745a","Brand":null,"PreferenceId":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Preference":null,"PolicyId":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Policy":null,"SurveyId":"d1969fb5-4135-4302-89c2-bdcde84d019d","Survey":null,"DomainId":"356ab978-1b98-48f4-ace6-3064d2a923f7","Domain":null,"OrderReferenceNoId":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","OrderReferenceNo":null,"Taxes":null,"Customers":null,"Tags":null,"Carts":null,"Orders":null,"Collections":null,"Products":null,"Blogs":null,"Suppliers":null,"PageContents":null,"Currencies":null,"PaymentMethods":null,"DeliveryMethods":null,"Reviews":null,"Discounts":null,"GUID":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null}],"Permissions":null,"GUID":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"2022-12-28T04:54:32.8033768Z","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":"kelvin.voon@techworkstudio.com"}, 61.6.137.137, 29cedb96-8a0e-4eff-9e5a-17427632c502, True, 12/28/2022 4:54:32 AM, 1/1/0001 12:00:00 AM, [20221228 12:54:32.824][INF] [AuthController][EmailLogin] {"Id":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","DefaultAuthScheme":0,"DefaultLang":0,"Stores":["ac702b8e-97d3-4a3a-936e-6e36a9ed82ce"],"RefreshToken":"hbWt7RTepAWnxrI+g05k7F9jOnIzPJMWH+Lc+azQ/WDcbOU/eSe2gmnpyNbQeILg6P5VyRjJ5Vj630TsE1dHfQ==","RefreshTokenExpiry":1672808072823,"Status":200,"Token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiIxYjNiNzJiMi0wMWJiLTRiMjQtOWIwYS1jOTQwM2VlYmEyYTIiLCJnaXZlbl9uYW1lIjoiS2VsdmluIiwiZmFtaWx5X25hbWUiOiJWb29uIiwibmFtZSI6IlZvb24gS2VsdmluIiwiZW1haWwiOiJrZWx2aW4udm9vbkB0ZWNod29ya3N0dWRpby5jb20iLCJhdXRobWV0aG9kIjoiRW1haWwiLCJyb2xlIjoiVXNlciIsIm5iZiI6MTY3MjIwMzI3MiwiZXhwIjoxNjcyMjAzNTcyLCJpYXQiOjE2NzIyMDMyNzIsImlzcyI6InRoZXNob3BiaXQuY29tIiwiYXVkIjoiZmUifQ.fwBp92Co5nCNSFVwC02S5LzCi2ev8gs_jRDWfebzCMg"} [20221228 12:55:08.067][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/auth/EmailLogin [20221228 12:55:08.068][INF] [DecryptionMiddleware][Invoke] RawBody EwQ3COQG4NqeHiXbbQSThP2Xm/yfkgsoc7Dr7LiBJoaE06U6LnA9dW6Cv91ULdeTICIdtvDbrPQWPOsDbKp3HKlzxW3NFmLMwUxfBYsG+DnSnZFU7a7A46m7d9iay1PG2U710PE9KVLEeX0S+smn/KklrCGMjQidYbt24lIfX0RdPLaIhUNN+YLul3LrMl7x5qUsHWjXKs4tcycN0X09Dof1lM2sV1bn3r6mJ6lO6tNHaBRmWgeFB5C5EsghDZNlbpc2cGrWB3nNmuPmcK09FD4wyWZ12KEwKD4JHMBJYBg8EMXyMJ13kuvCqX7xmVlDctjkYgsEEhAo5Jklc1WJiBZOoD3utpX7e0WiUdO+RBL5PIQQGbkjIwcgrMNvORivv95UcJBly+cYPJ0yXe6XquV5QtL+Ez5UMqt1oXWT7x4p2U3caSR0PkCjHwjW9v5s4khOUbMGkkAO5OxtdQLSfnNLxKKtusvZAatDv33MiltrRwktMySBPfMdkz96f90X+l08A/1Y8+pGAN8l4yRPLtcWEguueJhn49+/Pe1g1Qui5StMEckflKGb84FIw5dkwmYo2PQhFBnltCSZGlqotzhxsTOZGSX8kSF4e4r68OeX+uBi0vlzxGzx/9WYhbzMwrKQZiv8M7HM1FxRMaxEQbNohgryWbLQWM+WfAtORjI= [20221228 12:55:08.068][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"UserEmailLogin","SeqNo":"3db875f0-0386-482d-a334-bd55bfb1fb71","TimeSpan":1672203309,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"o6WdzzKlRqtN7EfaKinFAI5xKB2PL825FECDb8YzEkU=","AppVersion":"V1.0.0.2022092601","Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA="} [20221228 12:55:08.077][INF] [AuthController][EmailLogin] {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"3db875f0-0386-482d-a334-bd55bfb1fb71","TimeSpan":1672203309,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"o6WdzzKlRqtN7EfaKinFAI5xKB2PL825FECDb8YzEkU=","AppVersion":"V1.0.0.2022092601"} [20221228 12:55:08.078][INF] [BaseController][CheckValidation][UserLoginRequestModel] validationResult: true model: {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"3db875f0-0386-482d-a334-bd55bfb1fb71","TimeSpan":1672203309,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"o6WdzzKlRqtN7EfaKinFAI5xKB2PL825FECDb8YzEkU=","AppVersion":"V1.0.0.2022092601"} [20221228 12:55:08.082][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE (( `Email` = @Email0 ) AND ( `Password` = @Password1 )) Param: kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ [20221228 12:55:08.088][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:55:08.089][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:55:08.092][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 1, EmailLogin, {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"3db875f0-0386-482d-a334-bd55bfb1fb71","TimeSpan":1672203309,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"o6WdzzKlRqtN7EfaKinFAI5xKB2PL825FECDb8YzEkU=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, 9ae85d1d-a288-40c8-b438-437ee5c146f4, True, 12/28/2022 4:55:08 AM, 1/1/0001 12:00:00 AM, [20221228 12:55:08.096][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE `GUID` = @InPara0 Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2 [20221228 12:55:08.098][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:55:08.099][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:55:08.101][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblUser` SET `FirstName`=@FirstName,`LastName`=@LastName,`Email`=@Email,`Password`=@Password,`ContactNo`=@ContactNo,`Picture`=@Picture,`DefaultAuthScheme`=@DefaultAuthScheme,`DefaultLang`=@DefaultLang,`LastLoginIP`=@LastLoginIP,`LastLoginDate`=@LastLoginDate,`RefreshToken`=@RefreshToken,`RefreshTokenExpiry`=@RefreshTokenExpiry,`StoreId`=@StoreId,`OAuthId`=@OAuthId,`Status`=@Status,`ModifiedDate`=@ModifiedDate,`ModifiedBy`=@ModifiedBy WHERE `GUID`=@GUID Param: Kelvin, Voon, kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ, , , 0, 0, 61.6.137.137, 12/28/2022 4:55:08 AM, KwP1EGEFT4kFnudQpGbNhwtxpWsJqxpTFQqrLljKJUHfU9g9TJuPUypOfqXm0e/g0xvhItEeJUWVC7mYJl+oYw==, 1/4/2023 4:55:08 AM, , , 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, True, 12/28/2022 4:55:08 AM, kelvin.voon@techworkstudio.com [20221228 12:55:08.120][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 0, Login, {"FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","Password":"tzulv3JMUMJQPtAEIPVx4b\u002BW5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ","ContactNo":null,"Picture":null,"DefaultAuthScheme":0,"DefaultLang":0,"LastLoginIP":"61.6.137.137","LastLoginDate":"2022-12-28T04:55:08.1008592Z","RefreshToken":"KwP1EGEFT4kFnudQpGbNhwtxpWsJqxpTFQqrLljKJUHfU9g9TJuPUypOfqXm0e/g0xvhItEeJUWVC7mYJl\u002BoYw==","RefreshTokenExpiry":"2023-01-04T04:55:08.1009181Z","StoreId":null,"OAuthId":null,"Stores":[{"Name":"test","AddressId":"ad2a2335-b909-499a-a783-c2fb34fd3791","Address":null,"Users":null,"Staffs":null,"SEOId":null,"SEO":null,"BrandId":"0d29ac01-90f7-474d-9bf8-6476f665745a","Brand":null,"PreferenceId":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Preference":null,"PolicyId":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Policy":null,"SurveyId":"d1969fb5-4135-4302-89c2-bdcde84d019d","Survey":null,"DomainId":"356ab978-1b98-48f4-ace6-3064d2a923f7","Domain":null,"OrderReferenceNoId":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","OrderReferenceNo":null,"Taxes":null,"Customers":null,"Tags":null,"Carts":null,"Orders":null,"Collections":null,"Products":null,"Blogs":null,"Suppliers":null,"PageContents":null,"Currencies":null,"PaymentMethods":null,"DeliveryMethods":null,"Reviews":null,"Discounts":null,"GUID":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null}],"Permissions":null,"GUID":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"2022-12-28T04:55:08.1009204Z","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":"kelvin.voon@techworkstudio.com"}, 61.6.137.137, 36868dd9-9cb6-46a7-b41a-08b505e34533, True, 12/28/2022 4:55:08 AM, 1/1/0001 12:00:00 AM, [20221228 12:55:08.124][INF] [AuthController][EmailLogin] {"Id":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","DefaultAuthScheme":0,"DefaultLang":0,"Stores":["ac702b8e-97d3-4a3a-936e-6e36a9ed82ce"],"RefreshToken":"KwP1EGEFT4kFnudQpGbNhwtxpWsJqxpTFQqrLljKJUHfU9g9TJuPUypOfqXm0e/g0xvhItEeJUWVC7mYJl+oYw==","RefreshTokenExpiry":1672808108124,"Status":200,"Token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiIxYjNiNzJiMi0wMWJiLTRiMjQtOWIwYS1jOTQwM2VlYmEyYTIiLCJnaXZlbl9uYW1lIjoiS2VsdmluIiwiZmFtaWx5X25hbWUiOiJWb29uIiwibmFtZSI6IlZvb24gS2VsdmluIiwiZW1haWwiOiJrZWx2aW4udm9vbkB0ZWNod29ya3N0dWRpby5jb20iLCJhdXRobWV0aG9kIjoiRW1haWwiLCJyb2xlIjoiVXNlciIsIm5iZiI6MTY3MjIwMzMwOCwiZXhwIjoxNjcyMjAzNjA4LCJpYXQiOjE2NzIyMDMzMDgsImlzcyI6InRoZXNob3BiaXQuY29tIiwiYXVkIjoiZmUifQ.9S2aDVVqArgvzjA46vsTnjvYLz74ivF4wtu0c_yv4W8"} [20221228 12:55:25.041][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/auth/EmailLogin [20221228 12:55:25.042][INF] [DecryptionMiddleware][Invoke] RawBody EwQ3COQG4NqeHiXbbQSThP2Xm/yfkgsoc7Dr7LiBJoZI8xB5ga8hg6qZOrCVzQsoGaqAWcmNsIUDyXgbJVaWUHrVsDv/HpDb0xb3KIlc4pskuYPR5IyUWGEDmox9baH+2tz6lrGjXxyrtlI6fuztCG/dcKsiLsaID21u1tPxGi3IunIkQ9gbhmCv8TMPax4C7akxHrlAVaEtCdQ9hVUSnBWiGQqx+ZufeXITWsOmALcgusHxtKnNIEMBTDTm5VPUvKwroqXBzlvR1lFLJyETv86iEyOg+WIRPWFVNKzElWhoP+563Qt9DPkSi0/9S9QDDWEOrE6pLBQbZgSX709+m8ooDLIYTx6HW3Kxd72vRZbadZVwQx6Y5gL2RfBl6R/bVCY4BNSp3qLdElJ+z+tkWLKJyLUeGu16d5RI+P+1r+1lE6XzHkPXhQh81cIu49NddWT9KauMIMmxESB1ZhFtK0eiYgSBq1t4AbRiucJu7LrRD2vKxLuiKgCMzBtUHObmPFVkpEPzoHWyuKRA0YIkHWGWBwwYTaHX4HuDFTzPGyFFvjRED+lWOaI2j9lNqUJ2SWnbpUbLmoMoDembteXI1/ExwH6XbdsY9OgzkpoatsptUN4RTYiaK8EZtum5ajgb0/Q72aAsg3zzKO1rIcxrxj6h2FFjerlL6z8V70jd4zA= [20221228 12:55:25.042][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"UserEmailLogin","SeqNo":"b5d6f58f-37fc-44e9-9154-12fddecaf27a","TimeSpan":1672203325,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"TD80t13rIhvtAXvAbjLiAYHxSYdJn1Lg2f11DVm+8Ok=","AppVersion":"V1.0.0.2022092601","Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA="} [20221228 12:55:25.043][INF] [AuthController][EmailLogin] {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"b5d6f58f-37fc-44e9-9154-12fddecaf27a","TimeSpan":1672203325,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"TD80t13rIhvtAXvAbjLiAYHxSYdJn1Lg2f11DVm+8Ok=","AppVersion":"V1.0.0.2022092601"} [20221228 12:55:25.043][INF] [BaseController][CheckValidation][UserLoginRequestModel] validationResult: true model: {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"b5d6f58f-37fc-44e9-9154-12fddecaf27a","TimeSpan":1672203325,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"TD80t13rIhvtAXvAbjLiAYHxSYdJn1Lg2f11DVm+8Ok=","AppVersion":"V1.0.0.2022092601"} [20221228 12:55:25.045][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE (( `Email` = @Email0 ) AND ( `Password` = @Password1 )) Param: kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ [20221228 12:55:25.050][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:55:25.051][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:55:25.053][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 1, EmailLogin, {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"b5d6f58f-37fc-44e9-9154-12fddecaf27a","TimeSpan":1672203325,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"TD80t13rIhvtAXvAbjLiAYHxSYdJn1Lg2f11DVm+8Ok=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, 4c4b0f8b-488d-4172-8abf-bc0e786023b1, True, 12/28/2022 4:55:25 AM, 1/1/0001 12:00:00 AM, [20221228 12:55:25.059][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE `GUID` = @InPara0 Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2 [20221228 12:55:25.061][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:55:25.062][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:55:25.068][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblUser` SET `FirstName`=@FirstName,`LastName`=@LastName,`Email`=@Email,`Password`=@Password,`ContactNo`=@ContactNo,`Picture`=@Picture,`DefaultAuthScheme`=@DefaultAuthScheme,`DefaultLang`=@DefaultLang,`LastLoginIP`=@LastLoginIP,`LastLoginDate`=@LastLoginDate,`RefreshToken`=@RefreshToken,`RefreshTokenExpiry`=@RefreshTokenExpiry,`StoreId`=@StoreId,`OAuthId`=@OAuthId,`Status`=@Status,`ModifiedDate`=@ModifiedDate,`ModifiedBy`=@ModifiedBy WHERE `GUID`=@GUID Param: Kelvin, Voon, kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ, , , 0, 0, 61.6.137.137, 12/28/2022 4:55:25 AM, Yvibnc5vlP4lPM4u2d2+7fURUJ3DXsL9xDYDdJ1yrVsWPEUPnanEF5uqNJ8aia4XLSQHh/UxvFHuH7P+ilNV1g==, 1/4/2023 4:55:25 AM, , , 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, True, 12/28/2022 4:55:25 AM, kelvin.voon@techworkstudio.com [20221228 12:55:25.086][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 0, Login, {"FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","Password":"tzulv3JMUMJQPtAEIPVx4b\u002BW5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ","ContactNo":null,"Picture":null,"DefaultAuthScheme":0,"DefaultLang":0,"LastLoginIP":"61.6.137.137","LastLoginDate":"2022-12-28T04:55:25.067317Z","RefreshToken":"Yvibnc5vlP4lPM4u2d2\u002B7fURUJ3DXsL9xDYDdJ1yrVsWPEUPnanEF5uqNJ8aia4XLSQHh/UxvFHuH7P\u002BilNV1g==","RefreshTokenExpiry":"2023-01-04T04:55:25.0673911Z","StoreId":null,"OAuthId":null,"Stores":[{"Name":"test","AddressId":"ad2a2335-b909-499a-a783-c2fb34fd3791","Address":null,"Users":null,"Staffs":null,"SEOId":null,"SEO":null,"BrandId":"0d29ac01-90f7-474d-9bf8-6476f665745a","Brand":null,"PreferenceId":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Preference":null,"PolicyId":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Policy":null,"SurveyId":"d1969fb5-4135-4302-89c2-bdcde84d019d","Survey":null,"DomainId":"356ab978-1b98-48f4-ace6-3064d2a923f7","Domain":null,"OrderReferenceNoId":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","OrderReferenceNo":null,"Taxes":null,"Customers":null,"Tags":null,"Carts":null,"Orders":null,"Collections":null,"Products":null,"Blogs":null,"Suppliers":null,"PageContents":null,"Currencies":null,"PaymentMethods":null,"DeliveryMethods":null,"Reviews":null,"Discounts":null,"GUID":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null}],"Permissions":null,"GUID":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"2022-12-28T04:55:25.0673943Z","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":"kelvin.voon@techworkstudio.com"}, 61.6.137.137, 31020d1d-c788-4c58-8b0f-6b39147b53ca, True, 12/28/2022 4:55:25 AM, 1/1/0001 12:00:00 AM, [20221228 12:55:25.090][INF] [AuthController][EmailLogin] {"Id":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","DefaultAuthScheme":0,"DefaultLang":0,"Stores":["ac702b8e-97d3-4a3a-936e-6e36a9ed82ce"],"RefreshToken":"Yvibnc5vlP4lPM4u2d2+7fURUJ3DXsL9xDYDdJ1yrVsWPEUPnanEF5uqNJ8aia4XLSQHh/UxvFHuH7P+ilNV1g==","RefreshTokenExpiry":1672808125090,"Status":200,"Token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiIxYjNiNzJiMi0wMWJiLTRiMjQtOWIwYS1jOTQwM2VlYmEyYTIiLCJnaXZlbl9uYW1lIjoiS2VsdmluIiwiZmFtaWx5X25hbWUiOiJWb29uIiwibmFtZSI6IlZvb24gS2VsdmluIiwiZW1haWwiOiJrZWx2aW4udm9vbkB0ZWNod29ya3N0dWRpby5jb20iLCJhdXRobWV0aG9kIjoiRW1haWwiLCJyb2xlIjoiVXNlciIsIm5iZiI6MTY3MjIwMzMyNSwiZXhwIjoxNjcyMjAzNjI1LCJpYXQiOjE2NzIyMDMzMjUsImlzcyI6InRoZXNob3BiaXQuY29tIiwiYXVkIjoiZmUifQ.RT7FBy4jLpRYZU-U10VI5jscflKPMp1yZMyvtfuvRks"} [20221228 12:55:44.043][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/auth/EmailLogin [20221228 12:55:44.043][INF] [DecryptionMiddleware][Invoke] RawBody EwQ3COQG4NqeHiXbbQSThP2Xm/yfkgsoc7Dr7LiBJoYr/hkUbUPkmGOdD4qX/EoK0lfLCFBZ+C7CMjsKFW3aQqFzoShmPhR0+LOtbjKqnJLmIRaERJLSR5vTvG+F1yDIa0Vy7st8QwOElz+odDUhsmDmXkXD7bwZ1FA5W9tO1daN3+lYGW3YUivodKNXLtLveD2svsKj6jJF1YvMREUbXUTH0MlBMlOPhMjAdXBR48QY72kZiPECIhemEXtyoS/nvDRBs3cIl5dAxVVfwvu+6IX4Vdzy/MI35Hdwuax2MjAfwmgVBKJT7kcC7Y+lbV5G6scPgAkkCyITVMt1JKXih4e4SJiU+U8mMcraNhHuaenjp2H9I1mzUI20Xb7kUfbJubBFjqB1lfFPsUkiE+eShc2GUKxWvfNDLBFqXIk+raZWYTS1C2Z8WLjLdpLWL/p/HxOZOOrFBaUo+XY4/H4cnAQI5m5rAJB7FeapZvTMgrqbabLKrN06XMAJboE+1yygKRrgeR30tCBjZF3cJyrphyZW58c1fE/ecxKEg4ZxKz/DOPFo81yQhvX1t6RdenYJxnB0YRKP9CuvDPv2HpJ58TUu5xIij2TP3D5xObSdjKHjZ3UvETPqgrbsHoYnTgydWlnWXML47r4HgSrLklEx0EBuTkDWhm2aaMf80nkZBoE= [20221228 12:55:44.044][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"UserEmailLogin","SeqNo":"ce32db27-fcf3-48f7-957f-4dabb7f3c7de","TimeSpan":1672203344,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"zujNYGusfJHDlto1tP3nbOVN2rm6C01gzNicA3W4SiY=","AppVersion":"V1.0.0.2022092601","Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA="} [20221228 12:55:44.044][INF] [AuthController][EmailLogin] {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"ce32db27-fcf3-48f7-957f-4dabb7f3c7de","TimeSpan":1672203344,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"zujNYGusfJHDlto1tP3nbOVN2rm6C01gzNicA3W4SiY=","AppVersion":"V1.0.0.2022092601"} [20221228 12:55:44.045][INF] [BaseController][CheckValidation][UserLoginRequestModel] validationResult: true model: {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"ce32db27-fcf3-48f7-957f-4dabb7f3c7de","TimeSpan":1672203344,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"zujNYGusfJHDlto1tP3nbOVN2rm6C01gzNicA3W4SiY=","AppVersion":"V1.0.0.2022092601"} [20221228 12:55:44.046][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE (( `Email` = @Email0 ) AND ( `Password` = @Password1 )) Param: kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ [20221228 12:55:44.054][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:55:44.056][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:55:44.059][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 1, EmailLogin, {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"ce32db27-fcf3-48f7-957f-4dabb7f3c7de","TimeSpan":1672203344,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"zujNYGusfJHDlto1tP3nbOVN2rm6C01gzNicA3W4SiY=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, 2b576e84-711b-423c-8a04-221399e34f5d, True, 12/28/2022 4:55:44 AM, 1/1/0001 12:00:00 AM, [20221228 12:55:44.064][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE `GUID` = @InPara0 Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2 [20221228 12:55:44.068][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:55:44.070][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:55:44.072][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblUser` SET `FirstName`=@FirstName,`LastName`=@LastName,`Email`=@Email,`Password`=@Password,`ContactNo`=@ContactNo,`Picture`=@Picture,`DefaultAuthScheme`=@DefaultAuthScheme,`DefaultLang`=@DefaultLang,`LastLoginIP`=@LastLoginIP,`LastLoginDate`=@LastLoginDate,`RefreshToken`=@RefreshToken,`RefreshTokenExpiry`=@RefreshTokenExpiry,`StoreId`=@StoreId,`OAuthId`=@OAuthId,`Status`=@Status,`ModifiedDate`=@ModifiedDate,`ModifiedBy`=@ModifiedBy WHERE `GUID`=@GUID Param: Kelvin, Voon, kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ, , , 0, 0, 61.6.137.137, 12/28/2022 4:55:44 AM, PbcT2Q54v0Fl6VZCLzyfZcKEo+QioPz3jmTH95ErVvyEoeeQrLFchLb5ufpJVHrE4Yxz4PElkbru6xcsf5XcBQ==, 1/4/2023 4:55:44 AM, , , 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, True, 12/28/2022 4:55:44 AM, kelvin.voon@techworkstudio.com [20221228 12:55:44.093][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 0, Login, {"FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","Password":"tzulv3JMUMJQPtAEIPVx4b\u002BW5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ","ContactNo":null,"Picture":null,"DefaultAuthScheme":0,"DefaultLang":0,"LastLoginIP":"61.6.137.137","LastLoginDate":"2022-12-28T04:55:44.0718079Z","RefreshToken":"PbcT2Q54v0Fl6VZCLzyfZcKEo\u002BQioPz3jmTH95ErVvyEoeeQrLFchLb5ufpJVHrE4Yxz4PElkbru6xcsf5XcBQ==","RefreshTokenExpiry":"2023-01-04T04:55:44.0718333Z","StoreId":null,"OAuthId":null,"Stores":[{"Name":"test","AddressId":"ad2a2335-b909-499a-a783-c2fb34fd3791","Address":null,"Users":null,"Staffs":null,"SEOId":null,"SEO":null,"BrandId":"0d29ac01-90f7-474d-9bf8-6476f665745a","Brand":null,"PreferenceId":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Preference":null,"PolicyId":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Policy":null,"SurveyId":"d1969fb5-4135-4302-89c2-bdcde84d019d","Survey":null,"DomainId":"356ab978-1b98-48f4-ace6-3064d2a923f7","Domain":null,"OrderReferenceNoId":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","OrderReferenceNo":null,"Taxes":null,"Customers":null,"Tags":null,"Carts":null,"Orders":null,"Collections":null,"Products":null,"Blogs":null,"Suppliers":null,"PageContents":null,"Currencies":null,"PaymentMethods":null,"DeliveryMethods":null,"Reviews":null,"Discounts":null,"GUID":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null}],"Permissions":null,"GUID":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"2022-12-28T04:55:44.0718361Z","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":"kelvin.voon@techworkstudio.com"}, 61.6.137.137, 1b1d751b-8743-493a-8c81-2299c69b37c4, True, 12/28/2022 4:55:44 AM, 1/1/0001 12:00:00 AM, [20221228 12:55:44.097][INF] [AuthController][EmailLogin] {"Id":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","DefaultAuthScheme":0,"DefaultLang":0,"Stores":["ac702b8e-97d3-4a3a-936e-6e36a9ed82ce"],"RefreshToken":"PbcT2Q54v0Fl6VZCLzyfZcKEo+QioPz3jmTH95ErVvyEoeeQrLFchLb5ufpJVHrE4Yxz4PElkbru6xcsf5XcBQ==","RefreshTokenExpiry":1672808144097,"Status":200,"Token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiIxYjNiNzJiMi0wMWJiLTRiMjQtOWIwYS1jOTQwM2VlYmEyYTIiLCJnaXZlbl9uYW1lIjoiS2VsdmluIiwiZmFtaWx5X25hbWUiOiJWb29uIiwibmFtZSI6IlZvb24gS2VsdmluIiwiZW1haWwiOiJrZWx2aW4udm9vbkB0ZWNod29ya3N0dWRpby5jb20iLCJhdXRobWV0aG9kIjoiRW1haWwiLCJyb2xlIjoiVXNlciIsIm5iZiI6MTY3MjIwMzM0NCwiZXhwIjoxNjcyMjAzNjQ0LCJpYXQiOjE2NzIyMDMzNDQsImlzcyI6InRoZXNob3BiaXQuY29tIiwiYXVkIjoiZmUifQ.BIdBnmnMhL04TmRJvkPnfWqaMuLRGsMMGin3B_GLZlQ"} [20221228 12:59:39.025][INF] [DecryptionMiddleware][Invoke] Request Method POST, Path /api/v1/auth/EmailLogin [20221228 12:59:39.026][INF] [DecryptionMiddleware][Invoke] RawBody EwQ3COQG4NqeHiXbbQSThP2Xm/yfkgsoc7Dr7LiBJoYqdyGJbyqc/i+cFYbClTnGDFfZNvDCKiBoFkMFuZ7btaxpvNqRuF8ZY/u7DRHjfcUlrvm1waacL7JP5rhuKa2Ovjf1cwhJG0OUZecGgZNBZIiHjVhJuz4HiqkC+lkF6bXnxgm5x0Q5GFcySMAZPv5nBGNeLRlum7VvwGyFx+SNXoHCM7HpXKpn2EDgw31YenL147DwuexgPf/gyL/Sxy+TZgouISFEJi8AFpClEw67paHwBeTyUKfCJRkEYT0I5zoQTjhMOMQUSh8Fw7tZva7aWJDXGXrUcflGMnrsLKZdD8iYV+wtyA5VI+Nl31NsYjl7nji712PGQcUGU78tMo/gCbjz28c06lpT8S0XRLe2rDcbCDOCibBPiHbV8iV8fo1K4GMmcj8HHU9KdLMbC7uVfvYJbCnXjQJyerKj+1sX0LIHnywb9w4rcZN/FKc0mupYSPin5JhQzyDYxDSgyvDlgVbIBIFc0LDvZnFqzePFmvt92S3BTJHQwOr5e9Ogem3OWuGyEbdNd1IT41NosXhTqu9ahFyV5ZgXxOIRc+u4u6ctU2bzBE83fL4xuGTyRoJam/8jas/gWftqDIIc7PBExs/dyie58o+y6Q84qmwJbjvVm8Ve4XjzMGfaiWYVnuI= [20221228 12:59:39.026][INF] [DecryptionMiddleware][Invoke] DecryptedBody {"Cmd":"UserEmailLogin","SeqNo":"fe85bfe3-f73b-4bf0-a218-0d84d883b04a","TimeSpan":1672203579,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"ppskgbV6gzbFzlgTpOFWtT1hxElDNriWrA9eVrxe5+Y=","AppVersion":"V1.0.0.2022092601","Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA="} [20221228 12:59:39.029][INF] [AuthController][EmailLogin] {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"fe85bfe3-f73b-4bf0-a218-0d84d883b04a","TimeSpan":1672203579,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"ppskgbV6gzbFzlgTpOFWtT1hxElDNriWrA9eVrxe5+Y=","AppVersion":"V1.0.0.2022092601"} [20221228 12:59:39.030][INF] [BaseController][CheckValidation][UserLoginRequestModel] validationResult: true model: {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"fe85bfe3-f73b-4bf0-a218-0d84d883b04a","TimeSpan":1672203579,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"ppskgbV6gzbFzlgTpOFWtT1hxElDNriWrA9eVrxe5+Y=","AppVersion":"V1.0.0.2022092601"} [20221228 12:59:39.033][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE (( `Email` = @Email0 ) AND ( `Password` = @Password1 )) Param: kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ [20221228 12:59:39.040][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:59:39.042][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:59:39.046][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 1, EmailLogin, {"Email":"kelvin.voon@techworkstudio.com","Password":"DJyx60csXRYw1XFmIe0UemhEqxS6TZWXQA46RwZzGzA=","Cmd":"UserEmailLogin","SeqNo":"fe85bfe3-f73b-4bf0-a218-0d84d883b04a","TimeSpan":1672203579,"ApiKey":"KaaurR4+iUf/UXUI3ncJldsCz8tf1nOeznMYKITjBFhv9hP16Pnf+Y+P31D1rkns7I2+YAewrfOIAfzK2AASFJOIR5wesPsByfk+ZJ//uL6P0pm/EFhrtpwNPHchuT8sD9gnQYQTaweR8UvmUDvPQ9V7mqxAjedEfEDLm0M8s2jrvthqMj8YJclNFrAmN","IP":"61.6.137.137","Signature":"ppskgbV6gzbFzlgTpOFWtT1hxElDNriWrA9eVrxe5+Y=","AppVersion":"V1.0.0.2022092601"}, 61.6.137.137, bd38b2ed-e2e0-4743-983b-18da9528bb3c, True, 12/28/2022 4:59:39 AM, 1/1/0001 12:00:00 AM, [20221228 12:59:39.050][INF] [RepositoryContext][OnLogExecuting] SELECT `FirstName`,`LastName`,`Email`,`Password`,`ContactNo`,`Picture`,`DefaultAuthScheme`,`DefaultLang`,`LastLoginIP`,`LastLoginDate`,`RefreshToken`,`RefreshTokenExpiry`,`StoreId`,`OAuthId`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `TblUser` WHERE `GUID` = @InPara0 Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2 [20221228 12:59:39.052][INF] [RepositoryContext][OnLogExecuting] SELECT `UserId` as aid,`StoreId` as bid FROM `TblUserStoreMapping` WHERE `UserId` IN ('1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2') Param: [20221228 12:59:39.053][INF] [RepositoryContext][OnLogExecuting] SELECT * FROM `TblStore` WHERE `GUID` IN ('ac702b8e-97d3-4a3a-936e-6e36a9ed82ce') Param: [20221228 12:59:39.055][INF] [RepositoryContext][OnLogExecuting] UPDATE `TblUser` SET `FirstName`=@FirstName,`LastName`=@LastName,`Email`=@Email,`Password`=@Password,`ContactNo`=@ContactNo,`Picture`=@Picture,`DefaultAuthScheme`=@DefaultAuthScheme,`DefaultLang`=@DefaultLang,`LastLoginIP`=@LastLoginIP,`LastLoginDate`=@LastLoginDate,`RefreshToken`=@RefreshToken,`RefreshTokenExpiry`=@RefreshTokenExpiry,`StoreId`=@StoreId,`OAuthId`=@OAuthId,`Status`=@Status,`ModifiedDate`=@ModifiedDate,`ModifiedBy`=@ModifiedBy WHERE `GUID`=@GUID Param: Kelvin, Voon, kelvin.voon@techworkstudio.com, tzulv3JMUMJQPtAEIPVx4b+W5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ, , , 0, 0, 61.6.137.137, 12/28/2022 4:59:39 AM, 9gDEGthzM7fpWAIzCNpGzaUQP+HxrZ2nfnVqOK/Hrm3QlI6RQSHYHRsEu1RBNEciiCapfPWTyVjZwsiWzFgOhQ==, 1/4/2023 4:59:39 AM, , , 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, True, 12/28/2022 4:59:39 AM, kelvin.voon@techworkstudio.com [20221228 12:59:39.079][INF] [RepositoryContext][OnLogExecuting] INSERT INTO `TblUserLog` (`UserId`,`Action`,`ActionString`,`ModelString`,`IpAddress`,`GUID`,`Status`,`CreateDate`,`ModifiedDate`,`CreatedBy`) VALUES (@UserId,@Action,@ActionString,@ModelString,@IpAddress,@GUID,@Status,@CreateDate,@ModifiedDate,@CreatedBy) ; Param: 1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2, 0, Login, {"FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","Password":"tzulv3JMUMJQPtAEIPVx4b\u002BW5ZbVYo8pdBHd6StGE6G7KO2HXWCxMaQnVYN95IaZ","ContactNo":null,"Picture":null,"DefaultAuthScheme":0,"DefaultLang":0,"LastLoginIP":"61.6.137.137","LastLoginDate":"2022-12-28T04:59:39.0549223Z","RefreshToken":"9gDEGthzM7fpWAIzCNpGzaUQP\u002BHxrZ2nfnVqOK/Hrm3QlI6RQSHYHRsEu1RBNEciiCapfPWTyVjZwsiWzFgOhQ==","RefreshTokenExpiry":"2023-01-04T04:59:39.0550083Z","StoreId":null,"OAuthId":null,"Stores":[{"Name":"test","AddressId":"ad2a2335-b909-499a-a783-c2fb34fd3791","Address":null,"Users":null,"Staffs":null,"SEOId":null,"SEO":null,"BrandId":"0d29ac01-90f7-474d-9bf8-6476f665745a","Brand":null,"PreferenceId":"f5cf651c-0dec-4bc4-b1e6-dce4e5497f79","Preference":null,"PolicyId":"fe55caca-d676-47cc-9f1d-253bd500e6e5","Policy":null,"SurveyId":"d1969fb5-4135-4302-89c2-bdcde84d019d","Survey":null,"DomainId":"356ab978-1b98-48f4-ace6-3064d2a923f7","Domain":null,"OrderReferenceNoId":"b4eef56f-22dd-4252-a9be-ef90b628ac1e","OrderReferenceNo":null,"Taxes":null,"Customers":null,"Tags":null,"Carts":null,"Orders":null,"Collections":null,"Products":null,"Blogs":null,"Suppliers":null,"PageContents":null,"Currencies":null,"PaymentMethods":null,"DeliveryMethods":null,"Reviews":null,"Discounts":null,"GUID":"ac702b8e-97d3-4a3a-936e-6e36a9ed82ce","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"0001-01-01T00:00:00","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":null}],"Permissions":null,"GUID":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","Status":true,"CreateDate":"2022-12-28T04:54:19","ModifiedDate":"2022-12-28T04:59:39.0550161Z","CreatedBy":"kelvin.voon@techworkstudio.com","ModifiedBy":"kelvin.voon@techworkstudio.com"}, 61.6.137.137, 04376218-2c76-49e9-8dff-d8878b59b1d3, True, 12/28/2022 4:59:39 AM, 1/1/0001 12:00:00 AM, [20221228 12:59:39.088][INF] [AuthController][EmailLogin] {"Id":"1b3b72b2-01bb-4b24-9b0a-c9403eeba2a2","FirstName":"Kelvin","LastName":"Voon","Username":"Voon Kelvin","Email":"kelvin.voon@techworkstudio.com","DefaultAuthScheme":0,"DefaultLang":0,"Stores":["ac702b8e-97d3-4a3a-936e-6e36a9ed82ce"],"RefreshToken":"9gDEGthzM7fpWAIzCNpGzaUQP+HxrZ2nfnVqOK/Hrm3QlI6RQSHYHRsEu1RBNEciiCapfPWTyVjZwsiWzFgOhQ==","RefreshTokenExpiry":1672808379088,"Status":200,"Token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9zaWQiOiIxYjNiNzJiMi0wMWJiLTRiMjQtOWIwYS1jOTQwM2VlYmEyYTIiLCJnaXZlbl9uYW1lIjoiS2VsdmluIiwiZmFtaWx5X25hbWUiOiJWb29uIiwibmFtZSI6IlZvb24gS2VsdmluIiwiZW1haWwiOiJrZWx2aW4udm9vbkB0ZWNod29ya3N0dWRpby5jb20iLCJhdXRobWV0aG9kIjoiRW1haWwiLCJyb2xlIjoiVXNlciIsIm5iZiI6MTY3MjIwMzU3OSwiZXhwIjoxNjcyMjAzODc5LCJpYXQiOjE2NzIyMDM1NzksImlzcyI6InRoZXNob3BiaXQuY29tIiwiYXVkIjoiZmUifQ.5GmOIxuRuxAhEQ_Hc8eHxQ8e8vGhY0PxbwOm7_JWTLA"}