Time: 22/09/2025 04:50:15 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='imp12' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='imp12' AND UserPassword='MQA5ADkAMwA=' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='imp12' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='edf827c5ddd4a3a6' ; 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: 26/09/2025 05:22:01 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:22:06 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:22:12 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:22:43 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:24:24 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:24:39 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:24:52 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:25:32 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql: ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 26/09/2025 05:26:06 PM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='f505efa42f28247e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='f505efa42f28247e' AND a.MobilePINNo='0000' ; 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='9/26/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 FROM @FTable ORDER BY EmployeeId 
String sql:  UPDATE UserLoginDetail SET TokenTime=GETDATE(), TokenValue='E9M9P705050817036433849045540948334630718050507P9M9E' WHERE UserLoginId='EMP00010' ;
Data: System.Collections.ListDictionaryInternal
HelpLink: 
InnerException: 
Message: Input string was not in a correct format.
Source: mscorlib
StackTrace:    at System.Number.ParseDouble(String value, NumberStyles options, NumberFormatInfo numfmt)
   at System.Convert.ToDouble(String value)
   at GroupLoanOfficer.BusinessLayer.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Double ParseDouble(System.String, System.Globalization.NumberStyles, System.Globalization.NumberFormatInfo)

Time: 29/09/2025 09:08:53 AM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='edf827c5ddd4a3a6' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='edf827c5ddd4a3a6' AND a.MobilePINNo='1993' ; 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='9/29/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 FROM @FTable ORDER BY EmployeeId 
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('EMP00012','Pujesh Kumar Dubey', '9/29/2025 12:00:00 AM', GETDATE(), 'Pending', 'EMP00012', GETDATE(), '25.265728', '82.500262' ) ; 
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.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 28/10/2025 06:41:38 AM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='3d709948d301232e' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='3d709948d301232e' AND a.MobilePINNo='1987' ; 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='10/28/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 FROM @FTable ORDER BY EmployeeId 
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('E242501053','Sandesh Kumar Maurya', '10/28/2025 12:00:00 AM', GETDATE(), 'Pending', 'E242501053', GETDATE(), '25.266093', '82.496238' ) ; 
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.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)

Time: 30/10/2025 03:23:08 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='E0015' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='E0015' AND UserPassword='RQAwADAAMQA1AA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='E0015' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='0a12db3bd200729f' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql:  UPDATE UserLoginDetail SET TokenTime=GETDATE(), TokenValue='E6M1P701020405956631819374473918136659504020107P1M6E' WHERE UserLoginId='EMP00009' ;
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: 30/10/2025 03:23:13 PM
PageName: Object
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='E0015' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='E0015' AND UserPassword='RQAwADAAMQA1AA==' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='E0015' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='0a12db3bd200729f' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ;
String sql:  UPDATE UserLoginDetail SET TokenTime=GETDATE(), TokenValue='E6M1P701020405956631819374473918136659504020107P1M6E' WHERE UserLoginId='EMP00009' ;
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/11/2025 06:48:59 AM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='e3a626de740eb9e8' ; 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 AttendanceTime FROM ProjectDataSettingMaster WITH(nolock) ),'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='e3a626de740eb9e8' AND a.MobilePINNo='8922' ; 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='11/19/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 FROM @FTable ORDER BY EmployeeId 
String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('E242501056','Ganshyam Kumar', '11/19/2025 12:00:00 AM', GETDATE(), 'Pending', 'E242501056', GETDATE(), '25.292437', '82.306817' ) ; 
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.GroupOfficerUserAttendanceInOut(InputGroupOfficerUserAttendanceInOut objData)
TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean)