--------------------------------------------------------------- Log Entry : 2/24/2024 7:03:34 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"TestCust","sCode":"TestCustcode","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"5645454545454545","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"a@g.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 7:04:25 PM - ------------------------------------------------------------- check customer {"iId":1,"sName":"TestCust1","sCode":"TestCustcode","sAltName":"","iCreditDays":"","fCreditAmount":0.0,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"5645454545454545","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"a@g.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 7:04:52 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"TestCust2","sCode":"TestCus2","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"6666666666666666","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"v@h.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 7:05:57 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Drivertest1","sCode":"Drivertest1","sAltName":"","iWarehouse":1,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/24/2024 9:50:58 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"TestCust","sCode":"TestCust","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"1234567899999999","sPhone":"","iType":2,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"a@gma.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 9:52:36 PM - ------------------------------------------------------------- check customer {"iId":3,"sName":"TestCust","sCode":"TestCust","sAltName":"","iCreditDays":"","fCreditAmount":0.0,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"1234567899999999","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"a@gma.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 9:58:03 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Madeena Super Market","sCode":"MSM","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"5647777856666666","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"123456","bGroup":0,"iParentId":0,"sEmail":"b@h.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 9:58:51 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Lulu Super Market","sCode":"LSM","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"2567789999999","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"234561","bGroup":0,"iParentId":0,"sEmail":"bj@h.bb","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 9:59:31 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Manama Super Market","sCode":"MSM","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"6789999999999999","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"jj@h.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 9:59:39 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Manama Super Market","sCode":"MSM1","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"6789999999999999","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"jj@h.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 10:00:19 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Nesto Super Market","sCode":"NSM2","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"9999999999999999","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"897654","bGroup":0,"iParentId":0,"sEmail":"cd@h.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/24/2024 10:01:37 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Wheat Chappathi","sCode":"WC","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":44,"Body":[]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:02:06 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Chappathi","sCode":"CH","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":44,"Body":[]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:02:29 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Porotta","sCode":"PT","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":44,"Body":[]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:02:43 PM - ------------------------------------------------------------- check Product {"iId":2,"sName":"Chappathi","sCode":"CH","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":44,"Body":[]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:03:26 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"KPL CocuntuOil","sCode":"KPL","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":4,"Body":[]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:04:14 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Sugar","sCode":"SG","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 : 2/24/2024 10:25:25 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver2","sCode":"DR2","sAltName":"","iWarehouse":1001,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/24/2024 10:25:41 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver3","sCode":"DR3","sAltName":"","iWarehouse":1001,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/24/2024 10:25:51 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver4","sCode":"DR4","sAltName":"","iWarehouse":1001,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/24/2024 10:26:02 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Driver5","sCode":"DR5","sAltName":"","iWarehouse":1001,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/24/2024 10:37:31 PM - ------------------------------------------------------------- check Product {"iId":4,"sName":"KPL CocuntuOil","sCode":"KPL","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":4,"Body":[{"iUnit":1122,"sBarcode":"787","nConversion":1000.0}]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:37:31 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) at Sang.VanSales.WebApi.Controllers.VanSalesController.PostProduct(InsProductDetails obj) ClientConnectionId:2191c688-72e2-483a-8009-a62e7c5135fa Error Number:8115,State:8,Class:16 --------------------------------------------------------------- Log Entry : 2/24/2024 10:38:05 PM - ------------------------------------------------------------- check Product {"iId":4,"sName":"KPL CocuntuOil","sCode":"KPL","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":4,"Body":[{"iUnit":1122,"sBarcode":"787","nConversion":1000.0}]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:38:05 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) at Sang.VanSales.WebApi.Controllers.VanSalesController.PostProduct(InsProductDetails obj) ClientConnectionId:1a5e0b5d-3298-4d0f-817a-290f42a31fdb Error Number:8115,State:8,Class:16 --------------------------------------------------------------- Log Entry : 2/24/2024 10:38:51 PM - ------------------------------------------------------------- check Product {"iId":4,"sName":"KPL CocuntuOil","sCode":"KPL","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":1122,"Body":[{"iUnit":4,"sBarcode":"787","nConversion":0.0001}]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:39:10 PM - ------------------------------------------------------------- check Product {"iId":4,"sName":"KPL CocuntuOil","sCode":"KPL","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":1122,"Body":[{"iUnit":4,"sBarcode":"787","nConversion":0.001}]} --------------------------------------------------------------- Log Entry : 2/24/2024 10:42:08 PM - ------------------------------------------------------------- check Product {"iId":5,"sName":"Sugar","sCode":"SG","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":[{"iUnit":1123,"sBarcode":"","nConversion":0.02}]}