--------------------------------------------------------------- Log Entry : 2/27/2024 2:57:13 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 43 at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\ReportsController.cs:line 186 --------------------------------------------------------------- Log Entry : 2/27/2024 3:49:40 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"abc","sCode":"abc","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"6666666666666666","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"b@h.cc","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/27/2024 3:52:06 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 43 at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\ReportsController.cs:line 186 --------------------------------------------------------------- Log Entry : 2/27/2024 3:52:14 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 43 at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\ReportsController.cs:line 186 --------------------------------------------------------------- Log Entry : 2/27/2024 3:52:26 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 43 at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\ReportsController.cs:line 186 --------------------------------------------------------------- Log Entry : 2/27/2024 3:57:23 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"","sCode":"","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/27/2024 3:57:28 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"aa","sCode":"","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/27/2024 3:57:35 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"aa","sCode":"aaa","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/27/2024 4:37:56 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\ReportsController.cs:line 39 --------------------------------------------------------------- Log Entry : 2/27/2024 4:38:07 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\ReportsController.cs:line 39 --------------------------------------------------------------- Log Entry : 2/27/2024 4:41:13 PM - ------------------------------------------------------------- VanSalesController Method:PostWareHouse System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_m_Web_InsWarehouse' expects parameter '@iSalesman', which was not supplied. 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.PostWareHouse(InsWareHouseDetails obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\VanSalesController.cs:line 3000 ClientConnectionId:f5e27076-f79f-47c3-8476-bb66a2cffd80 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/27/2024 6:34:17 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"SijCus","sCode":"SijCuscode","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"5555555555555555","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"a@f.xx","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 2/27/2024 6:44:23 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Bread","sCode":"Bread","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":0,"Body":[]} --------------------------------------------------------------- Log Entry : 2/27/2024 6:45:55 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Bread","sCode":"Bread","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":1,"Body":[{"iUnit":2,"sBarcode":"","nConversion":10.0},{"iUnit":44,"sBarcode":"","nConversion":5.0}]} --------------------------------------------------------------- Log Entry : 2/27/2024 6:46:33 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Rice","sCode":"Ricecode","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 : 2/27/2024 6:48:19 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Rice","sCode":"Ricecode","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":43,"sBarcode":"","nConversion":0.25}]} --------------------------------------------------------------- Log Entry : 2/27/2024 6:51:04 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"SijDrvr","sCode":"SijDrvrcode","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/27/2024 6:52:36 PM - ------------------------------------------------------------- check customer {"iId":11,"sName":"SijDrvr","sCode":"SijDrvrcode","sAltName":"","iWarehouse":1012,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 2/27/2024 8:38:45 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.ReportsController.GetMasterReport(ReportMaster obj) in D:\Sang Solution\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\ReportsController.cs:line 247