private void LoadPersonPhone()
        {
            this.txtID.Text = Request.QueryString["PersonID"];
            int PersonID = Convert.ToInt32(txtID.Text);

            this.txtPhID.Text = Request.QueryString["PhoneID"];
            int PhoneID = Convert.ToInt32(txtPhID.Text);

            //I should make a line of code for every text box, converting the value to the string .

            DataManager.DataAccess da = new DataManager.DataAccess();

            DataSet ds  = da.FetchPhoneNumber(PhoneID);
            DataSet ds2 = da.FetchPersonPhone(PhoneID);
            //  DataSet ds2 = da.FetchPersonPhones(PersonID);

            // txtID.Text = ds.Tables[0].Rows[0]["PersonID"].ToString();
            //txtPhID.Text = ds.Tables[0].Rows[0]["PhoneID"].ToString();

            object pi = ds.Tables[0].Rows[0]["PhoneID"];  // PhoneID, AreaCode, PhoneNumber, Extension, PhoneType
            object ac = ds.Tables[0].Rows[0]["AreaCode"];
            object pn = ds.Tables[0].Rows[0]["PhoneNumber"];
            object ex = ds.Tables[0].Rows[0]["Extension"];
            object pt = ds.Tables[0].Rows[0]["PhoneTypeID"];

            // txtID.Text = pi.ToString();
            txtAreaCode.Text    = ac.ToString();
            txtPhoneNumber.Text = pn.ToString();
            txtExtension.Text   = ex.ToString();
            ddlPhoneTypeID.Text = pt.ToString();

            //DoNotCall, DoNotText, Description, Notes
            object dnc = ds2.Tables[0].Rows[0]["DoNotCall"];
            object dnt = ds2.Tables[0].Rows[0]["DoNotText"];

            object EPPn = ds2.Tables[0].Rows[0]["Notes"];
            object EPPd = ds2.Tables[0].Rows[0]["Description"];

            txtDescription.Text = EPPd.ToString();
            txtNotes.Text       = EPPn.ToString();


            cbDNT.Checked = Convert.ToBoolean(dnt.ToString());
            cbDNC.Checked = Convert.ToBoolean(dnc.ToString());
        }
        private void LoadPersonPhone()
        {
            this.txtID.Text = Request.QueryString["PersonID"];
            int PersonID = Convert.ToInt32(txtID.Text);

            this.txtPhID.Text = Request.QueryString["PhoneID"];
            int PhoneID = Convert.ToInt32(txtPhID.Text);
            //I should make a line of code for every text box, converting the value to the string .

            DataManager.DataAccess da = new DataManager.DataAccess();

            DataSet ds = da.FetchPhoneNumber(PhoneID);
            DataSet ds2 = da.FetchPersonPhone(PhoneID);
            //  DataSet ds2 = da.FetchPersonPhones(PersonID);

            // txtID.Text = ds.Tables[0].Rows[0]["PersonID"].ToString();
            //txtPhID.Text = ds.Tables[0].Rows[0]["PhoneID"].ToString();

            object pi = ds.Tables[0].Rows[0]["PhoneID"];  // PhoneID, AreaCode, PhoneNumber, Extension, PhoneType
            object ac = ds.Tables[0].Rows[0]["AreaCode"];
            object pn = ds.Tables[0].Rows[0]["PhoneNumber"];
            object ex = ds.Tables[0].Rows[0]["Extension"];
            object pt = ds.Tables[0].Rows[0]["PhoneTypeID"];
            // txtID.Text = pi.ToString();
            txtAreaCode.Text = ac.ToString();
            txtPhoneNumber.Text = pn.ToString();
            txtExtension.Text = ex.ToString();
            ddlPhoneTypeID.Text = pt.ToString();

            //DoNotCall, DoNotText, Description, Notes
            object dnc = ds2.Tables[0].Rows[0]["DoNotCall"];
            object dnt = ds2.Tables[0].Rows[0]["DoNotText"];

            object EPPn = ds2.Tables[0].Rows[0]["Notes"];
            object EPPd = ds2.Tables[0].Rows[0]["Description"];

            txtDescription.Text = EPPd.ToString();
            txtNotes.Text = EPPn.ToString();

            cbDNT.Checked = Convert.ToBoolean(dnt.ToString());
            cbDNC.Checked = Convert.ToBoolean(dnc.ToString());
        }