Time: 16/12/2025 04:28:57 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00004' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00004' AND UserPassword='RQBNAFAAMAAwADAAMAA0AA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00004' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='f838d98d9a6779e3' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: There is no row at position 0.
Source: System.Data
StackTrace:    at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
   at System.Data.DataRowCollection.get_Item(Int32 index)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerRegisterYourDevice(InputGroupOfficerRegisterYourDevice objData)
TargetSite: NodePath GetNodeByIndex(Int32)

Time: 16/12/2025 04:30:02 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00001' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00001' AND UserPassword='RQBNAFAAMAAwADAAMAAxAA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00001' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='f838d98d9a6779e3' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: There is no row at position 0.
Source: System.Data
StackTrace:    at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
   at System.Data.DataRowCollection.get_Item(Int32 index)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerRegisterYourDevice(InputGroupOfficerRegisterYourDevice objData)
TargetSite: NodePath GetNodeByIndex(Int32)

Time: 16/12/2025 06:08:40 PM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='M101000708' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberPhoto='M101000708MPhoto639015053202229479.jpg' WHERE MemberId='M101000708' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 16/12/2025 06:08:43 PM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='M101000708' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberSignature='M101000708MSign639015053231291655.jpg' WHERE MemberId='M101000708' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 16/12/2025 06:08:45 PM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='M101000708' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberPOIBack='M101000708MPOIBack639015053253478400.jpg' WHERE MemberId='M101000708' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 16/12/2025 06:08:46 PM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='M101000708' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberPOIFront='M101000708MPOIFront639015053268166278.jpg' WHERE MemberId='M101000708' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 17/12/2025 08:49:01 AM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='M101000714' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberSignature='M101000714MSign639015581415904698.jpg' WHERE MemberId='M101000714' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 17/12/2025 08:49:04 AM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='M101000714' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberPOIFront='M101000714MPOIFront639015581449354199.jpg' WHERE MemberId='M101000714' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 17/12/2025 08:49:09 AM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='M101000714' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberPOIBack='M101000714MPOIBack639015581498260779.jpg' WHERE MemberId='M101000714' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 17/12/2025 05:15:04 PM
PageName: GroupOfficerUpdateMemberKYCDetail
String str:  SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyPhysical' )AS CompanyPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL' )AS MobileAppURL, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical' )AS MobileAppPhysical, ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder' )AS GroupMemberKYCFolder, MemberPhoto, MemberSignature, MemberPOIFront, MemberPOIBack, MemberPOAFront, MemberPOABack, MemberBankPassBook, NomineePhoto, NomineeSignature, NomineePOIFront, NomineePOIBack, NomineePOAFront, NomineePOABack, MemberNomineeJointPhoto FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId='MH01010360104' ;
String sql: ; UPDATE GroupLoanMemberDetail SET MemberPOIBack='MH01010360104MPOIBack639015885040532380.jpg' WHERE MemberId='MH01010360104' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: This SqlTransaction has completed; it is no longer usable.
Source: System.Data
StackTrace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUpdateMemberKYCDetail(InputGroupOfficerUpdateMemberKYCDetail objData)
TargetSite: Void ZombieCheck()

Time: 17/12/2025 06:26:05 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='00020' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='00020' AND UserPassword='MgA1ADQANQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='00020' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='f9cbae4ae585ba73' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; UPDATE EmployeeAttendanceDetail SET AttOutTime=GETDATE(), AttOutLat='30.037114', AttOutLong='77.745506' WHERE EmployeeId='EMP00024' AND AttDate='12/17/2025 12:00:00 AM' ; 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: There is no row at position 0.
Source: System.Data
StackTrace:    at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
   at System.Data.DataRowCollection.get_Item(Int32 index)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerRegisterYourDevice(InputGroupOfficerRegisterYourDevice objData)
TargetSite: NodePath GetNodeByIndex(Int32)