********************************************************** Time Of Error : 6/23/2021 11:05:49 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 LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, String cityid, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String LedgerTransactionNo, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String stateid, String proid, String frRate, String fOldGross, String fOldNet, String referlab, String policyno, String mytokenno, String IdentityCardType, String IdentityCardNo, String Height, String Weight, String AutoMailToPatient, String uhid_hosp, String ipdno_hosp, String wardno, String bedno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId, String Pensionertype, String WBSHID, String ReferDate, String Employeeno, String DispCode, String DispDept, String EmployeeStatus, String officeaddress, String Employeerelation, String IPDtype, String RefbyHospital, String LMP, String collectioncharge, String DeliveryCharge, String pansionername, String BloodGroup, String OtherReferalDoctor, String AllowOutSideContainer, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String PatientOccupatient) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabOPD.cs:line 3287 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 11:06:28 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 LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, String cityid, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String LedgerTransactionNo, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String stateid, String proid, String frRate, String fOldGross, String fOldNet, String referlab, String policyno, String mytokenno, String IdentityCardType, String IdentityCardNo, String Height, String Weight, String AutoMailToPatient, String uhid_hosp, String ipdno_hosp, String wardno, String bedno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId, String Pensionertype, String WBSHID, String ReferDate, String Employeeno, String DispCode, String DispDept, String EmployeeStatus, String officeaddress, String Employeerelation, String IPDtype, String RefbyHospital, String LMP, String collectioncharge, String DeliveryCharge, String pansionername, String BloodGroup, String OtherReferalDoctor, String AllowOutSideContainer, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String PatientOccupatient) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabOPD.cs:line 3287 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 11:06:46 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 LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, String cityid, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String LedgerTransactionNo, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String stateid, String proid, String frRate, String fOldGross, String fOldNet, String referlab, String policyno, String mytokenno, String IdentityCardType, String IdentityCardNo, String Height, String Weight, String AutoMailToPatient, String uhid_hosp, String ipdno_hosp, String wardno, String bedno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId, String Pensionertype, String WBSHID, String ReferDate, String Employeeno, String DispCode, String DispDept, String EmployeeStatus, String officeaddress, String Employeerelation, String IPDtype, String RefbyHospital, String LMP, String collectioncharge, String DeliveryCharge, String pansionername, String BloodGroup, String OtherReferalDoctor, String AllowOutSideContainer, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String PatientOccupatient) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabOPD.cs:line 3287 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 11:06:52 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 LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, String cityid, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String LedgerTransactionNo, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String stateid, String proid, String frRate, String fOldGross, String fOldNet, String referlab, String policyno, String mytokenno, String IdentityCardType, String IdentityCardNo, String Height, String Weight, String AutoMailToPatient, String uhid_hosp, String ipdno_hosp, String wardno, String bedno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId, String Pensionertype, String WBSHID, String ReferDate, String Employeeno, String DispCode, String DispDept, String EmployeeStatus, String officeaddress, String Employeerelation, String IPDtype, String RefbyHospital, String LMP, String collectioncharge, String DeliveryCharge, String pansionername, String BloodGroup, String OtherReferalDoctor, String AllowOutSideContainer, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String PatientOccupatient) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabOPD.cs:line 3287 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 11:07:36 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 LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, String cityid, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String LedgerTransactionNo, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String stateid, String proid, String frRate, String fOldGross, String fOldNet, String referlab, String policyno, String mytokenno, String IdentityCardType, String IdentityCardNo, String Height, String Weight, String AutoMailToPatient, String uhid_hosp, String ipdno_hosp, String wardno, String bedno, String ageyear, String agemonth, String ageday, String doctorType, String dispatchMode, String collectionType, String collectionBoyId, String collectionBobyName, String deliveryBoyId, String deliveryBoyName, String assistantid, String referralTypeId, String marketingAgentId, String Pensionertype, String WBSHID, String ReferDate, String Employeeno, String DispCode, String DispDept, String EmployeeStatus, String officeaddress, String Employeerelation, String IPDtype, String RefbyHospital, String LMP, String collectioncharge, String DeliveryCharge, String pansionername, String BloodGroup, String OtherReferalDoctor, String AllowOutSideContainer, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String PatientOccupatient) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\LabOPD.cs:line 3287 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 11:17:32 AM 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='5',Territory_ID='6',ZSM_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, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3895 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 11:19:34 AM 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='5',Territory_ID='6',ZSM_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, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3895 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 12:20:03 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 : 6/23/2021 1:30: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 'S DIGITAL X-RAY AN E.C.G'' 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.ExecuteScalar() at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 1013 at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 989 at StockReports.ExecuteScalar(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 644 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, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3815 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 1:31:29 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 'S SKIN LASER AND COSMETOLOGY CLINIC'' 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.ExecuteScalar() at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 1013 at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 989 at StockReports.ExecuteScalar(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 644 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, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3815 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 1:33: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: 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='5',Territory_ID='6',ZSM_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, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3895 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 1:36: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 'fullpaidpanelid='78',collectiontype='2', bde_id='5',Territory_ID='6',ZSM_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, String AadhaarCard, String PanCard) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\CreateStockMaster.cs:line 3895 Error On Machine : WIN-EHNI66M25H8 Error Machine IP Address : 172.31.36.147 ********************************************************** Time Of Error : 6/23/2021 2:46:06 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 : 6/23/2021 3:47:00 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 : 6/23/2021 3:47:04 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 : 6/23/2021 4:37:23 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 : 6/23/2021 4:37: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 : 6/23/2021 4:37:54 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 : 6/23/2021 10:10:21 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