Time: 20/09/2025 10:44:25 AM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='emp000141' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='emp000141' AND UserPassword='MQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='emp000141' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='b9b7077dc52bb6ac' ; 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: 05/10/2025 08:50:41 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00037' AND UserPassword='MQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='a1486cb2f74021a9' ; 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: 05/10/2025 08:53:04 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00037' AND UserPassword='MQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='a1486cb2f74021a9' ; 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: 05/10/2025 08:54:21 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00037' AND UserPassword='MQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='a1486cb2f74021a9' ; 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: 05/10/2025 08:54:42 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00037' AND UserPassword='MgA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='a1486cb2f74021a9' ; 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: 05/10/2025 08:54:52 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00037' AND UserPassword='MQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='abcd' ; 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: 05/10/2025 08:55:01 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00037' AND UserPassword='MQA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP00037' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='abcd' ; 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: 20/12/2025 04:28:33 PM
PageName: GroupOfficerUserAttendanceImage
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='b9b7077dc52bb6ac' ; DECLARE @FTable TABLE ( AttendanceTime VARCHAR(10), EmployeeId VARCHAR(20), EmployeeName VARCHAR(50), AttInHH TINYINT, AttInMM TINYINT, AttOutHH TINYINT, AttOutMM TINYINT, BranchLatitude VARCHAR(20), BranchLongitude VARCHAR(20), BranchDistance SMALLINT, VersionStatus VARCHAR(10), AttExist TINYINT, AttInDuration SMALLINT ); INSERT INTO @FTable ( AttendanceTime, EmployeeId, EmployeeName, BranchLatitude, BranchLongitude, BranchDistance, VersionStatus ) SELECT isnull((SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='AttendanceTime' ),'INACTIVE')AS AttendanceTime, 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='b9b7077dc52bb6ac' AND a.MobilePINNo='1234' ; 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='12/20/2025 12:00:00 AM')b ON a.EmployeeId=b.EmployeeId ; SELECT AttendanceTime, 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 UserLoginDetail SET MobilePINNo='1234', MobileDeviceId='b9b7077dc52bb6ac' WHERE UserLoginId='emp00144'  ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Column 'EmployeeAttendanceFolder' does not belong to table DSResult.
Source: System.Data
StackTrace:    at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceImage(InputGroupOfficerUserAttendanceImage objData)
TargetSite: System.Data.DataColumn GetDataColumn(System.String)