[20240913 16:01:40.673][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:01:40.679][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","SessionToken":"wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE=","Cmd":"GetAuthorizeToken","SeqNo":"f29ea4c4-77ad-4701-9062-302726ff20e4","TimeSpan":1726214498,"Signature":"6ndx4mbespbimlcsxlzpku86sd/oyjdiyddhcc0waz4=","$type":"TokenRequestModel"} [20240913 16:01:40.680][INF] [TokenRequestModel] 1726214498GetAuthorizeTokenf29ea4c4-77ad-4701-9062-302726ff20e4b2234a53-976d-4336-85b6-8a4ae4e9c9e3wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE= [20240913 16:01:40.684][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:40.748][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:40.753][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:40.754][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:40.755][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTQ1MDAsImV4cCI6MTcyNjIxNDYyMCwiaWF0IjoxNzI2MjE0NTAwLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.sp2ho2nj2l2PBagUZIQpUUOdM43z_bDrTy8ixEENmwI","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:01:40.759][INF] HTTP POST /api/v1/token/authorize responded 200 in 86.7522 ms [20240913 16:01:40.782][INF] HTTP OPTIONS /api/v1/client/submitreport responded 204 in 0.0904 ms [20240913 16:01:42.064][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTQ1MDAsImV4cCI6MTcyNjIxNDYyMCwiaWF0IjoxNzI2MjE0NTAwLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9","EncodedSignature":"sp2ho2nj2l2PBagUZIQpUUOdM43z_bDrTy8ixEENmwI","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTQ1MDAsImV4cCI6MTcyNjIxNDYyMCwiaWF0IjoxNzI2MjE0NTAwLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.sp2ho2nj2l2PBagUZIQpUUOdM43z_bDrTy8ixEENmwI","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"dd563cbb-31e3-4c7d-affd-58bcd17a13d3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"demo","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Administrator","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726214500","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726214620","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726214500","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:01:40.0000000Z","Issuer":"localhost","Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","Subject":"demo@paybittech.com","ValidFrom":"2024-09-13T08:01:40.0000000Z","ValidTo":"2024-09-13T08:03:40.0000000Z","$type":"JsonWebToken"} [20240913 16:01:42.067][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.069][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.070][INF] [DbContext][OnLogExecuting] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.071][INF] [DbContext][OnLogExecuted] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.072][INF] [DbContext][OnLogExecuting] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.074][INF] [DbContext][OnLogExecuted] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.074][INF] [DbContext][OnLogExecuting] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:01:42.075][INF] [DbContext][OnLogExecuted] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:01:42.083][INF] [ClientController][SubmitDocument][Request] {"File":{"ContentDisposition":"form-data; name=\"file\"; filename=\"encrypt.enc\"","ContentType":"application/octet-stream","Headers":[{"Key":"Content-Disposition","Value":["form-data; name=\"file\"; filename=\"encrypt.enc\""],"$type":"KeyValuePair`2"},{"Key":"Content-Type","Value":["application/octet-stream"],"$type":"KeyValuePair`2"}],"Length":736,"Name":"file","FileName":"encrypt.enc","$type":"FormFile"},"$type":"FileTransferRequestModel"} [20240913 16:01:42.084][INF] [SubmitReportRequestModel] 1726214498SubmitDocument87b0b5e6-2a4e-4976-98cb-df34963cbc47 [20240913 16:01:42.086][INF] [DbContext][OnLogExecuting] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE (( `ClientId` = @ClientId0 ) AND ( `isCurrent` = @isCurrent1 )) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691, True] [20240913 16:01:42.088][INF] [DbContext][OnLogExecuted] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE (( `ClientId` = @ClientId0 ) AND ( `isCurrent` = @isCurrent1 )) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691, True] [20240913 16:01:42.088][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`ContentType` AS `ContentType`,`SubmissionId` AS `SubmissionId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_report_submission` WHERE `SubmissionId` = 'b3b8698c-8206-4339-ac7d-f23e8c9d35bc' Params: [] [20240913 16:01:42.089][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`ContentType` AS `ContentType`,`SubmissionId` AS `SubmissionId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_report_submission` WHERE `SubmissionId` = 'b3b8698c-8206-4339-ac7d-f23e8c9d35bc' Params: [] [20240913 16:01:42.090][INF] [DbContext][OnLogExecuting] SELECT `FullName` AS `FullName`,`RealName` AS `RealName`,`NRIC` AS `NRIC`,`Gender` AS `Gender`,`IDType` AS `IDType`,`Nationality` AS `Nationality`,`Nationality2` AS `Nationality2`,`PlaceOfIssue` AS `PlaceOfIssue`,`DateOfBirth` AS `DateOfBirth`,`IssueDate` AS `IssueDate`,`ExpiryDate` AS `ExpiryDate`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Password` AS `Password`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`IDType2` AS `IDType2`,`ClientType` AS `ClientType`,`Designation` AS `Designation`,`Title` AS `Title`,`Alias` AS `Alias`,`Country` AS `Country`,`City` AS `City`,`State` AS `State`,`PostCode` AS `PostCode`,`IsEmailVerify` AS `IsEmailVerify`,`IsInfoCompleted` AS `IsInfoCompleted`,`Status` AS `Status`,`LastLogin` AS `LastLogin`,`AuthCode` AS `AuthCode`,`AuthPublic` AS `AuthPublic`,`BindingDate` AS `BindingDate`,`BindingResetDate` AS `BindingResetDate`,`BindingResetBy` AS `BindingResetBy`,`BindAuth` AS `BindAuth`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_client` WHERE `Id` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:01:42.091][INF] [DbContext][OnLogExecuted] SELECT `FullName` AS `FullName`,`RealName` AS `RealName`,`NRIC` AS `NRIC`,`Gender` AS `Gender`,`IDType` AS `IDType`,`Nationality` AS `Nationality`,`Nationality2` AS `Nationality2`,`PlaceOfIssue` AS `PlaceOfIssue`,`DateOfBirth` AS `DateOfBirth`,`IssueDate` AS `IssueDate`,`ExpiryDate` AS `ExpiryDate`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Password` AS `Password`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`IDType2` AS `IDType2`,`ClientType` AS `ClientType`,`Designation` AS `Designation`,`Title` AS `Title`,`Alias` AS `Alias`,`Country` AS `Country`,`City` AS `City`,`State` AS `State`,`PostCode` AS `PostCode`,`IsEmailVerify` AS `IsEmailVerify`,`IsInfoCompleted` AS `IsInfoCompleted`,`Status` AS `Status`,`LastLogin` AS `LastLogin`,`AuthCode` AS `AuthCode`,`AuthPublic` AS `AuthPublic`,`BindingDate` AS `BindingDate`,`BindingResetDate` AS `BindingResetDate`,`BindingResetBy` AS `BindingResetBy`,`BindAuth` AS `BindAuth`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_client` WHERE `Id` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:01:42.101][INF] [DbContext][OnLogExecuting] INSERT INTO `tbl_report_submission` (`Path`,`Filename`,`Status`,`ContentType`,`SubmissionId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@Path,@Filename,@Status,@ContentType,@SubmissionId,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [/home/theshopbit/public_html/ekyc-api.theshopbit.com/submisison/f27b8c2f-3aef-4e94-b851-5c39cd79d691/report, YsON3RUrswRi63+9+QQJ3Axc97GGUJfNRHNTmuDlx2ijT32JMOzOm/6Lw3SFL3QFqP/fx/On6P955e0u8KD0m+Lv9fSKjTOpEnDQ8fG80Os=, 3, text/plain, b3b8698c-8206-4339-ac7d-f23e8c9d35bc, 64bd201d-cfda-427f-9ae6-9f96e8257e6c, 09/13/2024 08:01:42, 01/01/0001 00:00:00, demo, ] [20240913 16:01:42.102][INF] [DbContext][OnLogExecuted] INSERT INTO `tbl_report_submission` (`Path`,`Filename`,`Status`,`ContentType`,`SubmissionId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@Path,@Filename,@Status,@ContentType,@SubmissionId,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [/home/theshopbit/public_html/ekyc-api.theshopbit.com/submisison/f27b8c2f-3aef-4e94-b851-5c39cd79d691/report, YsON3RUrswRi63+9+QQJ3Axc97GGUJfNRHNTmuDlx2ijT32JMOzOm/6Lw3SFL3QFqP/fx/On6P955e0u8KD0m+Lv9fSKjTOpEnDQ8fG80Os=, 3, text/plain, b3b8698c-8206-4339-ac7d-f23e8c9d35bc, 64bd201d-cfda-427f-9ae6-9f96e8257e6c, 09/13/2024 08:01:42, 01/01/0001 00:00:00, demo, ] [20240913 16:01:42.104][INF] [DbContext][OnLogExecuting] UPDATE `tbl_submission` SET `Path`=@Path,`Filename`=@Filename,`Status`=@Status,`isCurrent`=@isCurrent,`Reasons`=@Reasons,`Remark`=@Remark,`ClientId`=@ClientId,`CreateDate`=@CreateDate,`ModifiedDate`=@ModifiedDate,`CreatedBy`=@CreatedBy,`ModifiedBy`=@ModifiedBy WHERE `Id`=@Id Params: [/home/theshopbit/public_html/ekyc-api.theshopbit.com/submisison/f27b8c2f-3aef-4e94-b851-5c39cd79d691, JRRvhdoCzc2tq0ThW5IXzMGUAhOzISows+UomKHfQYKe+0OGyaVfIRQEvYpm+rkjIH4K+VEYLgaZbL3ejcbfgy/Rzb8CCqKvCEPReXeR/4A=, 3, True, ["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"], Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW, f27b8c2f-3aef-4e94-b851-5c39cd79d691, b3b8698c-8206-4339-ac7d-f23e8c9d35bc, 09/13/2024 04:22:52, 09/13/2024 08:01:42, TestPilot, demo] [20240913 16:01:42.106][INF] [DbContext][OnLogExecuted] UPDATE `tbl_submission` SET `Path`=@Path,`Filename`=@Filename,`Status`=@Status,`isCurrent`=@isCurrent,`Reasons`=@Reasons,`Remark`=@Remark,`ClientId`=@ClientId,`CreateDate`=@CreateDate,`ModifiedDate`=@ModifiedDate,`CreatedBy`=@CreatedBy,`ModifiedBy`=@ModifiedBy WHERE `Id`=@Id Params: [/home/theshopbit/public_html/ekyc-api.theshopbit.com/submisison/f27b8c2f-3aef-4e94-b851-5c39cd79d691, JRRvhdoCzc2tq0ThW5IXzMGUAhOzISows+UomKHfQYKe+0OGyaVfIRQEvYpm+rkjIH4K+VEYLgaZbL3ejcbfgy/Rzb8CCqKvCEPReXeR/4A=, 3, True, ["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"], Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW, f27b8c2f-3aef-4e94-b851-5c39cd79d691, b3b8698c-8206-4339-ac7d-f23e8c9d35bc, 09/13/2024 04:22:52, 09/13/2024 08:01:42, TestPilot, demo] [20240913 16:01:42.109][INF] [DbContext][OnLogExecuting] select NOW(6) Params: [] [20240913 16:01:42.110][INF] [DbContext][OnLogExecuted] select NOW(6) Params: [] [20240913 16:01:42.112][INF] [DbContext][OnLogExecuting] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:01:42.121][INF] [DbContext][OnLogExecuted] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:01:42.122][INF] [DbContext][OnLogExecuting] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, {"Status":3,"Files":["data:text/plain;base64,MTN0aCBTZXB0ZW1iZXINCg0KUmVxdWlyZXMgYmFjayBncm91bmQgc2NyZWVuaW5nIGdpdmVuIEhOVyBhbmQgcG9saXRpY2FsIGFzc29jaWF0aW9uLiANCg0KQ2hlY2sgd2l0aCBSTSBhbmQgcGVyZm9ybSBFREQgYmVmb3JlIGFueSBmdXJ0aGVyIHByb2Nlc3NpbmcuIA0K"],"ClientId":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Reasons":["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"],"Remark":"Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW","Cmd":"SubmitDocument","SeqNo":"87b0b5e6-2a4e-4976-98cb-df34963cbc47","TimeSpan":1726214498,"Signature":"hc830+a9qlu39p66ccri8k2x9q/3k6kaddogt3rbj9u="}, Hold Client Submission (Success) - TestPilot, 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 143, SubmitClientReport, 6a3f70e2-8912-4887-9af7-04742119824f, 09/13/2024 08:01:42, 01/01/0001 00:00:00, , ] [20240913 16:01:42.123][INF] [DbContext][OnLogExecuted] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, {"Status":3,"Files":["data:text/plain;base64,MTN0aCBTZXB0ZW1iZXINCg0KUmVxdWlyZXMgYmFjayBncm91bmQgc2NyZWVuaW5nIGdpdmVuIEhOVyBhbmQgcG9saXRpY2FsIGFzc29jaWF0aW9uLiANCg0KQ2hlY2sgd2l0aCBSTSBhbmQgcGVyZm9ybSBFREQgYmVmb3JlIGFueSBmdXJ0aGVyIHByb2Nlc3NpbmcuIA0K"],"ClientId":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Reasons":["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"],"Remark":"Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW","Cmd":"SubmitDocument","SeqNo":"87b0b5e6-2a4e-4976-98cb-df34963cbc47","TimeSpan":1726214498,"Signature":"hc830+a9qlu39p66ccri8k2x9q/3k6kaddogt3rbj9u="}, Hold Client Submission (Success) - TestPilot, 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 143, SubmitClientReport, 6a3f70e2-8912-4887-9af7-04742119824f, 09/13/2024 08:01:42, 01/01/0001 00:00:00, , ] [20240913 16:01:42.125][INF] [ClientController][SubmitDocument][Response] {"Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"BaseResponseModel"} [20240913 16:01:42.127][INF] HTTP POST /api/v1/client/submitreport responded 200 in 63.8189 ms [20240913 16:01:42.159][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:01:42.160][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","SessionToken":"wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE=","Cmd":"GetAuthorizeToken","SeqNo":"740e6b04-c5c9-4f08-8c95-b267379530f0","TimeSpan":1726214500,"Signature":"jhl4nvgm57hrah8okhjoys2ggduibshxwinal/dghg8=","$type":"TokenRequestModel"} [20240913 16:01:42.160][INF] [TokenRequestModel] 1726214500GetAuthorizeToken740e6b04-c5c9-4f08-8c95-b267379530f0b2234a53-976d-4336-85b6-8a4ae4e9c9e3wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE= [20240913 16:01:42.161][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.163][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.165][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.167][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.167][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTQ1MDIsImV4cCI6MTcyNjIxNDYyMiwiaWF0IjoxNzI2MjE0NTAyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.j-2q9bV0ZBQJo59pt6tQXKKt4_lWWJ9S5TZszXfyQRQ","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:01:42.170][INF] HTTP POST /api/v1/token/authorize responded 200 in 10.5322 ms [20240913 16:01:42.185][INF] HTTP OPTIONS /api/v1/client/list responded 204 in 0.0370 ms [20240913 16:01:42.199][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTQ1MDIsImV4cCI6MTcyNjIxNDYyMiwiaWF0IjoxNzI2MjE0NTAyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9","EncodedSignature":"j-2q9bV0ZBQJo59pt6tQXKKt4_lWWJ9S5TZszXfyQRQ","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTQ1MDIsImV4cCI6MTcyNjIxNDYyMiwiaWF0IjoxNzI2MjE0NTAyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.j-2q9bV0ZBQJo59pt6tQXKKt4_lWWJ9S5TZszXfyQRQ","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"dd563cbb-31e3-4c7d-affd-58bcd17a13d3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"demo","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Administrator","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726214502","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726214622","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726214502","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:01:42.0000000Z","Issuer":"localhost","Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","Subject":"demo@paybittech.com","ValidFrom":"2024-09-13T08:01:42.0000000Z","ValidTo":"2024-09-13T08:03:42.0000000Z","$type":"JsonWebToken"} [20240913 16:01:42.202][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.203][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:01:42.204][INF] [DbContext][OnLogExecuting] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.205][INF] [DbContext][OnLogExecuted] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.205][INF] [DbContext][OnLogExecuting] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.206][INF] [DbContext][OnLogExecuted] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:01:42.207][INF] [DbContext][OnLogExecuting] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:01:42.208][INF] [DbContext][OnLogExecuted] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:01:42.208][INF] [WithDecryption][POST][/api/v1/client/list] [20240913 16:01:42.209][INF] [ClientController][GetClientList][Request] {"Name":null,"Status":null,"Page":1,"PageSize":10,"OrderBy":"CreateDate","SortType":"DESC","All":false,"SearchKey":"","FromDate":null,"ToDate":null,"Cmd":"GetClientList","SeqNo":"edd87e2f-c927-4278-963a-414a798759f0","TimeSpan":1726214500,"Signature":"jft4f19a94rlqhxfxk1/opd1awpkhtbk18nnyq5eaa0=","$type":"GetClientListRequestModel"} [20240913 16:01:42.211][INF] [GetClientListRequestModel] 1726214500GetClientListedd87e2f-c927-4278-963a-414a798759f0110 [20240913 16:01:42.213][INF] [DbContext][OnLogExecuting] SELECT Count(*) FROM `tbl_client` Params: [] [20240913 16:01:42.235][INF] [DbContext][OnLogExecuted] SELECT Count(*) FROM `tbl_client` Params: [] [20240913 16:01:42.236][INF] [DbContext][OnLogExecuting] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` ORDER BY `CreateDate` DESC LIMIT 0,10 Params: [] [20240913 16:01:42.238][INF] [DbContext][OnLogExecuted] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` ORDER BY `CreateDate` DESC LIMIT 0,10 Params: [] [20240913 16:01:42.239][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`DocumentType` AS `DocumentType`,`Remark` AS `Remark`,`ContentType` AS `ContentType`,`ExtraInfo` AS `ExtraInfo`,`ClientId` AS `ClientId`,`ShareholderId` AS `ShareholderId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_document` WHERE `ClientId` IN ('60476201-ea60-40d8-84ee-6aef8e64137d','f27b8c2f-3aef-4e94-b851-5c39cd79d691') Params: [] [20240913 16:01:42.240][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`DocumentType` AS `DocumentType`,`Remark` AS `Remark`,`ContentType` AS `ContentType`,`ExtraInfo` AS `ExtraInfo`,`ClientId` AS `ClientId`,`ShareholderId` AS `ShareholderId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_document` WHERE `ClientId` IN ('60476201-ea60-40d8-84ee-6aef8e64137d','f27b8c2f-3aef-4e94-b851-5c39cd79d691') Params: [] [20240913 16:01:42.241][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`isCurrent` AS `isCurrent`,`Reasons` AS `Reasons`,`Remark` AS `Remark`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_submission` WHERE `ClientId` IN ('60476201-ea60-40d8-84ee-6aef8e64137d','f27b8c2f-3aef-4e94-b851-5c39cd79d691') Params: [] [20240913 16:01:42.242][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`isCurrent` AS `isCurrent`,`Reasons` AS `Reasons`,`Remark` AS `Remark`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_submission` WHERE `ClientId` IN ('60476201-ea60-40d8-84ee-6aef8e64137d','f27b8c2f-3aef-4e94-b851-5c39cd79d691') Params: [] [20240913 16:01:42.243][INF] [DbContext][OnLogExecuting] select NOW(6) Params: [] [20240913 16:01:42.244][INF] [DbContext][OnLogExecuted] select NOW(6) Params: [] [20240913 16:01:42.245][INF] [DbContext][OnLogExecuting] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:01:42.247][INF] [DbContext][OnLogExecuted] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:01:42.247][INF] [DbContext][OnLogExecuting] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, {"Name":null,"Status":null,"Page":1,"PageSize":10,"OrderBy":0,"SortType":1,"All":false,"SearchKey":"","FromDate":null,"ToDate":null,"Cmd":"GetClientList","SeqNo":"edd87e2f-c927-4278-963a-414a798759f0","TimeSpan":1726214500,"Signature":"jft4f19a94rlqhxfxk1/opd1awpkhtbk18nnyq5eaa0="}, View Client List, 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 149, ViewClientList, e75975d8-dae4-4983-9ef6-9dea867b89f4, 09/13/2024 08:01:42, 01/01/0001 00:00:00, , ] [20240913 16:01:42.248][INF] [DbContext][OnLogExecuted] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, {"Name":null,"Status":null,"Page":1,"PageSize":10,"OrderBy":0,"SortType":1,"All":false,"SearchKey":"","FromDate":null,"ToDate":null,"Cmd":"GetClientList","SeqNo":"edd87e2f-c927-4278-963a-414a798759f0","TimeSpan":1726214500,"Signature":"jft4f19a94rlqhxfxk1/opd1awpkhtbk18nnyq5eaa0="}, View Client List, 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 149, ViewClientList, e75975d8-dae4-4983-9ef6-9dea867b89f4, 09/13/2024 08:01:42, 01/01/0001 00:00:00, , ] [20240913 16:01:42.250][INF] [ClientController][GetClientList][Response] {"Total":2,"Data":[{"FullName":"PersonX","RealName":"Thomas Shelby","Email":"jolyon.champion@paybittech.com","ContactNo":"411789562","Nationality":"HongKonger","Nationality2":null,"Status":"Active","Gender":null,"PlaceOfIssues":null,"DateOfBirth":null,"IssueDate":null,"ExpiryDate":null,"Address1":"Artus @ Victoria Dockside","Address2":"18 Salisbury Road, Tsim Sha Tsui, ","Address3":"Kowloon, Hong Kong","ClientType":"Company","Designation":"","Title":null,"Alias":"","Country":"HongKong","City":null,"State":null,"IDType":null,"IDType2":null,"NRIC":null,"SubmissionStatus":"Rejected","Reasons":["rejection.insufficient-doc-not-qualified","rejection.document-quality-issue","rejection.mismatched-document-info"],"Remark":"provided documents do not match for identification, proof of address and incorrect documents loaded. Unable to continue with the review until documents are loaded as required. ","CompanyInfo":null,"BankInfo":null,"PaymentDetails":null,"ShareHolders":null,"DirectorBoards":null,"BeneficiaryInfo":null,"Documents":[{"Id":"113a4eb7-6c5e-48b2-b398-2b33fdfecec2","DocumentType":"BUSINESS_REGISTRATION_CERTIFICATE","Remark":"","$type":"ClientDocModel"},{"Id":"29e8b278-6159-4a6e-9ad7-5589c2fbea28","DocumentType":"PROOF_OF_RESIDENCE","Remark":"","$type":"ClientDocModel"},{"Id":"2cffdaa7-3abe-4ab7-af3e-e3fb2694e5e9","DocumentType":"OTHER","Remark":"","$type":"ClientDocModel"},{"Id":"7a0d4aea-6f0e-47cd-9442-0c789cb275d7","DocumentType":"BUSINESS_REGISTRATION_CERTIFICATE","Remark":"","$type":"ClientDocModel"},{"Id":"7a0e088e-d1ff-4f52-9bc7-1af501a89a72","DocumentType":"OTHER","Remark":"","$type":"ClientDocModel"},{"Id":"7deb44f2-a3de-4ff5-8f1f-98439bf79db3","DocumentType":"PROOF_OF_RESIDENCE","Remark":"","$type":"ClientDocModel"},{"Id":"9faa930d-c9f8-45c7-819c-a578b103b4e1","DocumentType":"OTHER","Remark":"","$type":"ClientDocModel"},{"Id":"a325791c-b0c5-4bcb-ad3e-a1d1909e704b","DocumentType":"PROOF_OF_RESIDENCE","Remark":"","$type":"ClientDocModel"},{"Id":"a5ed2256-def7-4bf8-97b0-f84bc97ba3ad","DocumentType":"IC_FRONT","Remark":"","$type":"ClientDocModel"},{"Id":"e80cce7c-1364-438f-9316-a401ecd60588","DocumentType":"IC_FRONT","Remark":"","$type":"ClientDocModel"}],"Reports":null,"Id":"60476201-ea60-40d8-84ee-6aef8e64137d","CreateDate":"2024-09-13T06:10:37.0000000","ModifiedDate":"2024-09-13T06:46:49.0000000","CreatedBy":null,"ModifiedBy":"PersonX","$type":"ClientViewModel"},{"FullName":"TestPilot","RealName":"LEE WEN JIE ELROY","Email":"jm1champ@gmail.com","ContactNo":"123321","Nationality":"Singaporean","Nationality2":null,"Status":"Active","Gender":"Male","PlaceOfIssues":"The Istana","DateOfBirth":"1992-01-15","IssueDate":"2022-11-08","ExpiryDate":"2032-11-08","Address1":"10 ocean Drive","Address2":"Sentosa","Address3":"Singapore 154451","ClientType":"Personal","Designation":"business owner","Title":null,"Alias":"Rob Roy","Country":"Singapore","City":null,"State":null,"IDType":null,"IDType2":null,"NRIC":"K3608753K","SubmissionStatus":"Hold","Reasons":["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"],"Remark":"Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW","CompanyInfo":null,"BankInfo":null,"PaymentDetails":null,"ShareHolders":null,"DirectorBoards":null,"BeneficiaryInfo":null,"Documents":[{"Id":"0219ef3e-6872-4934-870b-c2894a592ffb","DocumentType":"IC_BACK","Remark":"","$type":"ClientDocModel"},{"Id":"1d89ad11-33ad-47d4-936b-de575f036bd4","DocumentType":"PROOF_OF_RESIDENCE","Remark":"","$type":"ClientDocModel"},{"Id":"4f95bce6-f71c-43b4-b9ff-d3e87e04c01c","DocumentType":"PASSPORT","Remark":"","$type":"ClientDocModel"},{"Id":"b3c24b99-437f-4395-b7a8-83d2b6069dfa","DocumentType":"IC_FRONT","Remark":"","$type":"ClientDocModel"}],"Reports":null,"Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","CreateDate":"2024-09-13T04:12:47.0000000","ModifiedDate":"2024-09-13T04:23:30.0000000","CreatedBy":null,"ModifiedBy":"TestPilot","$type":"ClientViewModel"}],"Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ListResponseModel`1"} [20240913 16:01:42.276][INF] HTTP POST /api/v1/client/list responded 200 in 77.3125 ms [20240913 16:06:10.062][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:06:10.064][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"60476201-ea60-40d8-84ee-6aef8e64137d","SessionToken":"88zJ3N73NQEwJVmZnBewgw2cgMCyzpCjZMMcvchR85g89OkahdtWHUqT9kVPqrTx0tYPOf52l+vvVkMrhIQbNxqtQIN0CSl1LJ4/wudmpnAf8SRdqhJSU4psTSId6W+pP7Giz180ZVr+sAOKFzRcNwULUn8+aLRPVbMHc0L1684=","Cmd":"GetAuthorizeToken","SeqNo":"263b2480-d984-43ae-a4b8-cf006f1b94b6","TimeSpan":1726214768,"Signature":"lnjy/bqcxhi5mkbiwwqrffuoirgmlosusfrrvuntgmc=","$type":"TokenRequestModel"} [20240913 16:06:10.065][INF] [TokenRequestModel] 1726214768GetAuthorizeToken263b2480-d984-43ae-a4b8-cf006f1b94b660476201-ea60-40d8-84ee-6aef8e64137d88zJ3N73NQEwJVmZnBewgw2cgMCyzpCjZMMcvchR85g89OkahdtWHUqT9kVPqrTx0tYPOf52l+vvVkMrhIQbNxqtQIN0CSl1LJ4/wudmpnAf8SRdqhJSU4psTSId6W+pP7Giz180ZVr+sAOKFzRcNwULUn8+aLRPVbMHc0L1684= [20240913 16:06:10.069][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [60476201-ea60-40d8-84ee-6aef8e64137d] [20240913 16:06:10.091][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [60476201-ea60-40d8-84ee-6aef8e64137d] [20240913 16:06:10.097][INF] [DbContext][OnLogExecuting] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [60476201-ea60-40d8-84ee-6aef8e64137d] [20240913 16:06:10.099][INF] [DbContext][OnLogExecuted] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [60476201-ea60-40d8-84ee-6aef8e64137d] [20240913 16:06:10.100][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiI2MDQ3NjIwMS1lYTYwLTQwZDgtODRlZS02YWVmOGU2NDEzN2QiLCJzdWIiOiJqb2x5b24uY2hhbXBpb25AcGF5Yml0dGVjaC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImpvbHlvbi5jaGFtcGlvbkBwYXliaXR0ZWNoLmNvbSIsImdpdmVuX25hbWUiOiJqb2x5b24uY2hhbXBpb25AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiUGVyc29uWCIsImFtciI6IkNsaWVudCIsIm5iZiI6MTcyNjIxNDc3MCwiZXhwIjoxNzI2MjE0ODkwLCJpYXQiOjE3MjYyMTQ3NzAsImlzcyI6ImxvY2FsaG9zdCIsImF1ZCI6ImZlIn0.QDsQYUGRQd0AoUhaliXliOV8d_Xk3mkT0eWcik1_sYM","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:10.104][INF] HTTP POST /api/v1/token/authorize responded 200 in 43.1054 ms [20240913 16:06:10.121][INF] HTTP OPTIONS /api/v1/client/dashboard responded 204 in 0.1181 ms [20240913 16:06:10.135][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiI2MDQ3NjIwMS1lYTYwLTQwZDgtODRlZS02YWVmOGU2NDEzN2QiLCJzdWIiOiJqb2x5b24uY2hhbXBpb25AcGF5Yml0dGVjaC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImpvbHlvbi5jaGFtcGlvbkBwYXliaXR0ZWNoLmNvbSIsImdpdmVuX25hbWUiOiJqb2x5b24uY2hhbXBpb25AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiUGVyc29uWCIsImFtciI6IkNsaWVudCIsIm5iZiI6MTcyNjIxNDc3MCwiZXhwIjoxNzI2MjE0ODkwLCJpYXQiOjE3MjYyMTQ3NzAsImlzcyI6ImxvY2FsaG9zdCIsImF1ZCI6ImZlIn0","EncodedSignature":"QDsQYUGRQd0AoUhaliXliOV8d_Xk3mkT0eWcik1_sYM","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiI2MDQ3NjIwMS1lYTYwLTQwZDgtODRlZS02YWVmOGU2NDEzN2QiLCJzdWIiOiJqb2x5b24uY2hhbXBpb25AcGF5Yml0dGVjaC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImpvbHlvbi5jaGFtcGlvbkBwYXliaXR0ZWNoLmNvbSIsImdpdmVuX25hbWUiOiJqb2x5b24uY2hhbXBpb25AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiUGVyc29uWCIsImFtciI6IkNsaWVudCIsIm5iZiI6MTcyNjIxNDc3MCwiZXhwIjoxNzI2MjE0ODkwLCJpYXQiOjE3MjYyMTQ3NzAsImlzcyI6ImxvY2FsaG9zdCIsImF1ZCI6ImZlIn0.QDsQYUGRQd0AoUhaliXliOV8d_Xk3mkT0eWcik1_sYM","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"60476201-ea60-40d8-84ee-6aef8e64137d","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"jolyon.champion@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"jolyon.champion@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"jolyon.champion@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"PersonX","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Client","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726214770","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726214890","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726214770","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:06:10.0000000Z","Issuer":"localhost","Id":"60476201-ea60-40d8-84ee-6aef8e64137d","Subject":"jolyon.champion@paybittech.com","ValidFrom":"2024-09-13T08:06:10.0000000Z","ValidTo":"2024-09-13T08:08:10.0000000Z","$type":"JsonWebToken"} [20240913 16:06:10.136][INF] [WithDecryption][POST][/api/v1/client/dashboard] [20240913 16:06:10.137][INF] [ClientController][Dashboard][Request] {"Cmd":"Dashboard","SeqNo":"a109fd07-3444-499d-a0a4-10be83a5c6d3","TimeSpan":1726214768,"Signature":"lgjexiu0ofwtbo4dd90jwk+khzguvbp/ck89ip+1j2s=","$type":"BaseRequestModel"} [20240913 16:06:10.137][INF] [BaseRequestModel] 1726214768Dashboarda109fd07-3444-499d-a0a4-10be83a5c6d3 [20240913 16:06:10.139][INF] [DbContext][OnLogExecuting] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE ( `ClientId` = @ClientId0 ) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [60476201-ea60-40d8-84ee-6aef8e64137d] [20240913 16:06:10.141][INF] [DbContext][OnLogExecuted] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE ( `ClientId` = @ClientId0 ) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [60476201-ea60-40d8-84ee-6aef8e64137d] [20240913 16:06:10.143][INF] [ClientController][Dashboard][Response] {"Data":{"SubmissionStatus":"Rejected","Id":"24c4c544-648e-4c6c-8cbd-a96464fe3c3d","AuditDate":"2024-09-13T07:55:39.0000000","Reasons":["rejection.insufficient-doc-not-qualified","rejection.document-quality-issue","rejection.mismatched-document-info"],"Remark":"provided documents do not match for identification, proof of address and incorrect documents loaded. Unable to continue with the review until documents are loaded as required. ","$type":"ClientDashboardRespModel"},"Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:10.148][INF] HTTP POST /api/v1/client/dashboard responded 200 in 13.5169 ms [20240913 16:06:35.826][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:06:35.827][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","SessionToken":"KKpPpFnuFeYVU1Pog/HHImV5xeHBxw0gYpW+oVZYcWtWUtpiibFKxilLBhJWS1uNnMyD29ceypFWD2hf7xLZm7xEgxSMF1Hupo1HnIah+m+rTNMVFuggVig65kv1YbPVHTGi3G8SjcLqMADeJh6jIYiyDchMvD5BZuxqZQ2Q2fM=","Cmd":"GetAuthorizeToken","SeqNo":"699b7141-818b-4d97-a18d-5f49204a2b3c","TimeSpan":1726214793,"Signature":"nijpgqvwutrihxziu02kgyqk5q+poi3ndcfehjww1ca=","$type":"TokenRequestModel"} [20240913 16:06:35.827][INF] [TokenRequestModel] 1726214793GetAuthorizeToken699b7141-818b-4d97-a18d-5f49204a2b3cf27b8c2f-3aef-4e94-b851-5c39cd79d691KKpPpFnuFeYVU1Pog/HHImV5xeHBxw0gYpW+oVZYcWtWUtpiibFKxilLBhJWS1uNnMyD29ceypFWD2hf7xLZm7xEgxSMF1Hupo1HnIah+m+rTNMVFuggVig65kv1YbPVHTGi3G8SjcLqMADeJh6jIYiyDchMvD5BZuxqZQ2Q2fM= [20240913 16:06:35.829][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:35.832][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:35.835][INF] [DbContext][OnLogExecuting] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:35.836][INF] [DbContext][OnLogExecuted] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:35.838][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0Nzk1LCJleHAiOjE3MjYyMTQ5MTUsImlhdCI6MTcyNjIxNDc5NSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ.QkkxFtK5I4GzyYZhiWPLo5Aue8EudPv-OAbbb2Ulz8o","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:35.841][INF] HTTP POST /api/v1/token/authorize responded 200 in 15.1320 ms [20240913 16:06:35.857][INF] HTTP OPTIONS /api/v1/client/dashboard responded 204 in 0.0768 ms [20240913 16:06:35.872][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0Nzk1LCJleHAiOjE3MjYyMTQ5MTUsImlhdCI6MTcyNjIxNDc5NSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ","EncodedSignature":"QkkxFtK5I4GzyYZhiWPLo5Aue8EudPv-OAbbb2Ulz8o","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0Nzk1LCJleHAiOjE3MjYyMTQ5MTUsImlhdCI6MTcyNjIxNDc5NSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ.QkkxFtK5I4GzyYZhiWPLo5Aue8EudPv-OAbbb2Ulz8o","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"TestPilot","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Client","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726214795","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726214915","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726214795","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:06:35.0000000Z","Issuer":"localhost","Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Subject":"jm1champ@gmail.com","ValidFrom":"2024-09-13T08:06:35.0000000Z","ValidTo":"2024-09-13T08:08:35.0000000Z","$type":"JsonWebToken"} [20240913 16:06:35.873][INF] [WithDecryption][POST][/api/v1/client/dashboard] [20240913 16:06:35.873][INF] [ClientController][Dashboard][Request] {"Cmd":"Dashboard","SeqNo":"4f255648-6a3d-4062-9a39-aa9ed044ad8e","TimeSpan":1726214793,"Signature":"gg0rn6kwkxfushvfgnoupec7ixi7vwrq1l2zyfxomf0=","$type":"BaseRequestModel"} [20240913 16:06:35.874][INF] [BaseRequestModel] 1726214793Dashboard4f255648-6a3d-4062-9a39-aa9ed044ad8e [20240913 16:06:35.875][INF] [DbContext][OnLogExecuting] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE ( `ClientId` = @ClientId0 ) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:35.877][INF] [DbContext][OnLogExecuted] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE ( `ClientId` = @ClientId0 ) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:35.877][INF] [ClientController][Dashboard][Response] {"Data":{"SubmissionStatus":"Hold","Id":"b3b8698c-8206-4339-ac7d-f23e8c9d35bc","AuditDate":"2024-09-13T08:01:42.0000000","Reasons":["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"],"Remark":"Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW","$type":"ClientDashboardRespModel"},"Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:35.882][INF] HTTP POST /api/v1/client/dashboard responded 200 in 10.7897 ms [20240913 16:06:41.591][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:06:41.592][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","SessionToken":"KKpPpFnuFeYVU1Pog/HHImV5xeHBxw0gYpW+oVZYcWtWUtpiibFKxilLBhJWS1uNnMyD29ceypFWD2hf7xLZm7xEgxSMF1Hupo1HnIah+m+rTNMVFuggVig65kv1YbPVHTGi3G8SjcLqMADeJh6jIYiyDchMvD5BZuxqZQ2Q2fM=","Cmd":"GetAuthorizeToken","SeqNo":"b6d5ed0e-b7ca-4ce2-8e6f-57e48d99e762","TimeSpan":1726214799,"Signature":"vlgqag1xosx0l3gd2b7c2tdasy+rflzgdra/xqg0bce=","$type":"TokenRequestModel"} [20240913 16:06:41.592][INF] [TokenRequestModel] 1726214799GetAuthorizeTokenb6d5ed0e-b7ca-4ce2-8e6f-57e48d99e762f27b8c2f-3aef-4e94-b851-5c39cd79d691KKpPpFnuFeYVU1Pog/HHImV5xeHBxw0gYpW+oVZYcWtWUtpiibFKxilLBhJWS1uNnMyD29ceypFWD2hf7xLZm7xEgxSMF1Hupo1HnIah+m+rTNMVFuggVig65kv1YbPVHTGi3G8SjcLqMADeJh6jIYiyDchMvD5BZuxqZQ2Q2fM= [20240913 16:06:41.593][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.594][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.596][INF] [DbContext][OnLogExecuting] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.598][INF] [DbContext][OnLogExecuted] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.599][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0ODAxLCJleHAiOjE3MjYyMTQ5MjEsImlhdCI6MTcyNjIxNDgwMSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ.FScr9NOfWNhJXKYeq878zwojIIu2jhKkQvb1xjzZEWY","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:41.601][INF] HTTP POST /api/v1/token/authorize responded 200 in 9.9374 ms [20240913 16:06:41.619][INF] HTTP OPTIONS /api/v1/auth/client/getSelfInfo responded 204 in 0.0458 ms [20240913 16:06:41.641][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0ODAxLCJleHAiOjE3MjYyMTQ5MjEsImlhdCI6MTcyNjIxNDgwMSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ","EncodedSignature":"FScr9NOfWNhJXKYeq878zwojIIu2jhKkQvb1xjzZEWY","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0ODAxLCJleHAiOjE3MjYyMTQ5MjEsImlhdCI6MTcyNjIxNDgwMSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ.FScr9NOfWNhJXKYeq878zwojIIu2jhKkQvb1xjzZEWY","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"TestPilot","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Client","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726214801","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726214921","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726214801","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:06:41.0000000Z","Issuer":"localhost","Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Subject":"jm1champ@gmail.com","ValidFrom":"2024-09-13T08:06:41.0000000Z","ValidTo":"2024-09-13T08:08:41.0000000Z","$type":"JsonWebToken"} [20240913 16:06:41.642][INF] [WithDecryption][POST][/api/v1/auth/client/getSelfInfo] [20240913 16:06:41.643][INF] [AuthController][ClientGetSelfInfo][Request] {"Cmd":"ClientGetSelfInfo","SeqNo":"b99549c1-6b67-4ac2-84d3-a1df7e60b07b","TimeSpan":1726214799,"Signature":"vnqbm08xpueu0gpdsexvkkmngeauko+hr7l2lar/mdw=","$type":"BaseRequestModel"} [20240913 16:06:41.643][INF] [BaseRequestModel] 1726214799ClientGetSelfInfob99549c1-6b67-4ac2-84d3-a1df7e60b07b [20240913 16:06:41.645][INF] [DbContext][OnLogExecuting] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.646][INF] [DbContext][OnLogExecuted] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.647][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`DocumentType` AS `DocumentType`,`Remark` AS `Remark`,`ContentType` AS `ContentType`,`ExtraInfo` AS `ExtraInfo`,`ClientId` AS `ClientId`,`ShareholderId` AS `ShareholderId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_document` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:06:41.649][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`DocumentType` AS `DocumentType`,`Remark` AS `Remark`,`ContentType` AS `ContentType`,`ExtraInfo` AS `ExtraInfo`,`ClientId` AS `ClientId`,`ShareholderId` AS `ShareholderId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_document` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:06:41.709][INF] [AuthController][ClientGetSelfInfo][Response] {"Data":{"FullName":"TestPilot","Email":"jm1champ@gmail.com","IsEmailVerify":true,"IsInfoCompleted":true,"IsUploadDocument":true,"IsBind2fa":false,"Token":null,"ClientType":"Personal","mrzField":null,"LastLogin":null,"Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","CreateDate":"2024-09-13T04:12:47.0000000","ModifiedDate":"2024-09-13T04:23:30.0000000","CreatedBy":null,"ModifiedBy":"TestPilot","$type":"ClientBaseViewModel"},"Status":"OK","Message":"","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:41.718][INF] HTTP POST /api/v1/auth/client/getSelfInfo responded 200 in 76.6743 ms [20240913 16:06:41.785][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:06:41.786][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","SessionToken":"KKpPpFnuFeYVU1Pog/HHImV5xeHBxw0gYpW+oVZYcWtWUtpiibFKxilLBhJWS1uNnMyD29ceypFWD2hf7xLZm7xEgxSMF1Hupo1HnIah+m+rTNMVFuggVig65kv1YbPVHTGi3G8SjcLqMADeJh6jIYiyDchMvD5BZuxqZQ2Q2fM=","Cmd":"GetAuthorizeToken","SeqNo":"0caae291-5c8f-4859-9f06-c963cdecb547","TimeSpan":1726214799,"Signature":"p5jpa5ity3gbd8kqu5iur7ogerslp3muez0iaor2fbi=","$type":"TokenRequestModel"} [20240913 16:06:41.787][INF] [TokenRequestModel] 1726214799GetAuthorizeToken0caae291-5c8f-4859-9f06-c963cdecb547f27b8c2f-3aef-4e94-b851-5c39cd79d691KKpPpFnuFeYVU1Pog/HHImV5xeHBxw0gYpW+oVZYcWtWUtpiibFKxilLBhJWS1uNnMyD29ceypFWD2hf7xLZm7xEgxSMF1Hupo1HnIah+m+rTNMVFuggVig65kv1YbPVHTGi3G8SjcLqMADeJh6jIYiyDchMvD5BZuxqZQ2Q2fM= [20240913 16:06:41.788][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.789][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.791][INF] [DbContext][OnLogExecuting] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.793][INF] [DbContext][OnLogExecuted] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.793][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0ODAxLCJleHAiOjE3MjYyMTQ5MjEsImlhdCI6MTcyNjIxNDgwMSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ.FScr9NOfWNhJXKYeq878zwojIIu2jhKkQvb1xjzZEWY","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:41.796][INF] HTTP POST /api/v1/token/authorize responded 200 in 10.6580 ms [20240913 16:06:41.816][INF] HTTP OPTIONS /api/v1/client/dashboard responded 204 in 0.0450 ms [20240913 16:06:41.833][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0ODAxLCJleHAiOjE3MjYyMTQ5MjEsImlhdCI6MTcyNjIxNDgwMSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ","EncodedSignature":"FScr9NOfWNhJXKYeq878zwojIIu2jhKkQvb1xjzZEWY","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJmMjdiOGMyZi0zYWVmLTRlOTQtYjg1MS01YzM5Y2Q3OWQ2OTEiLCJzdWIiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJzaWQiOiIiLCJlbWFpbCI6ImptMWNoYW1wQGdtYWlsLmNvbSIsImdpdmVuX25hbWUiOiJqbTFjaGFtcEBnbWFpbC5jb20iLCJuYW1lIjoiVGVzdFBpbG90IiwiYW1yIjoiQ2xpZW50IiwibmJmIjoxNzI2MjE0ODAxLCJleHAiOjE3MjYyMTQ5MjEsImlhdCI6MTcyNjIxNDgwMSwiaXNzIjoibG9jYWxob3N0IiwiYXVkIjoiZmUifQ.FScr9NOfWNhJXKYeq878zwojIIu2jhKkQvb1xjzZEWY","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"jm1champ@gmail.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"TestPilot","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Client","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726214801","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726214921","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726214801","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:06:41.0000000Z","Issuer":"localhost","Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Subject":"jm1champ@gmail.com","ValidFrom":"2024-09-13T08:06:41.0000000Z","ValidTo":"2024-09-13T08:08:41.0000000Z","$type":"JsonWebToken"} [20240913 16:06:41.835][INF] [WithDecryption][POST][/api/v1/client/dashboard] [20240913 16:06:41.835][INF] [ClientController][Dashboard][Request] {"Cmd":"Dashboard","SeqNo":"75413790-8c32-47b4-9869-83f558e8a608","TimeSpan":1726214799,"Signature":"5eu7c+e27h2zzgllmzrwo40uzk5rlu/ltn5sdk0veca=","$type":"BaseRequestModel"} [20240913 16:06:41.835][INF] [BaseRequestModel] 1726214799Dashboard75413790-8c32-47b4-9869-83f558e8a608 [20240913 16:06:41.837][INF] [DbContext][OnLogExecuting] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE ( `ClientId` = @ClientId0 ) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.838][INF] [DbContext][OnLogExecuted] SELECT `Path`,`Filename`,`Status`,`isCurrent`,`Reasons`,`Remark`,`ClientId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_submission` WHERE ( `ClientId` = @ClientId0 ) ORDER BY `CreateDate` DESC LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:06:41.839][INF] [ClientController][Dashboard][Response] {"Data":{"SubmissionStatus":"Hold","Id":"b3b8698c-8206-4339-ac7d-f23e8c9d35bc","AuditDate":"2024-09-13T08:01:42.0000000","Reasons":["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"],"Remark":"Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW","$type":"ClientDashboardRespModel"},"Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:06:41.843][INF] HTTP POST /api/v1/client/dashboard responded 200 in 10.0207 ms [20240913 16:11:33.224][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:11:33.230][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","SessionToken":"wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE=","Cmd":"GetAuthorizeToken","SeqNo":"f32a038e-9170-4369-aba7-002d0d0499a9","TimeSpan":1726215091,"Signature":"exrrfzsppenuc023rj0rnzw9rr/pcyetypd5n216j74=","$type":"TokenRequestModel"} [20240913 16:11:33.232][INF] [TokenRequestModel] 1726215091GetAuthorizeTokenf32a038e-9170-4369-aba7-002d0d0499a9b2234a53-976d-4336-85b6-8a4ae4e9c9e3wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE= [20240913 16:11:33.237][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:11:33.305][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:11:33.309][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:11:33.311][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:11:33.312][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTUwOTMsImV4cCI6MTcyNjIxNTIxMywiaWF0IjoxNzI2MjE1MDkzLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.D2brW9EYk9IJC_VB-7qJiTsKROKw2KtsGWPHEbYE9_4","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:11:33.316][INF] HTTP POST /api/v1/token/authorize responded 200 in 93.3094 ms [20240913 16:11:33.345][INF] HTTP OPTIONS /api/v1/admin/dashboard responded 204 in 0.1884 ms [20240913 16:11:33.366][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTUwOTMsImV4cCI6MTcyNjIxNTIxMywiaWF0IjoxNzI2MjE1MDkzLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9","EncodedSignature":"D2brW9EYk9IJC_VB-7qJiTsKROKw2KtsGWPHEbYE9_4","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTUwOTMsImV4cCI6MTcyNjIxNTIxMywiaWF0IjoxNzI2MjE1MDkzLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.D2brW9EYk9IJC_VB-7qJiTsKROKw2KtsGWPHEbYE9_4","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"dd563cbb-31e3-4c7d-affd-58bcd17a13d3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"demo","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Administrator","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726215093","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726215213","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726215093","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:11:33.0000000Z","Issuer":"localhost","Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","Subject":"demo@paybittech.com","ValidFrom":"2024-09-13T08:11:33.0000000Z","ValidTo":"2024-09-13T08:13:33.0000000Z","$type":"JsonWebToken"} [20240913 16:11:33.367][INF] [WithDecryption][POST][/api/v1/admin/dashboard] [20240913 16:11:33.370][INF] [AdminController][Dashboard][Request] {"Cmd":"Dashboard","SeqNo":"49e6d045-e404-43b0-b508-6e901f3ea809","TimeSpan":1726215091,"Signature":"sdk3n30rl0frfylan4wrvq0uiwpa8p8twe7posspnp4=","$type":"BaseRequestModel"} [20240913 16:11:33.370][INF] [BaseRequestModel] 1726215091Dashboard49e6d045-e404-43b0-b508-6e901f3ea809 [20240913 16:11:33.372][INF] [DbContext][OnLogExecuting] SELECT COUNT(1) FROM `tbl_submission` WHERE ( `Status` = @Status0 ) Params: [0] [20240913 16:11:33.375][INF] [DbContext][OnLogExecuted] SELECT COUNT(1) FROM `tbl_submission` WHERE ( `Status` = @Status0 ) Params: [0] [20240913 16:11:33.378][INF] [DbContext][OnLogExecuting] SELECT (SELECT `Id` FROM `tbl_client` WHERE `x`.`ClientId`=`Id` ) AS `Id` , `CreateDate` AS `CreateDate` , (SELECT `FullName` FROM `tbl_client` WHERE `x`.`ClientId`=`Id` ) AS `ClientName` , `Status` AS `Status` ,`x`.`Id` AS SugarNav_Id,`x`.`ClientId` AS SugarNav_ClientId FROM `tbl_submission` `x` WHERE (( `Status` = @Status0 ) OR ( `Status` = @Status1 )) ORDER BY `CreateDate` DESC LIMIT 0,5 Params: [0, 3] [20240913 16:11:33.380][INF] [DbContext][OnLogExecuted] SELECT (SELECT `Id` FROM `tbl_client` WHERE `x`.`ClientId`=`Id` ) AS `Id` , `CreateDate` AS `CreateDate` , (SELECT `FullName` FROM `tbl_client` WHERE `x`.`ClientId`=`Id` ) AS `ClientName` , `Status` AS `Status` ,`x`.`Id` AS SugarNav_Id,`x`.`ClientId` AS SugarNav_ClientId FROM `tbl_submission` `x` WHERE (( `Status` = @Status0 ) OR ( `Status` = @Status1 )) ORDER BY `CreateDate` DESC LIMIT 0,5 Params: [0, 3] [20240913 16:11:33.382][INF] [DbContext][OnLogExecuting] SELECT `FullName` AS `FullName`,`RealName` AS `RealName`,`NRIC` AS `NRIC`,`Gender` AS `Gender`,`IDType` AS `IDType`,`Nationality` AS `Nationality`,`Nationality2` AS `Nationality2`,`PlaceOfIssue` AS `PlaceOfIssue`,`DateOfBirth` AS `DateOfBirth`,`IssueDate` AS `IssueDate`,`ExpiryDate` AS `ExpiryDate`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Password` AS `Password`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`IDType2` AS `IDType2`,`ClientType` AS `ClientType`,`Designation` AS `Designation`,`Title` AS `Title`,`Alias` AS `Alias`,`Country` AS `Country`,`City` AS `City`,`State` AS `State`,`PostCode` AS `PostCode`,`IsEmailVerify` AS `IsEmailVerify`,`IsInfoCompleted` AS `IsInfoCompleted`,`Status` AS `Status`,`LastLogin` AS `LastLogin`,`AuthCode` AS `AuthCode`,`AuthPublic` AS `AuthPublic`,`BindingDate` AS `BindingDate`,`BindingResetDate` AS `BindingResetDate`,`BindingResetBy` AS `BindingResetBy`,`BindAuth` AS `BindAuth`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_client` WHERE `Id` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:11:33.383][INF] [DbContext][OnLogExecuted] SELECT `FullName` AS `FullName`,`RealName` AS `RealName`,`NRIC` AS `NRIC`,`Gender` AS `Gender`,`IDType` AS `IDType`,`Nationality` AS `Nationality`,`Nationality2` AS `Nationality2`,`PlaceOfIssue` AS `PlaceOfIssue`,`DateOfBirth` AS `DateOfBirth`,`IssueDate` AS `IssueDate`,`ExpiryDate` AS `ExpiryDate`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Password` AS `Password`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`IDType2` AS `IDType2`,`ClientType` AS `ClientType`,`Designation` AS `Designation`,`Title` AS `Title`,`Alias` AS `Alias`,`Country` AS `Country`,`City` AS `City`,`State` AS `State`,`PostCode` AS `PostCode`,`IsEmailVerify` AS `IsEmailVerify`,`IsInfoCompleted` AS `IsInfoCompleted`,`Status` AS `Status`,`LastLogin` AS `LastLogin`,`AuthCode` AS `AuthCode`,`AuthPublic` AS `AuthPublic`,`BindingDate` AS `BindingDate`,`BindingResetDate` AS `BindingResetDate`,`BindingResetBy` AS `BindingResetBy`,`BindAuth` AS `BindAuth`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_client` WHERE `Id` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:11:33.385][INF] [DbContext][OnLogExecuting] SELECT `CreateDate` AS `CreateDate` , `CreatedBy` AS `CreatedBy` , `Id` AS `Id` , `Message` AS `Message` , `ModifiedBy` AS `ModifiedBy` , `ModifiedDate` AS `ModifiedDate` FROM `tbl_notification` ORDER BY `CreateDate` DESC LIMIT 0,5 Params: [] [20240913 16:11:33.386][INF] [DbContext][OnLogExecuted] SELECT `CreateDate` AS `CreateDate` , `CreatedBy` AS `CreatedBy` , `Id` AS `Id` , `Message` AS `Message` , `ModifiedBy` AS `ModifiedBy` , `ModifiedDate` AS `ModifiedDate` FROM `tbl_notification` ORDER BY `CreateDate` DESC LIMIT 0,5 Params: [] [20240913 16:11:33.388][INF] [DbContext][OnLogExecuting] SELECT COUNT(1) FROM `tbl_client` Params: [] [20240913 16:11:33.402][INF] [DbContext][OnLogExecuted] SELECT COUNT(1) FROM `tbl_client` Params: [] [20240913 16:11:33.405][INF] [DbContext][OnLogExecuting] SELECT Count(*) FROM `tbl_notification` WHERE ( `CreateDate` >@constant1) Params: [09/13/2024 00:00:00] [20240913 16:11:33.406][INF] [DbContext][OnLogExecuted] SELECT Count(*) FROM `tbl_notification` WHERE ( `CreateDate` >@constant1) Params: [09/13/2024 00:00:00] [20240913 16:11:33.415][INF] [DbContext][OnLogExecuting] SELECT Count(*) FROM ( ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240901` ) UNION ALL ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240801` ) ) unionTable WHERE ( `CreateDate` >@constant1) Params: [09/13/2024 00:00:00] [20240913 16:11:33.419][INF] [DbContext][OnLogExecuted] SELECT Count(*) FROM ( ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240901` ) UNION ALL ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240801` ) ) unionTable WHERE ( `CreateDate` >@constant1) Params: [09/13/2024 00:00:00] [20240913 16:11:33.424][INF] [DbContext][OnLogExecuting] SELECT `CreateDate` AS `CreateDate` , `CreatedBy` AS `CreatedBy` , `Id` AS `Id` , `Description` AS `Description` , `ModifiedBy` AS `ModifiedBy` , `ModifiedDate` AS `ModifiedDate` , `IpAddress` AS `IpAddress` , `Username` AS `Username` , `Action` AS `Action` , `ActionName` AS `ActionName` FROM ( ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240901` ) UNION ALL ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240801` ) ) unionTable ORDER BY `CreateDate` DESC LIMIT 0,5 Params: [] [20240913 16:11:33.427][INF] [DbContext][OnLogExecuted] SELECT `CreateDate` AS `CreateDate` , `CreatedBy` AS `CreatedBy` , `Id` AS `Id` , `Description` AS `Description` , `ModifiedBy` AS `ModifiedBy` , `ModifiedDate` AS `ModifiedDate` , `IpAddress` AS `IpAddress` , `Username` AS `Username` , `Action` AS `Action` , `ActionName` AS `ActionName` FROM ( ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240901` ) UNION ALL ( SELECT `ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_action_log_20240801` ) ) unionTable ORDER BY `CreateDate` DESC LIMIT 0,5 Params: [] [20240913 16:11:33.427][INF] [AdminController][Dashboard][Response] {"Data":{"TodayNotificationCount":4,"TotalClientCount":2,"TotalPendingSubmissionsCount":0,"TodayAuditTrailCount":18,"pendingSubmissions":[],"notifications":[{"Message":"New Submission - PersonX","Id":"7549d9cb-0ce5-41c6-9a4a-b10fb3e06be8","CreateDate":"2024-09-13T06:47:15.0000000","ModifiedDate":null,"CreatedBy":"PersonX","ModifiedBy":null,"$type":"AdminDashboardNotificationModel"},{"Message":"New Register - PersonX","Id":"4b850545-904d-4efe-aace-d88980c74536","CreateDate":"2024-09-13T06:10:37.0000000","ModifiedDate":null,"CreatedBy":null,"ModifiedBy":null,"$type":"AdminDashboardNotificationModel"},{"Message":"New Submission - TestPilot","Id":"05fb9a70-084d-4470-85ed-71dc579d7895","CreateDate":"2024-09-13T04:22:52.0000000","ModifiedDate":null,"CreatedBy":"TestPilot","ModifiedBy":null,"$type":"AdminDashboardNotificationModel"},{"Message":"New Register - TestPilot","Id":"a1aaffb4-b96a-4847-a27f-087f17792c48","CreateDate":"2024-09-13T04:12:47.0000000","ModifiedDate":null,"CreatedBy":null,"ModifiedBy":null,"$type":"AdminDashboardNotificationModel"}],"auditTrails":[{"Description":"Hold Client Submission (Success) - TestPilot","IpAddress":"122.11.232.193","Username":"demo@paybittech.com","Action":"SubmitClientReport","ActionName":"SubmitClientReport","Id":"6a3f70e2-8912-4887-9af7-04742119824f","CreateDate":"2024-09-13T08:01:42.0000000","ModifiedDate":null,"CreatedBy":null,"ModifiedBy":null,"$type":"AdminDashboardAuditTrailModel"},{"Description":"View Client List","IpAddress":"122.11.232.193","Username":"demo@paybittech.com","Action":"ViewClientList","ActionName":"ViewClientList","Id":"e75975d8-dae4-4983-9ef6-9dea867b89f4","CreateDate":"2024-09-13T08:01:42.0000000","ModifiedDate":null,"CreatedBy":null,"ModifiedBy":null,"$type":"AdminDashboardAuditTrailModel"},{"Description":"View Client Detail - TestPilot","IpAddress":"122.11.232.193","Username":"demo@paybittech.com","Action":"ViewClientDetail","ActionName":"ViewClientDetail","Id":"403f4363-d5b7-47cf-9b31-48cb635a3df2","CreateDate":"2024-09-13T07:55:50.0000000","ModifiedDate":null,"CreatedBy":null,"ModifiedBy":null,"$type":"AdminDashboardAuditTrailModel"},{"Description":"View Client List","IpAddress":"122.11.232.193","Username":"demo@paybittech.com","Action":"ViewClientList","ActionName":"ViewClientList","Id":"f43e8902-de9d-4cca-a961-eeee83cdbed8","CreateDate":"2024-09-13T07:55:40.0000000","ModifiedDate":null,"CreatedBy":null,"ModifiedBy":null,"$type":"AdminDashboardAuditTrailModel"},{"Description":"Rejected Client Submission (Success) - PersonX","IpAddress":"122.11.232.193","Username":"demo@paybittech.com","Action":"SubmitClientReport","ActionName":"SubmitClientReport","Id":"4ca61993-e832-486e-92f7-8a6bf82c0f40","CreateDate":"2024-09-13T07:55:39.0000000","ModifiedDate":null,"CreatedBy":null,"ModifiedBy":null,"$type":"AdminDashboardAuditTrailModel"}],"holdSubmissions":[{"Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","ClientName":"TestPilot","Status":"Hold","CreateDate":"2024-09-13T04:22:52.0000000","$type":"AdminDashboardSubmissionModel"}],"$type":"AdminDashboardRespModel"},"Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:11:33.439][INF] HTTP POST /api/v1/admin/dashboard responded 200 in 74.1154 ms [20240913 16:29:22.169][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:29:22.172][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","SessionToken":"wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE=","Cmd":"GetAuthorizeToken","SeqNo":"d348dd3b-29a3-4fad-9de2-3c1af8818dbf","TimeSpan":1726216159,"Signature":"p0m1t0tq1lcgtesszkxyju34aggxzachie5mzlrmwzi=","$type":"TokenRequestModel"} [20240913 16:29:22.172][INF] [TokenRequestModel] 1726216159GetAuthorizeTokend348dd3b-29a3-4fad-9de2-3c1af8818dbfb2234a53-976d-4336-85b6-8a4ae4e9c9e3wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE= [20240913 16:29:22.177][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.244][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.248][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.249][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.250][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTYxNjIsImV4cCI6MTcyNjIxNjI4MiwiaWF0IjoxNzI2MjE2MTYyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.NlSdw-1ngDGbvbaGZ5gOIYAF3dESM2AhiBzhbatmXlg","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:29:22.255][INF] HTTP POST /api/v1/token/authorize responded 200 in 86.8868 ms [20240913 16:29:22.272][INF] HTTP OPTIONS /api/v1/auth/admin/getSelfInfo responded 204 in 0.1123 ms [20240913 16:29:22.287][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTYxNjIsImV4cCI6MTcyNjIxNjI4MiwiaWF0IjoxNzI2MjE2MTYyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9","EncodedSignature":"NlSdw-1ngDGbvbaGZ5gOIYAF3dESM2AhiBzhbatmXlg","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTYxNjIsImV4cCI6MTcyNjIxNjI4MiwiaWF0IjoxNzI2MjE2MTYyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.NlSdw-1ngDGbvbaGZ5gOIYAF3dESM2AhiBzhbatmXlg","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"dd563cbb-31e3-4c7d-affd-58bcd17a13d3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"demo","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Administrator","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726216162","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726216282","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726216162","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:29:22.0000000Z","Issuer":"localhost","Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","Subject":"demo@paybittech.com","ValidFrom":"2024-09-13T08:29:22.0000000Z","ValidTo":"2024-09-13T08:31:22.0000000Z","$type":"JsonWebToken"} [20240913 16:29:22.289][INF] [WithDecryption][POST][/api/v1/auth/admin/getSelfInfo] [20240913 16:29:22.289][INF] [AuthController][GetSelfInfo][Request] {"Cmd":"GetSelfInfo","SeqNo":"cb963d9d-7742-49e1-9239-21fa57cea6a7","TimeSpan":1726216159,"Signature":"cyzxczeb2//4ahwcwj0wnutbaaoeryeozfz1lcdpr8a=","$type":"BaseRequestModel"} [20240913 16:29:22.290][INF] [BaseRequestModel] 1726216159GetSelfInfocb963d9d-7742-49e1-9239-21fa57cea6a7 [20240913 16:29:22.291][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.292][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.294][INF] [DbContext][OnLogExecuting] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.295][INF] [DbContext][OnLogExecuted] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.296][INF] [DbContext][OnLogExecuting] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.297][INF] [DbContext][OnLogExecuted] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.298][INF] [DbContext][OnLogExecuting] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:29:22.299][INF] [DbContext][OnLogExecuted] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:29:22.300][INF] [AuthController][GetSelfInfo][Response] {"Data":{"Email":"demo@paybittech.com","Username":"demo@paybittech.com","Name":"demo","ContactNo":"1111111","IsSuperAdmin":false,"Status":true,"Token":"","Role":"Admin","DefaultLang":"EN","GroupId":"dd563cbb-31e3-4c7d-affd-58bcd17a13d3","GroupName":"Master Group","Permissions":["DeleteAdmin","Dashboard","BackupDB","GenerateLink","Client","ViewClientDocument","ConfigSetting","AdminGroupManage","CreateClient","ManageLink","AuditTrails","ViewReport","DeleteClient","Administration","UpdateConfig","CreateAdmin","UpdateLink","UpdateAdminGroup","UpdateAdmin","CreateAdminGroup","UpdateClient","SubmitClientReport"],"BindAuth":true,"Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","CreateDate":"2024-06-28T11:45:20.0000000","ModifiedDate":"2024-07-16T02:05:51.0000000","CreatedBy":"SuperAdmin","ModifiedBy":"SuperAdmin","$type":"AdminViewModel"},"Status":"OK","Message":"","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:29:22.308][INF] HTTP POST /api/v1/auth/admin/getSelfInfo responded 200 in 22.0812 ms [20240913 16:29:22.332][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:29:22.333][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","SessionToken":"wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE=","Cmd":"GetAuthorizeToken","SeqNo":"a5c3f2fc-0148-451b-b1a1-7105f020dcfa","TimeSpan":1726216160,"Signature":"/mhnd9x8eh960eytizuv0ra6ti35ssfxnnn8sxbfvs8=","$type":"TokenRequestModel"} [20240913 16:29:22.333][INF] [TokenRequestModel] 1726216160GetAuthorizeTokena5c3f2fc-0148-451b-b1a1-7105f020dcfab2234a53-976d-4336-85b6-8a4ae4e9c9e3wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE= [20240913 16:29:22.334][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.336][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.338][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.339][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.339][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTYxNjIsImV4cCI6MTcyNjIxNjI4MiwiaWF0IjoxNzI2MjE2MTYyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.NlSdw-1ngDGbvbaGZ5gOIYAF3dESM2AhiBzhbatmXlg","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:29:22.341][INF] HTTP POST /api/v1/token/authorize responded 200 in 9.4091 ms [20240913 16:29:22.357][INF] HTTP OPTIONS /api/v1/client/detail responded 204 in 0.0300 ms [20240913 16:29:22.370][INF] [OnTokenValidated] {"AuthenticationTag":"","Ciphertext":"","EncodedHeader":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9","EncryptedKey":"","EncodedPayload":"eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTYxNjIsImV4cCI6MTcyNjIxNjI4MiwiaWF0IjoxNzI2MjE2MTYyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9","EncodedSignature":"NlSdw-1ngDGbvbaGZ5gOIYAF3dESM2AhiBzhbatmXlg","EncodedToken":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTYxNjIsImV4cCI6MTcyNjIxNjI4MiwiaWF0IjoxNzI2MjE2MTYyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.NlSdw-1ngDGbvbaGZ5gOIYAF3dESM2AhiBzhbatmXlg","InitializationVector":"","InnerToken":null,"IsEncrypted":false,"IsSigned":true,"SecurityKey":null,"SigningKey":{"KeySize":504,"Key":"4E6E2567682C776164397937495E547B2D79737727263027334C31465365512A6026737C6B502D4F5E3E5D5E534C215A61457D2E23764A337E584164416A29","KeyId":null,"CryptoProviderFactory":{"CryptoProviderCache":{"$type":"InMemoryCryptoProviderCache"},"CustomCryptoProvider":null,"CacheSignatureProviders":true,"SignatureProviderObjectPoolCacheSize":16,"$type":"CryptoProviderFactory"},"$type":"SymmetricSecurityKey"},"Claims":[{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"jti","Value":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sub","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"sid","Value":"dd563cbb-31e3-4c7d-affd-58bcd17a13d3","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"email","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"given_name","Value":"demo@paybittech.com","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"name","Value":"demo","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"amr","Value":"Administrator","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"nbf","Value":"1726216162","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"exp","Value":"1726216282","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iat","Value":"1726216162","ValueType":"http://www.w3.org/2001/XMLSchema#integer64","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"iss","Value":"localhost","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"},{"Issuer":"localhost","OriginalIssuer":"localhost","Properties":{},"Subject":null,"Type":"aud","Value":"fe","ValueType":"http://www.w3.org/2001/XMLSchema#string","$type":"Claim"}],"Alg":"HS256","Cty":"","Enc":"","Kid":"","Typ":"JWT","X5t":"","Zip":"","Actor":"","Audiences":["fe"],"Azp":"","IssuedAt":"2024-09-13T08:29:22.0000000Z","Issuer":"localhost","Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","Subject":"demo@paybittech.com","ValidFrom":"2024-09-13T08:29:22.0000000Z","ValidTo":"2024-09-13T08:31:22.0000000Z","$type":"JsonWebToken"} [20240913 16:29:22.376][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.377][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:29:22.378][INF] [DbContext][OnLogExecuting] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.379][INF] [DbContext][OnLogExecuted] SELECT `GroupName` AS `GroupName`,`Status` AS `Status`,`IsMasterGroup` AS `IsMasterGroup`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_admin_group` WHERE `Id` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.379][INF] [DbContext][OnLogExecuting] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.380][INF] [DbContext][OnLogExecuted] SELECT `GroupId` as aid,`AccessRightId` as bid FROM `tbl_admin_access_right_map` WHERE `GroupId` = 'dd563cbb-31e3-4c7d-affd-58bcd17a13d3' Params: [] [20240913 16:29:22.380][INF] [DbContext][OnLogExecuting] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:29:22.381][INF] [DbContext][OnLogExecuted] SELECT `Permission` AS `Permission`,`PermissionName` AS `PermissionName`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_access_right` WHERE `Id` IN ('04c6f573-e18b-4d9a-83ed-c249193d402d','10eee0e7-067e-4332-ab4c-8a0f3b17f35f','1503e648-5c95-423b-ab99-4888b91e81fa','22152eb4-f701-449e-a493-eee0f9bb85e5','25c06e67-afcc-47a0-b1e7-20574335ddfb','3304d891-c07f-4acb-a36b-0a22fbfa8d16','3451c3a2-6d35-4b5f-a423-6260c91f18c8','4e1cec73-c615-4715-a66c-e920abc08352','582864bd-fae8-4c39-8d46-8ca2e748a500','6592751a-ed64-4873-83ca-3e7c6bc2eb05','786e1318-f52a-486d-ba66-13010c6cdbfe','80d925b7-f29b-4770-88ec-225667ed371c','81616e78-c84f-4d7e-b559-68b859fe8e2b','8fceb522-9df2-415e-9f48-1d0d45384961','902e41b4-4f50-4c7b-8156-fa410f238bf1','a5a3a6d6-db20-4ba2-9829-40ff5bc0147b','a7626732-8f54-414d-be29-5715b42ae8ff','aa07a66b-6ef4-4603-9532-0accde6be942','c8058d90-baeb-4284-8c04-6802efae7a1e','d39266b6-75cd-4412-9a34-dc50c6c781ba','d7bac359-4c50-45b2-9b38-b93a65feba34','f9d25c99-3d78-4a46-9f63-b24ed949482e') Params: [] [20240913 16:29:22.382][INF] [WithDecryption][POST][/api/v1/client/detail] [20240913 16:29:22.382][INF] [ClientController][GetClientDetail][Request] {"ClientId":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Cmd":"GetClientDetail","SeqNo":"99bc14e4-2f18-4e28-bbe6-b4aaee69a99b","TimeSpan":1726216160,"Signature":"xpihwdbv6fvv6ugoobedo25qvr7f26bhut5t5zkagao=","$type":"GetClientDetailRequestModel"} [20240913 16:29:22.382][INF] [GetClientDetailRequestModel] 1726216160GetClientDetail99bc14e4-2f18-4e28-bbe6-b4aaee69a99bf27b8c2f-3aef-4e94-b851-5c39cd79d691 [20240913 16:29:22.384][INF] [DbContext][OnLogExecuting] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:29:22.385][INF] [DbContext][OnLogExecuted] SELECT `FullName`,`RealName`,`NRIC`,`Gender`,`IDType`,`Nationality`,`Nationality2`,`PlaceOfIssue`,`DateOfBirth`,`IssueDate`,`ExpiryDate`,`ContactNo`,`Email`,`Password`,`Address1`,`Address2`,`Address3`,`IDType2`,`ClientType`,`Designation`,`Title`,`Alias`,`Country`,`City`,`State`,`PostCode`,`IsEmailVerify`,`IsInfoCompleted`,`Status`,`LastLogin`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_client` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [f27b8c2f-3aef-4e94-b851-5c39cd79d691] [20240913 16:29:22.387][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`DocumentType` AS `DocumentType`,`Remark` AS `Remark`,`ContentType` AS `ContentType`,`ExtraInfo` AS `ExtraInfo`,`ClientId` AS `ClientId`,`ShareholderId` AS `ShareholderId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_document` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' AND ( `ShareholderId` IS NULL ) Params: [] [20240913 16:29:22.388][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`DocumentType` AS `DocumentType`,`Remark` AS `Remark`,`ContentType` AS `ContentType`,`ExtraInfo` AS `ExtraInfo`,`ClientId` AS `ClientId`,`ShareholderId` AS `ShareholderId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_document` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' AND ( `ShareholderId` IS NULL ) Params: [] [20240913 16:29:22.389][INF] [DbContext][OnLogExecuting] SELECT `BeneficiaryCountry` AS `BeneficiaryCountry`,`Currency` AS `Currency`,`PurposeTransfer` AS `PurposeTransfer`,`Description` AS `Description`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_payment_details` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.391][INF] [DbContext][OnLogExecuted] SELECT `BeneficiaryCountry` AS `BeneficiaryCountry`,`Currency` AS `Currency`,`PurposeTransfer` AS `PurposeTransfer`,`Description` AS `Description`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_payment_details` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.392][INF] [DbContext][OnLogExecuting] SELECT `Name` AS `Name`,`Designation` AS `Designation`,`Nationality` AS `Nationality`,`Percentage` AS `Percentage`,`Alias` AS `Alias`,`IDType` AS `IDType`,`IDNumber` AS `IDNumber`,`PlaceOfIssue` AS `PlaceOfIssue`,`IssueDate` AS `IssueDate`,`ExpiryDate` AS `ExpiryDate`,`Gender` AS `Gender`,`DateOfBirth` AS `DateOfBirth`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_shareholders` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' ORDER BY `CreateDate` Params: [] [20240913 16:29:22.393][INF] [DbContext][OnLogExecuted] SELECT `Name` AS `Name`,`Designation` AS `Designation`,`Nationality` AS `Nationality`,`Percentage` AS `Percentage`,`Alias` AS `Alias`,`IDType` AS `IDType`,`IDNumber` AS `IDNumber`,`PlaceOfIssue` AS `PlaceOfIssue`,`IssueDate` AS `IssueDate`,`ExpiryDate` AS `ExpiryDate`,`Gender` AS `Gender`,`DateOfBirth` AS `DateOfBirth`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_shareholders` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' ORDER BY `CreateDate` Params: [] [20240913 16:29:22.394][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`isCurrent` AS `isCurrent`,`Reasons` AS `Reasons`,`Remark` AS `Remark`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_submission` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' AND ( `isCurrent`=1 ) ORDER BY `CreateDate` DESC Params: [] [20240913 16:29:22.395][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`isCurrent` AS `isCurrent`,`Reasons` AS `Reasons`,`Remark` AS `Remark`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_submission` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' AND ( `isCurrent`=1 ) ORDER BY `CreateDate` DESC Params: [] [20240913 16:29:22.395][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`ContentType` AS `ContentType`,`SubmissionId` AS `SubmissionId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_report_submission` WHERE `SubmissionId` = 'b3b8698c-8206-4339-ac7d-f23e8c9d35bc' Params: [] [20240913 16:29:22.396][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`ContentType` AS `ContentType`,`SubmissionId` AS `SubmissionId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_report_submission` WHERE `SubmissionId` = 'b3b8698c-8206-4339-ac7d-f23e8c9d35bc' Params: [] [20240913 16:29:22.398][INF] [DbContext][OnLogExecuting] SELECT `Name` AS `Name`,`Designation` AS `Designation`,`Nationality` AS `Nationality`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_director_board` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.399][INF] [DbContext][OnLogExecuted] SELECT `Name` AS `Name`,`Designation` AS `Designation`,`Nationality` AS `Nationality`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_director_board` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.400][INF] [DbContext][OnLogExecuting] SELECT `Name` AS `Name`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`ContactNo` AS `ContactNo`,`Nationality` AS `Nationality`,`NRIC` AS `NRIC`,`BusinessRegistrationNumber` AS `BusinessRegistrationNumber`,`UniqueId` AS `UniqueId`,`IDType` AS `IDType`,`BusinessName` AS `BusinessName`,`Country` AS `Country`,`DateOfBirth` AS `DateOfBirth`,`Designation` AS `Designation`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_beneficiary_info` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.401][INF] [DbContext][OnLogExecuted] SELECT `Name` AS `Name`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`ContactNo` AS `ContactNo`,`Nationality` AS `Nationality`,`NRIC` AS `NRIC`,`BusinessRegistrationNumber` AS `BusinessRegistrationNumber`,`UniqueId` AS `UniqueId`,`IDType` AS `IDType`,`BusinessName` AS `BusinessName`,`Country` AS `Country`,`DateOfBirth` AS `DateOfBirth`,`Designation` AS `Designation`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_beneficiary_info` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.402][INF] [DbContext][OnLogExecuting] SELECT `BankName` AS `BankName`,`BranchName` AS `BranchName`,`SwiftCode` AS `SwiftCode`,`AccountNo` AS `AccountNo`,`AccountType` AS `AccountType`,`Country` AS `Country`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_bank_info` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.403][INF] [DbContext][OnLogExecuted] SELECT `BankName` AS `BankName`,`BranchName` AS `BranchName`,`SwiftCode` AS `SwiftCode`,`AccountNo` AS `AccountNo`,`AccountType` AS `AccountType`,`Country` AS `Country`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_bank_info` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.403][INF] [DbContext][OnLogExecuting] SELECT `CompanyName` AS `CompanyName`,`TradingAs` AS `TradingAs`,`RegistrationNo` AS `RegistrationNo`,`IncorporateDate` AS `IncorporateDate`,`IncorporateCountry` AS `IncorporateCountry`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Website` AS `Website`,`IndustryType` AS `IndustryType`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`AddressOperation1` AS `AddressOperation1`,`AddressOperation2` AS `AddressOperation2`,`AddressOperation3` AS `AddressOperation3`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_company_info` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.404][INF] [DbContext][OnLogExecuted] SELECT `CompanyName` AS `CompanyName`,`TradingAs` AS `TradingAs`,`RegistrationNo` AS `RegistrationNo`,`IncorporateDate` AS `IncorporateDate`,`IncorporateCountry` AS `IncorporateCountry`,`ContactNo` AS `ContactNo`,`Email` AS `Email`,`Website` AS `Website`,`IndustryType` AS `IndustryType`,`Address1` AS `Address1`,`Address2` AS `Address2`,`Address3` AS `Address3`,`AddressOperation1` AS `AddressOperation1`,`AddressOperation2` AS `AddressOperation2`,`AddressOperation3` AS `AddressOperation3`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_company_info` WHERE `ClientId` = 'f27b8c2f-3aef-4e94-b851-5c39cd79d691' Params: [] [20240913 16:29:22.405][INF] [DbContext][OnLogExecuting] select NOW(6) Params: [] [20240913 16:29:22.406][INF] [DbContext][OnLogExecuted] select NOW(6) Params: [] [20240913 16:29:22.411][INF] [DbContext][OnLogExecuting] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:29:22.420][INF] [DbContext][OnLogExecuted] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:29:22.421][INF] [DbContext][OnLogExecuting] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, {"ClientId":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Cmd":"GetClientDetail","SeqNo":"99bc14e4-2f18-4e28-bbe6-b4aaee69a99b","TimeSpan":1726216160,"Signature":"xpihwdbv6fvv6ugoobedo25qvr7f26bhut5t5zkagao="}, View Client Detail - TestPilot, 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 144, ViewClientDetail, ef6da0a8-2d3c-41da-9f0b-7efd14be29e2, 09/13/2024 08:29:22, 01/01/0001 00:00:00, , ] [20240913 16:29:22.423][INF] [DbContext][OnLogExecuted] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, {"ClientId":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","Cmd":"GetClientDetail","SeqNo":"99bc14e4-2f18-4e28-bbe6-b4aaee69a99b","TimeSpan":1726216160,"Signature":"xpihwdbv6fvv6ugoobedo25qvr7f26bhut5t5zkagao="}, View Client Detail - TestPilot, 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 144, ViewClientDetail, ef6da0a8-2d3c-41da-9f0b-7efd14be29e2, 09/13/2024 08:29:22, 01/01/0001 00:00:00, , ] [20240913 16:29:22.454][INF] [ClientController][GetClientDetail][Response] {"Data":{"FullName":"TestPilot","RealName":"LEE WEN JIE ELROY","Email":"jm1champ@gmail.com","ContactNo":"123321","Nationality":"Singaporean","Nationality2":null,"Status":"Active","Gender":"Male","PlaceOfIssues":"The Istana","DateOfBirth":"1992-01-15","IssueDate":"2022-11-08","ExpiryDate":"2032-11-08","Address1":"10 ocean Drive","Address2":"Sentosa","Address3":"Singapore 154451","ClientType":"Personal","Designation":"business owner","Title":null,"Alias":"Rob Roy","Country":"Singapore","City":null,"State":null,"IDType":null,"IDType2":null,"NRIC":"K3608753K","SubmissionStatus":"Hold","Reasons":["hold.inconsistent-manipulated-document","hold.pep-sanctioned-person"],"Remark":"Person has regularly appeared on grounds of the Istana with a putting iron and this suggests a possibility of PEP. Furthermore we would like to investigate further based on SOW","CompanyInfo":null,"BankInfo":{"Id":"22208364-f417-4a78-ada4-334d3c54552d","BankName":"Malacca Private Bank","BranchName":"Malacca Plaza","SwiftCode":"542136","AccountNo":"41525558","AccountType":"deposit","Address1":"6 Plaza centre","Address2":"Malacca","Address3":"Malaysia","$type":"BankInfoModel"},"PaymentDetails":{"Id":"d55e83aa-58b7-4fd4-98fc-34a97a237ce7","BeneficiaryCountry":"Malaysia","Currency":"MYR","PurposeTransfer":"payment for training and onsite consulting services","Description":null,"$type":"PaymentDetailsModel"},"ShareHolders":[],"DirectorBoards":[],"BeneficiaryInfo":{"Id":"b2dbae21-a204-4b48-880f-7d25ab9905a9","Name":"Gogo Yubari","Address1":"101 Malacca Street","Address2":"Malacca ","Address3":"Malaysia 124577","ContactNo":"79854215","NRIC":"K3608753K","BusinessRegistrationNumber":null,"UniqueId":null,"IDType":"IdentifyCard","BusinessName":null,"Country":null,"DateOfBirth":"0001-01-01","Nationality":"Malaysian","Designation":null,"$type":"BeneficiaryInfoModel"},"Documents":[{"Id":"0219ef3e-6872-4934-870b-c2894a592ffb","DocumentType":"IC_BACK","Remark":"","$type":"ClientDocModel"},{"Id":"4f95bce6-f71c-43b4-b9ff-d3e87e04c01c","DocumentType":"PASSPORT","Remark":"","$type":"ClientDocModel"},{"Id":"b3c24b99-437f-4395-b7a8-83d2b6069dfa","DocumentType":"IC_FRONT","Remark":"","$type":"ClientDocModel"},{"Id":"1d89ad11-33ad-47d4-936b-de575f036bd4","DocumentType":"PROOF_OF_RESIDENCE","Remark":"","$type":"ClientDocModel"}],"Reports":[{"Id":"64bd201d-cfda-427f-9ae6-9f96e8257e6c","CreateDate":"2024-09-13T08:01:42.0000000","ModifiedDate":"0001-01-01T00:00:00.0000000","CreatedBy":"demo","ModifiedBy":null,"$type":"BaseViewModel"}],"Id":"f27b8c2f-3aef-4e94-b851-5c39cd79d691","CreateDate":"2024-09-13T04:12:47.0000000","ModifiedDate":"2024-09-13T04:23:30.0000000","CreatedBy":null,"ModifiedBy":"TestPilot","$type":"ClientViewModel"},"Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:29:22.483][INF] HTTP POST /api/v1/client/detail responded 200 in 113.5305 ms [20240913 16:36:42.887][INF] [WithDecryption][POST][/api/v1/token/authorize] [20240913 16:36:42.892][INF] [TokenController][GetAuthorizeToken][Request] {"Id":"b2234a53-976d-4336-85b6-8a4ae4e9c9e3","SessionToken":"wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE=","Cmd":"GetAuthorizeToken","SeqNo":"cfc636b7-a297-49b8-9907-5e840c69aa77","TimeSpan":1726216600,"Signature":"m31jx2sc1wvtkf54uxmooajf0luiuzedmgeunh+amd0=","$type":"TokenRequestModel"} [20240913 16:36:42.892][INF] [TokenRequestModel] 1726216600GetAuthorizeTokencfc636b7-a297-49b8-9907-5e840c69aa77b2234a53-976d-4336-85b6-8a4ae4e9c9e3wVsOpRiSp7g+8lCBE93xi2OkXoZPN01QpX4jw1a4QonL9Sb+WCQzMPQyQ68XFW2pj3/LDRjgJTDmnIOdlLtxCNwr6MHCFqBXu++za4+BXyqgs0FMmV6OGX3SfJfVDPn+qx4kVbHnLKCyvNzVdMhfJVHgHJyGRroIPXEMNQQqQtE= [20240913 16:36:42.898][INF] [DbContext][OnLogExecuting] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:36:42.983][INF] [DbContext][OnLogExecuted] SELECT 1 FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:36:42.990][INF] [DbContext][OnLogExecuting] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:36:42.992][INF] [DbContext][OnLogExecuted] SELECT `Username`,`Password`,`Name`,`Email`,`ContactNo`,`IsSuperAdmin`,`Status`,`AuthCode`,`AuthPublic`,`BindingDate`,`BindingResetDate`,`BindingResetBy`,`BindAuth`,`GroupId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_admin` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [b2234a53-976d-4336-85b6-8a4ae4e9c9e3] [20240913 16:36:42.993][INF] [TokenController][GetAuthorizeToken][Response] {"Data":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTY2MDIsImV4cCI6MTcyNjIxNjcyMiwiaWF0IjoxNzI2MjE2NjAyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.HSY_cFRQba8ORrqQgZNZ8WbXljDimAcG9HwyuNtWP8I","Status":"OK","Message":"Success","ErrorCode":null,"Errors":null,"$type":"ContentResponseModel`1"} [20240913 16:36:42.997][INF] HTTP POST /api/v1/token/authorize responded 200 in 110.6991 ms [20240913 16:36:43.160][INF] [ClientController][ViewReport][Request] 64bd201d-cfda-427f-9ae6-9f96e8257e6c [20240913 16:36:43.167][INF] [DbContext][OnLogExecuting] SELECT `Path`,`Filename`,`Status`,`ContentType`,`SubmissionId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_report_submission` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [64bd201d-cfda-427f-9ae6-9f96e8257e6c] [20240913 16:36:43.169][INF] [DbContext][OnLogExecuted] SELECT `Path`,`Filename`,`Status`,`ContentType`,`SubmissionId`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy` FROM `tbl_report_submission` WHERE ( `Id` = @Id0 ) LIMIT 0,1 Params: [64bd201d-cfda-427f-9ae6-9f96e8257e6c] [20240913 16:36:43.172][INF] [DbContext][OnLogExecuting] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`isCurrent` AS `isCurrent`,`Reasons` AS `Reasons`,`Remark` AS `Remark`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_submission` WHERE `Id` = 'b3b8698c-8206-4339-ac7d-f23e8c9d35bc' Params: [] [20240913 16:36:43.173][INF] [DbContext][OnLogExecuted] SELECT `Path` AS `Path`,`Filename` AS `Filename`,`Status` AS `Status`,`isCurrent` AS `isCurrent`,`Reasons` AS `Reasons`,`Remark` AS `Remark`,`ClientId` AS `ClientId`,`Id` AS `Id`,`CreateDate` AS `CreateDate`,`ModifiedDate` AS `ModifiedDate`,`CreatedBy` AS `CreatedBy`,`ModifiedBy` AS `ModifiedBy` FROM `tbl_submission` WHERE `Id` = 'b3b8698c-8206-4339-ac7d-f23e8c9d35bc' Params: [] [20240913 16:36:43.175][INF] [DbContext][OnLogExecuting] select NOW(6) Params: [] [20240913 16:36:43.176][INF] [DbContext][OnLogExecuted] select NOW(6) Params: [] [20240913 16:36:43.178][INF] [DbContext][OnLogExecuting] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:36:43.188][INF] [DbContext][OnLogExecuted] select TABLE_NAME as Name,TABLE_COMMENT as Description from information_schema.tables where TABLE_SCHEMA=(select database()) AND TABLE_TYPE='BASE TABLE' Params: [] [20240913 16:36:43.189][INF] [DbContext][OnLogExecuting] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, null, View Report - [-], 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 150, ViewReport, 204d6cea-f7be-42c8-b4bd-b756bcdfda46, 09/13/2024 08:36:43, 01/01/0001 00:00:00, , ] [20240913 16:36:43.191][INF] [DbContext][OnLogExecuted] INSERT INTO `tbl_action_log_20240901` (`ActionType`,`UserType`,`ModelString`,`Description`,`IpAddress`,`UserId`,`Username`,`Action`,`ActionName`,`Id`,`CreateDate`,`ModifiedDate`,`CreatedBy`,`ModifiedBy`) VALUES (@ActionType,@UserType,@ModelString,@Description,@IpAddress,@UserId,@Username,@Action,@ActionName,@Id,@CreateDate,@ModifiedDate,@CreatedBy,@ModifiedBy) ; Params: [0, 2, null, View Report - [-], 122.11.232.193, b2234a53-976d-4336-85b6-8a4ae4e9c9e3, demo@paybittech.com, 150, ViewReport, 204d6cea-f7be-42c8-b4bd-b756bcdfda46, 09/13/2024 08:36:43, 01/01/0001 00:00:00, , ] [20240913 16:36:43.195][INF] HTTP GET /api/v1/client/ViewReport/64bd201d-cfda-427f-9ae6-9f96e8257e6c/eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiJiMjIzNGE1My05NzZkLTQzMzYtODViNi04YTRhZTRlOWM5ZTMiLCJzdWIiOiJkZW1vQHBheWJpdHRlY2guY29tIiwic2lkIjoiZGQ1NjNjYmItMzFlMy00YzdkLWFmZmQtNThiY2QxN2ExM2QzIiwiZW1haWwiOiJkZW1vQHBheWJpdHRlY2guY29tIiwiZ2l2ZW5fbmFtZSI6ImRlbW9AcGF5Yml0dGVjaC5jb20iLCJuYW1lIjoiZGVtbyIsImFtciI6IkFkbWluaXN0cmF0b3IiLCJuYmYiOjE3MjYyMTY2MDIsImV4cCI6MTcyNjIxNjcyMiwiaWF0IjoxNzI2MjE2NjAyLCJpc3MiOiJsb2NhbGhvc3QiLCJhdWQiOiJmZSJ9.HSY_cFRQba8ORrqQgZNZ8WbXljDimAcG9HwyuNtWP8I responded 200 in 47.9728 ms