Time: 22/10/2025 11:01:39 PM PageName: ValourProject_ProjectTicketMaster String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Access to the path 'C:\Inetpub\vhosts\valourinfotech.in\support.valourinfotech.in\UploadedDocs\ValourProjectUser\VAL062500122102025638967708999437684.png' is denied. Source: mscorlib StackTrace: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode) at System.Web.HttpPostedFile.SaveAs(String filename) at ValourProject_ProjectTicketMaster.ImagePreview() TargetSite: Void WinIOError(Int32, System.String) Time: 22/10/2025 11:04:55 PM PageName: ValourProject_ProjectTicketMaster String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Access to the path 'C:\Inetpub\vhosts\valourinfotech.in\support.valourinfotech.in\UploadedDocs\ValourProjectUser\VAB000A2822102025638967710953747134.jpg' is denied. Source: mscorlib StackTrace: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode) at System.Web.HttpPostedFile.SaveAs(String filename) at ValourProject_ProjectTicketMaster.ImagePreview() TargetSite: Void WinIOError(Int32, System.String) Time: 22/10/2025 11:27:49 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/22/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '223.177.170.179', '', 'Chrome', '26.8436', '81.0116' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 23/10/2025 01:38:27 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/23/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '223.177.170.179', '', 'Chrome', '26.8715', '80.8997' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 24/10/2025 10:19:41 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/24/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '223.177.170.179', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/10/2025 10:14:03 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/25/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '223.177.170.179', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/10/2025 10:17:26 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/25/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '223.177.170.179', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/10/2025 10:17:49 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/25/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '223.177.170.179', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 26/10/2025 07:41:50 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/26/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '223.184.169.31', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 26/10/2025 04:29:42 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/26/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '223.177.170.179', '', 'Chrome', '26.8715', '80.8997' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 27/10/2025 10:13:18 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/27/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '223.177.170.179', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 28/10/2025 10:11:53 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/28/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '36.255.230.65', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 28/10/2025 05:59:01 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/28/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '36.255.230.65', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 29/10/2025 08:43:17 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/29/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '223.184.167.71', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 29/10/2025 10:10:14 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/29/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.236', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 30/10/2025 10:16:35 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/30/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '106.214.220.210', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 31/10/2025 10:09:27 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='10/31/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '106.214.220.210', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/11/2025 10:43:25 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/1/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '106.214.220.210', '', 'Chrome', '26.8140544', '80.8910848' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/11/2025 05:38:27 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/1/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '106.214.220.210', '', 'Chrome', '26.8140544', '80.8910848' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 03/11/2025 10:18:32 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/3/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '106.214.220.210', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 03/11/2025 03:32:46 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/3/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '106.214.220.210', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 04/11/2025 10:17:00 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/4/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '106.214.220.210', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 05/11/2025 10:11:01 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/5/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '106.214.220.210', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 06/11/2025 10:11:11 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/6/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 07/11/2025 10:16:58 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/7/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 07/11/2025 11:30:15 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/7/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 08/11/2025 11:22:22 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/8/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 09/11/2025 09:51:41 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/9/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 10/11/2025 10:14:09 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/10/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/11/2025 10:05:40 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/11/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/11/2025 11:56:20 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/11/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 12/11/2025 10:17:12 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/12/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 12/11/2025 11:12:35 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/12/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 15/11/2025 10:17:24 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/15/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 15/11/2025 10:20:41 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/15/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 17/11/2025 10:28:03 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/17/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '122.173.68.174', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 17/11/2025 10:36:41 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/17/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '122.173.68.174', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 18/11/2025 10:24:26 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/18/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '122.173.68.174', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 19/11/2025 10:07:03 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/19/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '122.173.68.174', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 20/11/2025 10:15:25 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/20/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '122.173.68.174', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 20/11/2025 01:28:26 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/20/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '122.173.68.174', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 21/11/2025 12:59:54 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/21/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '122.173.68.174', '', 'Chrome', '26.8402688', '81.0156032' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 21/11/2025 10:23:55 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/21/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '122.173.68.174', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 22/11/2025 10:43:31 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/22/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 22/11/2025 10:45:03 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/22/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 23/11/2025 09:51:40 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/23/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 24/11/2025 10:22:27 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/24/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/11/2025 10:15:57 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/25/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 26/11/2025 10:18:20 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/26/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 26/11/2025 07:09:54 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/26/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 26/11/2025 07:10:53 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/26/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 27/11/2025 05:23:46 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/27/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 28/11/2025 10:19:36 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/28/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 29/11/2025 09:32:09 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/29/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 30/11/2025 05:35:58 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='11/30/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '103.255.106.166', '', 'Chrome', '26.8510499', '81.0029807' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 10:12:21 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/1/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 11:52:41 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/1/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 02:48:04 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/1/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 03:09:39 PM PageName: ValourProject_ProjectURLSSLMaster String str: SELECT a.SrNo, a.ProjectId, a.ProjectName, a.ProductName, a.ProductURL, a.URLDetail, Convert(char,a.URLStartDate,103)AS URLStartDated, a.URLStartDate, Convert(char,a.URLRenewDate,103)AS URLRenewDated, a.URLRenewDate, Convert(char,a.URLSSLDate,103)AS URLSSLDated, a.URLSSLDate, a.URLStatus FROM ValourProjectURLMaster a WITH(nolock) WHERE a.URLStatus='Active' AND a.URLSSLDate>='11/1/2025 12:00:00 AM' String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: String was not recognized as a valid DateTime. Source: mscorlib StackTrace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at DateConversion.DateHelper.ConvertDate(String s) at ValourProject_ProjectURLSSLMaster.FillData() TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 01/12/2025 03:22:14 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/1/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 03:35:41 PM PageName: DataTableResult String str: DECLARE @TTable TABLE ( LedgerNo INT, LedgerId INT, LedgerName VARCHAR(100), LedgerHead INT, LedgerMain INT, LedgerDescription VARCHAR(100), LedgerLevel TINYINT, LedgerStatus VARCHAR(10), SubLedgerStatus VARCHAR(10), JournalVoucher VARCHAR(10), ContraVoucher VARCHAR(10), ReceiveVoucher VARCHAR(10), PaymentVoucher VARCHAR(10), CashAndBank VARCHAR(10), RequiredInMIS VARCHAR(10) ); INSERT INTO @TTable ( LedgerNo, LedgerId, LedgerName, LedgerHead, LedgerMain, LedgerDescription, LedgerLevel, LedgerStatus, SubLedgerStatus, JournalVoucher, ContraVoucher, ReceiveVoucher, PaymentVoucher, CashAndBank, RequiredInMIS ) SELECT a.LedgerNo, a.LedgerId, a.LedgerName, a.LedgerHead, a.LedgerMain, a.LedgerDescription, a.LedgerLevel, a.LedgerStatus, a.SubLedgerStatus, a.JournalVoucher, a.ContraVoucher, a.ReceiveVoucher, a.PaymentVoucher, a.CashAndBank, a.RequiredInMIS FROM AccountLedgerMaster a WITH(nolock) WHERE 1=1 SELECT t1.LedgerNo, t1.LedgerLevel, t1.LedgerMain, t1.LedgerHead, t2.LedgerName AS LedgerHeadName, t1.LedgerId, t1.LedgerName, CASE WHEN t1.LedgerLevel=1 THEN '........'+t1.LedgerName WHEN t1.LedgerLevel=2 THEN '................'+t1.LedgerName WHEN t1.LedgerLevel=3 THEN '........................'+t1.LedgerName WHEN t1.LedgerLevel=4 THEN '................................'+t1.LedgerName WHEN t1.LedgerLevel=5 THEN '........................................'+t1.LedgerName WHEN t1.LedgerLevel=6 THEN '................................................'+t1.LedgerName WHEN t1.LedgerLevel=7 THEN '........................................................'+t1.LedgerName WHEN t1.LedgerLevel=8 THEN '................................................................'+t1.LedgerName WHEN t1.LedgerLevel=9 THEN '........................................................................'+t1.LedgerName ELSE t1.LedgerName END AS LedgerNameView, t1.LedgerDescription, t1.LedgerStatus, t1.SubLedgerStatus, t1.JournalVoucher, t1.ContraVoucher, t1.ReceiveVoucher, t1.PaymentVoucher, t1.CashAndBank, t1.RequiredInMIS FROM @TTable t1 LEFT JOIN @TTable t2 ON t1.LedgerHead=t2.LedgerId LEFT JOIN @TTable t3 ON t2.LedgerHead=t3.LedgerId LEFT JOIN @TTable t4 ON t3.LedgerHead=t4.LedgerId LEFT JOIN @TTable t5 ON t4.LedgerHead=t5.LedgerId LEFT JOIN @TTable t6 ON t5.LedgerHead=t6.LedgerId LEFT JOIN @TTable t7 ON t6.LedgerHead=t7.LedgerId LEFT JOIN @TTable t8 ON t7.LedgerHead=t8.LedgerId LEFT JOIN @TTable t9 ON t8.LedgerHead=t9.LedgerId LEFT JOIN @TTable t10 ON t9.LedgerHead=t10.LedgerId WHERE 1=1 ORDER BY t1.LedgerMain, isnull(t10.LedgerName,'')+isnull(t9.LedgerName,'')+isnull(t8.LedgerName,'')+isnull(t7.LedgerName,'')+isnull(t6.LedgerName,'')+isnull(t5.LedgerName,'')+isnull(t4.LedgerName,'')+isnull(t3.LedgerName,'')+isnull(t2.LedgerName,'')+isnull(t1.LedgerName,'') ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Conversion failed when converting the varchar value 'VAL0624001' to data type int. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.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 ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 03:35:41 PM PageName: Account_AccountLedgerTableView String str: DECLARE @TTable TABLE ( LedgerNo INT, LedgerId INT, LedgerName VARCHAR(100), LedgerHead INT, LedgerMain INT, LedgerDescription VARCHAR(100), LedgerLevel TINYINT, LedgerStatus VARCHAR(10), SubLedgerStatus VARCHAR(10), JournalVoucher VARCHAR(10), ContraVoucher VARCHAR(10), ReceiveVoucher VARCHAR(10), PaymentVoucher VARCHAR(10), CashAndBank VARCHAR(10), RequiredInMIS VARCHAR(10) ); INSERT INTO @TTable ( LedgerNo, LedgerId, LedgerName, LedgerHead, LedgerMain, LedgerDescription, LedgerLevel, LedgerStatus, SubLedgerStatus, JournalVoucher, ContraVoucher, ReceiveVoucher, PaymentVoucher, CashAndBank, RequiredInMIS ) SELECT a.LedgerNo, a.LedgerId, a.LedgerName, a.LedgerHead, a.LedgerMain, a.LedgerDescription, a.LedgerLevel, a.LedgerStatus, a.SubLedgerStatus, a.JournalVoucher, a.ContraVoucher, a.ReceiveVoucher, a.PaymentVoucher, a.CashAndBank, a.RequiredInMIS FROM AccountLedgerMaster a WITH(nolock) WHERE 1=1 SELECT t1.LedgerNo, t1.LedgerLevel, t1.LedgerMain, t1.LedgerHead, t2.LedgerName AS LedgerHeadName, t1.LedgerId, t1.LedgerName, CASE WHEN t1.LedgerLevel=1 THEN '........'+t1.LedgerName WHEN t1.LedgerLevel=2 THEN '................'+t1.LedgerName WHEN t1.LedgerLevel=3 THEN '........................'+t1.LedgerName WHEN t1.LedgerLevel=4 THEN '................................'+t1.LedgerName WHEN t1.LedgerLevel=5 THEN '........................................'+t1.LedgerName WHEN t1.LedgerLevel=6 THEN '................................................'+t1.LedgerName WHEN t1.LedgerLevel=7 THEN '........................................................'+t1.LedgerName WHEN t1.LedgerLevel=8 THEN '................................................................'+t1.LedgerName WHEN t1.LedgerLevel=9 THEN '........................................................................'+t1.LedgerName ELSE t1.LedgerName END AS LedgerNameView, t1.LedgerDescription, t1.LedgerStatus, t1.SubLedgerStatus, t1.JournalVoucher, t1.ContraVoucher, t1.ReceiveVoucher, t1.PaymentVoucher, t1.CashAndBank, t1.RequiredInMIS FROM @TTable t1 LEFT JOIN @TTable t2 ON t1.LedgerHead=t2.LedgerId LEFT JOIN @TTable t3 ON t2.LedgerHead=t3.LedgerId LEFT JOIN @TTable t4 ON t3.LedgerHead=t4.LedgerId LEFT JOIN @TTable t5 ON t4.LedgerHead=t5.LedgerId LEFT JOIN @TTable t6 ON t5.LedgerHead=t6.LedgerId LEFT JOIN @TTable t7 ON t6.LedgerHead=t7.LedgerId LEFT JOIN @TTable t8 ON t7.LedgerHead=t8.LedgerId LEFT JOIN @TTable t9 ON t8.LedgerHead=t9.LedgerId LEFT JOIN @TTable t10 ON t9.LedgerHead=t10.LedgerId WHERE 1=1 ORDER BY t1.LedgerMain, isnull(t10.LedgerName,'')+isnull(t9.LedgerName,'')+isnull(t8.LedgerName,'')+isnull(t7.LedgerName,'')+isnull(t6.LedgerName,'')+isnull(t5.LedgerName,'')+isnull(t4.LedgerName,'')+isnull(t3.LedgerName,'')+isnull(t2.LedgerName,'')+isnull(t1.LedgerName,'') ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_fsidvwf1 StackTrace: at Account_AccountLedgerTableView.FillData() TargetSite: Void FillData() Time: 01/12/2025 03:35:45 PM PageName: DataTableResult String str: DECLARE @TTable TABLE ( LedgerNo INT, LedgerId INT, LedgerName VARCHAR(100), LedgerHead INT, LedgerMain INT, LedgerDescription VARCHAR(100), LedgerLevel TINYINT, LedgerStatus VARCHAR(10), SubLedgerStatus VARCHAR(10), JournalVoucher VARCHAR(10), ContraVoucher VARCHAR(10), ReceiveVoucher VARCHAR(10), PaymentVoucher VARCHAR(10), CashAndBank VARCHAR(10), RequiredInMIS VARCHAR(10) ); INSERT INTO @TTable ( LedgerNo, LedgerId, LedgerName, LedgerHead, LedgerMain, LedgerDescription, LedgerLevel, LedgerStatus, SubLedgerStatus, JournalVoucher, ContraVoucher, ReceiveVoucher, PaymentVoucher, CashAndBank, RequiredInMIS ) SELECT a.LedgerNo, a.LedgerId, a.LedgerName, a.LedgerHead, a.LedgerMain, a.LedgerDescription, a.LedgerLevel, a.LedgerStatus, a.SubLedgerStatus, a.JournalVoucher, a.ContraVoucher, a.ReceiveVoucher, a.PaymentVoucher, a.CashAndBank, a.RequiredInMIS FROM AccountLedgerMaster a WITH(nolock) WHERE 1=1 SELECT t1.LedgerNo, t1.LedgerLevel, t1.LedgerMain, t1.LedgerHead, t2.LedgerName AS LedgerHeadName, t1.LedgerId, t1.LedgerName, CASE WHEN t1.LedgerLevel=1 THEN '........'+t1.LedgerName WHEN t1.LedgerLevel=2 THEN '................'+t1.LedgerName WHEN t1.LedgerLevel=3 THEN '........................'+t1.LedgerName WHEN t1.LedgerLevel=4 THEN '................................'+t1.LedgerName WHEN t1.LedgerLevel=5 THEN '........................................'+t1.LedgerName WHEN t1.LedgerLevel=6 THEN '................................................'+t1.LedgerName WHEN t1.LedgerLevel=7 THEN '........................................................'+t1.LedgerName WHEN t1.LedgerLevel=8 THEN '................................................................'+t1.LedgerName WHEN t1.LedgerLevel=9 THEN '........................................................................'+t1.LedgerName ELSE t1.LedgerName END AS LedgerNameView, t1.LedgerDescription, t1.LedgerStatus, t1.SubLedgerStatus, t1.JournalVoucher, t1.ContraVoucher, t1.ReceiveVoucher, t1.PaymentVoucher, t1.CashAndBank, t1.RequiredInMIS FROM @TTable t1 LEFT JOIN @TTable t2 ON t1.LedgerHead=t2.LedgerId LEFT JOIN @TTable t3 ON t2.LedgerHead=t3.LedgerId LEFT JOIN @TTable t4 ON t3.LedgerHead=t4.LedgerId LEFT JOIN @TTable t5 ON t4.LedgerHead=t5.LedgerId LEFT JOIN @TTable t6 ON t5.LedgerHead=t6.LedgerId LEFT JOIN @TTable t7 ON t6.LedgerHead=t7.LedgerId LEFT JOIN @TTable t8 ON t7.LedgerHead=t8.LedgerId LEFT JOIN @TTable t9 ON t8.LedgerHead=t9.LedgerId LEFT JOIN @TTable t10 ON t9.LedgerHead=t10.LedgerId WHERE 1=1 ORDER BY t1.LedgerMain, isnull(t10.LedgerName,'')+isnull(t9.LedgerName,'')+isnull(t8.LedgerName,'')+isnull(t7.LedgerName,'')+isnull(t6.LedgerName,'')+isnull(t5.LedgerName,'')+isnull(t4.LedgerName,'')+isnull(t3.LedgerName,'')+isnull(t2.LedgerName,'')+isnull(t1.LedgerName,'') ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Conversion failed when converting the varchar value 'VAL0624001' to data type int. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.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 ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 03:35:45 PM PageName: Account_AccountLedgerTableView String str: DECLARE @TTable TABLE ( LedgerNo INT, LedgerId INT, LedgerName VARCHAR(100), LedgerHead INT, LedgerMain INT, LedgerDescription VARCHAR(100), LedgerLevel TINYINT, LedgerStatus VARCHAR(10), SubLedgerStatus VARCHAR(10), JournalVoucher VARCHAR(10), ContraVoucher VARCHAR(10), ReceiveVoucher VARCHAR(10), PaymentVoucher VARCHAR(10), CashAndBank VARCHAR(10), RequiredInMIS VARCHAR(10) ); INSERT INTO @TTable ( LedgerNo, LedgerId, LedgerName, LedgerHead, LedgerMain, LedgerDescription, LedgerLevel, LedgerStatus, SubLedgerStatus, JournalVoucher, ContraVoucher, ReceiveVoucher, PaymentVoucher, CashAndBank, RequiredInMIS ) SELECT a.LedgerNo, a.LedgerId, a.LedgerName, a.LedgerHead, a.LedgerMain, a.LedgerDescription, a.LedgerLevel, a.LedgerStatus, a.SubLedgerStatus, a.JournalVoucher, a.ContraVoucher, a.ReceiveVoucher, a.PaymentVoucher, a.CashAndBank, a.RequiredInMIS FROM AccountLedgerMaster a WITH(nolock) WHERE 1=1 SELECT t1.LedgerNo, t1.LedgerLevel, t1.LedgerMain, t1.LedgerHead, t2.LedgerName AS LedgerHeadName, t1.LedgerId, t1.LedgerName, CASE WHEN t1.LedgerLevel=1 THEN '........'+t1.LedgerName WHEN t1.LedgerLevel=2 THEN '................'+t1.LedgerName WHEN t1.LedgerLevel=3 THEN '........................'+t1.LedgerName WHEN t1.LedgerLevel=4 THEN '................................'+t1.LedgerName WHEN t1.LedgerLevel=5 THEN '........................................'+t1.LedgerName WHEN t1.LedgerLevel=6 THEN '................................................'+t1.LedgerName WHEN t1.LedgerLevel=7 THEN '........................................................'+t1.LedgerName WHEN t1.LedgerLevel=8 THEN '................................................................'+t1.LedgerName WHEN t1.LedgerLevel=9 THEN '........................................................................'+t1.LedgerName ELSE t1.LedgerName END AS LedgerNameView, t1.LedgerDescription, t1.LedgerStatus, t1.SubLedgerStatus, t1.JournalVoucher, t1.ContraVoucher, t1.ReceiveVoucher, t1.PaymentVoucher, t1.CashAndBank, t1.RequiredInMIS FROM @TTable t1 LEFT JOIN @TTable t2 ON t1.LedgerHead=t2.LedgerId LEFT JOIN @TTable t3 ON t2.LedgerHead=t3.LedgerId LEFT JOIN @TTable t4 ON t3.LedgerHead=t4.LedgerId LEFT JOIN @TTable t5 ON t4.LedgerHead=t5.LedgerId LEFT JOIN @TTable t6 ON t5.LedgerHead=t6.LedgerId LEFT JOIN @TTable t7 ON t6.LedgerHead=t7.LedgerId LEFT JOIN @TTable t8 ON t7.LedgerHead=t8.LedgerId LEFT JOIN @TTable t9 ON t8.LedgerHead=t9.LedgerId LEFT JOIN @TTable t10 ON t9.LedgerHead=t10.LedgerId WHERE 1=1 ORDER BY t1.LedgerMain, isnull(t10.LedgerName,'')+isnull(t9.LedgerName,'')+isnull(t8.LedgerName,'')+isnull(t7.LedgerName,'')+isnull(t6.LedgerName,'')+isnull(t5.LedgerName,'')+isnull(t4.LedgerName,'')+isnull(t3.LedgerName,'')+isnull(t2.LedgerName,'')+isnull(t1.LedgerName,'') ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_fsidvwf1 StackTrace: at Account_AccountLedgerTableView.FillData() TargetSite: Void FillData() Time: 01/12/2025 03:36:17 PM PageName: DataTableResult String str: SELECT a.TransNo, a.BranchId, a.BranchName, isnull(a.VoucherType,'N/A')AS VoucherType, Convert(char,a.TransDate,106)AS TransDate, a.VoucherId, a.HeadId, a.HeadName, a.Credit, a.Debit, a.TransactionId, a.Refer1, a.Refer2, a.Refer3, a.Narration, a.EntryType, a.EntryUser, rtrim(Convert(char,a.EntryTime,106))+' - '+rtrim(Convert(char,a.EntryTime,108))AS EntryTime, CASE WHEN len((SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId))>10 THEN 'View' ELSE '' END AS AttachFile, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )+'UploadedDocs/VoucherRequest/'+(SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId)AS AttachFileURL, (SELECT Reportvalue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='AccountVoucherHTML')AS HTMLReportPageName FROM F2526VoucherDetail a WITH(nolock) WHERE a.VoucherId='VH00000420' ORDER BY a.TransNo DESC ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'TransactionId'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.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 ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 03:36:17 PM PageName: Account_AccountVoucherDetail String str: SELECT a.TransNo, a.BranchId, a.BranchName, isnull(a.VoucherType,'N/A')AS VoucherType, Convert(char,a.TransDate,106)AS TransDate, a.VoucherId, a.HeadId, a.HeadName, a.Credit, a.Debit, a.TransactionId, a.Refer1, a.Refer2, a.Refer3, a.Narration, a.EntryType, a.EntryUser, rtrim(Convert(char,a.EntryTime,106))+' - '+rtrim(Convert(char,a.EntryTime,108))AS EntryTime, CASE WHEN len((SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId))>10 THEN 'View' ELSE '' END AS AttachFile, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )+'UploadedDocs/VoucherRequest/'+(SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId)AS AttachFileURL, (SELECT Reportvalue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='AccountVoucherHTML')AS HTMLReportPageName FROM F2526VoucherDetail a WITH(nolock) WHERE a.VoucherId='VH00000420' ORDER BY a.TransNo DESC ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_n4br4awl StackTrace: at Account_AccountVoucherDetail.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 01/12/2025 03:36:25 PM PageName: DataTableResult String str: SELECT a.TransNo, a.BranchId, a.BranchName, isnull(a.VoucherType,'N/A')AS VoucherType, Convert(char,a.TransDate,106)AS TransDate, a.VoucherId, a.HeadId, a.HeadName, a.Credit, a.Debit, a.TransactionId, a.Refer1, a.Refer2, a.Refer3, a.Narration, a.EntryType, a.EntryUser, rtrim(Convert(char,a.EntryTime,106))+' - '+rtrim(Convert(char,a.EntryTime,108))AS EntryTime, CASE WHEN len((SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId))>10 THEN 'View' ELSE '' END AS AttachFile, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )+'UploadedDocs/VoucherRequest/'+(SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId)AS AttachFileURL, (SELECT Reportvalue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='AccountVoucherHTML')AS HTMLReportPageName FROM F2526VoucherDetail a WITH(nolock) WHERE a.VoucherId='VH00000418' ORDER BY a.TransNo DESC ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'TransactionId'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.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 ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 03:36:25 PM PageName: Account_AccountVoucherDetail String str: SELECT a.TransNo, a.BranchId, a.BranchName, isnull(a.VoucherType,'N/A')AS VoucherType, Convert(char,a.TransDate,106)AS TransDate, a.VoucherId, a.HeadId, a.HeadName, a.Credit, a.Debit, a.TransactionId, a.Refer1, a.Refer2, a.Refer3, a.Narration, a.EntryType, a.EntryUser, rtrim(Convert(char,a.EntryTime,106))+' - '+rtrim(Convert(char,a.EntryTime,108))AS EntryTime, CASE WHEN len((SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId))>10 THEN 'View' ELSE '' END AS AttachFile, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )+'UploadedDocs/VoucherRequest/'+(SELECT TOP 1 VoucherFile FROM AccountVoucherDetail WITH(nolock) WHERE VoucherId=a.VoucherId)AS AttachFileURL, (SELECT Reportvalue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='AccountVoucherHTML')AS HTMLReportPageName FROM F2526VoucherDetail a WITH(nolock) WHERE a.VoucherId='VH00000418' ORDER BY a.TransNo DESC ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_n4br4awl StackTrace: at Account_AccountVoucherDetail.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 01/12/2025 03:37:09 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/12/2025 04:48:57 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/1/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 04:52:01 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/1/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '103.255.106.166', '', 'Chrome', '26.8510499', '81.0029807' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/12/2025 04:59:42 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/1/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 02/12/2025 10:08:30 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/2/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 03/12/2025 10:19:48 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/3/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 04/12/2025 10:16:27 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/4/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 04/12/2025 03:28:21 PM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/4/2025 12:00:00 AM' WHERE UserLoginId='root' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'root', GETDATE(), '103.255.106.166', '', 'Chrome', '26.8510499', '81.0029807' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 05/12/2025 10:20:41 AM PageName: IntInsUpDel String str: String sql: UPDATE UserLoginDetail SET UserLoginDate=GETDATE(), UserWorkingDate='12/5/2025 12:00:00 AM' WHERE UserLoginId='superadmin' ; INSERT INTO UserLoginTime ( UserType, UserId, LoginDate, IPAddress, RemoteUser, BrowserName, Latitude, Longitude ) VALUES ( 'AdminUser', 'superadmin', GETDATE(), '103.255.106.166', '', 'Chrome', '', '' ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserType'. Invalid column name 'Latitude'. Invalid column name 'Longitude'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ClassMaster.IntInsUpDel(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action])