Time: 22/05/2026 08:52:35 AM
PageName: GroupOfficerUserAttendanceImage
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='2eced633aae9dfb4' ; DECLARE @FTable TABLE ( EmployeeAttendanceTime VARCHAR(10), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), AttInHH TINYINT, AttInMM TINYINT, AttOutHH TINYINT, AttOutMM TINYINT, BranchLatitude VARCHAR(20), BranchLongitude VARCHAR(20), BranchDistance BIGINT, VersionStatus VARCHAR(10), AttExist TINYINT, AttInDuration SMALLINT ); INSERT INTO @FTable ( EmployeeAttendanceTime, EmployeeId, EmployeeName, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus ) SELECT isnull((SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='EmployeeAttendanceTime' ),'INACTIVE')AS EmployeeAttendanceTime, a.UserLoginId AS EmployeeId, a.UserName AS EmployeeName, c.BranchLatitude, c.BranchLongitude, c.BranchDistance, (SELECT VersionStatus FROM MobileAppVersion WITH(nolock) WHERE VersionNo='11')AS VersionStatus FROM UserLoginDetail a WITH(nolock) LEFT JOIN BranchPermission b WITH(nolock) ON a.UserLoginId=b.UserId INNER JOIN BranchNameMaster c WITH(nolock) ON isnull(b.BranchId,a.BranchId)=c.BranchId WHERE a.MobileDeviceId='2eced633aae9dfb4' AND a.MobilePINNo='0852' ; UPDATE a SET a.AttInHH=isnull(b.AttInHH,9), a.AttInMM=isnull(b.AttInMM,0), a.AttOutHH=isnull(b.AttOutHH,18), a.AttOutMM=isnull(b.AttOutMM,00) FROM @FTable a INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId ; UPDATE a SET a.AttExist=(CASE WHEN AttDate!='' THEN 1 ELSE 0 END), a.AttInDuration=datediff(minute,AttInTime,GETDATE()) FROM @FTable a INNER JOIN (SELECT EmployeeId, AttDate, AttInTime FROM EmployeeAttendanceDetail WITH(nolock) WHERE AttDate='5/22/2026 12:00:00 AM')b ON a.EmployeeId=b.EmployeeId ; SELECT EmployeeAttendanceTime, EmployeeId, EmployeeName, AttInHH, AttInMM, AttOutHH, AttOutMM, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus, isnull(AttExist,0)AS AttExist, AttInDuration, BranchDistance*5 AS CurrentDistance, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='CompanyPhysical')AS CompanyPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical')AS MobileAppPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeAttendanceFolder')AS EmployeeAttendanceFolder FROM @FTable ORDER BY EmployeeId 
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00016','KAJAL KUMARI', '5/22/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00016', GETDATE(), '25.603692', '85.485592', 'EMP0001622052026Att639150367540779458.jpg' ) ; 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceImage(InputGroupOfficerUserAttendanceImage objData)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 22/05/2026 08:52:35 AM
PageName: GroupOfficerUserAttendanceImage
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='2eced633aae9dfb4' ; DECLARE @FTable TABLE ( EmployeeAttendanceTime VARCHAR(10), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), AttInHH TINYINT, AttInMM TINYINT, AttOutHH TINYINT, AttOutMM TINYINT, BranchLatitude VARCHAR(20), BranchLongitude VARCHAR(20), BranchDistance BIGINT, VersionStatus VARCHAR(10), AttExist TINYINT, AttInDuration SMALLINT ); INSERT INTO @FTable ( EmployeeAttendanceTime, EmployeeId, EmployeeName, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus ) SELECT isnull((SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='EmployeeAttendanceTime' ),'INACTIVE')AS EmployeeAttendanceTime, a.UserLoginId AS EmployeeId, a.UserName AS EmployeeName, c.BranchLatitude, c.BranchLongitude, c.BranchDistance, (SELECT VersionStatus FROM MobileAppVersion WITH(nolock) WHERE VersionNo='11')AS VersionStatus FROM UserLoginDetail a WITH(nolock) LEFT JOIN BranchPermission b WITH(nolock) ON a.UserLoginId=b.UserId INNER JOIN BranchNameMaster c WITH(nolock) ON isnull(b.BranchId,a.BranchId)=c.BranchId WHERE a.MobileDeviceId='2eced633aae9dfb4' AND a.MobilePINNo='0852' ; UPDATE a SET a.AttInHH=isnull(b.AttInHH,9), a.AttInMM=isnull(b.AttInMM,0), a.AttOutHH=isnull(b.AttOutHH,18), a.AttOutMM=isnull(b.AttOutMM,00) FROM @FTable a INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId ; UPDATE a SET a.AttExist=(CASE WHEN AttDate!='' THEN 1 ELSE 0 END), a.AttInDuration=datediff(minute,AttInTime,GETDATE()) FROM @FTable a INNER JOIN (SELECT EmployeeId, AttDate, AttInTime FROM EmployeeAttendanceDetail WITH(nolock) WHERE AttDate='5/22/2026 12:00:00 AM')b ON a.EmployeeId=b.EmployeeId ; SELECT EmployeeAttendanceTime, EmployeeId, EmployeeName, AttInHH, AttInMM, AttOutHH, AttOutMM, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus, isnull(AttExist,0)AS AttExist, AttInDuration, BranchDistance*5 AS CurrentDistance, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='CompanyPhysical')AS CompanyPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical')AS MobileAppPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeAttendanceFolder')AS EmployeeAttendanceFolder FROM @FTable ORDER BY EmployeeId 
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00016','KAJAL KUMARI', '5/22/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00016', GETDATE(), '25.603692', '85.485592', 'EMP0001622052026Att639150367540779458.jpg' ) ; 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceImage(InputGroupOfficerUserAttendanceImage objData)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 11/06/2026 02:57:55 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP0009' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP0009' AND UserPassword='RQBNAFAAMAAwADAAOQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP0009' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='96ae3ae8d648cbf6' ; 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: 13/06/2026 05:23:30 PM
PageName: GroupOfficerUserAttendanceImage
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='78bccba2ff9afdd6' ; DECLARE @FTable TABLE ( EmployeeAttendanceTime VARCHAR(10), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), AttInHH TINYINT, AttInMM TINYINT, AttOutHH TINYINT, AttOutMM TINYINT, BranchLatitude VARCHAR(20), BranchLongitude VARCHAR(20), BranchDistance BIGINT, VersionStatus VARCHAR(10), AttExist TINYINT, AttInDuration SMALLINT ); INSERT INTO @FTable ( EmployeeAttendanceTime, EmployeeId, EmployeeName, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus ) SELECT isnull((SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='EmployeeAttendanceTime' ),'INACTIVE')AS EmployeeAttendanceTime, a.UserLoginId AS EmployeeId, a.UserName AS EmployeeName, c.BranchLatitude, c.BranchLongitude, c.BranchDistance, (SELECT VersionStatus FROM MobileAppVersion WITH(nolock) WHERE VersionNo='11')AS VersionStatus FROM UserLoginDetail a WITH(nolock) LEFT JOIN BranchPermission b WITH(nolock) ON a.UserLoginId=b.UserId INNER JOIN BranchNameMaster c WITH(nolock) ON isnull(b.BranchId,a.BranchId)=c.BranchId WHERE a.MobileDeviceId='78bccba2ff9afdd6' AND a.MobilePINNo='0852' ; UPDATE a SET a.AttInHH=isnull(b.AttInHH,9), a.AttInMM=isnull(b.AttInMM,0), a.AttOutHH=isnull(b.AttOutHH,18), a.AttOutMM=isnull(b.AttOutMM,00) FROM @FTable a INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId ; UPDATE a SET a.AttExist=(CASE WHEN AttDate!='' THEN 1 ELSE 0 END), a.AttInDuration=datediff(minute,AttInTime,GETDATE()) FROM @FTable a INNER JOIN (SELECT EmployeeId, AttDate, AttInTime FROM EmployeeAttendanceDetail WITH(nolock) WHERE AttDate='6/13/2026 12:00:00 AM')b ON a.EmployeeId=b.EmployeeId ; SELECT EmployeeAttendanceTime, EmployeeId, EmployeeName, AttInHH, AttInMM, AttOutHH, AttOutMM, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus, isnull(AttExist,0)AS AttExist, AttInDuration, BranchDistance*5 AS CurrentDistance, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='CompanyPhysical')AS CompanyPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical')AS MobileAppPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeAttendanceFolder')AS EmployeeAttendanceFolder FROM @FTable ORDER BY EmployeeId 
String sql: ; UPDATE EmployeeAttendanceDetail SET AttOutTime=GETDATE(), AttOutLat='25.710848', AttOutLong='85.54162', AttOutImage='EMP0001613062026Att639169681903050244.jpg' WHERE EmployeeId='EMP00016' AND AttDate='6/13/2026 12:00:00 AM' ;  UPDATE EmployeeAttendanceDetail SET AttValue=0, AttType='Present', AttStatus='Approved', ApproveUser='EMP00016', ApproveTime=GETDATE() WHERE EmployeeId='EMP00016' AND AttDate='6/13/2026 12:00:00 AM' ; 
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.GroupOfficerUserAttendanceImage(InputGroupOfficerUserAttendanceImage objData)
TargetSite: Void ZombieCheck()

