Beispiel #1
0
    public void PopulateUIDefaults()
    {
        XmlDocument xmlDoc = new XmlDocument();
        string      filename;

        //filename = "~/Template/Default_" + Session["uname"].ToString() + ".xml";
        //if (File.Exists(Server.MapPath(filename)))
        //{ xmlDoc.Load(Server.MapPath(filename)); }
        //else { xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml")); }
        xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml"));

        XmlNodeList nodeList = xmlDoc.DocumentElement.SelectNodes("/Defaults/IEPage3");

        foreach (XmlNode node in nodeList)
        {
            if (cboGAIT.Text == "")
            {
                cboGAIT.Text = node.SelectSingleNode("GAIT") == null?cboGAIT.Text.ToString().Trim() : node.SelectSingleNode("GAIT").InnerText;
            }
            if (cboAmbulates.Text == "")
            {
                cboAmbulates.Text = node.SelectSingleNode("Ambulates") == null?cboAmbulates.Text.ToString().Trim() : node.SelectSingleNode("Ambulates").InnerText;
            }
            chkFootslap.Checked           = node.SelectSingleNode("Footslap") == null ? chkFootslap.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Footslap").InnerText);
            chkKneehyperextension.Checked = node.SelectSingleNode("Kneehyperextension") == null ? chkKneehyperextension.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Kneehyperextension").InnerText);
            chkUnabletohealwalk.Checked   = node.SelectSingleNode("Unabletohealwalk") == null ? chkUnabletohealwalk.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Unabletohealwalk").InnerText);
            chkUnabletotoewalk.Checked    = node.SelectSingleNode("Unabletotoewalk") == null ? chkUnabletotoewalk.Checked : CommonConvert.ToBoolean(node.SelectSingleNode("Unabletotoewalk").InnerText);
            if (txtOther.Text == "")
            {
                txtOther.Text = node.SelectSingleNode("Other") == null?txtOther.Text.ToString().Trim() : node.SelectSingleNode("Other").InnerText;
            }
        }

        xmlDoc = new XmlDocument();
        xmlDoc.Load(Server.MapPath("~/Template/Default_Admin.xml"));
        nodeList = xmlDoc.DocumentElement.SelectNodes("/Defaults/IEPage2");

        foreach (XmlNode node in nodeList)
        {
            txtIntactExcept.Text = node.SelectSingleNode("intactexcept").InnerText;
            LEdtr.Checked        = node.SelectSingleNode("LEdtr") == null ? LEdtr.Checked : Convert.ToBoolean(node.SelectSingleNode("LEdtr").InnerText);

            //  chk_depression.Checked = node.SelectSingleNode("Depression") == null ? chk_depression.Checked : Convert.ToBoolean(node.SelectSingleNode("Depression").InnerText);

            LTricepstxt.Text      = node.SelectSingleNode("DTRtricepsLeft").InnerText;
            RTricepstxt.Text      = node.SelectSingleNode("DTRtricepsRight").InnerText;
            LBicepstxt.Text       = node.SelectSingleNode("DTRBicepsLeft").InnerText;
            RBicepstxt.Text       = node.SelectSingleNode("DTRBicepsRight").InnerText;
            RBrachioradialis.Text = node.SelectSingleNode("DTRBrachioRight").InnerText;
            LBrachioradialis.Text = node.SelectSingleNode("DTRBrachioLeft").InnerText;
            LKnee.Text            = node.SelectSingleNode("DTRKneeLeft").InnerText;
            RKnee.Text            = node.SelectSingleNode("DTRKneeRight").InnerText;
            LAnkle.Text           = node.SelectSingleNode("DTRAnkleLeft").InnerText;
            RAnkle.Text           = node.SelectSingleNode("DTRAnkleRight").InnerText;

            UExchk.Checked = node.SelectSingleNode("UEdtr") == null ? UExchk.Checked : Convert.ToBoolean(node.SelectSingleNode("UEdtr").InnerText);

            chkPinPrick.Checked   = node.SelectSingleNode("Pinprick") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("Pinprick").InnerText);
            chkLighttouch.Checked = node.SelectSingleNode("Lighttouch") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("Lighttouch").InnerText);
            txtSensory.Text       = node.SelectSingleNode("Sensory").InnerText;
            LESen_Click.Checked   = node.SelectSingleNode("LEsen") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("LEsen").InnerText);
            TextBox4.Text         = node.SelectSingleNode("LEL3Right").InnerText;
            txtDMTL3.Text         = node.SelectSingleNode("LEL3Left").InnerText;
            TextBox6.Text         = node.SelectSingleNode("LEL4Right").InnerText;
            TextBox5.Text         = node.SelectSingleNode("LEL4Left").InnerText;
            TextBox8.Text         = node.SelectSingleNode("LEL5Right").InnerText;
            TextBox7.Text         = node.SelectSingleNode("LEL5Left").InnerText;
            TextBox10.Text        = node.SelectSingleNode("LES1Left").InnerText;
            TextBox21.Text        = node.SelectSingleNode("LES1Right").InnerText;
            TextBox25.Text        = node.SelectSingleNode("LELumberParaspinalsRight").InnerText;
            TextBox24.Text        = node.SelectSingleNode("LELumberParaspinalsLeft").InnerText;

            UESen_Click.Checked = node.SelectSingleNode("UEsen") == null ? chkPinPrick.Checked : Convert.ToBoolean(node.SelectSingleNode("UEsen").InnerText);
            TextBox9.Text       = node.SelectSingleNode("UEC5Left").InnerText;
            txtUEC5Right.Text   = node.SelectSingleNode("UEC5Right").InnerText;

            TextBox11.Text = node.SelectSingleNode("UEC6Left").InnerText;
            TextBox12.Text = node.SelectSingleNode("UEC6Right").InnerText;

            TextBox13.Text = node.SelectSingleNode("UEC7Left").InnerText;
            TextBox14.Text = node.SelectSingleNode("UEC7Right").InnerText;

            TextBox15.Text = node.SelectSingleNode("UEC8Left").InnerText;
            TextBox16.Text = node.SelectSingleNode("UEC8Right").InnerText;

            TextBox18.Text = node.SelectSingleNode("UET1Right").InnerText;
            TextBox17.Text = node.SelectSingleNode("UET1Left").InnerText;
            TextBox20.Text = node.SelectSingleNode("UECervicalParaspinalsRight").InnerText;
            TextBox19.Text = node.SelectSingleNode("UECervicalParaspinalsLeft").InnerText;

            //cboHoffmanexam.SelectedValue = node.SelectSingleNode("HoffmanExam").InnerText;
            //chkStocking.Checked = node.SelectSingleNode("Stocking") == null ? chkStocking.Checked : Convert.ToBoolean(node.SelectSingleNode("Stocking").InnerText);
            //chkGlove.Checked = node.SelectSingleNode("Glove") == null ? chkGlove.Checked : Convert.ToBoolean(node.SelectSingleNode("Glove").InnerText);

            LEmmst.Checked = node.SelectSingleNode("LEmmst") == null ? LEmmst.Checked : Convert.ToBoolean(node.SelectSingleNode("LEmmst").InnerText);
            TextBox23.Text = node.SelectSingleNode("LEHipFlexionRight").InnerText;
            TextBox22.Text = node.SelectSingleNode("LEHipFlexionLeft").InnerText;
            TextBox41.Text = node.SelectSingleNode("LEHipAbductionRight").InnerText;
            TextBox40.Text = node.SelectSingleNode("LEHipAbductionLeft").InnerText;
            TextBox27.Text = node.SelectSingleNode("LEKneeExtensionRight").InnerText;
            TextBox26.Text = node.SelectSingleNode("LEKneeExtensionLeft").InnerText;

            TextBox43.Text = node.SelectSingleNode("LEKneeFlexionRight").InnerText;
            TextBox42.Text = node.SelectSingleNode("LEKneeFlexionLeft").InnerText;
            TextBox29.Text = node.SelectSingleNode("LEAnkleDorsiRight").InnerText;
            TextBox28.Text = node.SelectSingleNode("LEAnkleDorsiLeft").InnerText;

            TextBox45.Text = node.SelectSingleNode("LEAnklePlantarRight").InnerText;
            TextBox44.Text = node.SelectSingleNode("LEAnklePlantarLeft").InnerText;

            TextBox47.Text = node.SelectSingleNode("LEAnkleExtensorRight").InnerText;
            TextBox46.Text = node.SelectSingleNode("LEAnkleExtensorLeft").InnerText;

            UEmmst.Checked = node.SelectSingleNode("UEmmst") == null ? UEmmst.Checked : Convert.ToBoolean(node.SelectSingleNode("UEmmst").InnerText);

            TextBox31.Text = node.SelectSingleNode("UEShoulderAbductionRight").InnerText;
            TextBox30.Text = node.SelectSingleNode("UEShoulderAbductionLeft").InnerText;

            TextBox49.Text = node.SelectSingleNode("UEShoulderFlexionRight").InnerText;
            TextBox48.Text = node.SelectSingleNode("UEShoulderFlexionLeft").InnerText;

            TextBox33.Text = node.SelectSingleNode("UEElbowExtensionRight").InnerText;
            TextBox32.Text = node.SelectSingleNode("UEElbowExtensionLeft").InnerText;

            TextBox51.Text = node.SelectSingleNode("UEElbowFlexionRight").InnerText;
            TextBox50.Text = node.SelectSingleNode("UEElbowFlexionLeft").InnerText;

            TextBox53.Text = node.SelectSingleNode("UEElbowSupinationRight").InnerText;
            TextBox52.Text = node.SelectSingleNode("UEElbowSupinationLeft").InnerText;

            TextBox55.Text = node.SelectSingleNode("UEElbowPronationRight").InnerText;
            TextBox54.Text = node.SelectSingleNode("UEElbowPronationLeft").InnerText;

            TextBox37.Text = node.SelectSingleNode("UEWristFlexionRight").InnerText;
            TextBox36.Text = node.SelectSingleNode("UEWristFlexionLeft").InnerText;
            TextBox57.Text = node.SelectSingleNode("UEWristExtensionRight").InnerText;
            TextBox56.Text = node.SelectSingleNode("UEWristExtensionLeft").InnerText;
            TextBox39.Text = node.SelectSingleNode("UEHandGripStrengthRight").InnerText;
            TextBox38.Text = node.SelectSingleNode("UEHandGripStrengthLeft").InnerText;
            TextBox59.Text = node.SelectSingleNode("UEHandFingerAbductorsRight").InnerText;
            TextBox58.Text = node.SelectSingleNode("UEHandFingerAbductorsLeft").InnerText;
        }
    }
