**********************************************************  
 Time Of Error            : 5/19/2021 11:18:34 AM
 Error Message            : There is no row at position 0.
 Error Exeption            : 
 Error Place              :    at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
   at System.Data.RBTree`1.get_Item(Int32 index)
   at System.Data.DataRowCollection.get_Item(Int32 index)
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 114
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 1:38:57 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: Unknown column 'fpm.BlockPanelReporting' in 'field list'
   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 Design_Invoice_Test_CreditLimitNew.SearchClients(String SearchType, String Value, String PaymentMode, String ProID, String Option) in d:\Live_Code\360diagnostics\Design\Master\Test_CreditLimitNew.aspx.cs:line 109
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:13:08 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:14:36 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:15:40 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:16: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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:22:23 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:25:33 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:27:02 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 5:30:28 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:06:11 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:08:34 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:11:07 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:13:10 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:14: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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:15:50 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:19:28 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 'fullpaidpanelid='78',collectiontype='2', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:20:33 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:22:09 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:23:41 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 5/19/2021 6:25: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: 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 'fullpaidpanelid='78',collectiontype='1', bde_id='------SELECT-----',Territory_ID' 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(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, String Centre) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3891
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147