Time: 16/06/2026 03:47:03 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP0009' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP0009' AND UserPassword='RQBNAFAAMAAwADAAOQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP0009' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='96ae3ae8d648cbf6' ; 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: 19/06/2026 04:56:52 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid object name 'GroupLoanMemberDetail'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at GroupLoanOfficer.ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 19/06/2026 04:56:52 PM
PageName: GroupOfficerMemberDetailListForKYC
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: Assignment
StackTrace:    at GroupLoanOfficer.BusinessLayer.GroupOfficerMemberDetailListForKYC(InputGroupOfficerMemberDetailListForKYC objData)
TargetSite: System.Data.DataTable GroupOfficerMemberDetailListForKYC(GroupLoanOfficer.InputGroupOfficerMemberDetailListForKYC)

Time: 19/06/2026 04:56:56 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid object name 'GroupLoanMemberDetail'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at GroupLoanOfficer.ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 19/06/2026 04:56:56 PM
PageName: GroupOfficerMemberDetailListForKYC
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: Assignment
StackTrace:    at GroupLoanOfficer.BusinessLayer.GroupOfficerMemberDetailListForKYC(InputGroupOfficerMemberDetailListForKYC objData)
TargetSite: System.Data.DataTable GroupOfficerMemberDetailListForKYC(GroupLoanOfficer.InputGroupOfficerMemberDetailListForKYC)

