Time: 27/04/2026 07:52:51 AM PageName: GroupOfficerUserAttendanceInOut String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='faa04f493d5c5189' ; 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 SMALLINT, 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='faa04f493d5c5189' 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='4/27/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 FROM @FTable ORDER BY EmployeeId String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('EMP00153','Kapil Dev Pal', '4/27/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00153', GETDATE(), '25.384128', '81.88341' ) ; 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: 27/04/2026 07:52:55 AM PageName: GroupOfficerUserAttendanceInOut String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='faa04f493d5c5189' ; 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 SMALLINT, 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='faa04f493d5c5189' 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='4/27/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 FROM @FTable ORDER BY EmployeeId String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('EMP00153','Kapil Dev Pal', '4/27/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00153', GETDATE(), '25.384128', '81.88341' ) ; 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: 05/05/2026 07:08:51 AM PageName: GroupOfficerUserAttendanceInOut String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='faa04f493d5c5189' ; 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 SMALLINT, 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='faa04f493d5c5189' 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='5/5/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 FROM @FTable ORDER BY EmployeeId String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('EMP00153','Kapil Dev Pal', '5/5/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00153', GETDATE(), '25.384132', '81.883406' ) ; 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: 05/05/2026 07:08:56 AM PageName: GroupOfficerUserAttendanceInOut String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='faa04f493d5c5189' ; 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 SMALLINT, 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='faa04f493d5c5189' 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='5/5/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 FROM @FTable ORDER BY EmployeeId String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('EMP00153','Kapil Dev Pal', '5/5/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00153', GETDATE(), '25.384132', '81.883406' ) ; 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: 11/05/2026 07:42:43 AM PageName: GroupOfficerUserAttendanceInOut String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='faa04f493d5c5189' ; 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 SMALLINT, 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='faa04f493d5c5189' 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='5/11/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 FROM @FTable ORDER BY EmployeeId String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('EMP00153','Kapil Dev Pal', '5/11/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00153', GETDATE(), '25.384116', '81.88343' ) ; 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: 11/05/2026 07:42:56 AM PageName: GroupOfficerUserAttendanceInOut String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WITH(nolock) WHERE MobileDeviceId='faa04f493d5c5189' ; 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 SMALLINT, 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='faa04f493d5c5189' 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='5/11/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 FROM @FTable ORDER BY EmployeeId String sql: ; INSERT INTO EmployeeAttendanceDetail ( EmployeeId, EmployeeName, AttDate, AttInTime, AttStatus, EntryUser, EntryTime, AttInLat, AttInLong ) VALUES ('EMP00153','Kapil Dev Pal', '5/11/2026 12:00:00 AM', GETDATE(), 'Pending', 'EMP00153', GETDATE(), '25.384116', '81.88343' ) ; 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: 12/05/2026 01:24:58 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000154' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADQA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='ba31f4559227ad6b' ; 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: 12/05/2026 01:25:00 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000154' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADQA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='ba31f4559227ad6b' ; 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: 12/05/2026 01:25:01 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000154' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADQA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='ba31f4559227ad6b' ; 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: 12/05/2026 01:25:02 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000154' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADQA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='ba31f4559227ad6b' ; 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: 12/05/2026 01:25:02 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000154' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADQA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='ba31f4559227ad6b' ; 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: 12/05/2026 01:25:02 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000154' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADQA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='ba31f4559227ad6b' ; 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: 12/05/2026 01:25:03 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000154' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADQA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000154' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='ba31f4559227ad6b' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: There is no row at position 0. Source: System.Data StackTrace: at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.DataRowCollection.get_Item(Int32 index) at GroupLoanOfficer.BusinessLayer.GroupOfficerRegisterYourDevice(InputGroupOfficerRegisterYourDevice objData) TargetSite: NodePath GetNodeByIndex(Int32) Time: 16/05/2026 12:54:54 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000155' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000155' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADUA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000155' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='3a2f41c2973740cc' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: There is no row at position 0. Source: System.Data StackTrace: at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.DataRowCollection.get_Item(Int32 index) at GroupLoanOfficer.BusinessLayer.GroupOfficerRegisterYourDevice(InputGroupOfficerRegisterYourDevice objData) TargetSite: NodePath GetNodeByIndex(Int32) Time: 16/05/2026 12:55:41 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000155' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000155' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADUA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000155' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='3a2f41c2973740cc' ; SELECT VersionStatus FROM MobileAppVersion WHERE VersionNo='11' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: There is no row at position 0. Source: System.Data StackTrace: at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.DataRowCollection.get_Item(Int32 index) at GroupLoanOfficer.BusinessLayer.GroupOfficerRegisterYourDevice(InputGroupOfficerRegisterYourDevice objData) TargetSite: NodePath GetNodeByIndex(Int32) Time: 16/05/2026 12:56:03 PM PageName: Object String str: SELECT Count(1)AS Nos0 FROM UserLoginDetail WHERE UserLoginId='EMP000155' ; SELECT Count(1)AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP000155' AND UserPassword='RQBNAFAAMAAwADAAMQA1ADUA' ; SELECT UserLoginId, UserName, UserLoginStatus FROM UserLoginDetail WHERE UserLoginId='EMP000155' ; SELECT UserLoginId, UserName FROM UserLoginDetail with(nolock) WHERE MobileDeviceId='3a2f41c2973740cc' ; 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)