**********************************************************  
 Time Of Error            : 06-08-2015 12:38:40
 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 truncated for column 'Rate' at row 123
   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\ITDOSELIS\ITDOSELIS\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\ItDose\ITDOSELIS\ITDOSELIS\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Design_EDP_ImportToDatabase.btnSave_Click(Object sender, EventArgs e) in d:\ItDose\ITDOSELIS\ITDOSELIS\Design\EDP\ImportToDatabase.aspx.cs:line 161
 Error On Machine         : LIS-PC
 Error Machine IP Address : 192.168.2.27


  **********************************************************  
 Time Of Error            : 06-08-2015 12:44:22
 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 truncated for column 'Rate' at row 123
   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\ITDOSELIS\ITDOSELIS\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\ItDose\ITDOSELIS\ITDOSELIS\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Design_EDP_ImportToDatabase.btnSave_Click(Object sender, EventArgs e) in d:\ItDose\ITDOSELIS\ITDOSELIS\Design\EDP\ImportToDatabase.aspx.cs:line 161
 Error On Machine         : LIS-PC
 Error Machine IP Address : 192.168.2.27


  **********************************************************  
 Time Of Error            : 06-08-2015 17:06:46
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Patient_Master.Insert() in d:\ItDose\ITDOSELIS\ITDOSELIS\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) in d:\ItDose\ITDOSELIS\ITDOSELIS\App_Code\BuisnessLogic\LabOPD.cs:line 1403
 Error On Machine         : LIS-PC
 Error Machine IP Address : 192.168.2.27


  **********************************************************  
 Time Of Error            : 06-08-2015 17:36:03
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Patient_Master.Insert() in d:\ItDose\ITDOSELIS\ITDOSELIS\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) in d:\ItDose\ITDOSELIS\ITDOSELIS\App_Code\BuisnessLogic\LabOPD.cs:line 1403
 Error On Machine         : LIS-PC
 Error Machine IP Address : 192.168.2.27


  **********************************************************  
 Time Of Error            : 06-08-2015 17:37:56
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Patient_Master.Insert() in d:\ItDose\ITDOSELIS\ITDOSELIS\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) in d:\ItDose\ITDOSELIS\ITDOSELIS\App_Code\BuisnessLogic\LabOPD.cs:line 1403
 Error On Machine         : LIS-PC
 Error Machine IP Address : 192.168.2.27


  **********************************************************  
 Time Of Error            : 06-08-2015 17:38:17
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Patient_Master.Insert() in d:\ItDose\ITDOSELIS\ITDOSELIS\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) in d:\ItDose\ITDOSELIS\ITDOSELIS\App_Code\BuisnessLogic\LabOPD.cs:line 1403
 Error On Machine         : LIS-PC
 Error Machine IP Address : 192.168.2.27