Time: 19/06/2026 04:56:58 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid object name 'GroupLoanMemberDetail'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at GroupLoanOfficer.ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 19/06/2026 04:56:58 PM
PageName: GroupOfficerMemberDetailListForKYC
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: Assignment
StackTrace:    at GroupLoanOfficer.BusinessLayer.GroupOfficerMemberDetailListForKYC(InputGroupOfficerMemberDetailListForKYC objData)
TargetSite: System.Data.DataTable GroupOfficerMemberDetailListForKYC(GroupLoanOfficer.InputGroupOfficerMemberDetailListForKYC)

Time: 19/06/2026 04:57:08 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid object name 'GroupLoanMemberDetail'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at GroupLoanOfficer.ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 19/06/2026 04:57:08 PM
PageName: GroupOfficerMemberDetailListForKYC
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00013'  AND a.MemberJoinDate>='6/19/2026 12:00:00 AM'  AND a.MemberJoinDate<'6/20/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: Assignment
StackTrace:    at GroupLoanOfficer.BusinessLayer.GroupOfficerMemberDetailListForKYC(InputGroupOfficerMemberDetailListForKYC objData)
TargetSite: System.Data.DataTable GroupOfficerMemberDetailListForKYC(GroupLoanOfficer.InputGroupOfficerMemberDetailListForKYC)

