--------------------------------------------------------------- Log Entry : 5/27/2024 11:32:06 AM - ------------------------------------------------------------- check Product {"iId":1081,"sName":"sofa","sCode":"567","sAltName":"","iType":2,"fVatPer":2.00,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":15,"Body":[]} --------------------------------------------------------------- Log Entry : 5/27/2024 11:32:22 AM - ------------------------------------------------------------- check Product {"iId":1081,"sName":"sofa","sCode":"567","sAltName":"","iType":2,"fVatPer":2.0,"fTaxper":3.00,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":15,"Body":[]} --------------------------------------------------------------- Log Entry : 5/27/2024 11:55:26 AM - ------------------------------------------------------------- TransactionController Method:PostSales System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'sDocNo', table '@t_type_Sales'; column does not allow nulls. INSERT fails. The data for table-valued parameter "@t_type_Sales" doesn't conform to the table type of the parameter. SQL Server error is: 515, state: 2 The statement has been terminated. 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.VanSales.WebApi.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.PostSales(Sales obj) ClientConnectionId:f006cedd-1b4f-4502-bad4-7afc05134724 Error Number:515,State:2,Class:16 --------------------------------------------------------------- Log Entry : 5/27/2024 11:56:08 AM - ------------------------------------------------------------- TransactionController Method:PostSales System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'sDocNo', table '@t_type_Sales'; column does not allow nulls. INSERT fails. The data for table-valued parameter "@t_type_Sales" doesn't conform to the table type of the parameter. SQL Server error is: 515, state: 2 The statement has been terminated. 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.VanSales.WebApi.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.PostSales(Sales obj) ClientConnectionId:18f6be92-cf9c-4037-a994-ef91f34642d4 Error Number:515,State:2,Class:16 --------------------------------------------------------------- Log Entry : 5/27/2024 12:37:43 PM - ------------------------------------------------------------- check Product {"iId":1072,"sName":"Sugar","sCode":"sugar_code","sAltName":"","iType":2,"fVatPer":4.00,"fTaxper":5.00,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 5/27/2024 12:38:55 PM - ------------------------------------------------------------- check Product {"iId":2,"sName":"Pdct1","sCode":"Pdct1code","sAltName":"","iType":2,"fVatPer":5.00,"fTaxper":9.00,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":1,"iParentId":1,"sBarcode":"","iBaseUnit":1,"Body":[{"iUnit":2,"sBarcode":"","nConversion":3.0}]} --------------------------------------------------------------- Log Entry : 5/27/2024 4:02:38 PM - ------------------------------------------------------------- TransactionController Method:PostSales System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.TransactionController.PostSales(Sales obj) --------------------------------------------------------------- Log Entry : 5/27/2024 4:04:01 PM - ------------------------------------------------------------- TransactionController Method:PostSales System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.TransactionController.PostSales(Sales obj)