--------------------------------------------------------------- Log Entry : 1/8/2024 10:48:49 AM - ------------------------------------------------------------- SettingsController Method:DeleteUser System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.SettingsController.DeleteUser(DeleteUser obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\SettingsController.cs:line 432 --------------------------------------------------------------- Log Entry : 1/8/2024 11:40:36 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"yathu","sCode":"12345","sAltName":"qwer","iCreditDays":"4","fCreditAmount":300.0,"sAddress":"","sCity":"kannur","sCountry":"India","sPincode":"-2","sMobile":"9857362634","sPhone":"9857362634","iType":1,"iUser":0,"sGeoLocation":"kannur","sTRN_No":"12345","bGroup":0,"iParentId":0,"sEmail":"yathuchandran67437@gmail.com","sContactPersonNo":"","sFax":"1234","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/8/2024 11:40:45 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"yathu","sCode":"12345538697","sAltName":"qwer","iCreditDays":"4","fCreditAmount":300.0,"sAddress":"","sCity":"kannur","sCountry":"India","sPincode":"-2","sMobile":"9857362634","sPhone":"9857362634","iType":1,"iUser":0,"sGeoLocation":"kannur","sTRN_No":"12345","bGroup":0,"iParentId":0,"sEmail":"yathuchandran67437@gmail.com","sContactPersonNo":"","sFax":"1234","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/8/2024 11:41:01 AM - ------------------------------------------------------------- check customer {"iId":313,"sName":"yathu","sCode":"12345538697","sAltName":"qwer","iCreditDays":"5","fCreditAmount":300.0,"sAddress":"","sCity":"kannur","sCountry":"India","sPincode":"-2","sMobile":"9857362634","sPhone":"9857362634","iType":1,"iUser":0,"sGeoLocation":"kannur","sTRN_No":"12345","bGroup":0,"iParentId":0,"sEmail":"yathuchandran67437@gmail.com","sContactPersonNo":"","sFax":"1234","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/8/2024 11:41:16 AM - ------------------------------------------------------------- check customer {"iId":313,"sName":"yathu","sCode":"12345538697","sAltName":"asdfg","iCreditDays":"5","fCreditAmount":300.0,"sAddress":"","sCity":"kannur","sCountry":"India","sPincode":"-2","sMobile":"9857362634","sPhone":"9857362634","iType":1,"iUser":0,"sGeoLocation":"kannur","sTRN_No":"12345","bGroup":0,"iParentId":0,"sEmail":"yathuchandran67437@gmail.com","sContactPersonNo":"","sFax":"1234","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/8/2024 12:00:08 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK67","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:00:12 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK67","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:00:19 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK67","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:01:28 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:02:43 PM - ------------------------------------------------------------- check customer null --------------------------------------------------------------- Log Entry : 1/8/2024 12:02:43 PM - ------------------------------------------------------------- VanSalesController Method:PostDriver System.ArgumentNullException: Value cannot be null. Parameter name: instance at System.ComponentModel.DataAnnotations.ValidationContext..ctor(Object instance, IServiceProvider serviceProvider, IDictionary`2 items) at Sang.VanSales.WebApi.General.Common.checkvalidation(Object obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\Common.cs:line 16 at Sang.VanSales.WebApi.Controllers.VanSalesController.PostDriver(InsDriverDetails obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 3619 --------------------------------------------------------------- Log Entry : 1/8/2024 12:03:15 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:03:47 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:03:47 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:03:54 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:04:05 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:04:32 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Golu","sCode":"GK","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":0,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:25:20 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"rd","sCode":"e","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:31:15 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Steephan","sCode":"ST56","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:44:56 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"SheEn Driver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:45:12 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"Sheen Driver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:45:15 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"Sheen Driver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:45:21 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"SheenDriver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:45:45 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"SheenDriver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:45:58 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":" gh","sCode":"67","sAltName":"","iWarehouse":0,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:46:06 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"SheEn Driver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:48:16 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"SheenDriver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:49:13 PM - ------------------------------------------------------------- check customer null --------------------------------------------------------------- Log Entry : 1/8/2024 12:49:13 PM - ------------------------------------------------------------- VanSalesController Method:PostDriver System.ArgumentNullException: Value cannot be null. Parameter name: instance at System.ComponentModel.DataAnnotations.ValidationContext..ctor(Object instance, IServiceProvider serviceProvider, IDictionary`2 items) at Sang.VanSales.WebApi.General.Common.checkvalidation(Object obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\Common.cs:line 16 at Sang.VanSales.WebApi.Controllers.VanSalesController.PostDriver(InsDriverDetails obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 3619 --------------------------------------------------------------- Log Entry : 1/8/2024 12:49:50 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"SheenDriver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 12:53:57 PM - ------------------------------------------------------------- check customer {"iId":7,"sName":"SheEn Driver","sCode":"SHD","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:03:15 PM - ------------------------------------------------------------- check customer {"iId":6,"sName":"Steephan","sCode":"ST56","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:05:04 PM - ------------------------------------------------------------- check customer {"iId":6,"sName":"Steephan","sCode":"ST56","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:12:34 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Chandran","sCode":"VH","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:12:47 PM - ------------------------------------------------------------- check customer {"iId":11,"sName":"Chandran","sCode":"VH67","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:15:06 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"ShEEn","sCode":"SH","sAltName":"","iWarehouse":18,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:15:28 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"BR","sCode":"BR","sAltName":"","iWarehouse":35,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:15:51 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"S!","sCode":"TY","sAltName":"","iWarehouse":14,"iUser":3,"bGroup":true,"iParentId":12} --------------------------------------------------------------- Log Entry : 1/8/2024 1:17:11 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"ghj","sCode":"673","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:18:32 PM - ------------------------------------------------------------- check customer {"iId":15,"sName":"ghj","sCode":"673","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:18:38 PM - ------------------------------------------------------------- check customer {"iId":15,"sName":"ghj","sCode":"6736","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:18:43 PM - ------------------------------------------------------------- check customer {"iId":15,"sName":"ghj","sCode":"6736","sAltName":"","iWarehouse":15,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:19:09 PM - ------------------------------------------------------------- check customer {"iId":15,"sName":"ghj","sCode":"6736","sAltName":"","iWarehouse":17,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:19:22 PM - ------------------------------------------------------------- check customer {"iId":15,"sName":"ghj","sCode":"6730","sAltName":"","iWarehouse":17,"iUser":3,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 1:26:27 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Bathool","sCode":"VL","sAltName":"","iWarehouse":19,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:17:03 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver08-01-01","sCode":"Driver08-01-01code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:21:10 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"\tDriver08-01-02","sCode":"","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:21:49 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver08-01-02","sCode":"Driver08-01-02code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:22:03 PM - ------------------------------------------------------------- check customer {"iId":19,"sName":"Driver08-01-02","sCode":"Driver08-01-02code","sAltName":"","iWarehouse":17,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:23:35 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"\tDriver08-01-03code","sCode":"\tDriver08-01-02code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:25:17 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"\tDriver08-01-02code","sCode":"\tDriver08-01-02code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:25:26 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver08-01-02code","sCode":"Driver08-01-02code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:25:36 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver08-01-02code","sCode":"Driver08-01-03code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:26:47 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver08-01-02code","sCode":"\tDriver08-01-03code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:43:58 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver08-0104","sCode":"Driver08-0104","sAltName":"","iWarehouse":14,"iUser":2,"bGroup":true,"iParentId":20} --------------------------------------------------------------- Log Entry : 1/8/2024 3:45:52 PM - ------------------------------------------------------------- check customer {"iId":19,"sName":"Driver08-01-02","sCode":"Driver08-01-01code","sAltName":"","iWarehouse":17,"iUser":2,"bGroup":false,"iParentId":22} --------------------------------------------------------------- Log Entry : 1/8/2024 3:46:10 PM - ------------------------------------------------------------- check customer {"iId":22,"sName":"Driver08-01-02code","sCode":"Driver08-01-01code","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:59:12 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"gng655","sCode":"","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:59:17 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"gng655","sCode":"mjnh666","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:59:34 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"mjnh7","sCode":"","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:59:39 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"mjnh7","sCode":"","sAltName":"","iWarehouse":14,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 3:59:46 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"mjnh7","sCode":"umhnb7","sAltName":"","iWarehouse":14,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/8/2024 4:05:40 PM - ------------------------------------------------------------- check customer {"iId":24,"sName":"gng655","sCode":"mjnh666","sAltName":"","iWarehouse":15,"iUser":2,"bGroup":true,"iParentId":25} --------------------------------------------------------------- Log Entry : 1/8/2024 4:10:24 PM - ------------------------------------------------------------- check customer {"iId":18,"sName":"Driver08-01-01","sCode":"Driver08-01-01code","sAltName":"","iWarehouse":14,"iUser":2,"bGroup":false,"iParentId":22} --------------------------------------------------------------- Log Entry : 1/8/2024 8:48:37 PM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'set'. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.VanSales.WebApi.General.ClassDB.ExecuteNonQuery(String commandText, CommandType commandType, SqlParameter[] parameters) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 98 at Sang.VanSales.WebApi.Controllers.TransactionController.SuspendAllTransactions(SuspendObjTrans obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\TransactionController.cs:line 84 ClientConnectionId:9c5e68cf-c544-4bcc-9653-4aaa949d9df7 Error Number:156,State:1,Class:15