Time: 31/07/2026 08:54:56 AM
PageName: GroupOfficerUserAttendanceImage
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='e5421385c236ab42' ; DECLARE @FTable TABLE ( EmployeeAttendanceTime VARCHAR(10), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), AttInHH TINYINT, AttInMM TINYINT, AttOutHH TINYINT, AttOutMM TINYINT, BranchLatitude VARCHAR(20), BranchLongitude VARCHAR(20), BranchDistance BIGINT, VersionStatus VARCHAR(10), AttExist TINYINT, AttInDuration SMALLINT ); INSERT INTO @FTable ( EmployeeAttendanceTime, EmployeeId, EmployeeName, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus ) SELECT isnull((SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='EmployeeAttendanceTime' ),'INACTIVE')AS EmployeeAttendanceTime, a.UserLoginId AS EmployeeId, a.UserName AS EmployeeName, c.BranchLatitude, c.BranchLongitude, c.BranchDistance, (SELECT VersionStatus FROM MobileAppVersion WITH(nolock) WHERE VersionNo='11')AS VersionStatus FROM UserLoginDetail a WITH(nolock) LEFT JOIN BranchPermission b WITH(nolock) ON a.UserLoginId=b.UserId INNER JOIN BranchNameMaster c WITH(nolock) ON isnull(b.BranchId,a.BranchId)=c.BranchId WHERE a.MobileDeviceId='e5421385c236ab42' AND a.MobilePINNo='7050' ; UPDATE a SET a.AttInHH=isnull(b.AttInHH,9), a.AttInMM=isnull(b.AttInMM,0), a.AttOutHH=isnull(b.AttOutHH,18), a.AttOutMM=isnull(b.AttOutMM,00) FROM @FTable a INNER JOIN EmployeeRegistrationDetail b WITH(nolock) ON a.EmployeeId=b.EmployeeId ; UPDATE a SET a.AttExist=(CASE WHEN AttDate!='' THEN 1 ELSE 0 END), a.AttInDuration=datediff(minute,AttInTime,GETDATE()) FROM @FTable a INNER JOIN (SELECT EmployeeId, AttDate, AttInTime FROM EmployeeAttendanceDetail WITH(nolock) WHERE AttDate='7/31/2026 12:00:00 AM')b ON a.EmployeeId=b.EmployeeId ; SELECT EmployeeAttendanceTime, EmployeeId, EmployeeName, AttInHH, AttInMM, AttOutHH, AttOutMM, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus, isnull(AttExist,0)AS AttExist, AttInDuration, BranchDistance*5 AS CurrentDistance, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='CompanyPhysical')AS CompanyPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppPhysical')AS MobileAppPhysical, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeAttendanceFolder')AS EmployeeAttendanceFolder FROM @FTable ORDER BY EmployeeId 
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00018','ANJILA KUMARI', '7/31/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00018', GETDATE(), '25.710839', '85.541633', 'EMP0001831072026Att639210848724187041.jpg' ) ; 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
   at System.Int16.Parse(String s, NumberStyles style, NumberFormatInfo info)
   at System.Convert.ToInt16(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceImage(InputGroupOfficerUserAttendanceImage objData)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 14/08/2026 10:06:54 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBhAHkANAAzADEAMQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:07:00 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBhAHkANAAzADEAMQBAAA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:07:12 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBBAFkANAAzADEAMQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:07:15 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBBAFkANAAzADEAMQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:07:18 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBBAFkANAAzADEAMQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:07:24 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBBAFkANAAzADEAMQBAAA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:07:41 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBhAHkAMQA5ADkAOAA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:07:55 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='RQBNAFAAMAAwADAAMAA4AA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:08:58 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBhAHkANAAzADEAMQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:09:07 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBhAHkANAAzADEAMQBAAA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 14/08/2026 10:09:19 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EPM00008' AND UserPassword='SgBhAHkAMQA5ADkAOAA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EPM00008' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='769b727e98bb05e1' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/14/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603599', '85.485708', 'EMP0000714082026Att639222946246892688.jpg' ) ; 
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: 18/08/2026 02:41:54 PM
PageName: DataTableResult
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00010'  AND a.MemberJoinDate>='8/18/2026 12:00:00 AM'  AND a.MemberJoinDate<'8/19/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Invalid object name 'GroupLoanMemberDetail'.
Source: .Net SqlClient Data Provider
StackTrace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at GroupLoanOfficer.ClassMaster.DataTableResult(String query)
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])

Time: 18/08/2026 02:41:55 PM
PageName: GroupOfficerMemberDetailListForKYC
String str:  SELECT a.MemberId, rtrim(Convert(CHAR,a.MemberJoinDate,106))AS MemberJoinDate, isnull(a.MemberSalutation,'')+' '+isnull(a.MemberName,'') AS MemberName, isnull(a.GuardianSalutation,'')+' '+isnull(a.MemberGuardianName ,'')AS GuardianName, isnull(a.NomineeSalutation,'')+' '+isnull(a.NomineeName,'') AS NomineeName, a.MemberMobileNo, convert(CHAR,a.MemberDOB,106)AS MemberDOB, a.MemberProfileStatus, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+(SELECT replace(ReportValue, '~/', '') FROM ProjectReportSetting WITH(nolock) WHERE ReportName='GroupMemberKYCFolder')+ a.MemberId + '/' + a.MemberPhoto AS MemberProfileURL FROM GroupLoanMemberDetail a WITH(nolock) WHERE a.GroupOfficerId='EMP00010'  AND a.MemberJoinDate>='8/18/2026 12:00:00 AM'  AND a.MemberJoinDate<'8/19/2026 12:00:00 AM'  ORDER BY a.MemberName, a.MemberGuardianName ;
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong, AttInImage ) VALUES ('EMP00007','SUMAN KUMAR', '8/18/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00007', GETDATE(), '25.603733', '85.485665', 'EMP0000718082026Att639226400639506317.jpg' ) ; 
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Object reference not set to an instance of an object.
Source: Assignment
StackTrace:    at GroupLoanOfficer.BusinessLayer.GroupOfficerMemberDetailListForKYC(InputGroupOfficerMemberDetailListForKYC objData)
TargetSite: System.Data.DataTable GroupOfficerMemberDetailListForKYC(GroupLoanOfficer.InputGroupOfficerMemberDetailListForKYC)