//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated by a tool.
//     Runtime Version:4.0.30319.42000
//
//     Changes to this file may cause incorrect behavior and will be lost if
//     the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

#pragma warning disable 1591

namespace OccuCare.Report.Datasets.ClinicalInformation.Examination {
    
    
    /// <summary>
    ///Represents a strongly typed in-memory cache of data.
    ///</summary>
    [global::System.Serializable()]
    [global::System.ComponentModel.DesignerCategoryAttribute("code")]
    [global::System.ComponentModel.ToolboxItem(true)]
    [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
    [global::System.Xml.Serialization.XmlRootAttribute("OPDPrescriptionListWithBatchNExpiry")]
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
    public partial class OPDPrescriptionListWithBatchNExpiry : global::System.Data.DataSet {
        
        private pRptOPDPrescriptionListWithBatchNExpiryDataTable tablepRptOPDPrescriptionListWithBatchNExpiry;
        
        private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public OPDPrescriptionListWithBatchNExpiry() {
            this.BeginInit();
            this.InitClass();
            global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
            base.Tables.CollectionChanged += schemaChangedHandler;
            base.Relations.CollectionChanged += schemaChangedHandler;
            this.EndInit();
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected OPDPrescriptionListWithBatchNExpiry(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : 
                base(info, context, false) {
            if ((this.IsBinarySerialized(info, context) == true)) {
                this.InitVars(false);
                global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
                this.Tables.CollectionChanged += schemaChangedHandler1;
                this.Relations.CollectionChanged += schemaChangedHandler1;
                return;
            }
            string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
            if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
                global::System.Data.DataSet ds = new global::System.Data.DataSet();
                ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
                if ((ds.Tables["pRptOPDPrescriptionListWithBatchNExpiry"] != null)) {
                    base.Tables.Add(new pRptOPDPrescriptionListWithBatchNExpiryDataTable(ds.Tables["pRptOPDPrescriptionListWithBatchNExpiry"]));
                }
                this.DataSetName = ds.DataSetName;
                this.Prefix = ds.Prefix;
                this.Namespace = ds.Namespace;
                this.Locale = ds.Locale;
                this.CaseSensitive = ds.CaseSensitive;
                this.EnforceConstraints = ds.EnforceConstraints;
                this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
                this.InitVars();
            }
            else {
                this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
            }
            this.GetSerializationData(info, context);
            global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
            base.Tables.CollectionChanged += schemaChangedHandler;
            this.Relations.CollectionChanged += schemaChangedHandler;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.Browsable(false)]
        [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
        public pRptOPDPrescriptionListWithBatchNExpiryDataTable pRptOPDPrescriptionListWithBatchNExpiry {
            get {
                return this.tablepRptOPDPrescriptionListWithBatchNExpiry;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.BrowsableAttribute(true)]
        [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
        public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
            get {
                return this._schemaSerializationMode;
            }
            set {
                this._schemaSerializationMode = value;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public new global::System.Data.DataTableCollection Tables {
            get {
                return base.Tables;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
        public new global::System.Data.DataRelationCollection Relations {
            get {
                return base.Relations;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected override void InitializeDerivedDataSet() {
            this.BeginInit();
            this.InitClass();
            this.EndInit();
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public override global::System.Data.DataSet Clone() {
            OPDPrescriptionListWithBatchNExpiry cln = ((OPDPrescriptionListWithBatchNExpiry)(base.Clone()));
            cln.InitVars();
            cln.SchemaSerializationMode = this.SchemaSerializationMode;
            return cln;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected override bool ShouldSerializeTables() {
            return false;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected override bool ShouldSerializeRelations() {
            return false;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
            if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
                this.Reset();
                global::System.Data.DataSet ds = new global::System.Data.DataSet();
                ds.ReadXml(reader);
                if ((ds.Tables["pRptOPDPrescriptionListWithBatchNExpiry"] != null)) {
                    base.Tables.Add(new pRptOPDPrescriptionListWithBatchNExpiryDataTable(ds.Tables["pRptOPDPrescriptionListWithBatchNExpiry"]));
                }
                this.DataSetName = ds.DataSetName;
                this.Prefix = ds.Prefix;
                this.Namespace = ds.Namespace;
                this.Locale = ds.Locale;
                this.CaseSensitive = ds.CaseSensitive;
                this.EnforceConstraints = ds.EnforceConstraints;
                this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
                this.InitVars();
            }
            else {
                this.ReadXml(reader);
                this.InitVars();
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
            global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
            this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
            stream.Position = 0;
            return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        internal void InitVars() {
            this.InitVars(true);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        internal void InitVars(bool initTable) {
            this.tablepRptOPDPrescriptionListWithBatchNExpiry = ((pRptOPDPrescriptionListWithBatchNExpiryDataTable)(base.Tables["pRptOPDPrescriptionListWithBatchNExpiry"]));
            if ((initTable == true)) {
                if ((this.tablepRptOPDPrescriptionListWithBatchNExpiry != null)) {
                    this.tablepRptOPDPrescriptionListWithBatchNExpiry.InitVars();
                }
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private void InitClass() {
            this.DataSetName = "OPDPrescriptionListWithBatchNExpiry";
            this.Prefix = "";
            this.Namespace = "http://tempuri.org/OPDPrescriptionListWithBatchNExpiry.xsd";
            this.EnforceConstraints = true;
            this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
            this.tablepRptOPDPrescriptionListWithBatchNExpiry = new pRptOPDPrescriptionListWithBatchNExpiryDataTable();
            base.Tables.Add(this.tablepRptOPDPrescriptionListWithBatchNExpiry);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private bool ShouldSerializepRptOPDPrescriptionListWithBatchNExpiry() {
            return false;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
            if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
                this.InitVars();
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
            OPDPrescriptionListWithBatchNExpiry ds = new OPDPrescriptionListWithBatchNExpiry();
            global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
            global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
            global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
            any.Namespace = ds.Namespace;
            sequence.Items.Add(any);
            type.Particle = sequence;
            global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
            if (xs.Contains(dsSchema.TargetNamespace)) {
                global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
                global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
                try {
                    global::System.Xml.Schema.XmlSchema schema = null;
                    dsSchema.Write(s1);
                    for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
                        schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
                        s2.SetLength(0);
                        schema.Write(s2);
                        if ((s1.Length == s2.Length)) {
                            s1.Position = 0;
                            s2.Position = 0;
                            for (; ((s1.Position != s1.Length) 
                                        && (s1.ReadByte() == s2.ReadByte())); ) {
                                ;
                            }
                            if ((s1.Position == s1.Length)) {
                                return type;
                            }
                        }
                    }
                }
                finally {
                    if ((s1 != null)) {
                        s1.Close();
                    }
                    if ((s2 != null)) {
                        s2.Close();
                    }
                }
            }
            xs.Add(dsSchema);
            return type;
        }
        
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public delegate void pRptOPDPrescriptionListWithBatchNExpiryRowChangeEventHandler(object sender, pRptOPDPrescriptionListWithBatchNExpiryRowChangeEvent e);
        
        /// <summary>
        ///Represents the strongly named DataTable class.
        ///</summary>
        [global::System.Serializable()]
        [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
        public partial class pRptOPDPrescriptionListWithBatchNExpiryDataTable : global::System.Data.TypedTableBase<pRptOPDPrescriptionListWithBatchNExpiryRow> {
            
            private global::System.Data.DataColumn columnExaminationId;
            
            private global::System.Data.DataColumn columnprescriptionId;
            
            private global::System.Data.DataColumn columnParticipantCode;
            
            private global::System.Data.DataColumn columnParticipantName;
            
            private global::System.Data.DataColumn columnPatientCategory;
            
            private global::System.Data.DataColumn columnGender;
            
            private global::System.Data.DataColumn columnExaminationDate;
            
            private global::System.Data.DataColumn columnOPDOutTime;
            
            private global::System.Data.DataColumn columnBatchNo;
            
            private global::System.Data.DataColumn columnAge;
            
            private global::System.Data.DataColumn columnPulse;
            
            private global::System.Data.DataColumn columnTemperature;
            
            private global::System.Data.DataColumn columnBloodPressureSystolic;
            
            private global::System.Data.DataColumn columnBloodPressureDiastolic;
            
            private global::System.Data.DataColumn columnContactPerson;
            
            private global::System.Data.DataColumn columnOutsideMedicine;
            
            private global::System.Data.DataColumn columnOutsideTest;
            
            private global::System.Data.DataColumn columnDiagnosis;
            
            private global::System.Data.DataColumn columnproblems;
            
            private global::System.Data.DataColumn columnDrugInstruction;
            
            private global::System.Data.DataColumn columnMedicines;
            
            private global::System.Data.DataColumn columnMedicineQty;
            
            private global::System.Data.DataColumn columnDispensedQuantity;
            
            private global::System.Data.DataColumn columnDuration;
            
            private global::System.Data.DataColumn columnPrescribedQuantity;
            
            private global::System.Data.DataColumn columnParticipantSourceId;
            
            private global::System.Data.DataColumn columnStockId;
            
            private global::System.Data.DataColumn columnDrawSize;
            
            private global::System.Data.DataColumn columnMedicineDosage;
            
            private global::System.Data.DataColumn columnRemainingQty;
            
            private global::System.Data.DataColumn columnRefferedName;
            
            private global::System.Data.DataColumn columnMedicalRegistrationNo;
            
            private global::System.Data.DataColumn columnExaminationNumber;
            
            private global::System.Data.DataColumn columnCauseTitle;
            
            private global::System.Data.DataColumn columnDepartmentName;
            
            private global::System.Data.DataColumn columnDoctorSignature;
            
            private global::System.Data.DataColumn columnLogo;
            
            private global::System.Data.DataColumn columnSmallAddress1;
            
            private global::System.Data.DataColumn columnSmallAddress2;
            
            private global::System.Data.DataColumn columnCompanyName;
            
            private global::System.Data.DataColumn columnAdvice;
            
            private global::System.Data.DataColumn columnFurtherActionRemark;
            
            private global::System.Data.DataColumn columnorderindex;
            
            private global::System.Data.DataColumn columnTestName;
            
            private global::System.Data.DataColumn columnReferedDoctor;
            
            private global::System.Data.DataColumn columnReferedHospital;
            
            private global::System.Data.DataColumn columnIssueUOM;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public pRptOPDPrescriptionListWithBatchNExpiryDataTable() {
                this.TableName = "pRptOPDPrescriptionListWithBatchNExpiry";
                this.BeginInit();
                this.InitClass();
                this.EndInit();
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            internal pRptOPDPrescriptionListWithBatchNExpiryDataTable(global::System.Data.DataTable table) {
                this.TableName = table.TableName;
                if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
                    this.CaseSensitive = table.CaseSensitive;
                }
                if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
                    this.Locale = table.Locale;
                }
                if ((table.Namespace != table.DataSet.Namespace)) {
                    this.Namespace = table.Namespace;
                }
                this.Prefix = table.Prefix;
                this.MinimumCapacity = table.MinimumCapacity;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected pRptOPDPrescriptionListWithBatchNExpiryDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : 
                    base(info, context) {
                this.InitVars();
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ExaminationIdColumn {
                get {
                    return this.columnExaminationId;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn prescriptionIdColumn {
                get {
                    return this.columnprescriptionId;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ParticipantCodeColumn {
                get {
                    return this.columnParticipantCode;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ParticipantNameColumn {
                get {
                    return this.columnParticipantName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn PatientCategoryColumn {
                get {
                    return this.columnPatientCategory;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn GenderColumn {
                get {
                    return this.columnGender;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ExaminationDateColumn {
                get {
                    return this.columnExaminationDate;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn OPDOutTimeColumn {
                get {
                    return this.columnOPDOutTime;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn BatchNoColumn {
                get {
                    return this.columnBatchNo;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn AgeColumn {
                get {
                    return this.columnAge;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn PulseColumn {
                get {
                    return this.columnPulse;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn TemperatureColumn {
                get {
                    return this.columnTemperature;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn BloodPressureSystolicColumn {
                get {
                    return this.columnBloodPressureSystolic;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn BloodPressureDiastolicColumn {
                get {
                    return this.columnBloodPressureDiastolic;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ContactPersonColumn {
                get {
                    return this.columnContactPerson;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn OutsideMedicineColumn {
                get {
                    return this.columnOutsideMedicine;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn OutsideTestColumn {
                get {
                    return this.columnOutsideTest;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn DiagnosisColumn {
                get {
                    return this.columnDiagnosis;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn problemsColumn {
                get {
                    return this.columnproblems;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn DrugInstructionColumn {
                get {
                    return this.columnDrugInstruction;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn MedicinesColumn {
                get {
                    return this.columnMedicines;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn MedicineQtyColumn {
                get {
                    return this.columnMedicineQty;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn DispensedQuantityColumn {
                get {
                    return this.columnDispensedQuantity;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn DurationColumn {
                get {
                    return this.columnDuration;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn PrescribedQuantityColumn {
                get {
                    return this.columnPrescribedQuantity;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ParticipantSourceIdColumn {
                get {
                    return this.columnParticipantSourceId;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn StockIdColumn {
                get {
                    return this.columnStockId;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn DrawSizeColumn {
                get {
                    return this.columnDrawSize;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn MedicineDosageColumn {
                get {
                    return this.columnMedicineDosage;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn RemainingQtyColumn {
                get {
                    return this.columnRemainingQty;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn RefferedNameColumn {
                get {
                    return this.columnRefferedName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn MedicalRegistrationNoColumn {
                get {
                    return this.columnMedicalRegistrationNo;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ExaminationNumberColumn {
                get {
                    return this.columnExaminationNumber;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn CauseTitleColumn {
                get {
                    return this.columnCauseTitle;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn DepartmentNameColumn {
                get {
                    return this.columnDepartmentName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn DoctorSignatureColumn {
                get {
                    return this.columnDoctorSignature;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn LogoColumn {
                get {
                    return this.columnLogo;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn SmallAddress1Column {
                get {
                    return this.columnSmallAddress1;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn SmallAddress2Column {
                get {
                    return this.columnSmallAddress2;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn CompanyNameColumn {
                get {
                    return this.columnCompanyName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn AdviceColumn {
                get {
                    return this.columnAdvice;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn FurtherActionRemarkColumn {
                get {
                    return this.columnFurtherActionRemark;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn orderindexColumn {
                get {
                    return this.columnorderindex;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn TestNameColumn {
                get {
                    return this.columnTestName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ReferedDoctorColumn {
                get {
                    return this.columnReferedDoctor;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn ReferedHospitalColumn {
                get {
                    return this.columnReferedHospital;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataColumn IssueUOMColumn {
                get {
                    return this.columnIssueUOM;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            [global::System.ComponentModel.Browsable(false)]
            public int Count {
                get {
                    return this.Rows.Count;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public pRptOPDPrescriptionListWithBatchNExpiryRow this[int index] {
                get {
                    return ((pRptOPDPrescriptionListWithBatchNExpiryRow)(this.Rows[index]));
                }
            }
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public event pRptOPDPrescriptionListWithBatchNExpiryRowChangeEventHandler pRptOPDPrescriptionListWithBatchNExpiryRowChanging;
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public event pRptOPDPrescriptionListWithBatchNExpiryRowChangeEventHandler pRptOPDPrescriptionListWithBatchNExpiryRowChanged;
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public event pRptOPDPrescriptionListWithBatchNExpiryRowChangeEventHandler pRptOPDPrescriptionListWithBatchNExpiryRowDeleting;
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public event pRptOPDPrescriptionListWithBatchNExpiryRowChangeEventHandler pRptOPDPrescriptionListWithBatchNExpiryRowDeleted;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void AddpRptOPDPrescriptionListWithBatchNExpiryRow(pRptOPDPrescriptionListWithBatchNExpiryRow row) {
                this.Rows.Add(row);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public pRptOPDPrescriptionListWithBatchNExpiryRow AddpRptOPDPrescriptionListWithBatchNExpiryRow(
                        long ExaminationId, 
                        long prescriptionId, 
                        string ParticipantCode, 
                        string ParticipantName, 
                        string PatientCategory, 
                        string Gender, 
                        string ExaminationDate, 
                        string OPDOutTime, 
                        string BatchNo, 
                        int Age, 
                        short Pulse, 
                        decimal Temperature, 
                        int BloodPressureSystolic, 
                        short BloodPressureDiastolic, 
                        string ContactPerson, 
                        string OutsideMedicine, 
                        string OutsideTest, 
                        string Diagnosis, 
                        string problems, 
                        string DrugInstruction, 
                        string Medicines, 
                        string MedicineQty, 
                        string DispensedQuantity, 
                        string Duration, 
                        string PrescribedQuantity, 
                        long ParticipantSourceId, 
                        long StockId, 
                        decimal DrawSize, 
                        string MedicineDosage, 
                        string RemainingQty, 
                        string RefferedName, 
                        string MedicalRegistrationNo, 
                        string ExaminationNumber, 
                        string CauseTitle, 
                        string DepartmentName, 
                        byte[] DoctorSignature, 
                        byte[] Logo, 
                        string SmallAddress1, 
                        string SmallAddress2, 
                        string CompanyName, 
                        string Advice, 
                        string FurtherActionRemark, 
                        string orderindex, 
                        string TestName, 
                        string ReferedDoctor, 
                        string ReferedHospital, 
                        string IssueUOM) {
                pRptOPDPrescriptionListWithBatchNExpiryRow rowpRptOPDPrescriptionListWithBatchNExpiryRow = ((pRptOPDPrescriptionListWithBatchNExpiryRow)(this.NewRow()));
                object[] columnValuesArray = new object[] {
                        ExaminationId,
                        prescriptionId,
                        ParticipantCode,
                        ParticipantName,
                        PatientCategory,
                        Gender,
                        ExaminationDate,
                        OPDOutTime,
                        BatchNo,
                        Age,
                        Pulse,
                        Temperature,
                        BloodPressureSystolic,
                        BloodPressureDiastolic,
                        ContactPerson,
                        OutsideMedicine,
                        OutsideTest,
                        Diagnosis,
                        problems,
                        DrugInstruction,
                        Medicines,
                        MedicineQty,
                        DispensedQuantity,
                        Duration,
                        PrescribedQuantity,
                        ParticipantSourceId,
                        StockId,
                        DrawSize,
                        MedicineDosage,
                        RemainingQty,
                        RefferedName,
                        MedicalRegistrationNo,
                        ExaminationNumber,
                        CauseTitle,
                        DepartmentName,
                        DoctorSignature,
                        Logo,
                        SmallAddress1,
                        SmallAddress2,
                        CompanyName,
                        Advice,
                        FurtherActionRemark,
                        orderindex,
                        TestName,
                        ReferedDoctor,
                        ReferedHospital,
                        IssueUOM};
                rowpRptOPDPrescriptionListWithBatchNExpiryRow.ItemArray = columnValuesArray;
                this.Rows.Add(rowpRptOPDPrescriptionListWithBatchNExpiryRow);
                return rowpRptOPDPrescriptionListWithBatchNExpiryRow;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public override global::System.Data.DataTable Clone() {
                pRptOPDPrescriptionListWithBatchNExpiryDataTable cln = ((pRptOPDPrescriptionListWithBatchNExpiryDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected override global::System.Data.DataTable CreateInstance() {
                return new pRptOPDPrescriptionListWithBatchNExpiryDataTable();
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            internal void InitVars() {
                this.columnExaminationId = base.Columns["ExaminationId"];
                this.columnprescriptionId = base.Columns["prescriptionId"];
                this.columnParticipantCode = base.Columns["ParticipantCode"];
                this.columnParticipantName = base.Columns["ParticipantName"];
                this.columnPatientCategory = base.Columns["PatientCategory"];
                this.columnGender = base.Columns["Gender"];
                this.columnExaminationDate = base.Columns["ExaminationDate"];
                this.columnOPDOutTime = base.Columns["OPDOutTime"];
                this.columnBatchNo = base.Columns["BatchNo"];
                this.columnAge = base.Columns["Age"];
                this.columnPulse = base.Columns["Pulse"];
                this.columnTemperature = base.Columns["Temperature"];
                this.columnBloodPressureSystolic = base.Columns["BloodPressureSystolic"];
                this.columnBloodPressureDiastolic = base.Columns["BloodPressureDiastolic"];
                this.columnContactPerson = base.Columns["ContactPerson"];
                this.columnOutsideMedicine = base.Columns["OutsideMedicine"];
                this.columnOutsideTest = base.Columns["OutsideTest"];
                this.columnDiagnosis = base.Columns["Diagnosis"];
                this.columnproblems = base.Columns["problems"];
                this.columnDrugInstruction = base.Columns["DrugInstruction"];
                this.columnMedicines = base.Columns["Medicines"];
                this.columnMedicineQty = base.Columns["MedicineQty"];
                this.columnDispensedQuantity = base.Columns["DispensedQuantity"];
                this.columnDuration = base.Columns["Duration"];
                this.columnPrescribedQuantity = base.Columns["PrescribedQuantity"];
                this.columnParticipantSourceId = base.Columns["ParticipantSourceId"];
                this.columnStockId = base.Columns["StockId"];
                this.columnDrawSize = base.Columns["DrawSize"];
                this.columnMedicineDosage = base.Columns["MedicineDosage"];
                this.columnRemainingQty = base.Columns["RemainingQty"];
                this.columnRefferedName = base.Columns["RefferedName"];
                this.columnMedicalRegistrationNo = base.Columns["MedicalRegistrationNo"];
                this.columnExaminationNumber = base.Columns["ExaminationNumber"];
                this.columnCauseTitle = base.Columns["CauseTitle"];
                this.columnDepartmentName = base.Columns["DepartmentName"];
                this.columnDoctorSignature = base.Columns["DoctorSignature"];
                this.columnLogo = base.Columns["Logo"];
                this.columnSmallAddress1 = base.Columns["SmallAddress1"];
                this.columnSmallAddress2 = base.Columns["SmallAddress2"];
                this.columnCompanyName = base.Columns["CompanyName"];
                this.columnAdvice = base.Columns["Advice"];
                this.columnFurtherActionRemark = base.Columns["FurtherActionRemark"];
                this.columnorderindex = base.Columns["orderindex"];
                this.columnTestName = base.Columns["TestName"];
                this.columnReferedDoctor = base.Columns["ReferedDoctor"];
                this.columnReferedHospital = base.Columns["ReferedHospital"];
                this.columnIssueUOM = base.Columns["IssueUOM"];
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            private void InitClass() {
                this.columnExaminationId = new global::System.Data.DataColumn("ExaminationId", typeof(long), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnExaminationId);
                this.columnprescriptionId = new global::System.Data.DataColumn("prescriptionId", typeof(long), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnprescriptionId);
                this.columnParticipantCode = new global::System.Data.DataColumn("ParticipantCode", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnParticipantCode);
                this.columnParticipantName = new global::System.Data.DataColumn("ParticipantName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnParticipantName);
                this.columnPatientCategory = new global::System.Data.DataColumn("PatientCategory", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnPatientCategory);
                this.columnGender = new global::System.Data.DataColumn("Gender", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnGender);
                this.columnExaminationDate = new global::System.Data.DataColumn("ExaminationDate", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnExaminationDate);
                this.columnOPDOutTime = new global::System.Data.DataColumn("OPDOutTime", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnOPDOutTime);
                this.columnBatchNo = new global::System.Data.DataColumn("BatchNo", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnBatchNo);
                this.columnAge = new global::System.Data.DataColumn("Age", typeof(int), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnAge);
                this.columnPulse = new global::System.Data.DataColumn("Pulse", typeof(short), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnPulse);
                this.columnTemperature = new global::System.Data.DataColumn("Temperature", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnTemperature);
                this.columnBloodPressureSystolic = new global::System.Data.DataColumn("BloodPressureSystolic", typeof(int), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnBloodPressureSystolic);
                this.columnBloodPressureDiastolic = new global::System.Data.DataColumn("BloodPressureDiastolic", typeof(short), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnBloodPressureDiastolic);
                this.columnContactPerson = new global::System.Data.DataColumn("ContactPerson", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnContactPerson);
                this.columnOutsideMedicine = new global::System.Data.DataColumn("OutsideMedicine", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnOutsideMedicine);
                this.columnOutsideTest = new global::System.Data.DataColumn("OutsideTest", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnOutsideTest);
                this.columnDiagnosis = new global::System.Data.DataColumn("Diagnosis", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDiagnosis);
                this.columnproblems = new global::System.Data.DataColumn("problems", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnproblems);
                this.columnDrugInstruction = new global::System.Data.DataColumn("DrugInstruction", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDrugInstruction);
                this.columnMedicines = new global::System.Data.DataColumn("Medicines", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnMedicines);
                this.columnMedicineQty = new global::System.Data.DataColumn("MedicineQty", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnMedicineQty);
                this.columnDispensedQuantity = new global::System.Data.DataColumn("DispensedQuantity", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDispensedQuantity);
                this.columnDuration = new global::System.Data.DataColumn("Duration", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDuration);
                this.columnPrescribedQuantity = new global::System.Data.DataColumn("PrescribedQuantity", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnPrescribedQuantity);
                this.columnParticipantSourceId = new global::System.Data.DataColumn("ParticipantSourceId", typeof(long), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnParticipantSourceId);
                this.columnStockId = new global::System.Data.DataColumn("StockId", typeof(long), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnStockId);
                this.columnDrawSize = new global::System.Data.DataColumn("DrawSize", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDrawSize);
                this.columnMedicineDosage = new global::System.Data.DataColumn("MedicineDosage", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnMedicineDosage);
                this.columnRemainingQty = new global::System.Data.DataColumn("RemainingQty", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRemainingQty);
                this.columnRefferedName = new global::System.Data.DataColumn("RefferedName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRefferedName);
                this.columnMedicalRegistrationNo = new global::System.Data.DataColumn("MedicalRegistrationNo", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnMedicalRegistrationNo);
                this.columnExaminationNumber = new global::System.Data.DataColumn("ExaminationNumber", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnExaminationNumber);
                this.columnCauseTitle = new global::System.Data.DataColumn("CauseTitle", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCauseTitle);
                this.columnDepartmentName = new global::System.Data.DataColumn("DepartmentName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDepartmentName);
                this.columnDoctorSignature = new global::System.Data.DataColumn("DoctorSignature", typeof(byte[]), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDoctorSignature);
                this.columnLogo = new global::System.Data.DataColumn("Logo", typeof(byte[]), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnLogo);
                this.columnSmallAddress1 = new global::System.Data.DataColumn("SmallAddress1", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnSmallAddress1);
                this.columnSmallAddress2 = new global::System.Data.DataColumn("SmallAddress2", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnSmallAddress2);
                this.columnCompanyName = new global::System.Data.DataColumn("CompanyName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyName);
                this.columnAdvice = new global::System.Data.DataColumn("Advice", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnAdvice);
                this.columnFurtherActionRemark = new global::System.Data.DataColumn("FurtherActionRemark", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnFurtherActionRemark);
                this.columnorderindex = new global::System.Data.DataColumn("orderindex", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnorderindex);
                this.columnTestName = new global::System.Data.DataColumn("TestName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnTestName);
                this.columnReferedDoctor = new global::System.Data.DataColumn("ReferedDoctor", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnReferedDoctor);
                this.columnReferedHospital = new global::System.Data.DataColumn("ReferedHospital", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnReferedHospital);
                this.columnIssueUOM = new global::System.Data.DataColumn("IssueUOM", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnIssueUOM);
                this.columnExaminationId.ReadOnly = true;
                this.columnprescriptionId.ReadOnly = true;
                this.columnParticipantCode.ReadOnly = true;
                this.columnParticipantCode.MaxLength = 20;
                this.columnParticipantName.ReadOnly = true;
                this.columnParticipantName.MaxLength = 250;
                this.columnPatientCategory.ReadOnly = true;
                this.columnPatientCategory.MaxLength = 100;
                this.columnGender.ReadOnly = true;
                this.columnGender.MaxLength = 20;
                this.columnExaminationDate.ReadOnly = true;
                this.columnExaminationDate.MaxLength = 131;
                this.columnOPDOutTime.ReadOnly = true;
                this.columnOPDOutTime.MaxLength = 100;
                this.columnBatchNo.ReadOnly = true;
                this.columnBatchNo.MaxLength = 51;
                this.columnAge.ReadOnly = true;
                this.columnPulse.ReadOnly = true;
                this.columnTemperature.ReadOnly = true;
                this.columnBloodPressureSystolic.ReadOnly = true;
                this.columnBloodPressureDiastolic.ReadOnly = true;
                this.columnContactPerson.ReadOnly = true;
                this.columnContactPerson.MaxLength = 150;
                this.columnOutsideMedicine.ReadOnly = true;
                this.columnOutsideMedicine.MaxLength = 1000;
                this.columnOutsideTest.ReadOnly = true;
                this.columnOutsideTest.MaxLength = 1000;
                this.columnDiagnosis.ReadOnly = true;
                this.columnDiagnosis.MaxLength = 1000;
                this.columnproblems.ReadOnly = true;
                this.columnproblems.MaxLength = 500;
                this.columnDrugInstruction.ReadOnly = true;
                this.columnDrugInstruction.MaxLength = 200;
                this.columnMedicines.ReadOnly = true;
                this.columnMedicines.MaxLength = 100;
                this.columnMedicineQty.ReadOnly = true;
                this.columnMedicineQty.MaxLength = 200;
                this.columnDispensedQuantity.ReadOnly = true;
                this.columnDispensedQuantity.MaxLength = 20;
                this.columnDuration.ReadOnly = true;
                this.columnDuration.MaxLength = 100;
                this.columnPrescribedQuantity.ReadOnly = true;
                this.columnPrescribedQuantity.MaxLength = 100;
                this.columnParticipantSourceId.ReadOnly = true;
                this.columnStockId.ReadOnly = true;
                this.columnDrawSize.ReadOnly = true;
                this.columnMedicineDosage.ReadOnly = true;
                this.columnMedicineDosage.MaxLength = 100;
                this.columnRemainingQty.ReadOnly = true;
                this.columnRemainingQty.MaxLength = 100;
                this.columnRefferedName.ReadOnly = true;
                this.columnRefferedName.MaxLength = 201;
                this.columnMedicalRegistrationNo.ReadOnly = true;
                this.columnMedicalRegistrationNo.MaxLength = 30;
                this.columnExaminationNumber.ReadOnly = true;
                this.columnExaminationNumber.MaxLength = 200;
                this.columnCauseTitle.ReadOnly = true;
                this.columnCauseTitle.MaxLength = 100;
                this.columnDepartmentName.ReadOnly = true;
                this.columnDepartmentName.MaxLength = 100;
                this.columnDoctorSignature.ReadOnly = true;
                this.columnLogo.ReadOnly = true;
                this.columnSmallAddress1.ReadOnly = true;
                this.columnSmallAddress1.MaxLength = 100;
                this.columnSmallAddress2.ReadOnly = true;
                this.columnSmallAddress2.MaxLength = 100;
                this.columnCompanyName.ReadOnly = true;
                this.columnCompanyName.MaxLength = 300;
                this.columnAdvice.ReadOnly = true;
                this.columnAdvice.MaxLength = 300;
                this.columnFurtherActionRemark.ReadOnly = true;
                this.columnFurtherActionRemark.MaxLength = 250;
                this.columnorderindex.ReadOnly = true;
                this.columnorderindex.MaxLength = 1;
                this.columnTestName.ReadOnly = true;
                this.columnTestName.MaxLength = 2147483647;
                this.columnReferedDoctor.ReadOnly = true;
                this.columnReferedDoctor.MaxLength = 150;
                this.columnReferedHospital.ReadOnly = true;
                this.columnReferedHospital.MaxLength = 300;
                this.columnIssueUOM.ReadOnly = true;
                this.columnIssueUOM.MaxLength = 50;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public pRptOPDPrescriptionListWithBatchNExpiryRow NewpRptOPDPrescriptionListWithBatchNExpiryRow() {
                return ((pRptOPDPrescriptionListWithBatchNExpiryRow)(this.NewRow()));
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
                return new pRptOPDPrescriptionListWithBatchNExpiryRow(builder);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected override global::System.Type GetRowType() {
                return typeof(pRptOPDPrescriptionListWithBatchNExpiryRow);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.pRptOPDPrescriptionListWithBatchNExpiryRowChanged != null)) {
                    this.pRptOPDPrescriptionListWithBatchNExpiryRowChanged(this, new pRptOPDPrescriptionListWithBatchNExpiryRowChangeEvent(((pRptOPDPrescriptionListWithBatchNExpiryRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.pRptOPDPrescriptionListWithBatchNExpiryRowChanging != null)) {
                    this.pRptOPDPrescriptionListWithBatchNExpiryRowChanging(this, new pRptOPDPrescriptionListWithBatchNExpiryRowChangeEvent(((pRptOPDPrescriptionListWithBatchNExpiryRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.pRptOPDPrescriptionListWithBatchNExpiryRowDeleted != null)) {
                    this.pRptOPDPrescriptionListWithBatchNExpiryRowDeleted(this, new pRptOPDPrescriptionListWithBatchNExpiryRowChangeEvent(((pRptOPDPrescriptionListWithBatchNExpiryRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.pRptOPDPrescriptionListWithBatchNExpiryRowDeleting != null)) {
                    this.pRptOPDPrescriptionListWithBatchNExpiryRowDeleting(this, new pRptOPDPrescriptionListWithBatchNExpiryRowChangeEvent(((pRptOPDPrescriptionListWithBatchNExpiryRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void RemovepRptOPDPrescriptionListWithBatchNExpiryRow(pRptOPDPrescriptionListWithBatchNExpiryRow row) {
                this.Rows.Remove(row);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
                global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
                global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
                OPDPrescriptionListWithBatchNExpiry ds = new OPDPrescriptionListWithBatchNExpiry();
                global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
                any1.Namespace = "http://www.w3.org/2001/XMLSchema";
                any1.MinOccurs = new decimal(0);
                any1.MaxOccurs = decimal.MaxValue;
                any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
                sequence.Items.Add(any1);
                global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
                any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
                any2.MinOccurs = new decimal(1);
                any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
                sequence.Items.Add(any2);
                global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
                attribute1.Name = "namespace";
                attribute1.FixedValue = ds.Namespace;
                type.Attributes.Add(attribute1);
                global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
                attribute2.Name = "tableTypeName";
                attribute2.FixedValue = "pRptOPDPrescriptionListWithBatchNExpiryDataTable";
                type.Attributes.Add(attribute2);
                type.Particle = sequence;
                global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
                if (xs.Contains(dsSchema.TargetNamespace)) {
                    global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
                    global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
                    try {
                        global::System.Xml.Schema.XmlSchema schema = null;
                        dsSchema.Write(s1);
                        for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
                            schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
                            s2.SetLength(0);
                            schema.Write(s2);
                            if ((s1.Length == s2.Length)) {
                                s1.Position = 0;
                                s2.Position = 0;
                                for (; ((s1.Position != s1.Length) 
                                            && (s1.ReadByte() == s2.ReadByte())); ) {
                                    ;
                                }
                                if ((s1.Position == s1.Length)) {
                                    return type;
                                }
                            }
                        }
                    }
                    finally {
                        if ((s1 != null)) {
                            s1.Close();
                        }
                        if ((s2 != null)) {
                            s2.Close();
                        }
                    }
                }
                xs.Add(dsSchema);
                return type;
            }
        }
        
        /// <summary>
        ///Represents strongly named DataRow class.
        ///</summary>
        public partial class pRptOPDPrescriptionListWithBatchNExpiryRow : global::System.Data.DataRow {
            
            private pRptOPDPrescriptionListWithBatchNExpiryDataTable tablepRptOPDPrescriptionListWithBatchNExpiry;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            internal pRptOPDPrescriptionListWithBatchNExpiryRow(global::System.Data.DataRowBuilder rb) : 
                    base(rb) {
                this.tablepRptOPDPrescriptionListWithBatchNExpiry = ((pRptOPDPrescriptionListWithBatchNExpiryDataTable)(this.Table));
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public long ExaminationId {
                get {
                    try {
                        return ((long)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationIdColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ExaminationId\' in table \'pRptOPDPrescriptionListWithBatchNE" +
                                "xpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationIdColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public long prescriptionId {
                get {
                    try {
                        return ((long)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.prescriptionIdColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'prescriptionId\' in table \'pRptOPDPrescriptionListWithBatchN" +
                                "Expiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.prescriptionIdColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string ParticipantCode {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantCodeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ParticipantCode\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantCodeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string ParticipantName {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ParticipantName\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string PatientCategory {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PatientCategoryColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'PatientCategory\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PatientCategoryColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string Gender {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.GenderColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Gender\' in table \'pRptOPDPrescriptionListWithBatchNExpiry\' " +
                                "is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.GenderColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string ExaminationDate {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationDateColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ExaminationDate\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationDateColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string OPDOutTime {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OPDOutTimeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'OPDOutTime\' in table \'pRptOPDPrescriptionListWithBatchNExpi" +
                                "ry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OPDOutTimeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string BatchNo {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BatchNoColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'BatchNo\' in table \'pRptOPDPrescriptionListWithBatchNExpiry\'" +
                                " is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BatchNoColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public int Age {
                get {
                    try {
                        return ((int)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.AgeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Age\' in table \'pRptOPDPrescriptionListWithBatchNExpiry\' is " +
                                "DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.AgeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public short Pulse {
                get {
                    try {
                        return ((short)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PulseColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Pulse\' in table \'pRptOPDPrescriptionListWithBatchNExpiry\' i" +
                                "s DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PulseColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public decimal Temperature {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.TemperatureColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Temperature\' in table \'pRptOPDPrescriptionListWithBatchNExp" +
                                "iry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.TemperatureColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public int BloodPressureSystolic {
                get {
                    try {
                        return ((int)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureSystolicColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'BloodPressureSystolic\' in table \'pRptOPDPrescriptionListWit" +
                                "hBatchNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureSystolicColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public short BloodPressureDiastolic {
                get {
                    try {
                        return ((short)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureDiastolicColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'BloodPressureDiastolic\' in table \'pRptOPDPrescriptionListWi" +
                                "thBatchNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureDiastolicColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string ContactPerson {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ContactPersonColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ContactPerson\' in table \'pRptOPDPrescriptionListWithBatchNE" +
                                "xpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ContactPersonColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string OutsideMedicine {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideMedicineColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'OutsideMedicine\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideMedicineColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string OutsideTest {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideTestColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'OutsideTest\' in table \'pRptOPDPrescriptionListWithBatchNExp" +
                                "iry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideTestColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string Diagnosis {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DiagnosisColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Diagnosis\' in table \'pRptOPDPrescriptionListWithBatchNExpir" +
                                "y\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DiagnosisColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string problems {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.problemsColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'problems\' in table \'pRptOPDPrescriptionListWithBatchNExpiry" +
                                "\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.problemsColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string DrugInstruction {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrugInstructionColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DrugInstruction\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrugInstructionColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string Medicines {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicinesColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Medicines\' in table \'pRptOPDPrescriptionListWithBatchNExpir" +
                                "y\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicinesColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string MedicineQty {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineQtyColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'MedicineQty\' in table \'pRptOPDPrescriptionListWithBatchNExp" +
                                "iry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineQtyColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string DispensedQuantity {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DispensedQuantityColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DispensedQuantity\' in table \'pRptOPDPrescriptionListWithBat" +
                                "chNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DispensedQuantityColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string Duration {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DurationColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Duration\' in table \'pRptOPDPrescriptionListWithBatchNExpiry" +
                                "\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DurationColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string PrescribedQuantity {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PrescribedQuantityColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'PrescribedQuantity\' in table \'pRptOPDPrescriptionListWithBa" +
                                "tchNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PrescribedQuantityColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public long ParticipantSourceId {
                get {
                    try {
                        return ((long)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantSourceIdColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ParticipantSourceId\' in table \'pRptOPDPrescriptionListWithB" +
                                "atchNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantSourceIdColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public long StockId {
                get {
                    try {
                        return ((long)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.StockIdColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'StockId\' in table \'pRptOPDPrescriptionListWithBatchNExpiry\'" +
                                " is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.StockIdColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public decimal DrawSize {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrawSizeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DrawSize\' in table \'pRptOPDPrescriptionListWithBatchNExpiry" +
                                "\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrawSizeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string MedicineDosage {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineDosageColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'MedicineDosage\' in table \'pRptOPDPrescriptionListWithBatchN" +
                                "Expiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineDosageColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string RemainingQty {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.RemainingQtyColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'RemainingQty\' in table \'pRptOPDPrescriptionListWithBatchNEx" +
                                "piry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.RemainingQtyColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string RefferedName {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.RefferedNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'RefferedName\' in table \'pRptOPDPrescriptionListWithBatchNEx" +
                                "piry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.RefferedNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string MedicalRegistrationNo {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicalRegistrationNoColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'MedicalRegistrationNo\' in table \'pRptOPDPrescriptionListWit" +
                                "hBatchNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicalRegistrationNoColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string ExaminationNumber {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationNumberColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ExaminationNumber\' in table \'pRptOPDPrescriptionListWithBat" +
                                "chNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationNumberColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string CauseTitle {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.CauseTitleColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CauseTitle\' in table \'pRptOPDPrescriptionListWithBatchNExpi" +
                                "ry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.CauseTitleColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string DepartmentName {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DepartmentNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DepartmentName\' in table \'pRptOPDPrescriptionListWithBatchN" +
                                "Expiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DepartmentNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public byte[] DoctorSignature {
                get {
                    try {
                        return ((byte[])(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DoctorSignatureColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DoctorSignature\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DoctorSignatureColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public byte[] Logo {
                get {
                    try {
                        return ((byte[])(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.LogoColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Logo\' in table \'pRptOPDPrescriptionListWithBatchNExpiry\' is" +
                                " DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.LogoColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string SmallAddress1 {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress1Column]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'SmallAddress1\' in table \'pRptOPDPrescriptionListWithBatchNE" +
                                "xpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress1Column] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string SmallAddress2 {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress2Column]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'SmallAddress2\' in table \'pRptOPDPrescriptionListWithBatchNE" +
                                "xpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress2Column] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string CompanyName {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.CompanyNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyName\' in table \'pRptOPDPrescriptionListWithBatchNExp" +
                                "iry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.CompanyNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string Advice {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.AdviceColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Advice\' in table \'pRptOPDPrescriptionListWithBatchNExpiry\' " +
                                "is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.AdviceColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string FurtherActionRemark {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.FurtherActionRemarkColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'FurtherActionRemark\' in table \'pRptOPDPrescriptionListWithB" +
                                "atchNExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.FurtherActionRemarkColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string orderindex {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.orderindexColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'orderindex\' in table \'pRptOPDPrescriptionListWithBatchNExpi" +
                                "ry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.orderindexColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string TestName {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.TestNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'TestName\' in table \'pRptOPDPrescriptionListWithBatchNExpiry" +
                                "\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.TestNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string ReferedDoctor {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedDoctorColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ReferedDoctor\' in table \'pRptOPDPrescriptionListWithBatchNE" +
                                "xpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedDoctorColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string ReferedHospital {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedHospitalColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ReferedHospital\' in table \'pRptOPDPrescriptionListWithBatch" +
                                "NExpiry\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedHospitalColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public string IssueUOM {
                get {
                    try {
                        return ((string)(this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.IssueUOMColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'IssueUOM\' in table \'pRptOPDPrescriptionListWithBatchNExpiry" +
                                "\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.IssueUOMColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsExaminationIdNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationIdColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetExaminationIdNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationIdColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsprescriptionIdNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.prescriptionIdColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetprescriptionIdNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.prescriptionIdColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsParticipantCodeNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantCodeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetParticipantCodeNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantCodeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsParticipantNameNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetParticipantNameNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsPatientCategoryNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.PatientCategoryColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetPatientCategoryNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PatientCategoryColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsGenderNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.GenderColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetGenderNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.GenderColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsExaminationDateNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationDateColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetExaminationDateNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationDateColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsOPDOutTimeNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.OPDOutTimeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetOPDOutTimeNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OPDOutTimeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsBatchNoNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.BatchNoColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetBatchNoNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BatchNoColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsAgeNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.AgeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetAgeNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.AgeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsPulseNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.PulseColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetPulseNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PulseColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsTemperatureNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.TemperatureColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetTemperatureNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.TemperatureColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsBloodPressureSystolicNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureSystolicColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetBloodPressureSystolicNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureSystolicColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsBloodPressureDiastolicNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureDiastolicColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetBloodPressureDiastolicNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.BloodPressureDiastolicColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsContactPersonNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ContactPersonColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetContactPersonNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ContactPersonColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsOutsideMedicineNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideMedicineColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetOutsideMedicineNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideMedicineColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsOutsideTestNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideTestColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetOutsideTestNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.OutsideTestColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsDiagnosisNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.DiagnosisColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetDiagnosisNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DiagnosisColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsproblemsNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.problemsColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetproblemsNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.problemsColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsDrugInstructionNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrugInstructionColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetDrugInstructionNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrugInstructionColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsMedicinesNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicinesColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetMedicinesNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicinesColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsMedicineQtyNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineQtyColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetMedicineQtyNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineQtyColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsDispensedQuantityNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.DispensedQuantityColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetDispensedQuantityNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DispensedQuantityColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsDurationNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.DurationColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetDurationNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DurationColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsPrescribedQuantityNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.PrescribedQuantityColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetPrescribedQuantityNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.PrescribedQuantityColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsParticipantSourceIdNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantSourceIdColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetParticipantSourceIdNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ParticipantSourceIdColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsStockIdNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.StockIdColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetStockIdNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.StockIdColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsDrawSizeNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrawSizeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetDrawSizeNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DrawSizeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsMedicineDosageNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineDosageColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetMedicineDosageNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicineDosageColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsRemainingQtyNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.RemainingQtyColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetRemainingQtyNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.RemainingQtyColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsRefferedNameNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.RefferedNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetRefferedNameNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.RefferedNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsMedicalRegistrationNoNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicalRegistrationNoColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetMedicalRegistrationNoNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.MedicalRegistrationNoColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsExaminationNumberNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationNumberColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetExaminationNumberNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ExaminationNumberColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsCauseTitleNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.CauseTitleColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetCauseTitleNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.CauseTitleColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsDepartmentNameNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.DepartmentNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetDepartmentNameNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DepartmentNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsDoctorSignatureNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.DoctorSignatureColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetDoctorSignatureNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.DoctorSignatureColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsLogoNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.LogoColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetLogoNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.LogoColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsSmallAddress1Null() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress1Column);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetSmallAddress1Null() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress1Column] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsSmallAddress2Null() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress2Column);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetSmallAddress2Null() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.SmallAddress2Column] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsCompanyNameNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.CompanyNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetCompanyNameNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.CompanyNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsAdviceNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.AdviceColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetAdviceNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.AdviceColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsFurtherActionRemarkNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.FurtherActionRemarkColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetFurtherActionRemarkNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.FurtherActionRemarkColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsorderindexNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.orderindexColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetorderindexNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.orderindexColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsTestNameNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.TestNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetTestNameNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.TestNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsReferedDoctorNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedDoctorColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetReferedDoctorNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedDoctorColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsReferedHospitalNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedHospitalColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetReferedHospitalNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.ReferedHospitalColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public bool IsIssueUOMNull() {
                return this.IsNull(this.tablepRptOPDPrescriptionListWithBatchNExpiry.IssueUOMColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public void SetIssueUOMNull() {
                this[this.tablepRptOPDPrescriptionListWithBatchNExpiry.IssueUOMColumn] = global::System.Convert.DBNull;
            }
        }
        
        /// <summary>
        ///Row event argument class
        ///</summary>
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public class pRptOPDPrescriptionListWithBatchNExpiryRowChangeEvent : global::System.EventArgs {
            
            private pRptOPDPrescriptionListWithBatchNExpiryRow eventRow;
            
            private global::System.Data.DataRowAction eventAction;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public pRptOPDPrescriptionListWithBatchNExpiryRowChangeEvent(pRptOPDPrescriptionListWithBatchNExpiryRow row, global::System.Data.DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public pRptOPDPrescriptionListWithBatchNExpiryRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public global::System.Data.DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}
namespace OccuCare.Report.Datasets.ClinicalInformation.Examination.OPDPrescriptionListWithBatchNExpiryTableAdapters {
    
    
    /// <summary>
    ///Represents the connection and commands used to retrieve and save data.
    ///</summary>
    [global::System.ComponentModel.DesignerCategoryAttribute("code")]
    [global::System.ComponentModel.ToolboxItem(true)]
    [global::System.ComponentModel.DataObjectAttribute(true)]
    [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
        ", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
    public partial class pRptOPDPrescriptionListWithBatchNExpiryTableAdapter : global::System.ComponentModel.Component {
        
        private global::System.Data.SqlClient.SqlDataAdapter _adapter;
        
        private global::System.Data.SqlClient.SqlConnection _connection;
        
        private global::System.Data.SqlClient.SqlTransaction _transaction;
        
        private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
        
        private bool _clearBeforeFill;
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public pRptOPDPrescriptionListWithBatchNExpiryTableAdapter() {
            this.ClearBeforeFill = true;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
            get {
                if ((this._adapter == null)) {
                    this.InitAdapter();
                }
                return this._adapter;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        internal global::System.Data.SqlClient.SqlConnection Connection {
            get {
                if ((this._connection == null)) {
                    this.InitConnection();
                }
                return this._connection;
            }
            set {
                this._connection = value;
                if ((this.Adapter.InsertCommand != null)) {
                    this.Adapter.InsertCommand.Connection = value;
                }
                if ((this.Adapter.DeleteCommand != null)) {
                    this.Adapter.DeleteCommand.Connection = value;
                }
                if ((this.Adapter.UpdateCommand != null)) {
                    this.Adapter.UpdateCommand.Connection = value;
                }
                for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
                    if ((this.CommandCollection[i] != null)) {
                        ((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
                    }
                }
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        internal global::System.Data.SqlClient.SqlTransaction Transaction {
            get {
                return this._transaction;
            }
            set {
                this._transaction = value;
                for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
                    this.CommandCollection[i].Transaction = this._transaction;
                }
                if (((this.Adapter != null) 
                            && (this.Adapter.DeleteCommand != null))) {
                    this.Adapter.DeleteCommand.Transaction = this._transaction;
                }
                if (((this.Adapter != null) 
                            && (this.Adapter.InsertCommand != null))) {
                    this.Adapter.InsertCommand.Transaction = this._transaction;
                }
                if (((this.Adapter != null) 
                            && (this.Adapter.UpdateCommand != null))) {
                    this.Adapter.UpdateCommand.Transaction = this._transaction;
                }
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
            get {
                if ((this._commandCollection == null)) {
                    this.InitCommandCollection();
                }
                return this._commandCollection;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public bool ClearBeforeFill {
            get {
                return this._clearBeforeFill;
            }
            set {
                this._clearBeforeFill = value;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private void InitAdapter() {
            this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
            global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
            tableMapping.SourceTable = "Table";
            tableMapping.DataSetTable = "pRptOPDPrescriptionListWithBatchNExpiry";
            tableMapping.ColumnMappings.Add("ExaminationId", "ExaminationId");
            tableMapping.ColumnMappings.Add("prescriptionId", "prescriptionId");
            tableMapping.ColumnMappings.Add("ParticipantCode", "ParticipantCode");
            tableMapping.ColumnMappings.Add("ParticipantName", "ParticipantName");
            tableMapping.ColumnMappings.Add("PatientCategory", "PatientCategory");
            tableMapping.ColumnMappings.Add("Gender", "Gender");
            tableMapping.ColumnMappings.Add("ExaminationDate", "ExaminationDate");
            tableMapping.ColumnMappings.Add("OPDOutTime", "OPDOutTime");
            tableMapping.ColumnMappings.Add("BatchNo", "BatchNo");
            tableMapping.ColumnMappings.Add("Age", "Age");
            tableMapping.ColumnMappings.Add("Pulse", "Pulse");
            tableMapping.ColumnMappings.Add("Temperature", "Temperature");
            tableMapping.ColumnMappings.Add("BloodPressureSystolic", "BloodPressureSystolic");
            tableMapping.ColumnMappings.Add("BloodPressureDiastolic", "BloodPressureDiastolic");
            tableMapping.ColumnMappings.Add("ContactPerson", "ContactPerson");
            tableMapping.ColumnMappings.Add("OutsideMedicine", "OutsideMedicine");
            tableMapping.ColumnMappings.Add("OutsideTest", "OutsideTest");
            tableMapping.ColumnMappings.Add("Diagnosis", "Diagnosis");
            tableMapping.ColumnMappings.Add("problems", "problems");
            tableMapping.ColumnMappings.Add("DrugInstruction", "DrugInstruction");
            tableMapping.ColumnMappings.Add("Medicines", "Medicines");
            tableMapping.ColumnMappings.Add("MedicineQty", "MedicineQty");
            tableMapping.ColumnMappings.Add("DispensedQuantity", "DispensedQuantity");
            tableMapping.ColumnMappings.Add("Duration", "Duration");
            tableMapping.ColumnMappings.Add("PrescribedQuantity", "PrescribedQuantity");
            tableMapping.ColumnMappings.Add("ParticipantSourceId", "ParticipantSourceId");
            tableMapping.ColumnMappings.Add("StockId", "StockId");
            tableMapping.ColumnMappings.Add("DrawSize", "DrawSize");
            tableMapping.ColumnMappings.Add("MedicineDosage", "MedicineDosage");
            tableMapping.ColumnMappings.Add("RemainingQty", "RemainingQty");
            tableMapping.ColumnMappings.Add("RefferedName", "RefferedName");
            tableMapping.ColumnMappings.Add("MedicalRegistrationNo", "MedicalRegistrationNo");
            tableMapping.ColumnMappings.Add("ExaminationNumber", "ExaminationNumber");
            tableMapping.ColumnMappings.Add("CauseTitle", "CauseTitle");
            tableMapping.ColumnMappings.Add("DepartmentName", "DepartmentName");
            tableMapping.ColumnMappings.Add("DoctorSignature", "DoctorSignature");
            tableMapping.ColumnMappings.Add("Logo", "Logo");
            tableMapping.ColumnMappings.Add("SmallAddress1", "SmallAddress1");
            tableMapping.ColumnMappings.Add("SmallAddress2", "SmallAddress2");
            tableMapping.ColumnMappings.Add("CompanyName", "CompanyName");
            tableMapping.ColumnMappings.Add("Advice", "Advice");
            tableMapping.ColumnMappings.Add("FurtherActionRemark", "FurtherActionRemark");
            tableMapping.ColumnMappings.Add("orderindex", "orderindex");
            tableMapping.ColumnMappings.Add("TestName", "TestName");
            tableMapping.ColumnMappings.Add("ReferedDoctor", "ReferedDoctor");
            tableMapping.ColumnMappings.Add("ReferedHospital", "ReferedHospital");
            tableMapping.ColumnMappings.Add("IssueUOM", "IssueUOM");
            this._adapter.TableMappings.Add(tableMapping);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private void InitConnection() {
            this._connection = new global::System.Data.SqlClient.SqlConnection();
            this._connection.ConnectionString = global::Sapphire.Ohu.Report.Datasets.Properties.Settings.Default.OccuCareConnectionString2;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private void InitCommandCollection() {
            this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
            this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
            this._commandCollection[0].Connection = this.Connection;
            this._commandCollection[0].CommandText = "sExamination.pRptOPDPrescriptionListWithBatchNExpiry";
            this._commandCollection[0].CommandType = global::System.Data.CommandType.StoredProcedure;
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@RETURN_VALUE", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.ReturnValue, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rBuilder1", global::System.Data.SqlDbType.NVarChar, 2147483647, global::System.Data.ParameterDirection.Input, 0, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rBuilder2", global::System.Data.SqlDbType.NVarChar, 2147483647, global::System.Data.ParameterDirection.Input, 0, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rReportId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rStoreLocationId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rParticipantTypeId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rCaseCauseId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rLocationId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rFunctionId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rDepartmentGroupId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rDepartmentId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rGradeId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rDesignationId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rJobTitleId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rEmployeeTypeId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rCompanyId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rContractorId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rGenderId", global::System.Data.SqlDbType.SmallInt, 2, global::System.Data.ParameterDirection.Input, 5, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rStatusId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rAgeFrom", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rAgeTo", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rFromDate", global::System.Data.SqlDbType.Date, 3, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rToDate", global::System.Data.SqlDbType.DateTime, 8, global::System.Data.ParameterDirection.Input, 23, 3, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rOrgId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rEmployeeCode", global::System.Data.SqlDbType.NVarChar, 50, global::System.Data.ParameterDirection.Input, 0, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rEmployeeTypeGroupId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rEmployeeSubTypeId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rEmployeeGroupId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rOtherTypeId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
            this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@rExaminationId", global::System.Data.SqlDbType.BigInt, 8, global::System.Data.ParameterDirection.Input, 19, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
        public virtual int Fill(
                    OPDPrescriptionListWithBatchNExpiry.pRptOPDPrescriptionListWithBatchNExpiryDataTable dataTable, 
                    string rBuilder1, 
                    string rBuilder2, 
                    global::System.Nullable<int> rReportId, 
                    global::System.Nullable<int> rStoreLocationId, 
                    global::System.Nullable<int> rParticipantTypeId, 
                    global::System.Nullable<int> rCaseCauseId, 
                    global::System.Nullable<int> rLocationId, 
                    global::System.Nullable<int> rFunctionId, 
                    global::System.Nullable<int> rDepartmentGroupId, 
                    global::System.Nullable<int> rDepartmentId, 
                    global::System.Nullable<int> rGradeId, 
                    global::System.Nullable<int> rDesignationId, 
                    global::System.Nullable<int> rJobTitleId, 
                    global::System.Nullable<int> rEmployeeTypeId, 
                    global::System.Nullable<int> rCompanyId, 
                    global::System.Nullable<int> rContractorId, 
                    global::System.Nullable<short> rGenderId, 
                    global::System.Nullable<int> rStatusId, 
                    global::System.Nullable<int> rAgeFrom, 
                    global::System.Nullable<int> rAgeTo, 
                    global::System.Nullable<global::System.DateTime> rFromDate, 
                    global::System.Nullable<global::System.DateTime> rToDate, 
                    global::System.Nullable<int> rOrgId, 
                    string rEmployeeCode, 
                    global::System.Nullable<int> rEmployeeTypeGroupId, 
                    global::System.Nullable<int> rEmployeeSubTypeId, 
                    global::System.Nullable<int> rEmployeeGroupId, 
                    global::System.Nullable<int> rOtherTypeId, 
                    global::System.Nullable<long> rExaminationId) {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((rBuilder1 == null)) {
                this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[1].Value = ((string)(rBuilder1));
            }
            if ((rBuilder2 == null)) {
                this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[2].Value = ((string)(rBuilder2));
            }
            if ((rReportId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[3].Value = ((int)(rReportId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
            }
            if ((rStoreLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[4].Value = ((int)(rStoreLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
            }
            if ((rParticipantTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[5].Value = ((int)(rParticipantTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
            }
            if ((rCaseCauseId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[6].Value = ((int)(rCaseCauseId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
            }
            if ((rLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[7].Value = ((int)(rLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
            }
            if ((rFunctionId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[8].Value = ((int)(rFunctionId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[9].Value = ((int)(rDepartmentGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[10].Value = ((int)(rDepartmentId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
            }
            if ((rGradeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[11].Value = ((int)(rGradeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
            }
            if ((rDesignationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[12].Value = ((int)(rDesignationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
            }
            if ((rJobTitleId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[13].Value = ((int)(rJobTitleId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[14].Value = ((int)(rEmployeeTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
            }
            if ((rCompanyId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[15].Value = ((int)(rCompanyId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[15].Value = global::System.DBNull.Value;
            }
            if ((rContractorId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[16].Value = ((int)(rContractorId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[16].Value = global::System.DBNull.Value;
            }
            if ((rGenderId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[17].Value = ((short)(rGenderId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[17].Value = global::System.DBNull.Value;
            }
            if ((rStatusId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[18].Value = ((int)(rStatusId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[18].Value = global::System.DBNull.Value;
            }
            if ((rAgeFrom.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[19].Value = ((int)(rAgeFrom.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[19].Value = global::System.DBNull.Value;
            }
            if ((rAgeTo.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[20].Value = ((int)(rAgeTo.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[20].Value = global::System.DBNull.Value;
            }
            if ((rFromDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[21].Value = ((System.DateTime)(rFromDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[21].Value = global::System.DBNull.Value;
            }
            if ((rToDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[22].Value = ((System.DateTime)(rToDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[22].Value = global::System.DBNull.Value;
            }
            if ((rOrgId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[23].Value = ((int)(rOrgId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[23].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeCode == null)) {
                this.Adapter.SelectCommand.Parameters[24].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[24].Value = ((string)(rEmployeeCode));
            }
            if ((rEmployeeTypeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[25].Value = ((int)(rEmployeeTypeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[25].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeSubTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[26].Value = ((int)(rEmployeeSubTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[26].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[27].Value = ((int)(rEmployeeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[27].Value = global::System.DBNull.Value;
            }
            if ((rOtherTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[28].Value = ((int)(rOtherTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[28].Value = global::System.DBNull.Value;
            }
            if ((rExaminationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[29].Value = ((long)(rExaminationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[29].Value = global::System.DBNull.Value;
            }
            if ((this.ClearBeforeFill == true)) {
                dataTable.Clear();
            }
            int returnValue = this.Adapter.Fill(dataTable);
            return returnValue;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
        public virtual OPDPrescriptionListWithBatchNExpiry.pRptOPDPrescriptionListWithBatchNExpiryDataTable GetData(
                    string rBuilder1, 
                    string rBuilder2, 
                    global::System.Nullable<int> rReportId, 
                    global::System.Nullable<int> rStoreLocationId, 
                    global::System.Nullable<int> rParticipantTypeId, 
                    global::System.Nullable<int> rCaseCauseId, 
                    global::System.Nullable<int> rLocationId, 
                    global::System.Nullable<int> rFunctionId, 
                    global::System.Nullable<int> rDepartmentGroupId, 
                    global::System.Nullable<int> rDepartmentId, 
                    global::System.Nullable<int> rGradeId, 
                    global::System.Nullable<int> rDesignationId, 
                    global::System.Nullable<int> rJobTitleId, 
                    global::System.Nullable<int> rEmployeeTypeId, 
                    global::System.Nullable<int> rCompanyId, 
                    global::System.Nullable<int> rContractorId, 
                    global::System.Nullable<short> rGenderId, 
                    global::System.Nullable<int> rStatusId, 
                    global::System.Nullable<int> rAgeFrom, 
                    global::System.Nullable<int> rAgeTo, 
                    global::System.Nullable<global::System.DateTime> rFromDate, 
                    global::System.Nullable<global::System.DateTime> rToDate, 
                    global::System.Nullable<int> rOrgId, 
                    string rEmployeeCode, 
                    global::System.Nullable<int> rEmployeeTypeGroupId, 
                    global::System.Nullable<int> rEmployeeSubTypeId, 
                    global::System.Nullable<int> rEmployeeGroupId, 
                    global::System.Nullable<int> rOtherTypeId, 
                    global::System.Nullable<long> rExaminationId) {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((rBuilder1 == null)) {
                this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[1].Value = ((string)(rBuilder1));
            }
            if ((rBuilder2 == null)) {
                this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[2].Value = ((string)(rBuilder2));
            }
            if ((rReportId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[3].Value = ((int)(rReportId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
            }
            if ((rStoreLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[4].Value = ((int)(rStoreLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
            }
            if ((rParticipantTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[5].Value = ((int)(rParticipantTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
            }
            if ((rCaseCauseId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[6].Value = ((int)(rCaseCauseId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
            }
            if ((rLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[7].Value = ((int)(rLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
            }
            if ((rFunctionId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[8].Value = ((int)(rFunctionId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[9].Value = ((int)(rDepartmentGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[10].Value = ((int)(rDepartmentId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
            }
            if ((rGradeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[11].Value = ((int)(rGradeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
            }
            if ((rDesignationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[12].Value = ((int)(rDesignationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
            }
            if ((rJobTitleId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[13].Value = ((int)(rJobTitleId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[14].Value = ((int)(rEmployeeTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
            }
            if ((rCompanyId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[15].Value = ((int)(rCompanyId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[15].Value = global::System.DBNull.Value;
            }
            if ((rContractorId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[16].Value = ((int)(rContractorId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[16].Value = global::System.DBNull.Value;
            }
            if ((rGenderId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[17].Value = ((short)(rGenderId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[17].Value = global::System.DBNull.Value;
            }
            if ((rStatusId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[18].Value = ((int)(rStatusId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[18].Value = global::System.DBNull.Value;
            }
            if ((rAgeFrom.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[19].Value = ((int)(rAgeFrom.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[19].Value = global::System.DBNull.Value;
            }
            if ((rAgeTo.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[20].Value = ((int)(rAgeTo.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[20].Value = global::System.DBNull.Value;
            }
            if ((rFromDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[21].Value = ((System.DateTime)(rFromDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[21].Value = global::System.DBNull.Value;
            }
            if ((rToDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[22].Value = ((System.DateTime)(rToDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[22].Value = global::System.DBNull.Value;
            }
            if ((rOrgId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[23].Value = ((int)(rOrgId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[23].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeCode == null)) {
                this.Adapter.SelectCommand.Parameters[24].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[24].Value = ((string)(rEmployeeCode));
            }
            if ((rEmployeeTypeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[25].Value = ((int)(rEmployeeTypeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[25].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeSubTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[26].Value = ((int)(rEmployeeSubTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[26].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[27].Value = ((int)(rEmployeeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[27].Value = global::System.DBNull.Value;
            }
            if ((rOtherTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[28].Value = ((int)(rOtherTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[28].Value = global::System.DBNull.Value;
            }
            if ((rExaminationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[29].Value = ((long)(rExaminationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[29].Value = global::System.DBNull.Value;
            }
            OPDPrescriptionListWithBatchNExpiry.pRptOPDPrescriptionListWithBatchNExpiryDataTable dataTable = new OPDPrescriptionListWithBatchNExpiry.pRptOPDPrescriptionListWithBatchNExpiryDataTable();
            this.Adapter.Fill(dataTable);
            return dataTable;
        }
    }
    
    /// <summary>
    ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
    ///</summary>
    [global::System.ComponentModel.DesignerCategoryAttribute("code")]
    [global::System.ComponentModel.ToolboxItem(true)]
    [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
        "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
    public partial class TableAdapterManager : global::System.ComponentModel.Component {
        
        private UpdateOrderOption _updateOrder;
        
        private bool _backupDataSetBeforeUpdate;
        
        private global::System.Data.IDbConnection _connection;
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public UpdateOrderOption UpdateOrder {
            get {
                return this._updateOrder;
            }
            set {
                this._updateOrder = value;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public bool BackupDataSetBeforeUpdate {
            get {
                return this._backupDataSetBeforeUpdate;
            }
            set {
                this._backupDataSetBeforeUpdate = value;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.Browsable(false)]
        public global::System.Data.IDbConnection Connection {
            get {
                if ((this._connection != null)) {
                    return this._connection;
                }
                return null;
            }
            set {
                this._connection = value;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        [global::System.ComponentModel.Browsable(false)]
        public int TableAdapterInstanceCount {
            get {
                int count = 0;
                return count;
            }
        }
        
        /// <summary>
        ///Update rows in top-down order.
        ///</summary>
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private int UpdateUpdatedRows(OPDPrescriptionListWithBatchNExpiry dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
            int result = 0;
            return result;
        }
        
        /// <summary>
        ///Insert rows in top-down order.
        ///</summary>
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private int UpdateInsertedRows(OPDPrescriptionListWithBatchNExpiry dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
            int result = 0;
            return result;
        }
        
        /// <summary>
        ///Delete rows in bottom-up order.
        ///</summary>
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private int UpdateDeletedRows(OPDPrescriptionListWithBatchNExpiry dataSet, global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows) {
            int result = 0;
            return result;
        }
        
        /// <summary>
        ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
        ///</summary>
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows) {
            if (((updatedRows == null) 
                        || (updatedRows.Length < 1))) {
                return updatedRows;
            }
            if (((allAddedRows == null) 
                        || (allAddedRows.Count < 1))) {
                return updatedRows;
            }
            global::System.Collections.Generic.List<global::System.Data.DataRow> realUpdatedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
            for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
                global::System.Data.DataRow row = updatedRows[i];
                if ((allAddedRows.Contains(row) == false)) {
                    realUpdatedRows.Add(row);
                }
            }
            return realUpdatedRows.ToArray();
        }
        
        /// <summary>
        ///Update all changes to the dataset.
        ///</summary>
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public virtual int UpdateAll(OPDPrescriptionListWithBatchNExpiry dataSet) {
            if ((dataSet == null)) {
                throw new global::System.ArgumentNullException("dataSet");
            }
            if ((dataSet.HasChanges() == false)) {
                return 0;
            }
            global::System.Data.IDbConnection workConnection = this.Connection;
            if ((workConnection == null)) {
                throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" +
                        "ger TableAdapter property to a valid TableAdapter instance.");
            }
            bool workConnOpened = false;
            if (((workConnection.State & global::System.Data.ConnectionState.Broken) 
                        == global::System.Data.ConnectionState.Broken)) {
                workConnection.Close();
            }
            if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
                workConnection.Open();
                workConnOpened = true;
            }
            global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
            if ((workTransaction == null)) {
                throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" +
                        "ctions or the current state is not allowing the transaction to begin.");
            }
            global::System.Collections.Generic.List<global::System.Data.DataRow> allChangedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
            global::System.Collections.Generic.List<global::System.Data.DataRow> allAddedRows = new global::System.Collections.Generic.List<global::System.Data.DataRow>();
            global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter> adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List<global::System.Data.Common.DataAdapter>();
            global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection> revertConnections = new global::System.Collections.Generic.Dictionary<object, global::System.Data.IDbConnection>();
            int result = 0;
            global::System.Data.DataSet backupDataSet = null;
            if (this.BackupDataSetBeforeUpdate) {
                backupDataSet = new global::System.Data.DataSet();
                backupDataSet.Merge(dataSet);
            }
            try {
                // ---- Prepare for update -----------
                //
                // 
                //---- Perform updates -----------
                //
                if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) {
                    result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
                    result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
                }
                else {
                    result = (result + this.UpdateInsertedRows(dataSet, allAddedRows));
                    result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows));
                }
                result = (result + this.UpdateDeletedRows(dataSet, allChangedRows));
                // 
                //---- Commit updates -----------
                //
                workTransaction.Commit();
                if ((0 < allAddedRows.Count)) {
                    global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
                    allAddedRows.CopyTo(rows);
                    for (int i = 0; (i < rows.Length); i = (i + 1)) {
                        global::System.Data.DataRow row = rows[i];
                        row.AcceptChanges();
                    }
                }
                if ((0 < allChangedRows.Count)) {
                    global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count];
                    allChangedRows.CopyTo(rows);
                    for (int i = 0; (i < rows.Length); i = (i + 1)) {
                        global::System.Data.DataRow row = rows[i];
                        row.AcceptChanges();
                    }
                }
            }
            catch (global::System.Exception ex) {
                workTransaction.Rollback();
                // ---- Restore the dataset -----------
                if (this.BackupDataSetBeforeUpdate) {
                    global::System.Diagnostics.Debug.Assert((backupDataSet != null));
                    dataSet.Clear();
                    dataSet.Merge(backupDataSet);
                }
                else {
                    if ((0 < allAddedRows.Count)) {
                        global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count];
                        allAddedRows.CopyTo(rows);
                        for (int i = 0; (i < rows.Length); i = (i + 1)) {
                            global::System.Data.DataRow row = rows[i];
                            row.AcceptChanges();
                            row.SetAdded();
                        }
                    }
                }
                throw ex;
            }
            finally {
                if (workConnOpened) {
                    workConnection.Close();
                }
                if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) {
                    global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count];
                    adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters);
                    for (int i = 0; (i < adapters.Length); i = (i + 1)) {
                        global::System.Data.Common.DataAdapter adapter = adapters[i];
                        adapter.AcceptChangesDuringUpdate = true;
                    }
                }
            }
            return result;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) {
            global::System.Array.Sort<global::System.Data.DataRow>(rows, new SelfReferenceComparer(relation, childFirst));
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) {
            if ((this._connection != null)) {
                return true;
            }
            if (((this.Connection == null) 
                        || (inputConnection == null))) {
                return true;
            }
            if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) {
                return true;
            }
            return false;
        }
        
        /// <summary>
        ///Update Order Option
        ///</summary>
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        public enum UpdateOrderOption {
            
            InsertUpdateDelete = 0,
            
            UpdateInsertDelete = 1,
        }
        
        /// <summary>
        ///Used to sort self-referenced table's rows
        ///</summary>
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
        private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer<global::System.Data.DataRow> {
            
            private global::System.Data.DataRelation _relation;
            
            private int _childFirst;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) {
                this._relation = relation;
                if (childFirst) {
                    this._childFirst = -1;
                }
                else {
                    this._childFirst = 1;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) {
                global::System.Diagnostics.Debug.Assert((row != null));
                global::System.Data.DataRow root = row;
                distance = 0;

                global::System.Collections.Generic.IDictionary<global::System.Data.DataRow, global::System.Data.DataRow> traversedRows = new global::System.Collections.Generic.Dictionary<global::System.Data.DataRow, global::System.Data.DataRow>();
                traversedRows[row] = row;

                global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
                for (
                ; ((parent != null) 
                            && (traversedRows.ContainsKey(parent) == false)); 
                ) {
                    distance = (distance + 1);
                    root = parent;
                    traversedRows[parent] = parent;
                    parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default);
                }

                if ((distance == 0)) {
                    traversedRows.Clear();
                    traversedRows[row] = row;
                    parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
                    for (
                    ; ((parent != null) 
                                && (traversedRows.ContainsKey(parent) == false)); 
                    ) {
                        distance = (distance + 1);
                        root = parent;
                        traversedRows[parent] = parent;
                        parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original);
                    }
                }

                return root;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "16.0.0.0")]
            public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) {
                if (object.ReferenceEquals(row1, row2)) {
                    return 0;
                }
                if ((row1 == null)) {
                    return -1;
                }
                if ((row2 == null)) {
                    return 1;
                }

                int distance1 = 0;
                global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1);

                int distance2 = 0;
                global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2);

                if (object.ReferenceEquals(root1, root2)) {
                    return (this._childFirst * distance1.CompareTo(distance2));
                }
                else {
                    global::System.Diagnostics.Debug.Assert(((root1.Table != null) 
                                    && (root2.Table != null)));
                    if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) {
                        return -1;
                    }
                    else {
                        return 1;
                    }
                }
            }
        }
    }
}

#pragma warning restore 1591