**********************************************************  
 Time Of Error            : 8/9/2023 5:22: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: Deadlock found when trying to get lock; try restarting transaction
   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) in d:\itdose\livecode\arthdiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2798
 Error On Machine         : WIN-9TQ7CF0O89H
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 8/9/2023 8:10: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: Data too long for column 'CancelReason' at row 1
   at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
 Error Place              :    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at MembershipCard.Update_Membership(String patient_id, String Lab_no, String ID, String cardNo, String title, String Name, String Age, String gender, String address, String phone, String mobile, String email, String photoID, String membershipcardID, String membershipcardName, String validfrom, String validto, String amount, String status, String memberdetails, String validfor, String PaymentData, Double DiscAmount, Double DiscPercent, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String ItemID, String SubCategoryID, String deletePhoto, String AgeStatus, String DOB, String IsActive, String ClReason) in d:\itdose\livecode\arthdiagnostic\App_Code\MembershipCard.cs:line 209
 Error On Machine         : WIN-9TQ7CF0O89H
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 8/9/2023 8:10:59 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: Data too long for column 'CancelReason' at row 1
   at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
   at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
   at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   --- End of inner exception stack trace ---
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
 Error Place              :    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\itdose\livecode\arthdiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at MembershipCard.Update_Membership(String patient_id, String Lab_no, String ID, String cardNo, String title, String Name, String Age, String gender, String address, String phone, String mobile, String email, String photoID, String membershipcardID, String membershipcardName, String validfrom, String validto, String amount, String status, String memberdetails, String validfor, String PaymentData, Double DiscAmount, Double DiscPercent, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String ItemID, String SubCategoryID, String deletePhoto, String AgeStatus, String DOB, String IsActive, String ClReason) in d:\itdose\livecode\arthdiagnostic\App_Code\MembershipCard.cs:line 209
 Error On Machine         : WIN-9TQ7CF0O89H
 Error Machine IP Address : 192.168.2.33