Beispiel #2
0
    private void bindData()
    {
        DBHelperClass db    = new DBHelperClass();
        string        query = "";

        query = "select top 1 * from tblPatientIEDetailPage2 where PatientIE_ID=" + Session["PatientIE_ID"].ToString();
        DataSet ds = db.selectData(query);

        if (ds.Tables[0].Rows.Count > 0)
        {
            //chk_seizures.Checked = ds.Tables[0].Rows[0]["Seizures"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Seizures"].ToString()) : false;
            //chk_chest_pain.Checked = ds.Tables[0].Rows[0]["ChestPain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["ChestPain"].ToString()) : false;
            //chk_shortness_of_breath.Checked = ds.Tables[0].Rows[0]["ShortnessOfBreath"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["ShortnessOfBreath"].ToString()) : false;
            //chk_jaw_pain.Checked = ds.Tables[0].Rows[0]["Jawpain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Jawpain"].ToString()) : false;
            //chk_abdominal_pain.Checked = ds.Tables[0].Rows[0]["AbdominalPain"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["AbdominalPain"].ToString()) : false;
            //chk_fever.Checked = ds.Tables[0].Rows[0]["Fevers"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Fevers"].ToString()) : false;
            //chk_diarrhea.Checked = ds.Tables[0].Rows[0]["Diarrhea"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Diarrhea"].ToString()) : false;
            //chk_bowel_bladder.Checked = ds.Tables[0].Rows[0]["Bowel"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Bowel"].ToString()) : false;
            //chk_blurred.Checked = ds.Tables[0].Rows[0]["DoubleVision"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["DoubleVision"].ToString()) : false;
            //chk_recent_wt.Checked = ds.Tables[0].Rows[0]["RecentWeightloss"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["RecentWeightloss"].ToString()) : false;
            //chk_episodic_ligth.Checked = ds.Tables[0].Rows[0]["Episodic"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Episodic"].ToString()) : false;
            //chk_rashes.Checked = ds.Tables[0].Rows[0]["Rashes"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Rashes"].ToString()) : false;
            //chk_hearing_loss.Checked = ds.Tables[0].Rows[0]["HearingLoss"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["HearingLoss"].ToString()) : false;
            //chk_sleep_disturbance.Checked = ds.Tables[0].Rows[0]["NightSweats"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["NightSweats"].ToString()) : false;
            //chk_depression.Checked = ds.Tables[0].Rows[0]["Depression"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Depression"].ToString()) : false;

            //chk_bloodinurine.Checked = ds.Tables[0].Rows[0]["dloodinurine"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["dloodinurine"].ToString()) : false;

            LTricepstxt.Text      = Convert.ToString(ds.Tables[0].Rows[0]["DTRtricepsLeft"]);
            RTricepstxt.Text      = Convert.ToString(ds.Tables[0].Rows[0]["DTRtricepsRight"]);
            LBicepstxt.Text       = Convert.ToString(ds.Tables[0].Rows[0]["DTRBicepsLeft"]);
            RBicepstxt.Text       = Convert.ToString(ds.Tables[0].Rows[0]["DTRBicepsRight"]);
            RBrachioradialis.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBrachioRight"]);
            LBrachioradialis.Text = Convert.ToString(ds.Tables[0].Rows[0]["DTRBrachioLeft"]);
            LKnee.Text            = Convert.ToString(ds.Tables[0].Rows[0]["DTRKneeLeft"]);
            RKnee.Text            = Convert.ToString(ds.Tables[0].Rows[0]["DTRKneeRight"]);
            LAnkle.Text           = Convert.ToString(ds.Tables[0].Rows[0]["DTRAnkleLeft"]);
            RAnkle.Text           = Convert.ToString(ds.Tables[0].Rows[0]["DTRAnkleRight"]);
            UExchk.Checked        = ds.Tables[0].Rows[0]["UEdtr"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEdtr"].ToString()) : false;
            chkPinPrick.Checked   = ds.Tables[0].Rows[0]["Pinprick"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Pinprick"].ToString()) : false;
            chkLighttouch.Checked = ds.Tables[0].Rows[0]["Lighttouch"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Lighttouch"].ToString()) : false;
            txtSensory.Text       = Convert.ToString(ds.Tables[0].Rows[0]["Sensory"]);
            LESen_Click.Checked   = ds.Tables[0].Rows[0]["LEsen"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEsen"].ToString()) : false;
            TextBox4.Text         = Convert.ToString(ds.Tables[0].Rows[0]["LEL3Right"]);
            txtDMTL3.Text         = Convert.ToString(ds.Tables[0].Rows[0]["LEL3Left"]);
            TextBox6.Text         = Convert.ToString(ds.Tables[0].Rows[0]["LEL4Right"]);
            TextBox5.Text         = Convert.ToString(ds.Tables[0].Rows[0]["LEL4Left"]);
            TextBox8.Text         = Convert.ToString(ds.Tables[0].Rows[0]["LEL5Right"]);
            TextBox7.Text         = Convert.ToString(ds.Tables[0].Rows[0]["LEL5Left"]);
            TextBox10.Text        = Convert.ToString(ds.Tables[0].Rows[0]["LES1Left"]);
            TextBox21.Text        = Convert.ToString(ds.Tables[0].Rows[0]["LES1Right"]);
            TextBox25.Text        = Convert.ToString(ds.Tables[0].Rows[0]["LELumberParaspinalsRight"]);
            TextBox24.Text        = Convert.ToString(ds.Tables[0].Rows[0]["LELumberParaspinalsLeft"]);
            UESen_Click.Checked   = ds.Tables[0].Rows[0]["UEsen"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEsen"].ToString()) : false;
            TextBox9.Text         = Convert.ToString(ds.Tables[0].Rows[0]["UEC5Left"]);
            txtUEC5Right.Text     = Convert.ToString(ds.Tables[0].Rows[0]["UEC5Right"]);
            TextBox11.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UEC6Left"]);
            TextBox12.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UEC6Right"]);
            TextBox13.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UEC7Left"]);
            TextBox14.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UEC7Right"]);
            TextBox15.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UEC8Left"]);
            TextBox16.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UEC8Right"]);
            TextBox18.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UET1Right"]);
            TextBox17.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UET1Left"]);
            TextBox20.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UECervicalParaspinalsRight"]);
            TextBox19.Text        = Convert.ToString(ds.Tables[0].Rows[0]["UECervicalParaspinalsLeft"]);
            //  cboHoffmanexam.SelectedValue = Convert.ToString(ds.Tables[0].Rows[0]["HoffmanExam"]);
            // chkStocking.Checked = ds.Tables[0].Rows[0]["Stocking"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Stocking"].ToString()) : false;
            //chkGlove.Checked = ds.Tables[0].Rows[0]["Glove"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["Glove"].ToString()) : false;
            LEmmst.Checked       = ds.Tables[0].Rows[0]["LEmmst"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEmmst"].ToString()) : false;
            TextBox23.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEHipFlexionRight"]);
            TextBox22.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEHipFlexionLeft"]);
            TextBox41.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEHipAbductionRight"]);
            TextBox40.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEHipAbductionLeft"]);
            TextBox27.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeExtensionRight"]);
            TextBox26.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeExtensionLeft"]);
            TextBox43.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeFlexionRight"]);
            TextBox42.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEKneeFlexionLeft"]);
            TextBox29.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleDorsiRight"]);
            TextBox28.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleDorsiLeft"]);
            TextBox45.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEAnklePlantarRight"]);
            TextBox44.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEAnklePlantarLeft"]);
            TextBox47.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleExtensorRight"]);
            TextBox46.Text       = Convert.ToString(ds.Tables[0].Rows[0]["LEAnkleExtensorLeft"]);
            UEmmst.Checked       = ds.Tables[0].Rows[0]["UEmmst"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["UEmmst"].ToString()) : false;
            TextBox31.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderAbductionRight"]);
            TextBox30.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderAbductionLeft"]);
            TextBox49.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderFlexionRight"]);
            TextBox48.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEShoulderFlexionLeft"]);
            TextBox33.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowExtensionRight"]);
            TextBox32.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowExtensionLeft"]);
            TextBox51.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowFlexionRight"]);
            TextBox50.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowFlexionLeft"]);
            TextBox53.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowSupinationRight"]);
            TextBox52.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowSupinationLeft"]);
            TextBox55.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowPronationRight"]);
            TextBox54.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEElbowPronationLeft"]);
            TextBox37.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEWristFlexionRight"]);
            TextBox36.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEWristFlexionLeft"]);
            TextBox57.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEWristExtensionRight"]);
            TextBox56.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEWristExtensionLeft"]);
            TextBox39.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEHandGripStrengthRight"]);
            TextBox38.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEHandGripStrengthLeft"]);
            TextBox59.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEHandFingerAbductorsRight"]);
            TextBox58.Text       = Convert.ToString(ds.Tables[0].Rows[0]["UEHandFingerAbductorsLeft"]);
            txtIntactExcept.Text = Convert.ToString(ds.Tables[0].Rows[0]["intactexcept"]);
            LEdtr.Checked        = ds.Tables[0].Rows[0]["LEdtr"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["LEdtr"].ToString()) : false;
        }
        else
        {
            PopulateUIDefaults();
        }

        query = "select * from tblPage3HTMLContent where  PatientIE_ID=" + Session["PatientIE_ID"].ToString();
        ds    = db.selectData(query);

        if (ds.Tables[0].Rows.Count > 0)
        {
            divHtml.InnerHtml    = ds.Tables[0].Rows[0]["HTMLContent"].ToString();
            divtopHtml.InnerHtml = ds.Tables[0].Rows[0]["topSectionHTML"].ToString();
        }
        else
        {
            bindHtml();
        }

        query = "Select * from tblPatientIEDetailPage3 WHERE PatientIE_ID = " + Session["PatientIE_ID"].ToString();
        ds    = db.selectData(query);


        if (ds.Tables[0].Rows.Count > 0)
        {
            cboGAIT.Text                  = ds.Tables[0].Rows[0]["GAIT"].ToString().Trim();
            cboAmbulates.Text             = ds.Tables[0].Rows[0]["Ambulates"].ToString().Trim();
            chkFootslap.Checked           = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Footslap"].ToString());
            chkKneehyperextension.Checked = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Kneehyperextension"].ToString());
            chkUnabletohealwalk.Checked   = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Unabletohealwalk"].ToString());
            chkUnabletotoewalk.Checked    = CommonConvert.ToBoolean(ds.Tables[0].Rows[0]["Unabletotoewalk"].ToString());
            txtOther.Text                 = ds.Tables[0].Rows[0]["Other"].ToString().Trim();
        }
    }