--------------------------------------------------------------- Log Entry : 4/19/2024 10:20:42 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"testProduct1","sCode":"testProduct1Code","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":0,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 10:20:52 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"testProduct1","sCode":"testProduct1Code","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 11:24:09 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"testProduct3","sCode":"testProduct3code","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":0,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 11:24:15 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"testProduct3","sCode":"testProduct3code","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":0,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 11:24:23 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"testProduct3","sCode":"testProduct3code","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 11:52:14 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"product23","sCode":"45","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":19,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 3:14:11 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"s_customer1","sCode":"","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 4/19/2024 3:14:39 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"s_customer1","sCode":"","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 4/19/2024 3:14:48 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"s_customer1","sCode":"s_1","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"678903456","sPhone":"","iType":null,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 4/19/2024 3:15:00 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"s_customer1","sCode":"s_1","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"678903456","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 4/19/2024 3:15:09 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"s_customer1","sCode":"s_1","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"678903456678","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 4/19/2024 3:15:34 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"s_customer1","sCode":"s_1","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"678903456678","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"scustomer1@gmail.com","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 4/19/2024 4:04:25 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"s_salesman1","sCode":"s1","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 4/19/2024 4:38:16 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"s_product1","sCode":"s1","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":0,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 4:38:35 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"s_product1","sCode":"s1","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 4:42:41 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"s_product2","sCode":"s2","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[{"iUnit":3,"sBarcode":"","nConversion":1000.0},{"iUnit":7,"sBarcode":"","nConversion":5.0}]} --------------------------------------------------------------- Log Entry : 4/19/2024 4:42:42 PM - ------------------------------------------------------------- VanSalesController Method:PostProduct System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting numeric to data type numeric. The data for table-valued parameter "@t_type_ProductUnit" doesn't conform to the table type of the parameter. SQL Server error is: 8115, state: 8 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) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 73 at Sang.VanSales.WebApi.Controllers.VanSalesController.PostProduct(InsProductDetails obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 2468 ClientConnectionId:4e54fa33-7251-4964-bdc7-97bc184b7385 Error Number:8115,State:8,Class:16 --------------------------------------------------------------- Log Entry : 4/19/2024 4:43:12 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"s_product2","sCode":"s2","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[{"iUnit":3,"sBarcode":"","nConversion":1000.0},{"iUnit":7,"sBarcode":"","nConversion":5.0}]} --------------------------------------------------------------- Log Entry : 4/19/2024 4:43:12 PM - ------------------------------------------------------------- VanSalesController Method:PostProduct System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting numeric to data type numeric. The data for table-valued parameter "@t_type_ProductUnit" doesn't conform to the table type of the parameter. SQL Server error is: 8115, state: 8 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) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 73 at Sang.VanSales.WebApi.Controllers.VanSalesController.PostProduct(InsProductDetails obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 2468 ClientConnectionId:4e54fa33-7251-4964-bdc7-97bc184b7385 Error Number:8115,State:8,Class:16 --------------------------------------------------------------- Log Entry : 4/19/2024 4:57:51 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"s_product3","sCode":"112","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 4/19/2024 4:58:52 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"s_productgroup1","sCode":"1122","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":1,"iParentId":0,"sBarcode":"","iBaseUnit":2,"Body":[]}