//------------------------------------------------------------------------------
// <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 Sapphire.Ohu.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("HealthCardFull")]
    [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
    public partial class HealthCardFull : global::System.Data.DataSet {
        
        private pRptFullHealthCardGetDataTable tablepRptFullHealthCardGet;
        
        private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
        public HealthCardFull() {
            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", "4.0.0.0")]
        protected HealthCardFull(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["pRptFullHealthCardGet"] != null)) {
                    base.Tables.Add(new pRptFullHealthCardGetDataTable(ds.Tables["pRptFullHealthCardGet"]));
                }
                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", "4.0.0.0")]
        [global::System.ComponentModel.Browsable(false)]
        [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
        public pRptFullHealthCardGetDataTable pRptFullHealthCardGet {
            get {
                return this.tablepRptFullHealthCardGet;
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.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", "4.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", "4.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", "4.0.0.0")]
        public override global::System.Data.DataSet Clone() {
            HealthCardFull cln = ((HealthCardFull)(base.Clone()));
            cln.InitVars();
            cln.SchemaSerializationMode = this.SchemaSerializationMode;
            return cln;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
        protected override bool ShouldSerializeTables() {
            return false;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
        protected override bool ShouldSerializeRelations() {
            return false;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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["pRptFullHealthCardGet"] != null)) {
                    base.Tables.Add(new pRptFullHealthCardGetDataTable(ds.Tables["pRptFullHealthCardGet"]));
                }
                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", "4.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", "4.0.0.0")]
        internal void InitVars() {
            this.InitVars(true);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
        internal void InitVars(bool initTable) {
            this.tablepRptFullHealthCardGet = ((pRptFullHealthCardGetDataTable)(base.Tables["pRptFullHealthCardGet"]));
            if ((initTable == true)) {
                if ((this.tablepRptFullHealthCardGet != null)) {
                    this.tablepRptFullHealthCardGet.InitVars();
                }
            }
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
        private void InitClass() {
            this.DataSetName = "HealthCardFull";
            this.Prefix = "";
            this.Namespace = "http://tempuri.org/HealthCardFull.xsd";
            this.EnforceConstraints = true;
            this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
            this.tablepRptFullHealthCardGet = new pRptFullHealthCardGetDataTable();
            base.Tables.Add(this.tablepRptFullHealthCardGet);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
        private bool ShouldSerializepRptFullHealthCardGet() {
            return false;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.0.0.0")]
        public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
            HealthCardFull ds = new HealthCardFull();
            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", "4.0.0.0")]
        public delegate void pRptFullHealthCardGetRowChangeEventHandler(object sender, pRptFullHealthCardGetRowChangeEvent e);
        
        /// <summary>
        ///Represents the strongly named DataTable class.
        ///</summary>
        [global::System.Serializable()]
        [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
        public partial class pRptFullHealthCardGetDataTable : global::System.Data.TypedTableBase<pRptFullHealthCardGetRow> {
            
            private global::System.Data.DataColumn columnExaminationId;
            
            private global::System.Data.DataColumn columnExaminationIdText;
            
            private global::System.Data.DataColumn columnCode;
            
            private global::System.Data.DataColumn columnEmployeeName;
            
            private global::System.Data.DataColumn columnExaminationDate;
            
            private global::System.Data.DataColumn columnExDate;
            
            private global::System.Data.DataColumn columnEmployeeType;
            
            private global::System.Data.DataColumn columnMainTypeId;
            
            private global::System.Data.DataColumn columnRoundName;
            
            private global::System.Data.DataColumn columnDepartment;
            
            private global::System.Data.DataColumn columnDesignation;
            
            private global::System.Data.DataColumn columnBloodGroup;
            
            private global::System.Data.DataColumn columnAge;
            
            private global::System.Data.DataColumn columnHeight;
            
            private global::System.Data.DataColumn columnWeight;
            
            private global::System.Data.DataColumn columnBMI;
            
            private global::System.Data.DataColumn columnGender;
            
            private global::System.Data.DataColumn columnRoundName1;
            
            private global::System.Data.DataColumn columnDiagnosisRemark;
            
            private global::System.Data.DataColumn columnRecommendationEnglish;
            
            private global::System.Data.DataColumn columnDisease;
            
            private global::System.Data.DataColumn columnHistory;
            
            private global::System.Data.DataColumn columnAllergy;
            
            private global::System.Data.DataColumn columnFamilyHistory;
            
            private global::System.Data.DataColumn columnHabit;
            
            private global::System.Data.DataColumn columnDateOfBirth;
            
            private global::System.Data.DataColumn columnDepartmentName;
            
            private global::System.Data.DataColumn columnBloodPressureSystolic;
            
            private global::System.Data.DataColumn columnBloodPressureDiastolic;
            
            private global::System.Data.DataColumn columnPulse;
            
            private global::System.Data.DataColumn columnRespiration;
            
            private global::System.Data.DataColumn columnRemark;
            
            private global::System.Data.DataColumn columnCode1;
            
            private global::System.Data.DataColumn columnTitle;
            
            private global::System.Data.DataColumn columnParentCompanyName;
            
            private global::System.Data.DataColumn columnFirstLine;
            
            private global::System.Data.DataColumn columnFourthLine;
            
            private global::System.Data.DataColumn columnStreetOne;
            
            private global::System.Data.DataColumn columnStreetTwo;
            
            private global::System.Data.DataColumn columnStreetThree;
            
            private global::System.Data.DataColumn columnStreetFour;
            
            private global::System.Data.DataColumn columnCityName;
            
            private global::System.Data.DataColumn columnStateName;
            
            private global::System.Data.DataColumn columnReportTitle;
            
            private global::System.Data.DataColumn columnLogo;
            
            private global::System.Data.DataColumn columnCompanyTitle;
            
            private global::System.Data.DataColumn columnCompanyAddressOne;
            
            private global::System.Data.DataColumn columnCompanyAddressTwo;
            
            private global::System.Data.DataColumn columnCompanyAddressThree;
            
            private global::System.Data.DataColumn columnCompanyCityName;
            
            private global::System.Data.DataColumn columnCompanyStateNAme;
            
            private global::System.Data.DataColumn columnCompanyCountryName;
            
            private global::System.Data.DataColumn columnCompanyZipCode;
            
            private global::System.Data.DataColumn columnCompanyPhoneNo;
            
            private global::System.Data.DataColumn columnFVCObserved;
            
            private global::System.Data.DataColumn columnFEV1Observed;
            
            private global::System.Data.DataColumn columnMVVObserved;
            
            private global::System.Data.DataColumn columnPFRObserved;
            
            private global::System.Data.DataColumn columnSurgeryRemark;
            
            private global::System.Data.DataColumn columnLocation;
            
            private global::System.Data.DataColumn columnAcRightDB;
            
            private global::System.Data.DataColumn columnAcLeftDB;
            
            private global::System.Data.DataColumn columnLeftResult;
            
            private global::System.Data.DataColumn columnRightResult;
            
            private global::System.Data.DataColumn columnEmployeeCompanyTitle;
            
            private global::System.Data.DataColumn columnTodayDate;
            
            private global::System.Data.DataColumn columnFitUnfitStatus;
            
            private global::System.Data.DataColumn columnDoctorSignature;
            
            private global::System.Data.DataColumn columnTemperature;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public pRptFullHealthCardGetDataTable() {
                this.TableName = "pRptFullHealthCardGet";
                this.BeginInit();
                this.InitClass();
                this.EndInit();
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            internal pRptFullHealthCardGetDataTable(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", "4.0.0.0")]
            protected pRptFullHealthCardGetDataTable(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", "4.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", "4.0.0.0")]
            public global::System.Data.DataColumn ExaminationIdTextColumn {
                get {
                    return this.columnExaminationIdText;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CodeColumn {
                get {
                    return this.columnCode;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn EmployeeNameColumn {
                get {
                    return this.columnEmployeeName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.0.0.0")]
            public global::System.Data.DataColumn ExDateColumn {
                get {
                    return this.columnExDate;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn EmployeeTypeColumn {
                get {
                    return this.columnEmployeeType;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn MainTypeIdColumn {
                get {
                    return this.columnMainTypeId;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn RoundNameColumn {
                get {
                    return this.columnRoundName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn DepartmentColumn {
                get {
                    return this.columnDepartment;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn DesignationColumn {
                get {
                    return this.columnDesignation;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn BloodGroupColumn {
                get {
                    return this.columnBloodGroup;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.0.0.0")]
            public global::System.Data.DataColumn HeightColumn {
                get {
                    return this.columnHeight;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn WeightColumn {
                get {
                    return this.columnWeight;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn BMIColumn {
                get {
                    return this.columnBMI;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.0.0.0")]
            public global::System.Data.DataColumn RoundName1Column {
                get {
                    return this.columnRoundName1;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn DiagnosisRemarkColumn {
                get {
                    return this.columnDiagnosisRemark;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn RecommendationEnglishColumn {
                get {
                    return this.columnRecommendationEnglish;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn DiseaseColumn {
                get {
                    return this.columnDisease;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn HistoryColumn {
                get {
                    return this.columnHistory;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn AllergyColumn {
                get {
                    return this.columnAllergy;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn FamilyHistoryColumn {
                get {
                    return this.columnFamilyHistory;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn HabitColumn {
                get {
                    return this.columnHabit;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn DateOfBirthColumn {
                get {
                    return this.columnDateOfBirth;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.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", "4.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", "4.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", "4.0.0.0")]
            public global::System.Data.DataColumn RespirationColumn {
                get {
                    return this.columnRespiration;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn RemarkColumn {
                get {
                    return this.columnRemark;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn Code1Column {
                get {
                    return this.columnCode1;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn TitleColumn {
                get {
                    return this.columnTitle;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn ParentCompanyNameColumn {
                get {
                    return this.columnParentCompanyName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn FirstLineColumn {
                get {
                    return this.columnFirstLine;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn FourthLineColumn {
                get {
                    return this.columnFourthLine;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn StreetOneColumn {
                get {
                    return this.columnStreetOne;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn StreetTwoColumn {
                get {
                    return this.columnStreetTwo;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn StreetThreeColumn {
                get {
                    return this.columnStreetThree;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn StreetFourColumn {
                get {
                    return this.columnStreetFour;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CityNameColumn {
                get {
                    return this.columnCityName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn StateNameColumn {
                get {
                    return this.columnStateName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn ReportTitleColumn {
                get {
                    return this.columnReportTitle;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyTitleColumn {
                get {
                    return this.columnCompanyTitle;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyAddressOneColumn {
                get {
                    return this.columnCompanyAddressOne;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyAddressTwoColumn {
                get {
                    return this.columnCompanyAddressTwo;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyAddressThreeColumn {
                get {
                    return this.columnCompanyAddressThree;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyCityNameColumn {
                get {
                    return this.columnCompanyCityName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyStateNAmeColumn {
                get {
                    return this.columnCompanyStateNAme;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyCountryNameColumn {
                get {
                    return this.columnCompanyCountryName;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyZipCodeColumn {
                get {
                    return this.columnCompanyZipCode;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn CompanyPhoneNoColumn {
                get {
                    return this.columnCompanyPhoneNo;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn FVCObservedColumn {
                get {
                    return this.columnFVCObserved;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn FEV1ObservedColumn {
                get {
                    return this.columnFEV1Observed;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn MVVObservedColumn {
                get {
                    return this.columnMVVObserved;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn PFRObservedColumn {
                get {
                    return this.columnPFRObserved;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn SurgeryRemarkColumn {
                get {
                    return this.columnSurgeryRemark;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn LocationColumn {
                get {
                    return this.columnLocation;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn AcRightDBColumn {
                get {
                    return this.columnAcRightDB;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn AcLeftDBColumn {
                get {
                    return this.columnAcLeftDB;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn LeftResultColumn {
                get {
                    return this.columnLeftResult;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn RightResultColumn {
                get {
                    return this.columnRightResult;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn EmployeeCompanyTitleColumn {
                get {
                    return this.columnEmployeeCompanyTitle;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn TodayDateColumn {
                get {
                    return this.columnTodayDate;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataColumn FitUnfitStatusColumn {
                get {
                    return this.columnFitUnfitStatus;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.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", "4.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", "4.0.0.0")]
            public pRptFullHealthCardGetRow this[int index] {
                get {
                    return ((pRptFullHealthCardGetRow)(this.Rows[index]));
                }
            }
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public event pRptFullHealthCardGetRowChangeEventHandler pRptFullHealthCardGetRowChanging;
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public event pRptFullHealthCardGetRowChangeEventHandler pRptFullHealthCardGetRowChanged;
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public event pRptFullHealthCardGetRowChangeEventHandler pRptFullHealthCardGetRowDeleting;
            
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public event pRptFullHealthCardGetRowChangeEventHandler pRptFullHealthCardGetRowDeleted;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void AddpRptFullHealthCardGetRow(pRptFullHealthCardGetRow row) {
                this.Rows.Add(row);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public pRptFullHealthCardGetRow AddpRptFullHealthCardGetRow(
                        long ExaminationId, 
                        string ExaminationIdText, 
                        string Code, 
                        string EmployeeName, 
                        System.DateTime ExaminationDate, 
                        string ExDate, 
                        string EmployeeType, 
                        byte MainTypeId, 
                        string RoundName, 
                        string Department, 
                        string Designation, 
                        string BloodGroup, 
                        int Age, 
                        int Height, 
                        decimal Weight, 
                        decimal BMI, 
                        string Gender, 
                        string RoundName1, 
                        string DiagnosisRemark, 
                        string RecommendationEnglish, 
                        string Disease, 
                        string History, 
                        string Allergy, 
                        string FamilyHistory, 
                        string Habit, 
                        System.DateTime DateOfBirth, 
                        string DepartmentName, 
                        int BloodPressureSystolic, 
                        short BloodPressureDiastolic, 
                        short Pulse, 
                        int Respiration, 
                        string Remark, 
                        string Code1, 
                        string Title, 
                        string ParentCompanyName, 
                        string FirstLine, 
                        string FourthLine, 
                        string StreetOne, 
                        string StreetTwo, 
                        string StreetThree, 
                        string StreetFour, 
                        string CityName, 
                        string StateName, 
                        string ReportTitle, 
                        byte[] Logo, 
                        string CompanyTitle, 
                        string CompanyAddressOne, 
                        string CompanyAddressTwo, 
                        string CompanyAddressThree, 
                        string CompanyCityName, 
                        string CompanyStateNAme, 
                        string CompanyCountryName, 
                        string CompanyZipCode, 
                        string CompanyPhoneNo, 
                        decimal FVCObserved, 
                        decimal FEV1Observed, 
                        decimal MVVObserved, 
                        decimal PFRObserved, 
                        string SurgeryRemark, 
                        string Location, 
                        decimal AcRightDB, 
                        decimal AcLeftDB, 
                        string LeftResult, 
                        string RightResult, 
                        string EmployeeCompanyTitle, 
                        System.DateTime TodayDate, 
                        string FitUnfitStatus, 
                        byte[] DoctorSignature, 
                        decimal Temperature) {
                pRptFullHealthCardGetRow rowpRptFullHealthCardGetRow = ((pRptFullHealthCardGetRow)(this.NewRow()));
                object[] columnValuesArray = new object[] {
                        ExaminationId,
                        ExaminationIdText,
                        Code,
                        EmployeeName,
                        ExaminationDate,
                        ExDate,
                        EmployeeType,
                        MainTypeId,
                        RoundName,
                        Department,
                        Designation,
                        BloodGroup,
                        Age,
                        Height,
                        Weight,
                        BMI,
                        Gender,
                        RoundName1,
                        DiagnosisRemark,
                        RecommendationEnglish,
                        Disease,
                        History,
                        Allergy,
                        FamilyHistory,
                        Habit,
                        DateOfBirth,
                        DepartmentName,
                        BloodPressureSystolic,
                        BloodPressureDiastolic,
                        Pulse,
                        Respiration,
                        Remark,
                        Code1,
                        Title,
                        ParentCompanyName,
                        FirstLine,
                        FourthLine,
                        StreetOne,
                        StreetTwo,
                        StreetThree,
                        StreetFour,
                        CityName,
                        StateName,
                        ReportTitle,
                        Logo,
                        CompanyTitle,
                        CompanyAddressOne,
                        CompanyAddressTwo,
                        CompanyAddressThree,
                        CompanyCityName,
                        CompanyStateNAme,
                        CompanyCountryName,
                        CompanyZipCode,
                        CompanyPhoneNo,
                        FVCObserved,
                        FEV1Observed,
                        MVVObserved,
                        PFRObserved,
                        SurgeryRemark,
                        Location,
                        AcRightDB,
                        AcLeftDB,
                        LeftResult,
                        RightResult,
                        EmployeeCompanyTitle,
                        TodayDate,
                        FitUnfitStatus,
                        DoctorSignature,
                        Temperature};
                rowpRptFullHealthCardGetRow.ItemArray = columnValuesArray;
                this.Rows.Add(rowpRptFullHealthCardGetRow);
                return rowpRptFullHealthCardGetRow;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public override global::System.Data.DataTable Clone() {
                pRptFullHealthCardGetDataTable cln = ((pRptFullHealthCardGetDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            protected override global::System.Data.DataTable CreateInstance() {
                return new pRptFullHealthCardGetDataTable();
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            internal void InitVars() {
                this.columnExaminationId = base.Columns["ExaminationId"];
                this.columnExaminationIdText = base.Columns["ExaminationIdText"];
                this.columnCode = base.Columns["Code"];
                this.columnEmployeeName = base.Columns["EmployeeName"];
                this.columnExaminationDate = base.Columns["ExaminationDate"];
                this.columnExDate = base.Columns["ExDate"];
                this.columnEmployeeType = base.Columns["EmployeeType"];
                this.columnMainTypeId = base.Columns["MainTypeId"];
                this.columnRoundName = base.Columns["RoundName"];
                this.columnDepartment = base.Columns["Department"];
                this.columnDesignation = base.Columns["Designation"];
                this.columnBloodGroup = base.Columns["BloodGroup"];
                this.columnAge = base.Columns["Age"];
                this.columnHeight = base.Columns["Height"];
                this.columnWeight = base.Columns["Weight"];
                this.columnBMI = base.Columns["BMI"];
                this.columnGender = base.Columns["Gender"];
                this.columnRoundName1 = base.Columns["RoundName1"];
                this.columnDiagnosisRemark = base.Columns["DiagnosisRemark"];
                this.columnRecommendationEnglish = base.Columns["RecommendationEnglish"];
                this.columnDisease = base.Columns["Disease"];
                this.columnHistory = base.Columns["History"];
                this.columnAllergy = base.Columns["Allergy"];
                this.columnFamilyHistory = base.Columns["FamilyHistory"];
                this.columnHabit = base.Columns["Habit"];
                this.columnDateOfBirth = base.Columns["DateOfBirth"];
                this.columnDepartmentName = base.Columns["DepartmentName"];
                this.columnBloodPressureSystolic = base.Columns["BloodPressureSystolic"];
                this.columnBloodPressureDiastolic = base.Columns["BloodPressureDiastolic"];
                this.columnPulse = base.Columns["Pulse"];
                this.columnRespiration = base.Columns["Respiration"];
                this.columnRemark = base.Columns["Remark"];
                this.columnCode1 = base.Columns["Code1"];
                this.columnTitle = base.Columns["Title"];
                this.columnParentCompanyName = base.Columns["ParentCompanyName"];
                this.columnFirstLine = base.Columns["FirstLine"];
                this.columnFourthLine = base.Columns["FourthLine"];
                this.columnStreetOne = base.Columns["StreetOne"];
                this.columnStreetTwo = base.Columns["StreetTwo"];
                this.columnStreetThree = base.Columns["StreetThree"];
                this.columnStreetFour = base.Columns["StreetFour"];
                this.columnCityName = base.Columns["CityName"];
                this.columnStateName = base.Columns["StateName"];
                this.columnReportTitle = base.Columns["ReportTitle"];
                this.columnLogo = base.Columns["Logo"];
                this.columnCompanyTitle = base.Columns["CompanyTitle"];
                this.columnCompanyAddressOne = base.Columns["CompanyAddressOne"];
                this.columnCompanyAddressTwo = base.Columns["CompanyAddressTwo"];
                this.columnCompanyAddressThree = base.Columns["CompanyAddressThree"];
                this.columnCompanyCityName = base.Columns["CompanyCityName"];
                this.columnCompanyStateNAme = base.Columns["CompanyStateNAme"];
                this.columnCompanyCountryName = base.Columns["CompanyCountryName"];
                this.columnCompanyZipCode = base.Columns["CompanyZipCode"];
                this.columnCompanyPhoneNo = base.Columns["CompanyPhoneNo"];
                this.columnFVCObserved = base.Columns["FVCObserved"];
                this.columnFEV1Observed = base.Columns["FEV1Observed"];
                this.columnMVVObserved = base.Columns["MVVObserved"];
                this.columnPFRObserved = base.Columns["PFRObserved"];
                this.columnSurgeryRemark = base.Columns["SurgeryRemark"];
                this.columnLocation = base.Columns["Location"];
                this.columnAcRightDB = base.Columns["AcRightDB"];
                this.columnAcLeftDB = base.Columns["AcLeftDB"];
                this.columnLeftResult = base.Columns["LeftResult"];
                this.columnRightResult = base.Columns["RightResult"];
                this.columnEmployeeCompanyTitle = base.Columns["EmployeeCompanyTitle"];
                this.columnTodayDate = base.Columns["TodayDate"];
                this.columnFitUnfitStatus = base.Columns["FitUnfitStatus"];
                this.columnDoctorSignature = base.Columns["DoctorSignature"];
                this.columnTemperature = base.Columns["Temperature"];
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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.columnExaminationIdText = new global::System.Data.DataColumn("ExaminationIdText", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnExaminationIdText);
                this.columnCode = new global::System.Data.DataColumn("Code", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCode);
                this.columnEmployeeName = new global::System.Data.DataColumn("EmployeeName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnEmployeeName);
                this.columnExaminationDate = new global::System.Data.DataColumn("ExaminationDate", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnExaminationDate);
                this.columnExDate = new global::System.Data.DataColumn("ExDate", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnExDate);
                this.columnEmployeeType = new global::System.Data.DataColumn("EmployeeType", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnEmployeeType);
                this.columnMainTypeId = new global::System.Data.DataColumn("MainTypeId", typeof(byte), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnMainTypeId);
                this.columnRoundName = new global::System.Data.DataColumn("RoundName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRoundName);
                this.columnDepartment = new global::System.Data.DataColumn("Department", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDepartment);
                this.columnDesignation = new global::System.Data.DataColumn("Designation", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDesignation);
                this.columnBloodGroup = new global::System.Data.DataColumn("BloodGroup", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnBloodGroup);
                this.columnAge = new global::System.Data.DataColumn("Age", typeof(int), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnAge);
                this.columnHeight = new global::System.Data.DataColumn("Height", typeof(int), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnHeight);
                this.columnWeight = new global::System.Data.DataColumn("Weight", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnWeight);
                this.columnBMI = new global::System.Data.DataColumn("BMI", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnBMI);
                this.columnGender = new global::System.Data.DataColumn("Gender", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnGender);
                this.columnRoundName1 = new global::System.Data.DataColumn("RoundName1", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRoundName1);
                this.columnDiagnosisRemark = new global::System.Data.DataColumn("DiagnosisRemark", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDiagnosisRemark);
                this.columnRecommendationEnglish = new global::System.Data.DataColumn("RecommendationEnglish", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRecommendationEnglish);
                this.columnDisease = new global::System.Data.DataColumn("Disease", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDisease);
                this.columnHistory = new global::System.Data.DataColumn("History", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnHistory);
                this.columnAllergy = new global::System.Data.DataColumn("Allergy", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnAllergy);
                this.columnFamilyHistory = new global::System.Data.DataColumn("FamilyHistory", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnFamilyHistory);
                this.columnHabit = new global::System.Data.DataColumn("Habit", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnHabit);
                this.columnDateOfBirth = new global::System.Data.DataColumn("DateOfBirth", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDateOfBirth);
                this.columnDepartmentName = new global::System.Data.DataColumn("DepartmentName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDepartmentName);
                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.columnPulse = new global::System.Data.DataColumn("Pulse", typeof(short), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnPulse);
                this.columnRespiration = new global::System.Data.DataColumn("Respiration", typeof(int), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRespiration);
                this.columnRemark = new global::System.Data.DataColumn("Remark", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRemark);
                this.columnCode1 = new global::System.Data.DataColumn("Code1", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCode1);
                this.columnTitle = new global::System.Data.DataColumn("Title", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnTitle);
                this.columnParentCompanyName = new global::System.Data.DataColumn("ParentCompanyName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnParentCompanyName);
                this.columnFirstLine = new global::System.Data.DataColumn("FirstLine", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnFirstLine);
                this.columnFourthLine = new global::System.Data.DataColumn("FourthLine", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnFourthLine);
                this.columnStreetOne = new global::System.Data.DataColumn("StreetOne", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnStreetOne);
                this.columnStreetTwo = new global::System.Data.DataColumn("StreetTwo", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnStreetTwo);
                this.columnStreetThree = new global::System.Data.DataColumn("StreetThree", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnStreetThree);
                this.columnStreetFour = new global::System.Data.DataColumn("StreetFour", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnStreetFour);
                this.columnCityName = new global::System.Data.DataColumn("CityName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCityName);
                this.columnStateName = new global::System.Data.DataColumn("StateName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnStateName);
                this.columnReportTitle = new global::System.Data.DataColumn("ReportTitle", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnReportTitle);
                this.columnLogo = new global::System.Data.DataColumn("Logo", typeof(byte[]), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnLogo);
                this.columnCompanyTitle = new global::System.Data.DataColumn("CompanyTitle", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyTitle);
                this.columnCompanyAddressOne = new global::System.Data.DataColumn("CompanyAddressOne", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyAddressOne);
                this.columnCompanyAddressTwo = new global::System.Data.DataColumn("CompanyAddressTwo", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyAddressTwo);
                this.columnCompanyAddressThree = new global::System.Data.DataColumn("CompanyAddressThree", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyAddressThree);
                this.columnCompanyCityName = new global::System.Data.DataColumn("CompanyCityName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyCityName);
                this.columnCompanyStateNAme = new global::System.Data.DataColumn("CompanyStateNAme", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyStateNAme);
                this.columnCompanyCountryName = new global::System.Data.DataColumn("CompanyCountryName", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyCountryName);
                this.columnCompanyZipCode = new global::System.Data.DataColumn("CompanyZipCode", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyZipCode);
                this.columnCompanyPhoneNo = new global::System.Data.DataColumn("CompanyPhoneNo", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnCompanyPhoneNo);
                this.columnFVCObserved = new global::System.Data.DataColumn("FVCObserved", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnFVCObserved);
                this.columnFEV1Observed = new global::System.Data.DataColumn("FEV1Observed", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnFEV1Observed);
                this.columnMVVObserved = new global::System.Data.DataColumn("MVVObserved", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnMVVObserved);
                this.columnPFRObserved = new global::System.Data.DataColumn("PFRObserved", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnPFRObserved);
                this.columnSurgeryRemark = new global::System.Data.DataColumn("SurgeryRemark", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnSurgeryRemark);
                this.columnLocation = new global::System.Data.DataColumn("Location", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnLocation);
                this.columnAcRightDB = new global::System.Data.DataColumn("AcRightDB", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnAcRightDB);
                this.columnAcLeftDB = new global::System.Data.DataColumn("AcLeftDB", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnAcLeftDB);
                this.columnLeftResult = new global::System.Data.DataColumn("LeftResult", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnLeftResult);
                this.columnRightResult = new global::System.Data.DataColumn("RightResult", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnRightResult);
                this.columnEmployeeCompanyTitle = new global::System.Data.DataColumn("EmployeeCompanyTitle", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnEmployeeCompanyTitle);
                this.columnTodayDate = new global::System.Data.DataColumn("TodayDate", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnTodayDate);
                this.columnFitUnfitStatus = new global::System.Data.DataColumn("FitUnfitStatus", typeof(string), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnFitUnfitStatus);
                this.columnDoctorSignature = new global::System.Data.DataColumn("DoctorSignature", typeof(byte[]), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnDoctorSignature);
                this.columnTemperature = new global::System.Data.DataColumn("Temperature", typeof(decimal), null, global::System.Data.MappingType.Element);
                base.Columns.Add(this.columnTemperature);
                this.columnExaminationId.AllowDBNull = false;
                this.columnExaminationIdText.ReadOnly = true;
                this.columnExaminationIdText.MaxLength = 50;
                this.columnCode.ReadOnly = true;
                this.columnCode.MaxLength = 20;
                this.columnEmployeeName.ReadOnly = true;
                this.columnEmployeeName.MaxLength = 302;
                this.columnExaminationDate.AllowDBNull = false;
                this.columnExDate.ReadOnly = true;
                this.columnExDate.MaxLength = 10;
                this.columnEmployeeType.AllowDBNull = false;
                this.columnEmployeeType.MaxLength = 100;
                this.columnMainTypeId.AllowDBNull = false;
                this.columnRoundName.ReadOnly = true;
                this.columnRoundName.MaxLength = 115;
                this.columnDepartment.MaxLength = 100;
                this.columnDesignation.ReadOnly = true;
                this.columnDesignation.MaxLength = 100;
                this.columnBloodGroup.ReadOnly = true;
                this.columnBloodGroup.MaxLength = 20;
                this.columnAge.ReadOnly = true;
                this.columnGender.ReadOnly = true;
                this.columnGender.MaxLength = 20;
                this.columnRoundName1.AllowDBNull = false;
                this.columnRoundName1.MaxLength = 100;
                this.columnDiagnosisRemark.MaxLength = 2000;
                this.columnRecommendationEnglish.MaxLength = 2000;
                this.columnDisease.ReadOnly = true;
                this.columnDisease.MaxLength = 1000;
                this.columnHistory.ReadOnly = true;
                this.columnHistory.MaxLength = 2147483647;
                this.columnAllergy.ReadOnly = true;
                this.columnAllergy.MaxLength = 2147483647;
                this.columnFamilyHistory.ReadOnly = true;
                this.columnFamilyHistory.MaxLength = 2147483647;
                this.columnHabit.ReadOnly = true;
                this.columnHabit.MaxLength = 1000;
                this.columnDateOfBirth.ReadOnly = true;
                this.columnDepartmentName.MaxLength = 100;
                this.columnRemark.MaxLength = 300;
                this.columnCode1.AllowDBNull = false;
                this.columnCode1.MaxLength = 20;
                this.columnTitle.AllowDBNull = false;
                this.columnTitle.MaxLength = 300;
                this.columnParentCompanyName.MaxLength = 300;
                this.columnFirstLine.ReadOnly = true;
                this.columnFirstLine.MaxLength = 152;
                this.columnFourthLine.ReadOnly = true;
                this.columnFourthLine.MaxLength = 109;
                this.columnStreetOne.MaxLength = 50;
                this.columnStreetTwo.MaxLength = 50;
                this.columnStreetThree.MaxLength = 50;
                this.columnStreetFour.MaxLength = 50;
                this.columnCityName.MaxLength = 100;
                this.columnStateName.MaxLength = 100;
                this.columnReportTitle.ReadOnly = true;
                this.columnReportTitle.MaxLength = 100;
                this.columnCompanyTitle.AllowDBNull = false;
                this.columnCompanyTitle.MaxLength = 300;
                this.columnCompanyAddressOne.MaxLength = 50;
                this.columnCompanyAddressTwo.MaxLength = 50;
                this.columnCompanyAddressThree.MaxLength = 50;
                this.columnCompanyCityName.MaxLength = 100;
                this.columnCompanyStateNAme.MaxLength = 100;
                this.columnCompanyCountryName.MaxLength = 100;
                this.columnCompanyZipCode.MaxLength = 20;
                this.columnCompanyPhoneNo.MaxLength = 50;
                this.columnSurgeryRemark.MaxLength = 2147483647;
                this.columnLocation.AllowDBNull = false;
                this.columnLocation.MaxLength = 300;
                this.columnLeftResult.ReadOnly = true;
                this.columnLeftResult.MaxLength = 100;
                this.columnRightResult.ReadOnly = true;
                this.columnRightResult.MaxLength = 100;
                this.columnEmployeeCompanyTitle.ReadOnly = true;
                this.columnEmployeeCompanyTitle.MaxLength = 100;
                this.columnTodayDate.ReadOnly = true;
                this.columnFitUnfitStatus.ReadOnly = true;
                this.columnFitUnfitStatus.MaxLength = 7;
                this.columnDoctorSignature.ReadOnly = true;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public pRptFullHealthCardGetRow NewpRptFullHealthCardGetRow() {
                return ((pRptFullHealthCardGetRow)(this.NewRow()));
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
                return new pRptFullHealthCardGetRow(builder);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            protected override global::System.Type GetRowType() {
                return typeof(pRptFullHealthCardGetRow);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.pRptFullHealthCardGetRowChanged != null)) {
                    this.pRptFullHealthCardGetRowChanged(this, new pRptFullHealthCardGetRowChangeEvent(((pRptFullHealthCardGetRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.pRptFullHealthCardGetRowChanging != null)) {
                    this.pRptFullHealthCardGetRowChanging(this, new pRptFullHealthCardGetRowChangeEvent(((pRptFullHealthCardGetRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.pRptFullHealthCardGetRowDeleted != null)) {
                    this.pRptFullHealthCardGetRowDeleted(this, new pRptFullHealthCardGetRowChangeEvent(((pRptFullHealthCardGetRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.pRptFullHealthCardGetRowDeleting != null)) {
                    this.pRptFullHealthCardGetRowDeleting(this, new pRptFullHealthCardGetRowChangeEvent(((pRptFullHealthCardGetRow)(e.Row)), e.Action));
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void RemovepRptFullHealthCardGetRow(pRptFullHealthCardGetRow row) {
                this.Rows.Remove(row);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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();
                HealthCardFull ds = new HealthCardFull();
                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 = "pRptFullHealthCardGetDataTable";
                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 pRptFullHealthCardGetRow : global::System.Data.DataRow {
            
            private pRptFullHealthCardGetDataTable tablepRptFullHealthCardGet;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            internal pRptFullHealthCardGetRow(global::System.Data.DataRowBuilder rb) : 
                    base(rb) {
                this.tablepRptFullHealthCardGet = ((pRptFullHealthCardGetDataTable)(this.Table));
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public long ExaminationId {
                get {
                    return ((long)(this[this.tablepRptFullHealthCardGet.ExaminationIdColumn]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.ExaminationIdColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string ExaminationIdText {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.ExaminationIdTextColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ExaminationIdText\' in table \'pRptFullHealthCardGet\' is DBNu" +
                                "ll.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.ExaminationIdTextColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Code {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CodeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Code\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CodeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string EmployeeName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.EmployeeNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'EmployeeName\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.EmployeeNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public System.DateTime ExaminationDate {
                get {
                    return ((global::System.DateTime)(this[this.tablepRptFullHealthCardGet.ExaminationDateColumn]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.ExaminationDateColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string ExDate {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.ExDateColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ExDate\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.ExDateColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string EmployeeType {
                get {
                    return ((string)(this[this.tablepRptFullHealthCardGet.EmployeeTypeColumn]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.EmployeeTypeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public byte MainTypeId {
                get {
                    return ((byte)(this[this.tablepRptFullHealthCardGet.MainTypeIdColumn]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.MainTypeIdColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string RoundName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.RoundNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'RoundName\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.RoundNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Department {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.DepartmentColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Department\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.DepartmentColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Designation {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.DesignationColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Designation\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.DesignationColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string BloodGroup {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.BloodGroupColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'BloodGroup\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.BloodGroupColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public int Age {
                get {
                    try {
                        return ((int)(this[this.tablepRptFullHealthCardGet.AgeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Age\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.AgeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public int Height {
                get {
                    try {
                        return ((int)(this[this.tablepRptFullHealthCardGet.HeightColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Height\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.HeightColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal Weight {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.WeightColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Weight\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.WeightColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal BMI {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.BMIColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'BMI\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.BMIColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Gender {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.GenderColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Gender\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.GenderColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string RoundName1 {
                get {
                    return ((string)(this[this.tablepRptFullHealthCardGet.RoundName1Column]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.RoundName1Column] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string DiagnosisRemark {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.DiagnosisRemarkColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DiagnosisRemark\' in table \'pRptFullHealthCardGet\' is DBNull" +
                                ".", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.DiagnosisRemarkColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string RecommendationEnglish {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.RecommendationEnglishColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'RecommendationEnglish\' in table \'pRptFullHealthCardGet\' is " +
                                "DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.RecommendationEnglishColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Disease {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.DiseaseColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Disease\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.DiseaseColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string History {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.HistoryColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'History\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.HistoryColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Allergy {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.AllergyColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Allergy\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.AllergyColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string FamilyHistory {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.FamilyHistoryColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'FamilyHistory\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.FamilyHistoryColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Habit {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.HabitColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Habit\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.HabitColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public System.DateTime DateOfBirth {
                get {
                    try {
                        return ((global::System.DateTime)(this[this.tablepRptFullHealthCardGet.DateOfBirthColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DateOfBirth\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.DateOfBirthColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string DepartmentName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.DepartmentNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DepartmentName\' in table \'pRptFullHealthCardGet\' is DBNull." +
                                "", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.DepartmentNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public int BloodPressureSystolic {
                get {
                    try {
                        return ((int)(this[this.tablepRptFullHealthCardGet.BloodPressureSystolicColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'BloodPressureSystolic\' in table \'pRptFullHealthCardGet\' is " +
                                "DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.BloodPressureSystolicColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public short BloodPressureDiastolic {
                get {
                    try {
                        return ((short)(this[this.tablepRptFullHealthCardGet.BloodPressureDiastolicColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'BloodPressureDiastolic\' in table \'pRptFullHealthCardGet\' is" +
                                " DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.BloodPressureDiastolicColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public short Pulse {
                get {
                    try {
                        return ((short)(this[this.tablepRptFullHealthCardGet.PulseColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Pulse\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.PulseColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public int Respiration {
                get {
                    try {
                        return ((int)(this[this.tablepRptFullHealthCardGet.RespirationColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Respiration\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.RespirationColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Remark {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.RemarkColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Remark\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.RemarkColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Code1 {
                get {
                    return ((string)(this[this.tablepRptFullHealthCardGet.Code1Column]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.Code1Column] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Title {
                get {
                    return ((string)(this[this.tablepRptFullHealthCardGet.TitleColumn]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.TitleColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string ParentCompanyName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.ParentCompanyNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ParentCompanyName\' in table \'pRptFullHealthCardGet\' is DBNu" +
                                "ll.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.ParentCompanyNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string FirstLine {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.FirstLineColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'FirstLine\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.FirstLineColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string FourthLine {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.FourthLineColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'FourthLine\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.FourthLineColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string StreetOne {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.StreetOneColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'StreetOne\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.StreetOneColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string StreetTwo {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.StreetTwoColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'StreetTwo\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.StreetTwoColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string StreetThree {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.StreetThreeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'StreetThree\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.StreetThreeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string StreetFour {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.StreetFourColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'StreetFour\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.StreetFourColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CityName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CityNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CityName\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CityNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string StateName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.StateNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'StateName\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.StateNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string ReportTitle {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.ReportTitleColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'ReportTitle\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.ReportTitleColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public byte[] Logo {
                get {
                    try {
                        return ((byte[])(this[this.tablepRptFullHealthCardGet.LogoColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Logo\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.LogoColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyTitle {
                get {
                    return ((string)(this[this.tablepRptFullHealthCardGet.CompanyTitleColumn]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyTitleColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyAddressOne {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyAddressOneColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyAddressOne\' in table \'pRptFullHealthCardGet\' is DBNu" +
                                "ll.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyAddressOneColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyAddressTwo {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyAddressTwoColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyAddressTwo\' in table \'pRptFullHealthCardGet\' is DBNu" +
                                "ll.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyAddressTwoColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyAddressThree {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyAddressThreeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyAddressThree\' in table \'pRptFullHealthCardGet\' is DB" +
                                "Null.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyAddressThreeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyCityName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyCityNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyCityName\' in table \'pRptFullHealthCardGet\' is DBNull" +
                                ".", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyCityNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyStateNAme {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyStateNAmeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyStateNAme\' in table \'pRptFullHealthCardGet\' is DBNul" +
                                "l.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyStateNAmeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyCountryName {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyCountryNameColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyCountryName\' in table \'pRptFullHealthCardGet\' is DBN" +
                                "ull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyCountryNameColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyZipCode {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyZipCodeColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyZipCode\' in table \'pRptFullHealthCardGet\' is DBNull." +
                                "", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyZipCodeColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string CompanyPhoneNo {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.CompanyPhoneNoColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'CompanyPhoneNo\' in table \'pRptFullHealthCardGet\' is DBNull." +
                                "", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.CompanyPhoneNoColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal FVCObserved {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.FVCObservedColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'FVCObserved\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.FVCObservedColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal FEV1Observed {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.FEV1ObservedColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'FEV1Observed\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.FEV1ObservedColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal MVVObserved {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.MVVObservedColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'MVVObserved\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.MVVObservedColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal PFRObserved {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.PFRObservedColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'PFRObserved\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.PFRObservedColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string SurgeryRemark {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.SurgeryRemarkColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'SurgeryRemark\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.SurgeryRemarkColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string Location {
                get {
                    return ((string)(this[this.tablepRptFullHealthCardGet.LocationColumn]));
                }
                set {
                    this[this.tablepRptFullHealthCardGet.LocationColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal AcRightDB {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.AcRightDBColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'AcRightDB\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.AcRightDBColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal AcLeftDB {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.AcLeftDBColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'AcLeftDB\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.AcLeftDBColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string LeftResult {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.LeftResultColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'LeftResult\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.LeftResultColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string RightResult {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.RightResultColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'RightResult\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.RightResultColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string EmployeeCompanyTitle {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.EmployeeCompanyTitleColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'EmployeeCompanyTitle\' in table \'pRptFullHealthCardGet\' is D" +
                                "BNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.EmployeeCompanyTitleColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public System.DateTime TodayDate {
                get {
                    try {
                        return ((global::System.DateTime)(this[this.tablepRptFullHealthCardGet.TodayDateColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'TodayDate\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.TodayDateColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public string FitUnfitStatus {
                get {
                    try {
                        return ((string)(this[this.tablepRptFullHealthCardGet.FitUnfitStatusColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'FitUnfitStatus\' in table \'pRptFullHealthCardGet\' is DBNull." +
                                "", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.FitUnfitStatusColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public byte[] DoctorSignature {
                get {
                    try {
                        return ((byte[])(this[this.tablepRptFullHealthCardGet.DoctorSignatureColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'DoctorSignature\' in table \'pRptFullHealthCardGet\' is DBNull" +
                                ".", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.DoctorSignatureColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public decimal Temperature {
                get {
                    try {
                        return ((decimal)(this[this.tablepRptFullHealthCardGet.TemperatureColumn]));
                    }
                    catch (global::System.InvalidCastException e) {
                        throw new global::System.Data.StrongTypingException("The value for column \'Temperature\' in table \'pRptFullHealthCardGet\' is DBNull.", e);
                    }
                }
                set {
                    this[this.tablepRptFullHealthCardGet.TemperatureColumn] = value;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsExaminationIdTextNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.ExaminationIdTextColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetExaminationIdTextNull() {
                this[this.tablepRptFullHealthCardGet.ExaminationIdTextColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCodeNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CodeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCodeNull() {
                this[this.tablepRptFullHealthCardGet.CodeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsEmployeeNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.EmployeeNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetEmployeeNameNull() {
                this[this.tablepRptFullHealthCardGet.EmployeeNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsExDateNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.ExDateColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetExDateNull() {
                this[this.tablepRptFullHealthCardGet.ExDateColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsRoundNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.RoundNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetRoundNameNull() {
                this[this.tablepRptFullHealthCardGet.RoundNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsDepartmentNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.DepartmentColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetDepartmentNull() {
                this[this.tablepRptFullHealthCardGet.DepartmentColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsDesignationNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.DesignationColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetDesignationNull() {
                this[this.tablepRptFullHealthCardGet.DesignationColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsBloodGroupNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.BloodGroupColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetBloodGroupNull() {
                this[this.tablepRptFullHealthCardGet.BloodGroupColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsAgeNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.AgeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetAgeNull() {
                this[this.tablepRptFullHealthCardGet.AgeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsHeightNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.HeightColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetHeightNull() {
                this[this.tablepRptFullHealthCardGet.HeightColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsWeightNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.WeightColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetWeightNull() {
                this[this.tablepRptFullHealthCardGet.WeightColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsBMINull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.BMIColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetBMINull() {
                this[this.tablepRptFullHealthCardGet.BMIColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsGenderNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.GenderColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetGenderNull() {
                this[this.tablepRptFullHealthCardGet.GenderColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsDiagnosisRemarkNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.DiagnosisRemarkColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetDiagnosisRemarkNull() {
                this[this.tablepRptFullHealthCardGet.DiagnosisRemarkColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsRecommendationEnglishNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.RecommendationEnglishColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetRecommendationEnglishNull() {
                this[this.tablepRptFullHealthCardGet.RecommendationEnglishColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsDiseaseNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.DiseaseColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetDiseaseNull() {
                this[this.tablepRptFullHealthCardGet.DiseaseColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsHistoryNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.HistoryColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetHistoryNull() {
                this[this.tablepRptFullHealthCardGet.HistoryColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsAllergyNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.AllergyColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetAllergyNull() {
                this[this.tablepRptFullHealthCardGet.AllergyColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsFamilyHistoryNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.FamilyHistoryColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetFamilyHistoryNull() {
                this[this.tablepRptFullHealthCardGet.FamilyHistoryColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsHabitNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.HabitColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetHabitNull() {
                this[this.tablepRptFullHealthCardGet.HabitColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsDateOfBirthNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.DateOfBirthColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetDateOfBirthNull() {
                this[this.tablepRptFullHealthCardGet.DateOfBirthColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsDepartmentNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.DepartmentNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetDepartmentNameNull() {
                this[this.tablepRptFullHealthCardGet.DepartmentNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsBloodPressureSystolicNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.BloodPressureSystolicColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetBloodPressureSystolicNull() {
                this[this.tablepRptFullHealthCardGet.BloodPressureSystolicColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsBloodPressureDiastolicNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.BloodPressureDiastolicColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetBloodPressureDiastolicNull() {
                this[this.tablepRptFullHealthCardGet.BloodPressureDiastolicColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsPulseNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.PulseColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetPulseNull() {
                this[this.tablepRptFullHealthCardGet.PulseColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsRespirationNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.RespirationColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetRespirationNull() {
                this[this.tablepRptFullHealthCardGet.RespirationColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsRemarkNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.RemarkColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetRemarkNull() {
                this[this.tablepRptFullHealthCardGet.RemarkColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsParentCompanyNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.ParentCompanyNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetParentCompanyNameNull() {
                this[this.tablepRptFullHealthCardGet.ParentCompanyNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsFirstLineNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.FirstLineColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetFirstLineNull() {
                this[this.tablepRptFullHealthCardGet.FirstLineColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsFourthLineNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.FourthLineColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetFourthLineNull() {
                this[this.tablepRptFullHealthCardGet.FourthLineColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsStreetOneNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.StreetOneColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetStreetOneNull() {
                this[this.tablepRptFullHealthCardGet.StreetOneColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsStreetTwoNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.StreetTwoColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetStreetTwoNull() {
                this[this.tablepRptFullHealthCardGet.StreetTwoColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsStreetThreeNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.StreetThreeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetStreetThreeNull() {
                this[this.tablepRptFullHealthCardGet.StreetThreeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsStreetFourNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.StreetFourColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetStreetFourNull() {
                this[this.tablepRptFullHealthCardGet.StreetFourColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCityNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CityNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCityNameNull() {
                this[this.tablepRptFullHealthCardGet.CityNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsStateNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.StateNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetStateNameNull() {
                this[this.tablepRptFullHealthCardGet.StateNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsReportTitleNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.ReportTitleColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetReportTitleNull() {
                this[this.tablepRptFullHealthCardGet.ReportTitleColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsLogoNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.LogoColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetLogoNull() {
                this[this.tablepRptFullHealthCardGet.LogoColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyAddressOneNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyAddressOneColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyAddressOneNull() {
                this[this.tablepRptFullHealthCardGet.CompanyAddressOneColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyAddressTwoNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyAddressTwoColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyAddressTwoNull() {
                this[this.tablepRptFullHealthCardGet.CompanyAddressTwoColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyAddressThreeNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyAddressThreeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyAddressThreeNull() {
                this[this.tablepRptFullHealthCardGet.CompanyAddressThreeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyCityNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyCityNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyCityNameNull() {
                this[this.tablepRptFullHealthCardGet.CompanyCityNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyStateNAmeNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyStateNAmeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyStateNAmeNull() {
                this[this.tablepRptFullHealthCardGet.CompanyStateNAmeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyCountryNameNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyCountryNameColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyCountryNameNull() {
                this[this.tablepRptFullHealthCardGet.CompanyCountryNameColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyZipCodeNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyZipCodeColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyZipCodeNull() {
                this[this.tablepRptFullHealthCardGet.CompanyZipCodeColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsCompanyPhoneNoNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.CompanyPhoneNoColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetCompanyPhoneNoNull() {
                this[this.tablepRptFullHealthCardGet.CompanyPhoneNoColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsFVCObservedNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.FVCObservedColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetFVCObservedNull() {
                this[this.tablepRptFullHealthCardGet.FVCObservedColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsFEV1ObservedNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.FEV1ObservedColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetFEV1ObservedNull() {
                this[this.tablepRptFullHealthCardGet.FEV1ObservedColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsMVVObservedNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.MVVObservedColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetMVVObservedNull() {
                this[this.tablepRptFullHealthCardGet.MVVObservedColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsPFRObservedNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.PFRObservedColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetPFRObservedNull() {
                this[this.tablepRptFullHealthCardGet.PFRObservedColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsSurgeryRemarkNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.SurgeryRemarkColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetSurgeryRemarkNull() {
                this[this.tablepRptFullHealthCardGet.SurgeryRemarkColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsAcRightDBNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.AcRightDBColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetAcRightDBNull() {
                this[this.tablepRptFullHealthCardGet.AcRightDBColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsAcLeftDBNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.AcLeftDBColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetAcLeftDBNull() {
                this[this.tablepRptFullHealthCardGet.AcLeftDBColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsLeftResultNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.LeftResultColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetLeftResultNull() {
                this[this.tablepRptFullHealthCardGet.LeftResultColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsRightResultNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.RightResultColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetRightResultNull() {
                this[this.tablepRptFullHealthCardGet.RightResultColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsEmployeeCompanyTitleNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.EmployeeCompanyTitleColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetEmployeeCompanyTitleNull() {
                this[this.tablepRptFullHealthCardGet.EmployeeCompanyTitleColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsTodayDateNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.TodayDateColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetTodayDateNull() {
                this[this.tablepRptFullHealthCardGet.TodayDateColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsFitUnfitStatusNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.FitUnfitStatusColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetFitUnfitStatusNull() {
                this[this.tablepRptFullHealthCardGet.FitUnfitStatusColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsDoctorSignatureNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.DoctorSignatureColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetDoctorSignatureNull() {
                this[this.tablepRptFullHealthCardGet.DoctorSignatureColumn] = global::System.Convert.DBNull;
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public bool IsTemperatureNull() {
                return this.IsNull(this.tablepRptFullHealthCardGet.TemperatureColumn);
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public void SetTemperatureNull() {
                this[this.tablepRptFullHealthCardGet.TemperatureColumn] = global::System.Convert.DBNull;
            }
        }
        
        /// <summary>
        ///Row event argument class
        ///</summary>
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
        public class pRptFullHealthCardGetRowChangeEvent : global::System.EventArgs {
            
            private pRptFullHealthCardGetRow eventRow;
            
            private global::System.Data.DataRowAction eventAction;
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public pRptFullHealthCardGetRowChangeEvent(pRptFullHealthCardGetRow 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", "4.0.0.0")]
            public pRptFullHealthCardGetRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")]
            public global::System.Data.DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}
namespace Sapphire.Ohu.Report.Datasets.ClinicalInformation.Examination.HealthCardFullTableAdapters {
    
    
    /// <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 pRptFullHealthCardGetTableAdapter : 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", "4.0.0.0")]
        public pRptFullHealthCardGetTableAdapter() {
            this.ClearBeforeFill = true;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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", "4.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", "4.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", "4.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", "4.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", "4.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 = "pRptFullHealthCardGet";
            tableMapping.ColumnMappings.Add("ExaminationId", "ExaminationId");
            tableMapping.ColumnMappings.Add("ExaminationIdText", "ExaminationIdText");
            tableMapping.ColumnMappings.Add("Code", "Code");
            tableMapping.ColumnMappings.Add("EmployeeName", "EmployeeName");
            tableMapping.ColumnMappings.Add("ExaminationDate", "ExaminationDate");
            tableMapping.ColumnMappings.Add("ExDate", "ExDate");
            tableMapping.ColumnMappings.Add("EmployeeType", "EmployeeType");
            tableMapping.ColumnMappings.Add("MainTypeId", "MainTypeId");
            tableMapping.ColumnMappings.Add("RoundName", "RoundName");
            tableMapping.ColumnMappings.Add("Department", "Department");
            tableMapping.ColumnMappings.Add("Designation", "Designation");
            tableMapping.ColumnMappings.Add("BloodGroup", "BloodGroup");
            tableMapping.ColumnMappings.Add("Age", "Age");
            tableMapping.ColumnMappings.Add("Height", "Height");
            tableMapping.ColumnMappings.Add("Weight", "Weight");
            tableMapping.ColumnMappings.Add("BMI", "BMI");
            tableMapping.ColumnMappings.Add("Gender", "Gender");
            tableMapping.ColumnMappings.Add("RoundName1", "RoundName1");
            tableMapping.ColumnMappings.Add("DiagnosisRemark", "DiagnosisRemark");
            tableMapping.ColumnMappings.Add("RecommendationEnglish", "RecommendationEnglish");
            tableMapping.ColumnMappings.Add("Disease", "Disease");
            tableMapping.ColumnMappings.Add("History", "History");
            tableMapping.ColumnMappings.Add("Allergy", "Allergy");
            tableMapping.ColumnMappings.Add("FamilyHistory", "FamilyHistory");
            tableMapping.ColumnMappings.Add("Habit", "Habit");
            tableMapping.ColumnMappings.Add("DateOfBirth", "DateOfBirth");
            tableMapping.ColumnMappings.Add("DepartmentName", "DepartmentName");
            tableMapping.ColumnMappings.Add("BloodPressureSystolic", "BloodPressureSystolic");
            tableMapping.ColumnMappings.Add("BloodPressureDiastolic", "BloodPressureDiastolic");
            tableMapping.ColumnMappings.Add("Pulse", "Pulse");
            tableMapping.ColumnMappings.Add("Respiration", "Respiration");
            tableMapping.ColumnMappings.Add("Remark", "Remark");
            tableMapping.ColumnMappings.Add("Code1", "Code1");
            tableMapping.ColumnMappings.Add("Title", "Title");
            tableMapping.ColumnMappings.Add("ParentCompanyName", "ParentCompanyName");
            tableMapping.ColumnMappings.Add("FirstLine", "FirstLine");
            tableMapping.ColumnMappings.Add("FourthLine", "FourthLine");
            tableMapping.ColumnMappings.Add("StreetOne", "StreetOne");
            tableMapping.ColumnMappings.Add("StreetTwo", "StreetTwo");
            tableMapping.ColumnMappings.Add("StreetThree", "StreetThree");
            tableMapping.ColumnMappings.Add("StreetFour", "StreetFour");
            tableMapping.ColumnMappings.Add("CityName", "CityName");
            tableMapping.ColumnMappings.Add("StateName", "StateName");
            tableMapping.ColumnMappings.Add("ReportTitle", "ReportTitle");
            tableMapping.ColumnMappings.Add("Logo", "Logo");
            tableMapping.ColumnMappings.Add("CompanyTitle", "CompanyTitle");
            tableMapping.ColumnMappings.Add("CompanyAddressOne", "CompanyAddressOne");
            tableMapping.ColumnMappings.Add("CompanyAddressTwo", "CompanyAddressTwo");
            tableMapping.ColumnMappings.Add("CompanyAddressThree", "CompanyAddressThree");
            tableMapping.ColumnMappings.Add("CompanyCityName", "CompanyCityName");
            tableMapping.ColumnMappings.Add("CompanyStateNAme", "CompanyStateNAme");
            tableMapping.ColumnMappings.Add("CompanyCountryName", "CompanyCountryName");
            tableMapping.ColumnMappings.Add("CompanyZipCode", "CompanyZipCode");
            tableMapping.ColumnMappings.Add("CompanyPhoneNo", "CompanyPhoneNo");
            tableMapping.ColumnMappings.Add("FVCObserved", "FVCObserved");
            tableMapping.ColumnMappings.Add("FEV1Observed", "FEV1Observed");
            tableMapping.ColumnMappings.Add("MVVObserved", "MVVObserved");
            tableMapping.ColumnMappings.Add("PFRObserved", "PFRObserved");
            tableMapping.ColumnMappings.Add("SurgeryRemark", "SurgeryRemark");
            tableMapping.ColumnMappings.Add("Location", "Location");
            tableMapping.ColumnMappings.Add("AcRightDB", "AcRightDB");
            tableMapping.ColumnMappings.Add("AcLeftDB", "AcLeftDB");
            tableMapping.ColumnMappings.Add("LeftResult", "LeftResult");
            tableMapping.ColumnMappings.Add("RightResult", "RightResult");
            tableMapping.ColumnMappings.Add("EmployeeCompanyTitle", "EmployeeCompanyTitle");
            tableMapping.ColumnMappings.Add("TodayDate", "TodayDate");
            tableMapping.ColumnMappings.Add("FitUnfitStatus", "FitUnfitStatus");
            tableMapping.ColumnMappings.Add("DoctorSignature", "DoctorSignature");
            tableMapping.ColumnMappings.Add("Temperature", "Temperature");
            this._adapter.TableMappings.Add(tableMapping);
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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.OccuCareConnectionString3;
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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.pRptFullHealthCardGet";
            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("@rReportId", 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("@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("@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("@rExaminationTypeId", 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("@rRoundId", 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("@rStatusId", 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("@rGenderId", global::System.Data.SqlDbType.TinyInt, 1, global::System.Data.ParameterDirection.Input, 3, 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.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("@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("@rEmployeeId", 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("@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("@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("@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("@rSectorId", 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("@rVerticalId", 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("@rCompanyGroupId", 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("@rMedicalAgencyId", 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("@rTargetGroupId", 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("@rProcessTypeId", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 10, 0, null, global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
        }
        
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.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(
                    HealthCardFull.pRptFullHealthCardGetDataTable dataTable, 
                    global::System.Nullable<short> rReportId, 
                    global::System.Nullable<int> rStoreLocationId, 
                    global::System.Nullable<int> rLocationId, 
                    global::System.Nullable<int> rExaminationTypeId, 
                    global::System.Nullable<int> rRoundId, 
                    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> rStatusId, 
                    global::System.Nullable<byte> rGenderId, 
                    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, 
                    string rEmployeeId, 
                    global::System.Nullable<int> rEmployeeGroupId, 
                    global::System.Nullable<int> rEmployeeSubTypeId, 
                    global::System.Nullable<int> rEmployeeTypeGroupId, 
                    global::System.Nullable<int> rSectorId, 
                    global::System.Nullable<int> rVerticalId, 
                    global::System.Nullable<int> rCompanyGroupId, 
                    global::System.Nullable<int> rMedicalAgencyId, 
                    global::System.Nullable<int> rTargetGroupId, 
                    global::System.Nullable<int> rProcessTypeId) {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((rReportId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[1].Value = ((short)(rReportId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
            }
            if ((rStoreLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[2].Value = ((int)(rStoreLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
            }
            if ((rLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[3].Value = ((int)(rLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
            }
            if ((rExaminationTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[4].Value = ((int)(rExaminationTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
            }
            if ((rRoundId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[5].Value = ((int)(rRoundId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
            }
            if ((rFunctionId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[6].Value = ((int)(rFunctionId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[7].Value = ((int)(rDepartmentGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[8].Value = ((int)(rDepartmentId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
            }
            if ((rGradeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[9].Value = ((int)(rGradeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
            }
            if ((rDesignationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[10].Value = ((int)(rDesignationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
            }
            if ((rJobTitleId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[11].Value = ((int)(rJobTitleId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[12].Value = ((int)(rEmployeeTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
            }
            if ((rCompanyId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[13].Value = ((int)(rCompanyId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
            }
            if ((rContractorId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[14].Value = ((int)(rContractorId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
            }
            if ((rStatusId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[15].Value = ((short)(rStatusId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[15].Value = global::System.DBNull.Value;
            }
            if ((rGenderId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[16].Value = ((byte)(rGenderId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[16].Value = global::System.DBNull.Value;
            }
            if ((rAgeFrom.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[17].Value = ((int)(rAgeFrom.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[17].Value = global::System.DBNull.Value;
            }
            if ((rAgeTo.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[18].Value = ((int)(rAgeTo.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[18].Value = global::System.DBNull.Value;
            }
            if ((rFromDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[19].Value = ((System.DateTime)(rFromDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[19].Value = global::System.DBNull.Value;
            }
            if ((rToDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[20].Value = ((System.DateTime)(rToDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[20].Value = global::System.DBNull.Value;
            }
            if ((rOrgId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[21].Value = ((int)(rOrgId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[21].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeCode == null)) {
                this.Adapter.SelectCommand.Parameters[22].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[22].Value = ((string)(rEmployeeCode));
            }
            if ((rEmployeeId == null)) {
                this.Adapter.SelectCommand.Parameters[23].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[23].Value = ((string)(rEmployeeId));
            }
            if ((rEmployeeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[24].Value = ((int)(rEmployeeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[24].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeSubTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[25].Value = ((int)(rEmployeeSubTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[25].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeTypeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[26].Value = ((int)(rEmployeeTypeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[26].Value = global::System.DBNull.Value;
            }
            if ((rSectorId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[27].Value = ((int)(rSectorId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[27].Value = global::System.DBNull.Value;
            }
            if ((rVerticalId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[28].Value = ((int)(rVerticalId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[28].Value = global::System.DBNull.Value;
            }
            if ((rCompanyGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[29].Value = ((int)(rCompanyGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[29].Value = global::System.DBNull.Value;
            }
            if ((rMedicalAgencyId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[30].Value = ((int)(rMedicalAgencyId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[30].Value = global::System.DBNull.Value;
            }
            if ((rTargetGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[31].Value = ((int)(rTargetGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[31].Value = global::System.DBNull.Value;
            }
            if ((rProcessTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[32].Value = ((int)(rProcessTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[32].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", "4.0.0.0")]
        [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
        [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
        public virtual HealthCardFull.pRptFullHealthCardGetDataTable GetData(
                    global::System.Nullable<short> rReportId, 
                    global::System.Nullable<int> rStoreLocationId, 
                    global::System.Nullable<int> rLocationId, 
                    global::System.Nullable<int> rExaminationTypeId, 
                    global::System.Nullable<int> rRoundId, 
                    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> rStatusId, 
                    global::System.Nullable<byte> rGenderId, 
                    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, 
                    string rEmployeeId, 
                    global::System.Nullable<int> rEmployeeGroupId, 
                    global::System.Nullable<int> rEmployeeSubTypeId, 
                    global::System.Nullable<int> rEmployeeTypeGroupId, 
                    global::System.Nullable<int> rSectorId, 
                    global::System.Nullable<int> rVerticalId, 
                    global::System.Nullable<int> rCompanyGroupId, 
                    global::System.Nullable<int> rMedicalAgencyId, 
                    global::System.Nullable<int> rTargetGroupId, 
                    global::System.Nullable<int> rProcessTypeId) {
            this.Adapter.SelectCommand = this.CommandCollection[0];
            if ((rReportId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[1].Value = ((short)(rReportId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
            }
            if ((rStoreLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[2].Value = ((int)(rStoreLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
            }
            if ((rLocationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[3].Value = ((int)(rLocationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
            }
            if ((rExaminationTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[4].Value = ((int)(rExaminationTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
            }
            if ((rRoundId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[5].Value = ((int)(rRoundId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
            }
            if ((rFunctionId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[6].Value = ((int)(rFunctionId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[7].Value = ((int)(rDepartmentGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
            }
            if ((rDepartmentId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[8].Value = ((int)(rDepartmentId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
            }
            if ((rGradeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[9].Value = ((int)(rGradeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
            }
            if ((rDesignationId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[10].Value = ((int)(rDesignationId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
            }
            if ((rJobTitleId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[11].Value = ((int)(rJobTitleId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[12].Value = ((int)(rEmployeeTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
            }
            if ((rCompanyId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[13].Value = ((int)(rCompanyId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
            }
            if ((rContractorId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[14].Value = ((int)(rContractorId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
            }
            if ((rStatusId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[15].Value = ((short)(rStatusId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[15].Value = global::System.DBNull.Value;
            }
            if ((rGenderId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[16].Value = ((byte)(rGenderId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[16].Value = global::System.DBNull.Value;
            }
            if ((rAgeFrom.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[17].Value = ((int)(rAgeFrom.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[17].Value = global::System.DBNull.Value;
            }
            if ((rAgeTo.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[18].Value = ((int)(rAgeTo.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[18].Value = global::System.DBNull.Value;
            }
            if ((rFromDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[19].Value = ((System.DateTime)(rFromDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[19].Value = global::System.DBNull.Value;
            }
            if ((rToDate.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[20].Value = ((System.DateTime)(rToDate.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[20].Value = global::System.DBNull.Value;
            }
            if ((rOrgId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[21].Value = ((int)(rOrgId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[21].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeCode == null)) {
                this.Adapter.SelectCommand.Parameters[22].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[22].Value = ((string)(rEmployeeCode));
            }
            if ((rEmployeeId == null)) {
                this.Adapter.SelectCommand.Parameters[23].Value = global::System.DBNull.Value;
            }
            else {
                this.Adapter.SelectCommand.Parameters[23].Value = ((string)(rEmployeeId));
            }
            if ((rEmployeeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[24].Value = ((int)(rEmployeeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[24].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeSubTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[25].Value = ((int)(rEmployeeSubTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[25].Value = global::System.DBNull.Value;
            }
            if ((rEmployeeTypeGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[26].Value = ((int)(rEmployeeTypeGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[26].Value = global::System.DBNull.Value;
            }
            if ((rSectorId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[27].Value = ((int)(rSectorId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[27].Value = global::System.DBNull.Value;
            }
            if ((rVerticalId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[28].Value = ((int)(rVerticalId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[28].Value = global::System.DBNull.Value;
            }
            if ((rCompanyGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[29].Value = ((int)(rCompanyGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[29].Value = global::System.DBNull.Value;
            }
            if ((rMedicalAgencyId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[30].Value = ((int)(rMedicalAgencyId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[30].Value = global::System.DBNull.Value;
            }
            if ((rTargetGroupId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[31].Value = ((int)(rTargetGroupId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[31].Value = global::System.DBNull.Value;
            }
            if ((rProcessTypeId.HasValue == true)) {
                this.Adapter.SelectCommand.Parameters[32].Value = ((int)(rProcessTypeId.Value));
            }
            else {
                this.Adapter.SelectCommand.Parameters[32].Value = global::System.DBNull.Value;
            }
            HealthCardFull.pRptFullHealthCardGetDataTable dataTable = new HealthCardFull.pRptFullHealthCardGetDataTable();
            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", "4.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", "4.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", "4.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", "4.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", "4.0.0.0")]
        private int UpdateUpdatedRows(HealthCardFull 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", "4.0.0.0")]
        private int UpdateInsertedRows(HealthCardFull 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", "4.0.0.0")]
        private int UpdateDeletedRows(HealthCardFull 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", "4.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", "4.0.0.0")]
        public virtual int UpdateAll(HealthCardFull 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", "4.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", "4.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", "4.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", "4.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", "4.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", "4.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", "4.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