********************************************************** Time Of Error : 02-03-2022 10:58:04 Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\Itdose\Naokon\App_Code\DataLinkLayer\Centre.cs:line 20 at Design_Welcome.LoadData() in d:\Itdose\Naokon\Design\Welcome.aspx.cs:line 287 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:39:00 Error Message : The given path's format is not supported. Error Exeption : Error Place : at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, AccessControlActions control, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents) at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Itdose\Naokon\Design\Lab\Services\PatientLabSearch.asmx:line 1173 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:39:02 Error Message : The given path's format is not supported. Error Exeption : Error Place : at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, AccessControlActions control, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents) at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Itdose\Naokon\Design\Lab\Services\PatientLabSearch.asmx:line 1173 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:39:08 Error Message : The given path's format is not supported. Error Exeption : Error Place : at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, AccessControlActions control, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents) at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Itdose\Naokon\Design\Lab\Services\PatientLabSearch.asmx:line 1173 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:39:18 Error Message : The given path's format is not supported. Error Exeption : Error Place : at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, AccessControlActions control, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents) at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Itdose\Naokon\Design\Lab\Services\PatientLabSearch.asmx:line 1173 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:39:18 Error Message : The given path's format is not supported. Error Exeption : Error Place : at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, AccessControlActions control, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents) at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Itdose\Naokon\Design\Lab\Services\PatientLabSearch.asmx:line 1173 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:39:22 Error Message : The given path's format is not supported. Error Exeption : Error Place : at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, AccessControlActions control, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents) at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Itdose\Naokon\Design\Lab\Services\PatientLabSearch.asmx:line 1173 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:39:28 Error Message : The given path's format is not supported. Error Exeption : Error Place : at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath) at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath) at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList) at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, AccessControlActions control, String[] pathList, Boolean checkForDuplicates, Boolean needFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents, Encoding encoding) at System.IO.File.WriteAllText(String path, String contents) at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Itdose\Naokon\Design\Lab\Services\PatientLabSearch.asmx:line 1173 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:50:44 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: Incorrect integer value: '' for column 'assistantId' 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\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Itdose\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at LabOPD.LabPrescriptionOPD(String collectiondate, String barcodeNo, String myAppNumber, String myAppDate, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String stateid, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String mobileappno, String policyno, String mrpbooking, String pagetype, 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 disctype1, String ToutNo, String RandomNo, String AuthCode, 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 BloodGroup, String collectioncharge, String DeliveryCharge, String pansionername, String AllowOutSideContainer, String OtherReferalDoctor, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String patientoccupatient) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2136 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:50:56 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: Incorrect integer value: '' for column 'assistantId' 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\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Itdose\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at LabOPD.LabPrescriptionOPD(String collectiondate, String barcodeNo, String myAppNumber, String myAppDate, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String stateid, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String mobileappno, String policyno, String mrpbooking, String pagetype, 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 disctype1, String ToutNo, String RandomNo, String AuthCode, 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 BloodGroup, String collectioncharge, String DeliveryCharge, String pansionername, String AllowOutSideContainer, String OtherReferalDoctor, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String patientoccupatient) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2136 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:51:21 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: Incorrect integer value: '' for column 'assistantId' 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\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Itdose\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at LabOPD.LabPrescriptionOPD(String collectiondate, String barcodeNo, String myAppNumber, String myAppDate, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String stateid, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String mobileappno, String policyno, String mrpbooking, String pagetype, 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 disctype1, String ToutNo, String RandomNo, String AuthCode, 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 BloodGroup, String collectioncharge, String DeliveryCharge, String pansionername, String AllowOutSideContainer, String OtherReferalDoctor, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String patientoccupatient) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2136 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:52:39 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: Incorrect integer value: '' for column 'assistantId' 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\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Itdose\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at LabOPD.LabPrescriptionOPD(String collectiondate, String barcodeNo, String myAppNumber, String myAppDate, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String stateid, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String mobileappno, String policyno, String mrpbooking, String pagetype, 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 disctype1, String ToutNo, String RandomNo, String AuthCode, 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 BloodGroup, String collectioncharge, String DeliveryCharge, String pansionername, String AllowOutSideContainer, String OtherReferalDoctor, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String patientoccupatient) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2136 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100 ********************************************************** Time Of Error : 02-03-2022 11:53:15 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: Incorrect integer value: '' for column 'assistantId' 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\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 324 at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Itdose\Naokon\App_Code\DataLinkLayer\ODBCHelper.cs:line 300 at LabOPD.LabPrescriptionOPD(String collectiondate, String barcodeNo, String myAppNumber, String myAppDate, 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 CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String stateid, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile, String mobileappno, String policyno, String mrpbooking, String pagetype, 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 disctype1, String ToutNo, String RandomNo, String AuthCode, 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 BloodGroup, String collectioncharge, String DeliveryCharge, String pansionername, String AllowOutSideContainer, String OtherReferalDoctor, String OutSideSample, Int32 IsHomeDelivery, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String patientoccupatient) in d:\Itdose\Naokon\App_Code\BuisnessLogic\LabOPD.cs:line 2136 Error On Machine : NAOKON-SRV Error Machine IP Address : 10.0.0.100