Time: 29/09/2025 08:37:55 AM
PageName: GroupOfficerUserAttendanceInOut
String str:  SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='8c767f1c865e2c34' ; 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='8c767f1c865e2c34' 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='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 ('EMP00001','Munna Kumar', '9/29/2025 12:00:00 AM', GETDATE(), 'Pending', 'EMP00001', GETDATE(), '25.451047', '87.257599' ) ; 
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)