********************************************************** Time Of Error : 7/3/2021 10:43:53 AM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 12:25:54 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 12:26:43 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 12:28:19 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 12:33:51 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:00:19 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 247 at MySqlHelper.ExecuteNonQuery(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 223 at LabResultEntry.SaveResultText(String content, String ID, String TestID, String Approved) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabResultEntry.cs:line 747 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:00:35 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 247 at MySqlHelper.ExecuteNonQuery(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 223 at LabResultEntry.SaveResultText(String content, String ID, String TestID, String Approved) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabResultEntry.cs:line 747 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:00:43 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 247 at MySqlHelper.ExecuteNonQuery(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 223 at LabResultEntry.SaveResultText(String content, String ID, String TestID, String Approved) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabResultEntry.cs:line 747 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:01:24 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:02:06 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:10:50 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:10:50 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:58:55 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' inner join investigation_master im on pli.Investigation_ID = im.Investigation' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 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 MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 488 at MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 460 at StockReports.GetDataTable(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 566 at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Live_Code\360diagnostics\Design\Lab\Services\PatientLabSearch.asmx:line 1174 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 1:58:55 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' inner join investigation_master im on pli.Investigation_ID = im.Investigation' at line 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) 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 MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 488 at MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 460 at StockReports.GetDataTable(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 566 at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Live_Code\360diagnostics\Design\Lab\Services\PatientLabSearch.asmx:line 1174 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 2:17:32 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 2:18:04 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 3:01:41 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 3:07:05 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'MinBalReceive' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at StockReports.ExecuteDML(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 598 at CreateStockMaster.SavePanelMaster(String CompanyName, String Addr1, String Addr2, String HospitalCode, String PanelCode, String IsTPA, String Email, String Phone, String Mobile, String ContactPerson, String Fax, String RefCodeOPD, String RefCodeIPD, String Agreement, String isServiceTax, String DateFrom, String DateTo, String CreditLimit, String PanelGroupID, String PaymentMode, String PanelUserID, String PanelPassword, String SpecialityDoctor, String CompanyType, String ServiceProvider, String SalesHead, String MarketingPerson, String FieldBoy, String contractdate, String ContractPeriod, String ContractMonth, String TaxPercentage, String IsActive, String PROId, String ReportDispatchMode, String PrintAtCentre, String IsLock, String printinlab, String mincash, String fullpaidpanel, String showheaderinreceipt, String showmrpinreceipt, String colltype, String state, String city, String area, String territory, String asm, String bde, String zsm, String HideRate, String isfullpaidreceipt, String HideDiscount, String HideDoctorDiscount, String allowshare, String Invoicepanelid, String InvoiceType, Int32 AllowTout, String MinValue, String MaxValue, String DueReport, String SeniorCitizenDisc, String OutSideContainer, String OutSideSample, String CommisionType, Int32 IsFranchise, Int32 IsPrepaid, String Centre, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3896 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 3:20:24 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 3:46:19 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 6:13:44 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 6:44:48 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'MinBalReceive' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at StockReports.ExecuteDML(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 598 at CreateStockMaster.SavePanelMaster(String CompanyName, String Addr1, String Addr2, String HospitalCode, String PanelCode, String IsTPA, String Email, String Phone, String Mobile, String ContactPerson, String Fax, String RefCodeOPD, String RefCodeIPD, String Agreement, String isServiceTax, String DateFrom, String DateTo, String CreditLimit, String PanelGroupID, String PaymentMode, String PanelUserID, String PanelPassword, String SpecialityDoctor, String CompanyType, String ServiceProvider, String SalesHead, String MarketingPerson, String FieldBoy, String contractdate, String ContractPeriod, String ContractMonth, String TaxPercentage, String IsActive, String PROId, String ReportDispatchMode, String PrintAtCentre, String IsLock, String printinlab, String mincash, String fullpaidpanel, String showheaderinreceipt, String showmrpinreceipt, String colltype, String state, String city, String area, String territory, String asm, String bde, String zsm, String HideRate, String isfullpaidreceipt, String HideDiscount, String HideDoctorDiscount, String allowshare, String Invoicepanelid, String InvoiceType, Int32 AllowTout, String MinValue, String MaxValue, String DueReport, String SeniorCitizenDisc, String OutSideContainer, String OutSideSample, String CommisionType, Int32 IsFranchise, Int32 IsPrepaid, String Centre, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3896 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 6:46:53 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 6:52:46 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'MinBalReceive' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at StockReports.ExecuteDML(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 598 at CreateStockMaster.SavePanelMaster(String CompanyName, String Addr1, String Addr2, String HospitalCode, String PanelCode, String IsTPA, String Email, String Phone, String Mobile, String ContactPerson, String Fax, String RefCodeOPD, String RefCodeIPD, String Agreement, String isServiceTax, String DateFrom, String DateTo, String CreditLimit, String PanelGroupID, String PaymentMode, String PanelUserID, String PanelPassword, String SpecialityDoctor, String CompanyType, String ServiceProvider, String SalesHead, String MarketingPerson, String FieldBoy, String contractdate, String ContractPeriod, String ContractMonth, String TaxPercentage, String IsActive, String PROId, String ReportDispatchMode, String PrintAtCentre, String IsLock, String printinlab, String mincash, String fullpaidpanel, String showheaderinreceipt, String showmrpinreceipt, String colltype, String state, String city, String area, String territory, String asm, String bde, String zsm, String HideRate, String isfullpaidreceipt, String HideDiscount, String HideDoctorDiscount, String allowshare, String Invoicepanelid, String InvoiceType, Int32 AllowTout, String MinValue, String MaxValue, String DueReport, String SeniorCitizenDisc, String OutSideContainer, String OutSideSample, String CommisionType, Int32 IsFranchise, Int32 IsPrepaid, String Centre, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3896 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 6:54:26 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'MinBalReceive' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at StockReports.ExecuteDML(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 598 at CreateStockMaster.SavePanelMaster(String CompanyName, String Addr1, String Addr2, String HospitalCode, String PanelCode, String IsTPA, String Email, String Phone, String Mobile, String ContactPerson, String Fax, String RefCodeOPD, String RefCodeIPD, String Agreement, String isServiceTax, String DateFrom, String DateTo, String CreditLimit, String PanelGroupID, String PaymentMode, String PanelUserID, String PanelPassword, String SpecialityDoctor, String CompanyType, String ServiceProvider, String SalesHead, String MarketingPerson, String FieldBoy, String contractdate, String ContractPeriod, String ContractMonth, String TaxPercentage, String IsActive, String PROId, String ReportDispatchMode, String PrintAtCentre, String IsLock, String printinlab, String mincash, String fullpaidpanel, String showheaderinreceipt, String showmrpinreceipt, String colltype, String state, String city, String area, String territory, String asm, String bde, String zsm, String HideRate, String isfullpaidreceipt, String HideDiscount, String HideDoctorDiscount, String allowshare, String Invoicepanelid, String InvoiceType, Int32 AllowTout, String MinValue, String MaxValue, String DueReport, String SeniorCitizenDisc, String OutSideContainer, String OutSideSample, String CommisionType, Int32 IsFranchise, Int32 IsPrepaid, String Centre, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3896 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 7:00:42 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'MinBalReceive' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at StockReports.ExecuteDML(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 598 at CreateStockMaster.SavePanelMaster(String CompanyName, String Addr1, String Addr2, String HospitalCode, String PanelCode, String IsTPA, String Email, String Phone, String Mobile, String ContactPerson, String Fax, String RefCodeOPD, String RefCodeIPD, String Agreement, String isServiceTax, String DateFrom, String DateTo, String CreditLimit, String PanelGroupID, String PaymentMode, String PanelUserID, String PanelPassword, String SpecialityDoctor, String CompanyType, String ServiceProvider, String SalesHead, String MarketingPerson, String FieldBoy, String contractdate, String ContractPeriod, String ContractMonth, String TaxPercentage, String IsActive, String PROId, String ReportDispatchMode, String PrintAtCentre, String IsLock, String printinlab, String mincash, String fullpaidpanel, String showheaderinreceipt, String showmrpinreceipt, String colltype, String state, String city, String area, String territory, String asm, String bde, String zsm, String HideRate, String isfullpaidreceipt, String HideDiscount, String HideDoctorDiscount, String allowshare, String Invoicepanelid, String InvoiceType, Int32 AllowTout, String MinValue, String MaxValue, String DueReport, String SeniorCitizenDisc, String OutSideContainer, String OutSideSample, String CommisionType, Int32 IsFranchise, Int32 IsPrepaid, String Centre, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3896 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 7:05:47 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 7:06:05 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 7:44:31 PM Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Incorrect integer value: '' for column 'CentreID' at row 1 at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Settelment.cs:line 504 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 7/3/2021 8:02:49 PM Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 286 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147