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());
}