--------------------------------------------------------------- Log Entry : 1/12/2024 10:29:19 AM - ------------------------------------------------------------- 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:1d9d1567-f47b-4f9c-ab1b-d4ed7fef1144 Error Number:156,State:1,Class:15 --------------------------------------------------------------- Log Entry : 1/12/2024 10:59:03 AM - ------------------------------------------------------------- check customer {"iId":312,"sName":"CutomerNewCutomerNewCutomerNewCutomerNewCutomerNewCutomerNewCutomerNewCutomerNewCutomerNewCutomerNew","sCode":"120034567","sAltName":"","iCreditDays":"","fCreditAmount":0.0,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"9897654321","sPhone":"","iType":1,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"cutsmer@gmail.com","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/12/2024 11:10:48 AM - ------------------------------------------------------------- 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:62cefd7a-4d40-48f4-ba0d-9f30c931ccaa Error Number:156,State:1,Class:15 --------------------------------------------------------------- Log Entry : 1/12/2024 3:43:52 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"driver1201","sCode":"driver1201code","sAltName":"","iWarehouse":13,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/12/2024 3:45:20 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"driver1201","sCode":"driver1201code1","sAltName":"","iWarehouse":13,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/12/2024 3:46:09 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"drvr1201","sCode":"drvr1201code","sAltName":"","iWarehouse":13,"iUser":2,"bGroup":false,"iParentId":1023} --------------------------------------------------------------- Log Entry : 1/12/2024 4:03:37 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"driver1201","sCode":"driver120131","sAltName":"","iWarehouse":14,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/12/2024 4:19:51 PM - ------------------------------------------------------------- VanSalesController Method:DeleteCustomer System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.VanSalesController.DeleteCustomer(DeleteObj obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 936 --------------------------------------------------------------- Log Entry : 1/12/2024 4:20:18 PM - ------------------------------------------------------------- VanSalesController Method:DeleteCustomer System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.VanSalesController.DeleteCustomer(DeleteObj obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 936 --------------------------------------------------------------- Log Entry : 1/12/2024 4:20:37 PM - ------------------------------------------------------------- VanSalesController Method:DeleteCustomer System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.VanSalesController.DeleteCustomer(DeleteObj obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 936 --------------------------------------------------------------- Log Entry : 1/12/2024 4:21:01 PM - ------------------------------------------------------------- VanSalesController Method:DeleteCustomer System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.VanSalesController.DeleteCustomer(DeleteObj obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 936