********************************************************** Time Of Error : 7/20/2024 9:04:41 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 's friend ',UpdateID='LSHHI192',UpdateName='khushbu choubisa',UpdateRemarks='Edit' 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 LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_ShowFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2276 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 7/20/2024 9:05:33 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 's friend ',UpdateID='LSHHI192',UpdateName='khushbu choubisa',UpdateRemarks='Rece' 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 LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, 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 proid, String frRate, String fOldGross, String fOldNet, String referlab, String couponcode) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2818 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 7/20/2024 9:21:04 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 's friend so 20% less',UpdateID='LSHHI192',UpdateName='khushbu choubisa',UpdateRe' 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 LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_ShowFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2276 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 7/20/2024 9:22:45 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 's friend so 20% less',UpdateID='LSHHI192',UpdateName='khushbu choubisa',UpdateRe' 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 LabOPD.LabPrescriptionOPDEdit(String PatientID, String Title, String PName, String Gender, String House_No, String City, 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 proid, String frRate, String fOldGross, String fOldNet, String referlab, String couponcode) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2818 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 7/20/2024 10:02:14 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: Data too long for column 'Pname' at row 281 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 Patient_Master.Insert() in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\Patient_Master.cs:line 787 at LabOPD.LabPrescriptionOPD(String barcodeNo, String myAppNumber, String myAppDate, String PatientID, String Title, String PName, String Gender, String House_No, String City, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String AppID, String Couponcode) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 1424 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 7/20/2024 10:02:30 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: Data too long for column 'Pname' at row 281 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 Patient_Master.Insert() in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\Patient_Master.cs:line 787 at LabOPD.LabPrescriptionOPD(String barcodeNo, String myAppNumber, String myAppDate, String PatientID, String Title, String PName, String Gender, String House_No, String City, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String AppID, String Couponcode) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 1424 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 7/20/2024 10:02:44 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: Data too long for column 'Pname' at row 281 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 Patient_Master.Insert() in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\Patient_Master.cs:line 787 at LabOPD.LabPrescriptionOPD(String barcodeNo, String myAppNumber, String myAppDate, String PatientID, String Title, String PName, String Gender, String House_No, String City, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String AppID, String Couponcode) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 1424 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33 ********************************************************** Time Of Error : 7/20/2024 5:25:13 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: Duplicate entry '012400058271' for key 'PRIMARY' at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at Receipt.Insert() in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\Receipt.cs:line 767 at Settelment.SavePendingReceipt(String HOSPID, String PanelID, Single Amount, DateTime PaidDate, DateTime PaidTime, String userId, String LedgerTranNo, String PatientID, String TransactionID, String PaidBy, String PaymentMode, String CreditCardNo, String Bank, String Naration, String Date, String PatientLedgerNo, String HospitalLedgerNo, String Type, String OldReceiptNo, String UniqueHash, Double TDS_PER, Double TDS_AMT, Double WriteOff, MySqlTransaction tranX) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\Settelment.cs:line 498 Error On Machine : WIN-9TQ7CF0O89H Error Machine IP Address : 192.168.2.33