protected void btnSearch_Click1(object sender, EventArgs e)
{
if (txtID.Text != "")
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsCompanies = new DataSet();
int CompanyID = Convert.ToInt32(txtID.Text);
dsCompanies = da.FetchCompany(CompanyID);
gvCompanyName.DataSource = dsCompanies;
gvCompanyName.DataBind();
}
else
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsCompanies = new DataSet();
String Name = txtName.Text;
dsCompanies = da.FetchCompany(Name);
gvCompanyName.DataSource = dsCompanies;
gvCompanyName.DataBind();
//dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim());
//gvPersonName.DataSource = dsPersons;
//gvPersonName.DataBind();
}
}
protected void btnSave_Click1(object sender, EventArgs e)
{
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
// Here we are declaring a variable for PersonID and calling the new InsertPerson2 method (remember that the new
// method returns a value where the old method did not)
object personID = da.InsertPerson2(FirstName, LastName);
txtID.Text = personID.ToString();
SuccessLabel.Visible = true;
NameDisplayLabel.Text = FirstName + ' ' + LastName;
txtFirstName.Text = "";
txtLastName.Text = "";
txtFirstName.Text = FirstName;
txtLastName.Text = LastName;
btnSave.Visible = false;
AddButton.Visible = true;
// This is how a queryString when there are 2 values
// Response.Redirect("TestPage2.aspx?Name=" +
//this.txtName.Text + "&LastName=" +
//this.txtLastName.Text);
Response.Redirect("EditPerson.aspx?PersonID=" +
this.txtID.Text + "&Mode=Edit");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int CompanyID = Convert.ToInt32(txtID.Text);
int AddressID = Convert.ToInt32(txtAID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeleteCompanyAddress(CompanyID, AddressID);
//Response.Redirect("FetchPerson.aspx");
Response.Redirect("EditCompany.aspx?Mode=Edit&CompanyID=" + this.txtID.Text);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int CompanyID = Convert.ToInt32(txtID.Text);
String Name = txtName.Text;
String Notes = txtNotes.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeleteCompany(CompanyID);
Response.Redirect("FetchCompany.aspx");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int PersonID = Convert.ToInt32(txtID.Text);
int PhoneID = Convert.ToInt32(txtPhID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeletePersonPhoneNumber(PersonID, PhoneID);
//Response.Redirect("FetchPerson.aspx");
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int PersonID = Convert.ToInt32(txtID.Text);
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeletePerson(PersonID);
Response.Redirect("FetchPerson.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPersons();
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPersons();
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int CompanyID = Convert.ToInt32(txtID.Text);
int AddressID = Convert.ToInt32(txtAID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeleteCompanyAddress(CompanyID, AddressID);
//Response.Redirect("FetchPerson.aspx");
Response.Redirect("EditCompany.aspx?Mode=Edit&CompanyID=" + this.txtID.Text);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int CompanyID = Convert.ToInt32(txtID.Text);
String Name = txtName.Text;
String Notes = txtNotes.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeleteCompany(CompanyID);
Response.Redirect("FetchCompany.aspx");
}
protected void btnFillAddress_Click(object sender, EventArgs e)
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchPersonAddressesGrid(PersonID);
gvPersonAddresses.DataSource = ds2;
gvPersonAddresses.DataBind();
}
public void SearchPersonFunction()
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
dsPersons = da.FetchPerson(PersonID);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
dsPersons = da.FetchPerson(PersonID);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void gvPersonName_PageIndexChanging2(object sender, GridViewPageEventArgs e)
{
gvPersonName.PageIndex = e.NewPageIndex;
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim());
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void gvPersonName_PageIndexChanging2(object sender, GridViewPageEventArgs e)
{
gvPersonName.PageIndex = e.NewPageIndex;
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim());
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int PersonID = Convert.ToInt32(txtID.Text);
int PhoneID = Convert.ToInt32(txtPhID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeletePersonPhoneNumber(PersonID, PhoneID);
//Response.Redirect("FetchPerson.aspx");
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
}
protected void btnFillEmail_Click(object sender, EventArgs e)
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int EmailAddressID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchEmailAddress(EmailAddressID);
gvEmail.DataSource = ds2;
gvEmail.DataBind();
}
public void SearchPersonFunction()
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
dsPersons = da.FetchPerson(PersonID);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
dsPersons = da.FetchPerson(PersonID);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int PersonID = Convert.ToInt32(txtID.Text);
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
da.DeletePerson(PersonID);
Response.Redirect("FetchPerson.aspx");
}
// This code is the btnDisplay click Event Page load fillPhoneGrid() replaces this click event
//protected void btnDisplay_Click(object sender, EventArgs e)
//{
// DataManager.DataAccess da = new DataManager.DataAccess();
// DataSet ds = new DataSet();
// int PersonID = Convert.ToInt32(txtID.Text);
// ds = da.FetchPersonPhonesGrid(PersonID);
// gvPersonPhoneNumber.DataSource = ds;
// gvPersonPhoneNumber.DataBind();
//}
protected void fillPhoneGrid()
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
ds = da.FetchPersonPhonesGrid(PersonID);
gvPersonPhoneNumber.DataSource = ds;
gvPersonPhoneNumber.DataBind();
}
protected void fillCompanyAddressGrid()
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int CompanyID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchCompanyAddressesGrid(CompanyID);
gvCompanyAddresses.DataSource = ds2;
gvCompanyAddresses.DataBind();
}
protected void fillAddressGrid()
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchPersonAddressesGrid(PersonID);
gvPersonAddresses.DataSource = ds2;
gvPersonAddresses.DataBind();
}
protected void btnFillAddress_Click(object sender, EventArgs e)
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchPersonAddressesGrid(PersonID);
gvPersonAddresses.DataSource = ds2;
gvPersonAddresses.DataBind();
}
private void LoadCompanyAddress()
{
this.txtID.Text = Request.QueryString["CompanyID"];
int CompanyID = Convert.ToInt32(txtID.Text);
// if (Request.QueryString["AddressID"] != null)
this.txtAID.Text = Request.QueryString["AddressID"];
int AddressID = Convert.ToInt32(txtAID.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.FetchPersonsAddresses(PersonID, AddressID);
// DataSet ds2 = da.FetchPersonAddresses(PersonID);
DataSet ds = da.FetchCompaniesAddresses(CompanyID, AddressID);
DataSet ds2 = da.FetchCompanyAddresses(CompanyID, AddressID);
//////////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 fpa = da.FetchPersonAddresses();
object ai = ds.Tables[0].Rows[0]["AddressID"]; // PhoneID, AreaCode, PhoneNumber, Extension, PhoneType
object s1 = ds.Tables[0].Rows[0]["Street1"];
object s2 = ds.Tables[0].Rows[0]["Street2"];
object ci = ds.Tables[0].Rows[0]["City"];
object st = ds.Tables[0].Rows[0]["State"];
object zi = ds.Tables[0].Rows[0]["Zip"];
//txtID.Text = pi.ToString();
txtStreet1.Text = s1.ToString();
txtStreet2.Text = s2.ToString();
txtCity.Text = ci.ToString();
txtState.Text = st.ToString();
txtZip.Text = zi.ToString();
// object pid = ds2.Tables[0].Rows[0]["PersonID"];
// object aid = ds2.Tables[0].Rows[0]["AddressID"];
// object atid = ds2.Tables[0].Rows[0]["AddressTypeID"];
object EPAn = ds2.Tables[0].Rows[0]["Notes"];
object EPAd = ds2.Tables[0].Rows[0]["Description"];
txtDescription.Text = EPAd.ToString();
txtNotes.Text = EPAn.ToString();
}
protected void btnFillEmail_Click(object sender, EventArgs e)
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int EmailAddressID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchEmailAddress(EmailAddressID);
gvEmail.DataSource = ds2;
gvEmail.DataBind();
}
protected void btnFindPerson_Click(object sender, EventArgs e)
{
//'Dim da As New DataAccess_OLD
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim());
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
String Address = txtEmail.Text;
int EmailAddressID;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
this.txtEID.Text = Request.QueryString["EmailAddressID"];
txtEID.Enabled = true;
EmailAddressID = Convert.ToInt32(txtEID.Text);
Address = txtEmail.Text;
int PersonID = Convert.ToInt32(txtID.Text);
da.UpdateEmailAddress(EmailAddressID, Address, PersonID);
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
btnDone.Enabled = true;
btnDone.Visible = false;
// Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
break;
case "New":
Address = txtEmail.Text;
PersonID = Convert.ToInt32(txtID.Text);
object oEmailAddressID = da.InsertEmailAddress(Address, PersonID);
txtEID.Text = oEmailAddressID.ToString();
EmailAddressID = Convert.ToInt32(oEmailAddressID.ToString());
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
// Response.Redirect("EditPersonPhoneNumber.aspx?PersonID=" +
//this.txtID.Text + "&Mode=Edit&PhoneID=" + this.txtPhID.Text);
break;
}
}
protected void fillCompanyPhoneGrid()
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
int CompanyID = Convert.ToInt32(txtID.Text);
ds = da.FetchCompanyPhonesGrid(CompanyID);
gvCompanyPhoneNumber.DataSource = ds;
gvCompanyPhoneNumber.DataBind();
}
protected void btnFindPerson_Click(object sender, EventArgs e)
{
//'Dim da As New DataAccess_OLD
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim());
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
String Address = txtEmail.Text;
int EmailAddressID;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
this.txtEID.Text = Request.QueryString["EmailAddressID"];
txtEID.Enabled = true;
EmailAddressID = Convert.ToInt32(txtEID.Text);
Address = txtEmail.Text;
int PersonID = Convert.ToInt32(txtID.Text);
da.UpdateEmailAddress(EmailAddressID, Address, PersonID);
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
btnDone.Enabled = true;
btnDone.Visible = false;
// Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
break;
case "New":
Address = txtEmail.Text;
PersonID = Convert.ToInt32(txtID.Text);
object oEmailAddressID = da.InsertEmailAddress(Address, PersonID);
txtEID.Text = oEmailAddressID.ToString();
EmailAddressID = Convert.ToInt32(oEmailAddressID.ToString());
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
// Response.Redirect("EditPersonPhoneNumber.aspx?PersonID=" +
//this.txtID.Text + "&Mode=Edit&PhoneID=" + this.txtPhID.Text);
break;
}
}
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 LoadEmailAddress()
{
this.txtID.Text = Request.QueryString["PersonID"];
int PersonID = Convert.ToInt32(txtID.Text);
object EmailID = Convert.ToInt32(Request.QueryString["EmailAddressID"]);
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = da.FetchEmailAddress(PersonID);
object ei = ds.Tables[0].Rows[0]["EmailAddressID"]; // PhoneID, AreaCode, PhoneNumber, Extension, PhoneType
object ea = ds.Tables[0].Rows[0]["Address"];
// object pid = ds.Tables[0].Rows[0]["PersonID"];
txtEID.Text = ei.ToString();
txtEmail.Text = ea.ToString();
}
//protected void fillAddressGrid()
//{
// DataManager.DataAccess da = new DataManager.DataAccess();
// DataSet ds = new DataSet();
// int PersonID = Convert.ToInt32(txtID.Text);
// ds = da.FetchPersonAddressesGrid(PersonID);
// gvPersonPhoneNumber.DataSource = ds;
// gvPersonPhoneNumber.DataBind();
// //if (gvPersonPhoneNumber.DataSource != null)
// //{
// //}
// //else
// //{
// // NameDisplayLabel.Text = "No Results Found!";
// //}
//}
protected void fillEmail()
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int EmailAddressID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchEmailAddress(EmailAddressID);
gvEmail.DataSource = ds2;
gvEmail.DataBind();
//////DataManager.DataAccess da = new DataManager.DataAccess();
//////DataSet ds = new DataSet();
//////int PersonID = Convert.ToInt32(txtID.Text);
//////ds = da.FetchPersonAddressesGrid(PersonID);
//////gvPersonPhoneNumber.DataSource = ds;
//////gvPersonPhoneNumber.DataBind();
}
private void LoadCompany()
{
this.txtID.Text = Request.QueryString["CompanyID"];
int CompanyID = Convert.ToInt32(txtID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = da.FetchCompany(CompanyID);
object ci = ds.Tables[0].Rows[0]["CompanyID"];
object cn = ds.Tables[0].Rows[0]["Name"];
object n = ds.Tables[0].Rows[0]["Notes"];
txtID.Text = ci.ToString();
txtName.Text = cn.ToString();
txtNotes.Text = n.ToString();
String Name = txtName.Text;
}
protected void btnSave_Click(object sender, EventArgs e)
{
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
txtID.Enabled = true;
int PersonID = Convert.ToInt32(txtID.Text);
FirstName = txtFirstName.Text;
LastName = txtLastName.Text;
da.UpdatePerson(PersonID, FirstName, LastName);
Response.Redirect("EditPerson.aspx?PersonID=" +
this.txtID.Text + "&Mode=Edit");
//Response.Redirect("EditPerson.aspx?Mode=Edit");
btnDone.Enabled = true;
btnDone.Visible = true;
break;
case "New":
FirstName = txtFirstName.Text;
LastName = txtLastName.Text;
DataManager.DataAccess da2 = new DataManager.DataAccess();
object personID = da2.InsertPerson2(FirstName, LastName);
txtID.Text = personID.ToString();
PersonID = Convert.ToInt32(txtID.Text);
txtFirstName.Text = FirstName;
txtLastName.Text = LastName;
Response.Redirect("EditPerson.aspx?PersonID=" +
this.txtID.Text + "&Mode=Edit");
break;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
String Name = txtName.Text;
String Notes = txtNotes.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
txtID.Enabled = true;
int CompanyID = Convert.ToInt32(txtID.Text);
Name = txtName.Text;
Notes = txtNotes.Text;
da.UpdateCompany(CompanyID, Name, Notes);
Response.Redirect("EditCompany.aspx?CompanyID=" +
this.txtID.Text + "&Mode=Edit");
//Response.Redirect("EditPerson.aspx?Mode=Edit");
btnDone.Enabled = true;
btnDone.Visible = true;
break;
case "New":
Name = txtName.Text;
Notes = txtNotes.Text;
DataManager.DataAccess da2 = new DataManager.DataAccess();
object companyID = da2.InsertCompany2(Name, Notes);
txtID.Text = companyID.ToString();
CompanyID = Convert.ToInt32(txtID.Text);
txtName.Text = Name;
txtNotes.Text = Notes;
Response.Redirect("EditCompany.aspx?CompanyID=" +
this.txtID.Text + "&Mode=Edit");
break;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
txtID.Enabled = true;
int PersonID = Convert.ToInt32(txtID.Text);
FirstName = txtFirstName.Text;
LastName = txtLastName.Text;
da.UpdatePerson(PersonID, FirstName, LastName);
Response.Redirect("EditPerson.aspx?PersonID=" +
this.txtID.Text + "&Mode=Edit");
//Response.Redirect("EditPerson.aspx?Mode=Edit");
btnDone.Enabled = true;
btnDone.Visible = true;
break;
case "New":
FirstName = txtFirstName.Text;
LastName = txtLastName.Text;
DataManager.DataAccess da2 = new DataManager.DataAccess();
object personID = da2.InsertPerson2(FirstName, LastName);
txtID.Text = personID.ToString();
PersonID = Convert.ToInt32(txtID.Text);
txtFirstName.Text = FirstName;
txtLastName.Text = LastName;
Response.Redirect("EditPerson.aspx?PersonID=" +
this.txtID.Text + "&Mode=Edit");
break;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
String Name = txtName.Text;
String Notes = txtNotes.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
txtID.Enabled = true;
int CompanyID = Convert.ToInt32(txtID.Text);
Name = txtName.Text;
Notes = txtNotes.Text;
da.UpdateCompany(CompanyID, Name, Notes);
Response.Redirect("EditCompany.aspx?CompanyID=" +
this.txtID.Text + "&Mode=Edit");
//Response.Redirect("EditPerson.aspx?Mode=Edit");
btnDone.Enabled = true;
btnDone.Visible = true;
break;
case "New":
Name = txtName.Text;
Notes = txtNotes.Text;
DataManager.DataAccess da2 = new DataManager.DataAccess();
object companyID = da2.InsertCompany2(Name, Notes);
txtID.Text = companyID.ToString();
CompanyID = Convert.ToInt32(txtID.Text);
txtName.Text = Name;
txtNotes.Text = Notes;
Response.Redirect("EditCompany.aspx?CompanyID=" +
this.txtID.Text + "&Mode=Edit");
break;
}
}
protected void btnSave_Click1(object sender, EventArgs e)
{
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
DataManager.DataAccess da = new DataManager.DataAccess();
// Here we are declaring a variable for PersonID and calling the new InsertPerson2 method (remember that the new
// method returns a value where the old method did not)
object personID = da.InsertPerson2(FirstName, LastName);
txtID.Text = personID.ToString();
SuccessLabel.Visible = true;
NameDisplayLabel.Text = FirstName + ' ' + LastName;
txtFirstName.Text = "";
txtLastName.Text = "";
txtFirstName.Text = FirstName;
txtLastName.Text = LastName;
btnSave.Visible = false;
AddButton.Visible = true;
// This is how a queryString when there are 2 values
// Response.Redirect("TestPage2.aspx?Name=" +
//this.txtName.Text + "&LastName=" +
//this.txtLastName.Text);
Response.Redirect("EditPerson.aspx?PersonID=" +
this.txtID.Text + "&Mode=Edit");
}
private void LoadPerson()
{
this.txtID.Text = Request.QueryString["PersonID"];
int PersonID = Convert.ToInt32(txtID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = da.FetchPerson(PersonID);
object pi = ds.Tables[0].Rows[0]["PersonID"];
object fn = ds.Tables[0].Rows[0]["FirstName"];
object ln = ds.Tables[0].Rows[0]["LastName"];
txtID.Text = pi.ToString();
txtFirstName.Text = fn.ToString();
txtLastName.Text = ln.ToString();
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
// add an else, set the NameDisplayLabel to empty string, and i
NameDisplayLabel.Text = FirstName + " " + LastName + " has been added to the database.";
}
protected void SearchButton_Click(object sender, EventArgs e)
{
if (txtID.Text != "")
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
dsPersons = da.FetchPerson(PersonID);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
else
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim());
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
String data;
if (Request.QueryString["Mode"] != null)
{
//
}
else
{
data = Request.QueryString["Mode"].ToString();
}
// ////////// Response.Redirect("EditPersonPhoneNumber.aspx?Mode=New");
if (!IsPostBack)
{
string ModeStatus = Request.QueryString["Mode"];
switch (ModeStatus)
{
case "New":
lblModeStatus.Text = "Add New Phone Number";
break;
case "View":
lblModeStatus.Text = "View Phone Number";
break;
case "Edit":
lblModeStatus.Text = "Edit Phone Number";
break;
case "Delete":
lblModeStatus.Text = "Delete Phone Number";
break;
}
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
ds = da.FetchPhoneTypes();
ddlPhoneTypeID.DataSource = ds.Tables[0];
//The DataTextField is the value of what will show in the ddl
// the DataValueField is the Value of the
ddlPhoneTypeID.DataTextField = "Name";
ddlPhoneTypeID.DataValueField = "PhoneTypeID";
ddlPhoneTypeID.DataBind();
//object phoneTypeID = da5.FetchPhoneTypes();
if (Request.QueryString != null)
{
if (Request.QueryString["PersonID"] != null)
{
this.txtID.Text = Request.QueryString["PersonID"].ToString();
}
string Mode = Request.QueryString["Mode"];
switch (Mode)
{
case "View":
btnDone.Visible = true;
btnSave.Visible = false;
btnDelete.Visible = false;
btnCancel.Visible = false;
LoadPersonPhone();
txtPhID.Enabled = false;
txtAreaCode.Enabled = false;
txtPhoneNumber.Enabled = false;
txtExtension.Enabled = false;
ddlPhoneTypeID.Enabled = false;
txtDescription.Enabled = false;
txtNotes.Enabled = false;
cbDNC.Enabled = false;
cbDNT.Enabled = false;
txtID.Enabled = false;
txtPhID.Enabled = false;
break;
case "New":
btnDone.Visible = false;
btnSave.Visible = true;
btnDelete.Visible = false;
// LoadPerson();
txtPhID.Enabled = false;
txtAreaCode.Enabled = true;
txtPhoneNumber.Enabled = true;
txtExtension.Enabled = true;
ddlPhoneTypeID.Enabled = true;
break;
case "Edit":
txtID.Enabled = false;
btnDone.Visible = true;
btnSave.Visible = true;
btnDelete.Visible = false;
btnCancel.Visible = false;
txtPhID.Enabled = false;
txtAreaCode.Enabled = true;
txtPhoneNumber.Enabled = true;
txtExtension.Enabled = true;
ddlPhoneTypeID.Enabled = true;
object PhoneID = Convert.ToInt32(Request.QueryString["PhoneID"]);
txtPhID.Text = PhoneID.ToString();
LoadPersonPhone();
btnDone.Visible = false;
break;
case "Delete":
btnDone.Visible = false;
btnSave.Visible = false;
btnDelete.Visible = true;
//NameDisplayLabel.Visible = false;
LoadPersonPhone();
txtPhID.Enabled = false;
txtAreaCode.Enabled = false;
txtPhoneNumber.Enabled = false;
txtExtension.Enabled = false;
ddlPhoneTypeID.Enabled = false;
txtNotes.ReadOnly = true;
txtDescription.ReadOnly = true;
txtDescription.Enabled = false;
txtNotes.Enabled = false;
txtID.Enabled = false;
break;
//Request.QueryString["PersonID"] = "New";
}
}
else
{
Response.Redirect("FetchPerson.aspx");
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
String AreaCode = txtAreaCode.Text;
String PhoneNumber = txtPhoneNumber.Text;
String Extension = txtExtension.Text;
int PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text);
bool DoNotText;
bool DoNotCall;
// int PhoneID = Convert.ToInt32(txtPhID.Text);
int PhoneID;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
this.txtPhID.Text = Request.QueryString["PhoneID"];
txtPhID.Enabled = true;
PhoneID = Convert.ToInt32(txtPhID.Text);
AreaCode = txtAreaCode.Text;
PhoneNumber = txtPhoneNumber.Text;
Extension = txtExtension.Text;
PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text);
int PersonID = Convert.ToInt32(txtID.Text);
String Description = txtDescription.Text;
String Notes = txtNotes.Text;
if (cbDNC.Checked == false)
{
cbDNC.Checked = false;
}
if (cbDNC.Checked == true)
{
cbDNC.Checked = true;
}
if (cbDNT.Checked == false)
{
cbDNT.Checked = false;
}
if (cbDNT.Checked == true)
{
cbDNT.Checked = true;
}
DoNotCall = cbDNC.Checked;
DoNotText = cbDNT.Checked;
da.UpdatePhone(PhoneID, AreaCode, PhoneNumber, Extension, PhoneTypeID); //UpdatePhone(int PhoneID, int AreaCode, int PhoneNumber, String Extension, int PhoneTypeID)
da.UpdatePersonPhoneNumber(PersonID, PhoneID, Description, Notes, DoNotCall, DoNotText);
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
btnDone.Enabled = true;
btnDone.Visible = false;
// Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
break;
case "New":
AreaCode = txtAreaCode.Text;
PhoneNumber = txtPhoneNumber.Text;
Extension = txtExtension.Text;
PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.SelectedValue);
//PersonID = Convert.ToInt32(txtID.Text);
// PhoneID = Convert.ToInt32(txtPhID.Text);
Description = txtDescription.Text;
Notes = txtNotes.Text;
DoNotCall = cbDNC.Checked;
DoNotText = cbDNT.Checked;
PersonID = Convert.ToInt32(txtID.Text);
object phoneNumberID = da.InsertPhoneNumber(AreaCode, PhoneNumber, Extension, PhoneTypeID);
txtPhID.Text = phoneNumberID.ToString();
// da.InsertPhoneNumber(AreaCode, PhoneNumber, Extension, PhoneTypeID);
//txtPhID.Text = phoneNumberID.ToString();
PhoneID = Convert.ToInt32(txtPhID.Text.ToString());
// txtNotes.Text = PhoneID.ToString();
da.InsertPersonPhone(PersonID, PhoneID, Description, Notes, DoNotCall, DoNotText);
// I need to send the PersonID and the PhoneID to the Edit Page
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
// Response.Redirect("EditPersonPhoneNumber.aspx?PersonID=" +
//this.txtID.Text + "&Mode=Edit&PhoneID=" + this.txtPhID.Text);
break;
}
}
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 LoadCompany()
{
this.txtID.Text = Request.QueryString["CompanyID"];
int CompanyID = Convert.ToInt32(txtID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = da.FetchCompany(CompanyID);
object ci = ds.Tables[0].Rows[0]["CompanyID"];
object cn = ds.Tables[0].Rows[0]["Name"];
object n = ds.Tables[0].Rows[0]["Notes"];
txtID.Text = ci.ToString();
txtName.Text = cn.ToString();
txtNotes.Text = n.ToString();
String Name = txtName.Text;
}
protected void Page_Load(object sender, EventArgs e)
{
String data;
if (Request.QueryString["Mode"] != null)
{
//
}
else
{
data = Request.QueryString["Mode"].ToString();
}
// ////////// Response.Redirect("EditPersonPhoneNumber.aspx?Mode=New");
if (!IsPostBack)
{
string ModeStatus = Request.QueryString["Mode"];
switch (ModeStatus)
{
case "New":
lblModeStatus.Text = "Add New Phone Number";
break;
case "View":
lblModeStatus.Text = "View Phone Number";
break;
case "Edit":
lblModeStatus.Text = "Edit Phone Number";
break;
case "Delete":
lblModeStatus.Text = "Delete Phone Number";
break;
}
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
ds = da.FetchPhoneTypes();
ddlPhoneTypeID.DataSource = ds.Tables[0];
//The DataTextField is the value of what will show in the ddl
// the DataValueField is the Value of the
ddlPhoneTypeID.DataTextField = "Name";
ddlPhoneTypeID.DataValueField = "PhoneTypeID";
ddlPhoneTypeID.DataBind();
//object phoneTypeID = da5.FetchPhoneTypes();
if (Request.QueryString != null)
{
if (Request.QueryString["PersonID"] != null)
{
this.txtID.Text = Request.QueryString["PersonID"].ToString();
}
string Mode = Request.QueryString["Mode"];
switch (Mode)
{
case "View":
btnDone.Visible = true;
btnSave.Visible = false;
btnDelete.Visible = false;
btnCancel.Visible = false;
LoadPersonPhone();
txtPhID.Enabled = false;
txtAreaCode.Enabled = false;
txtPhoneNumber.Enabled = false;
txtExtension.Enabled = false;
ddlPhoneTypeID.Enabled = false;
txtDescription.Enabled = false;
txtNotes.Enabled = false;
cbDNC.Enabled = false;
cbDNT.Enabled = false;
txtID.Enabled = false;
txtPhID.Enabled = false;
break;
case "New":
btnDone.Visible = false;
btnSave.Visible = true;
btnDelete.Visible = false;
// LoadPerson();
txtPhID.Enabled = false;
txtAreaCode.Enabled = true;
txtPhoneNumber.Enabled = true;
txtExtension.Enabled = true;
ddlPhoneTypeID.Enabled = true;
break;
case "Edit":
txtID.Enabled = false;
btnDone.Visible = true;
btnSave.Visible = true;
btnDelete.Visible = false;
btnCancel.Visible = false;
txtPhID.Enabled = false;
txtAreaCode.Enabled = true;
txtPhoneNumber.Enabled = true;
txtExtension.Enabled = true;
ddlPhoneTypeID.Enabled = true;
object PhoneID = Convert.ToInt32(Request.QueryString["PhoneID"]);
txtPhID.Text = PhoneID.ToString();
LoadPersonPhone();
btnDone.Visible = false;
break;
case "Delete":
btnDone.Visible = false;
btnSave.Visible = false;
btnDelete.Visible = true;
//NameDisplayLabel.Visible = false;
LoadPersonPhone();
txtPhID.Enabled = false;
txtAreaCode.Enabled = false;
txtPhoneNumber.Enabled = false;
txtExtension.Enabled = false;
ddlPhoneTypeID.Enabled = false;
txtNotes.ReadOnly = true;
txtDescription.ReadOnly = true;
txtDescription.Enabled = false;
txtNotes.Enabled = false;
txtID.Enabled = false;
break;
//Request.QueryString["PersonID"] = "New";
}
}
else
{
Response.Redirect("FetchPerson.aspx");
}
}
}
// This code is the btnDisplay click Event Page load fillPhoneGrid() replaces this click event
//protected void btnDisplay_Click(object sender, EventArgs e)
//{
// DataManager.DataAccess da = new DataManager.DataAccess();
// DataSet ds = new DataSet();
// int PersonID = Convert.ToInt32(txtID.Text);
// ds = da.FetchPersonPhonesGrid(PersonID);
// gvPersonPhoneNumber.DataSource = ds;
// gvPersonPhoneNumber.DataBind();
//}
protected void fillPhoneGrid()
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
ds = da.FetchPersonPhonesGrid(PersonID);
gvPersonPhoneNumber.DataSource = ds;
gvPersonPhoneNumber.DataBind();
}
protected void btnSave_Click1(object sender, EventArgs e)
{
String Street1 = txtStreet1.Text;
String Street2 = txtStreet2.Text;
String City = txtCity.Text;
String State = txtState.Text;
String Zip = txtZip.Text;
int AddressTypeID = Convert.ToInt32(ddlAddressTypeID.Text);
//bool DoNotText;
//bool DoNotCall;
// int PhoneID = Convert.ToInt32(txtPhID.Text);
int AddressID;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
this.txtAID.Text = Request.QueryString["AddressID"];
txtAID.Enabled = true;
AddressID = Convert.ToInt32(txtAID.Text);
Street1 = txtStreet1.Text;
Street2 = txtStreet2.Text;
City = txtCity.Text;
State = txtState.Text;
Zip = txtZip.Text;
AddressTypeID = Convert.ToInt32(ddlAddressTypeID.Text);
int PersonID = Convert.ToInt32(txtID.Text);
String Description = txtDescription.Text;
String Notes = txtNotes.Text;
da.UpdateAddress(AddressID, Street1, Street2, City, State, Zip); //UpdatePhone(int PhoneID, int AreaCode, int PhoneNumber, String Extension, int PhoneTypeID)
da.UpdatePersonAddress(PersonID, AddressID, AddressTypeID, Description, Notes);
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
btnDone.Enabled = true;
btnDone.Visible = false;
// Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
break;
case "New":
Street1 = txtStreet1.Text;
Street2 = txtStreet2.Text;
City = txtCity.Text;
State = txtState.Text;
Zip = txtZip.Text;
AddressTypeID = Convert.ToInt32(ddlAddressTypeID.SelectedValue);
//PersonID = Convert.ToInt32(txtID.Text);
// PhoneID = Convert.ToInt32(txtPhID.Text);
Description = txtDescription.Text;
Notes = txtNotes.Text;
PersonID = Convert.ToInt32(txtID.Text);
object oAddressID = da.InsertAddress(Street1, Street2, City, State, Zip);
txtAID.Text = oAddressID.ToString();
AddressID = Convert.ToInt32(oAddressID.ToString());
//da.InsertPhoneNumber(AreaCode, PhoneNumber, Extension, PhoneTypeID);
//txtPhID.Text = phoneNumberID.ToString();
//AddressID = Convert.ToInt32(txtAID.Text.ToString());
// txtNotes.Text = PhoneID.ToString();
da.InsertPersonAddress(PersonID, AddressID, AddressTypeID, Description, Notes);
// I need to send the PersonID and the PhoneID to the Edit Page
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
// Response.Redirect("EditPersonPhoneNumber.aspx?PersonID=" +
//this.txtID.Text + "&Mode=Edit&PhoneID=" + this.txtPhID.Text);
break;
}
}
protected void btnSearchPersonKeywords_Click(object sender, EventArgs e)
{
//if search site is checked then I need to do similar to what is already being done
//if advanced search is checked, but no boxes are checked, I need to do what is being done here
if (txtPersonKeywords.Text != "")
{
if (radioSearch.Checked == true)
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
// int CompanyID = Convert.ToInt32(txtID.Text);
String KeywordValue = txtPersonKeywords.Text;
dsPersons = da.FetchPersonKeywords(KeywordValue);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
if (radioAdvanced.Checked == true)
{
String KeywordValue = txtPersonKeywords.Text;
bool cName;
bool cAreaCode;
bool cPhoneNumber;
bool cAddress;
bool cZip;
bool cEmail;
if (cbEmail.Checked == true)
{
cEmail = true;
}
else
{
cEmail = false;
}
if (cbEmail.Checked == false)
{
cEmail = false;
}
else
{
cEmail = true;
}
if (cbName.Checked == true)
{
cName = true;
}
else
{
cName = false;
}
if (cbName.Checked == false)
{
cName = false;
}
else
{
cName = true;
}
if (cbAreaCode.Checked == true)
{
cAreaCode = true;
}
else
{
cAreaCode = false;
}
if (cbAreaCode.Checked == false)
{
cAreaCode = false;
}
else
{
cAreaCode = true;
}
if (cbPhoneNumber.Checked == true)
{
cPhoneNumber = true;
}
else
{
cPhoneNumber = false;
}
if (cbPhoneNumber.Checked == false)
{
cPhoneNumber = false;
}
else
{
cPhoneNumber = true;
}
if (cbAddress.Checked == true)
{
cAddress = true;
}
else
{
cAddress = false;
}
if (cbAddress.Checked == false)
{
cAddress = false;
}
else
{
cAddress = true;
}
if (cbZip.Checked == true)
{
cZip = true;
}
else
{
cZip = false;
}
if (cbZip.Checked == false)
{
cZip = false;
}
else
{
cZip = true;
}
if (cbEmail.Checked == true)
{
cEmail = true;
}
else
{
cEmail = false;
}
if (cbEmail.Checked == false)
{
cEmail = false;
}
else
{
cEmail = true;
}
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
// String Name = txtCompanyKeywords.Text;
ds = da.FetchPersonKeywords(KeywordValue, cName, cAddress, cZip, cAreaCode, cPhoneNumber, cEmail);
gvPersonName.DataSource = ds;
gvPersonName.DataBind();
}
}
}
protected void btnSearchPersonKeywords_Click(object sender, EventArgs e)
{
//if search site is checked then I need to do similar to what is already being done
//if advanced search is checked, but no boxes are checked, I need to do what is being done here
if (txtPersonKeywords.Text != "")
{
if (radioSearch.Checked == true)
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
// int CompanyID = Convert.ToInt32(txtID.Text);
String KeywordValue = txtPersonKeywords.Text;
dsPersons = da.FetchPersonKeywords(KeywordValue);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
if (radioAdvanced.Checked == true)
{
String KeywordValue = txtPersonKeywords.Text;
bool cName;
bool cAreaCode;
bool cPhoneNumber;
bool cAddress;
bool cZip;
bool cEmail;
if (cbEmail.Checked == true)
{
cEmail = true;
}
else
{
cEmail = false;
}
if (cbEmail.Checked == false)
{
cEmail = false;
}
else
{
cEmail = true;
}
if (cbName.Checked == true)
{
cName = true;
}
else
{
cName = false;
}
if (cbName.Checked == false)
{
cName = false;
}
else
{
cName = true;
}
if (cbAreaCode.Checked == true)
{
cAreaCode = true;
}
else
{
cAreaCode = false;
}
if (cbAreaCode.Checked == false)
{
cAreaCode = false;
}
else
{
cAreaCode = true;
}
if (cbPhoneNumber.Checked == true)
{
cPhoneNumber = true;
}
else
{
cPhoneNumber = false;
}
if (cbPhoneNumber.Checked == false)
{
cPhoneNumber = false;
}
else
{
cPhoneNumber = true;
}
if (cbAddress.Checked == true)
{
cAddress = true;
}
else
{
cAddress = false;
}
if (cbAddress.Checked == false)
{
cAddress = false;
}
else
{
cAddress = true;
}
if (cbZip.Checked == true)
{
cZip = true;
}
else
{
cZip = false;
}
if (cbZip.Checked == false)
{
cZip = false;
}
else
{
cZip = true;
}
if (cbEmail.Checked == true)
{
cEmail = true;
}
else
{
cEmail = false;
}
if (cbEmail.Checked == false)
{
cEmail = false;
}
else
{
cEmail = true;
}
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
// String Name = txtCompanyKeywords.Text;
ds = da.FetchPersonKeywords(KeywordValue, cName, cAddress, cZip, cAreaCode, cPhoneNumber, cEmail);
gvPersonName.DataSource = ds;
gvPersonName.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPhoneTypes = da.FetchPhoneTypes();
ddlPhoneTypeID.DataSource = dsPhoneTypes.Tables[0];
// ddlPhoneTypeID.Items.Add(New ListItem("", ""));
ddlPhoneTypeID.DataTextField = "Name";
ddlPhoneTypeID.DataValueField = "PhoneTypeID";
ddlPhoneTypeID.DataBind();
// ddlPhoneTypeID.Items.Add(new ListItem("Please Select Phone Type", ""));
ddlPhoneTypeID.Items.Insert(0, new ListItem("PLEASE SELECT PHONE TYPE", string.Empty));
// DataPortal.PersonPhoneData ppd = new DataPortal.PersonPhoneData();
BusinessObjects.PersonPhone pp = new BusinessObjects.PersonPhone();
DataSet ds2 = new DataSet();
if (Request.QueryString["Mode"] == null)
{
Request.QueryString["Mode"] = "New";
}
if (Request.QueryString["PersonID"] != null)
{
txtID.Text = Request.QueryString["PersonID"].ToString();
lblID.Text = Request.QueryString["PersonID"].ToString();
}
if (Request.QueryString["phoneID"] != null)
{
txtPHID.Text = Request.QueryString["phoneID"].ToString();
}
if (Request.QueryString != null)
{
string mode = Request.QueryString["Mode"];
switch (mode)
{
case "View":
break;
case "New":
btnSave.Visible = true;
txtID.Enabled = false;
txtPHTID.Visible = false;
btnDelete.Visible = false;
break;
case "Edit":
btnSave.Visible = true;
txtID.Enabled = false;
int id = Convert.ToInt32(txtID.Text);
BusinessObjects.Person person = new BusinessObjects.Person(id);
DataSet ds = new DataSet();
// id = Convert.ToInt32(txtID.ToString());
person.Fetch(id);
person.id = id;
object t = person.Title.ToString();
object fn = person.FirstName.ToString();
object ln = person.LastName.ToString();
lblFirstName.Text = fn.ToString();
lblLastName.Text = ln.ToString();
int PhoneID = Convert.ToInt32(txtPHID.Text);
BusinessObjects.PersonPhone personPhone = new BusinessObjects.PersonPhone(id, PhoneID);
id = Convert.ToInt32(lblID.Text);
int PersonID = id;
ds = personPhone.Fetch(PersonID, PhoneID);
// object pid = personPhone.PhoneID.ToString();
// object ac = personPhone.AreaCode.ToString();
object ac = ds.Tables[0].Rows[0]["AreaCode"].ToString();
object pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString();
object ex = ds.Tables[0].Rows[0]["Extension"].ToString();
object d = ds.Tables[0].Rows[0]["Description"].ToString();
object n = ds.Tables[0].Rows[0]["Notes"].ToString();
object ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString();
txtAreaCode.Text = ac.ToString();
txtPhoneNumber.Text = pn.ToString();
txtExtension.Text = ex.ToString();
txtDescription.Text = d.ToString();
txtNotes.Text = n.ToString();
txtPHTID.Text = ptid.ToString();
ddlPhoneTypeID.Text = ptid.ToString();
object dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString();
object dt = ds.Tables[0].Rows[0]["DoNotText"].ToString();
cbDNT.Checked = Convert.ToBoolean(dt.ToString());
cbDNC.Checked = Convert.ToBoolean(dc.ToString());
btnDelete.Visible = false;
// txtDescription.Text = d.ToString();
// txtNotes.Text = n.ToString();
// cbDNT.Checked = Convert.ToBoolean(dt.ToString());
// cbDNC.Checked = Convert.ToBoolean(dc.ToString());
// // ddlPhoneTypeID.SelectedIndex = 0;
// btnDelete.Visible = false;
//First create a DataSet that returns, equals person.Fetch(PersonID) as
/////////////////////////////////OLD CODE Start
// DataPortal.PersonData pd = new DataPortal.PersonData();
// DataSet pds = new DataSet();
// O int PersonID = Convert.ToInt32(txtID.Text); ///
// L pds = pd.Fetch(PersonID);
// D object fn = pds.Tables[0].Rows[0]["FirstName"].ToString();
// object ln = pds.Tables[0].Rows[0]["LastName"].ToString();
// C lblFirstName.Text = fn.ToString(); ///
// O lblLastName.Text = ln.ToString(); ///
//D
// E ppd = new DataPortal.PersonPhoneData();
// DataSet ds = new DataSet();
// int PhoneID = Convert.ToInt32(txtPHID.Text); ///
// ds = ppd.Fetch(PersonID, PhoneID);
// object pid = ds.Tables[0].Rows[0]["PhoneID"].ToString();
// object ac = ds.Tables[0].Rows[0]["AreaCode"].ToString();
// object pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString();
// object ex = ds.Tables[0].Rows[0]["Extension"].ToString();
// object ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString();
// txtPHID.Text = pid.ToString();
// txtAreaCode.Text = ac.ToString();
// txtPhoneNumber.Text = pn.ToString();
// txtExtension.Text = ex.ToString();
// txtPHTID.Text = ptid.ToString();
// txtPHTID.Visible = false;
// ddlPhoneTypeID.Text = ptid.ToString();
// object d = ds.Tables[0].Rows[0]["Description"].ToString();
// object n = ds.Tables[0].Rows[0]["Notes"].ToString();
// object dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString();
// object dt = ds.Tables[0].Rows[0]["DoNotText"].ToString();
// txtDescription.Text = d.ToString();
// txtNotes.Text = n.ToString();
// cbDNT.Checked = Convert.ToBoolean(dt.ToString());
// cbDNC.Checked = Convert.ToBoolean(dc.ToString());
// // ddlPhoneTypeID.SelectedIndex = 0;
// btnDelete.Visible = false;
/////////////////////////////////////////OLD CODE Stop
break;
case "Delete":
btnSave.Visible = false;
txtID.Enabled = true;
btnSave.Visible = true;
txtID.Enabled = false;
id = Convert.ToInt32(txtID.Text);
person = new BusinessObjects.Person(id);
ds = new DataSet();
// id = Convert.ToInt32(txtID.ToString());
person.Fetch(id);
person.id = id;
t = person.Title.ToString();
fn = person.FirstName.ToString();
ln = person.LastName.ToString();
lblFirstName.Text = fn.ToString();
lblLastName.Text = ln.ToString();
PhoneID = Convert.ToInt32(txtPHID.Text);
personPhone = new BusinessObjects.PersonPhone(id, PhoneID);
id = Convert.ToInt32(lblID.Text);
PersonID = id;
ds = personPhone.Fetch(PersonID, PhoneID);
// object pid = personPhone.PhoneID.ToString();
// object ac = personPhone.AreaCode.ToString();
ac = ds.Tables[0].Rows[0]["AreaCode"].ToString();
pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString();
ex = ds.Tables[0].Rows[0]["Extension"].ToString();
d = ds.Tables[0].Rows[0]["Description"].ToString();
n = ds.Tables[0].Rows[0]["Notes"].ToString();
ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString();
txtAreaCode.Text = ac.ToString();
txtPhoneNumber.Text = pn.ToString();
txtExtension.Text = ex.ToString();
txtDescription.Text = d.ToString();
txtNotes.Text = n.ToString();
txtPHTID.Text = ptid.ToString();
ddlPhoneTypeID.Text = ptid.ToString();
dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString();
dt = ds.Tables[0].Rows[0]["DoNotText"].ToString();
cbDNT.Checked = Convert.ToBoolean(dt.ToString());
cbDNC.Checked = Convert.ToBoolean(dc.ToString());
btnDelete.Visible = true;
btnSave.Visible = false;
disableForm();
////// pd = new DataPortal.PersonData();
//////pds = new DataSet();
//////PersonID = Convert.ToInt32(txtID.Text);
//Fix later //////pds = pd.Fetch(PersonID);
////// fn = pds.Tables[0].Rows[0]["FirstName"].ToString();
//////ln = pds.Tables[0].Rows[0]["LastName"].ToString();
//////lblFirstName.Text = fn.ToString();
//////lblLastName.Text = ln.ToString();
//////ds = new DataSet();
////// PhoneID = Convert.ToInt32(txtPHID.Text);
//////ds = ppd.Fetch(PersonID, PhoneID);
////// pid = ds.Tables[0].Rows[0]["PhoneID"].ToString();
////// ac = ds.Tables[0].Rows[0]["AreaCode"].ToString();
////// pn = ds.Tables[0].Rows[0]["PhoneNumber"].ToString();
////// ex = ds.Tables[0].Rows[0]["Extension"].ToString();
////// ptid = ds.Tables[0].Rows[0]["PhoneTypeID"].ToString();
//txtPHID.Text = pid.ToString();
//txtAreaCode.Text = ac.ToString();
//txtPhoneNumber.Text = pn.ToString();
//txtExtension.Text = ex.ToString();
//txtPHTID.Text = ptid.ToString();
//txtPHTID.Visible = false;
//ddlPhoneTypeID.Text = ptid.ToString();
//txtAreaCode.Enabled = false;
//txtPhoneNumber.Enabled = false;
//txtExtension.Enabled = false;
//txtPHTID.Enabled = false;
//ddlPhoneTypeID.Enabled = false;
//cbDNC.Enabled = false;
//cbDNT.Enabled = false;
//txtDescription.Enabled = false;
//txtNotes.Enabled = false;
// d = ds.Tables[0].Rows[0]["Description"].ToString();
// n = ds.Tables[0].Rows[0]["Notes"].ToString();
// dc = ds.Tables[0].Rows[0]["DoNotCall"].ToString();
//dt = ds.Tables[0].Rows[0]["DoNotText"].ToString();
//txtDescription.Text = d.ToString();
//txtNotes.Text = n.ToString();
//cbDNT.Checked = Convert.ToBoolean(dt.ToString());
//cbDNC.Checked = Convert.ToBoolean(dc.ToString());
break;
}
}
}
}
protected void fillAddressGrid()
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchPersonAddressesGrid(PersonID);
gvPersonAddresses.DataSource = ds2;
gvPersonAddresses.DataBind();
}
//protected void fillAddressGrid()
//{
// DataManager.DataAccess da = new DataManager.DataAccess();
// DataSet ds = new DataSet();
// int PersonID = Convert.ToInt32(txtID.Text);
// ds = da.FetchPersonAddressesGrid(PersonID);
// gvPersonPhoneNumber.DataSource = ds;
// gvPersonPhoneNumber.DataBind();
// //if (gvPersonPhoneNumber.DataSource != null)
// //{
// //}
// //else
// //{
// // NameDisplayLabel.Text = "No Results Found!";
// //}
//}
protected void fillEmail()
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int EmailAddressID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchEmailAddress(EmailAddressID);
gvEmail.DataSource = ds2;
gvEmail.DataBind();
//////DataManager.DataAccess da = new DataManager.DataAccess();
//////DataSet ds = new DataSet();
//////int PersonID = Convert.ToInt32(txtID.Text);
//////ds = da.FetchPersonAddressesGrid(PersonID);
//////gvPersonPhoneNumber.DataSource = ds;
//////gvPersonPhoneNumber.DataBind();
}
protected void fillCompanyPhoneGrid()
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = new DataSet();
int CompanyID = Convert.ToInt32(txtID.Text);
ds = da.FetchCompanyPhonesGrid(CompanyID);
gvCompanyPhoneNumber.DataSource = ds;
gvCompanyPhoneNumber.DataBind();
}
protected void SearchButton_Click(object sender, EventArgs e)
{
if (txtID.Text != "")
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
int PersonID = Convert.ToInt32(txtID.Text);
dsPersons = da.FetchPerson(PersonID);
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
else
{
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet dsPersons = new DataSet();
dsPersons = da.FetchPerson(txtFirstName.Text.Trim(), txtLastName.Text.Trim());
gvPersonName.DataSource = dsPersons;
gvPersonName.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
String AreaCode = txtAreaCode.Text;
String PhoneNumber = txtPhoneNumber.Text;
String Extension = txtExtension.Text;
int PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text);
bool DoNotText;
bool DoNotCall;
// int PhoneID = Convert.ToInt32(txtPhID.Text);
int PhoneID;
DataManager.DataAccess da = new DataManager.DataAccess();
switch (Request.QueryString["Mode"])
{
case "Edit":
this.txtPhID.Text = Request.QueryString["PhoneID"];
txtPhID.Enabled = true;
PhoneID = Convert.ToInt32(txtPhID.Text);
AreaCode = txtAreaCode.Text;
PhoneNumber = txtPhoneNumber.Text;
Extension = txtExtension.Text;
PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.Text);
int PersonID = Convert.ToInt32(txtID.Text);
String Description = txtDescription.Text;
String Notes = txtNotes.Text;
if (cbDNC.Checked == false)
{
cbDNC.Checked = false;
}
if (cbDNC.Checked == true)
{
cbDNC.Checked = true;
}
if (cbDNT.Checked == false)
{
cbDNT.Checked = false;
}
if (cbDNT.Checked == true)
{
cbDNT.Checked = true;
}
DoNotCall = cbDNC.Checked;
DoNotText = cbDNT.Checked;
da.UpdatePhone(PhoneID, AreaCode, PhoneNumber, Extension, PhoneTypeID); //UpdatePhone(int PhoneID, int AreaCode, int PhoneNumber, String Extension, int PhoneTypeID)
da.UpdatePersonPhoneNumber(PersonID, PhoneID, Description, Notes, DoNotCall, DoNotText);
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
btnDone.Enabled = true;
btnDone.Visible = false;
// Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
break;
case "New":
AreaCode = txtAreaCode.Text;
PhoneNumber = txtPhoneNumber.Text;
Extension = txtExtension.Text;
PhoneTypeID = Convert.ToInt32(ddlPhoneTypeID.SelectedValue);
//PersonID = Convert.ToInt32(txtID.Text);
// PhoneID = Convert.ToInt32(txtPhID.Text);
Description = txtDescription.Text;
Notes = txtNotes.Text;
DoNotCall = cbDNC.Checked;
DoNotText = cbDNT.Checked;
PersonID = Convert.ToInt32(txtID.Text);
object phoneNumberID = da.InsertPhoneNumber(AreaCode, PhoneNumber, Extension, PhoneTypeID);
txtPhID.Text = phoneNumberID.ToString();
// da.InsertPhoneNumber(AreaCode, PhoneNumber, Extension, PhoneTypeID);
//txtPhID.Text = phoneNumberID.ToString();
PhoneID = Convert.ToInt32(txtPhID.Text.ToString());
// txtNotes.Text = PhoneID.ToString();
da.InsertPersonPhone(PersonID, PhoneID, Description, Notes, DoNotCall, DoNotText);
// I need to send the PersonID and the PhoneID to the Edit Page
Response.Redirect("EditPerson.aspx?Mode=Edit&PersonID=" + this.txtID.Text);
// Response.Redirect("EditPersonPhoneNumber.aspx?PersonID=" +
//this.txtID.Text + "&Mode=Edit&PhoneID=" + this.txtPhID.Text);
break;
}
}
protected void fillCompanyAddressGrid()
{
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
int CompanyID = Convert.ToInt32(txtID.Text);
ds2 = da2.FetchCompanyAddressesGrid(CompanyID);
gvCompanyAddresses.DataSource = ds2;
gvCompanyAddresses.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
txtATID.Visible = false;
ddlAddressTypeID.Enabled = true;
DataManager.DataAccess da2 = new DataManager.DataAccess();
DataSet ds3 = new DataSet();
ds3 = da2.FetchAddressTypes();
ddlAddressTypeID.DataSource = ds3.Tables[0];
//The DataTextField is the value of what will show in the ddl
// the DataValueField is the Value of the
ddlAddressTypeID.DataTextField = "Name";
ddlAddressTypeID.DataValueField = "AddressTypeID";
ddlAddressTypeID.DataBind();
ddlAddressTypeID.Items.Insert(0, new ListItem("PLEASE SELECT ADDRESS TYPE", string.Empty));
if (Request.QueryString["Mode"] == null)
{
Request.QueryString["Mode"] = "New";
//Response.Redirect("AddressForm.aspx?Mode=Edit");
}
if (Request.QueryString["PersonID"] != null)
{
txtID.Text = Request.QueryString["PersonID"].ToString();
//
}
if (Request.QueryString["addressID"] != null)
{
txtAID.Text = Request.QueryString["addressID"].ToString();
}
if (Request.QueryString != null)
{
string mode = Request.QueryString["Mode"];
// if mode = null then mode = new
//one other way would be to get rid of the test and in the switch statement view edit delete and instead of case new
// change that so that you are doing it to false whenmode is new, view, a default case would be new
switch (mode)
{
case "View":
//btnDone.Visible = true;
//btnSave.Visible = false;
btnDelete.Visible = false;
//LoadPerson();
//txtID.Enabled = false;
//txtFirstName.Enabled = false;
//txtLastName.Enabled = false;
//btnCancel.Visible = false;
//fillPhoneGrid();
//fillAddressGrid();
//fillEmail();
break;
case "New":
//btnDone.Visible = false;
btnSave.Visible = true;
//btnDelete.Visible = false;
// LoadPerson();
txtID.Enabled = false;
ddlAddressTypeID.Visible = true;
btnDelete.Visible = false;
//txtFirstName.Enabled = true;
//txtLastName.Enabled = true;
//btnAddPhoneNum.Visible = false;
ddlAddressTypeID.SelectedIndex = 0;
break;
case "Edit":
//btnDone.Visible = true;
btnSave.Visible = true;
//btnDelete.Visible = false;
btnDelete.Visible = false;
//LoadPerson();
txtID.Enabled = false;
ddlAddressTypeID.Visible = true;
ddlAddressTypeID.Enabled = true;
int id = Convert.ToInt32(txtID.Text);
loadPerson(id);
// DataPortal.PersonData pd = new DataPortal.PersonData();
// DataSet pds = new DataSet();
// int PersonID = Convert.ToInt32(txtID.Text);
// pds = pd.Fetch(PersonID);
// object fn = pds.Tables[0].Rows[0]["FirstName"].ToString();
// object ln = pds.Tables[0].Rows[0]["LastName"].ToString();
// ////////txtFirstName.Text = fn.ToString();
// ////////txtLastName.Text = ln.ToString();
// lblFirstName.Text = fn.ToString();
// lblLastName.Text = ln.ToString();
//DataPortal.PersonAddressData pad = new DataPortal.PersonAddressData();
//DataSet ds = new DataSet();
int AddressID = Convert.ToInt32(txtAID.Text);
BusinessObjects.PersonAddress personAddress = new BusinessObjects.PersonAddress();
DataSet ds = new DataSet();
ds = personAddress.LoadAddress(id, AddressID);
txtStreet1.Text = ds.Tables[0].Rows[0]["Street1"].ToString();
txtStreet2.Text = ds.Tables[0].Rows[0]["Street2"].ToString();
txtCity.Text = ds.Tables[0].Rows[0]["City"].ToString();
txtState.Text = ds.Tables[0].Rows[0]["State"].ToString();
txtZip.Text = ds.Tables[0].Rows[0]["Zip"].ToString();
txtNotes.Text = ds.Tables[0].Rows[0]["Notes"].ToString();
txtDescription.Text = ds.Tables[0].Rows[0]["Description"].ToString();
//int AddressID = Convert.ToInt32(txtAID.Text);
//ds = pad.Fetch(PersonID, AddressID);
//object s1 = ds.Tables[0].Rows[0]["Street1"].ToString();
//object s2 = ds.Tables[0].Rows[0]["Street2"].ToString();
//object ci = ds.Tables[0].Rows[0]["City"].ToString();
//object st = ds.Tables[0].Rows[0]["State"].ToString();
//object zi = ds.Tables[0].Rows[0]["Zip"].ToString();
//object atid = ds.Tables[0].Rows[0]["AddressTypeID"].ToString();
//object d = ds.Tables[0].Rows[0]["Description"].ToString();
//object n = ds.Tables[0].Rows[0]["Notes"].ToString();
//txtStreet1.Text = s1.ToString();
//txtStreet2.Text = s2.ToString();
//txtCity.Text = ci.ToString();
//txtState.Text = st.ToString();
//txtZip.Text = zi.ToString();
//ddlAddressTypeID.Text = atid.ToString();
//txtATID.Text = atid.ToString();
//txtDescription.Text = d.ToString();
//txtNotes.Text = n.ToString();
break;
case "Delete":
btnSave.Visible = false;
//btnDelete.Visible = false;
btnDelete.Visible = true;
//LoadPerson();
txtID.Enabled = false;
ddlAddressTypeID.Visible = true;
ddlAddressTypeID.Enabled = true;
// pd = new DataPortal.PersonData();
// pds = new DataSet();
// PersonID = Convert.ToInt32(txtID.Text);
// pds = pd.Fetch(PersonID);
//fn = pds.Tables[0].Rows[0]["FirstName"].ToString();
//ln = pds.Tables[0].Rows[0]["LastName"].ToString();
// lblFirstName.Text = fn.ToString();
// lblLastName.Text = ln.ToString();
// pad = new DataPortal.PersonAddressData();
// ds = new DataSet();
// AddressID = Convert.ToInt32(txtAID.Text);
// ds = pad.Fetch(PersonID, AddressID);
// s1 = ds.Tables[0].Rows[0]["Street1"].ToString();
// s2 = ds.Tables[0].Rows[0]["Street2"].ToString();
// ci = ds.Tables[0].Rows[0]["City"].ToString();
// st = ds.Tables[0].Rows[0]["State"].ToString();
// zi = ds.Tables[0].Rows[0]["Zip"].ToString();
// atid = ds.Tables[0].Rows[0]["AddressTypeID"].ToString();
// d = ds.Tables[0].Rows[0]["Description"].ToString();
// n = ds.Tables[0].Rows[0]["Notes"].ToString();
// txtStreet1.Text = s1.ToString();
// txtStreet2.Text = s2.ToString();
// txtCity.Text = ci.ToString();
// txtState.Text = st.ToString();
// txtZip.Text = zi.ToString();
// ddlAddressTypeID.Text = atid.ToString();
// txtATID.Text = atid.ToString();
// txtDescription.Text = d.ToString();
// txtNotes.Text = n.ToString();
// txtStreet1.Enabled = false;
// //city state zip notes description
// txtStreet2.Enabled = false;
// txtCity.Enabled = false;
// txtState.Enabled = false;
// txtZip.Enabled = false;
// txtNotes.Enabled = false;
// txtDescription.Enabled = false;
// ddlAddressTypeID.Enabled = false;
break;
}
}
if (txtID.Text != "")
{
if (txtAID.Text == null)
{
//DataPortal.PersonData pd = new DataPortal.PersonData();
//DataSet pds = new DataSet();
//int PersonID = Convert.ToInt32(txtID.Text);
//pds = pd.Fetch(PersonID);
//object fn = pds.Tables[0].Rows[0]["FirstName"].ToString();
//object ln = pds.Tables[0].Rows[0]["LastName"].ToString();
int id = Convert.ToInt32(txtID.Text);
loadPerson(id);
// DataPortal.PersonAddressData pad = new DataPortal.PersonAddressData();
// DataSet ds = new DataSet();
// int AddressID = Convert.ToInt32(txtAID.Text);
// ds = pad.Fetch(PersonID, AddressID);
// object s1 = ds.Tables[0].Rows[0]["Street1"].ToString();
// object s2 = ds.Tables[0].Rows[0]["Street2"].ToString();
// object ci = ds.Tables[0].Rows[0]["City"].ToString();
// object st = ds.Tables[0].Rows[0]["State"].ToString();
// object zi = ds.Tables[0].Rows[0]["Zip"].ToString();
// object atid = ds.Tables[0].Rows[0]["AddressTypeID"].ToString();
// object d = ds.Tables[0].Rows[0]["Description"].ToString();
// object n = ds.Tables[0].Rows[0]["Notes"].ToString();
// txtStreet1.Text = s1.ToString();
// txtStreet2.Text = s2.ToString();
// txtCity.Text = ci.ToString();
// txtState.Text = st.ToString();
// txtZip.Text = zi.ToString();
//txtATID.Text = atid.ToString();
// txtDescription.Text = d.ToString();
// txtNotes.Text = n.ToString();
int AddressID = Convert.ToInt32(txtAID.Text);
BusinessObjects.PersonAddress personAddress = new BusinessObjects.PersonAddress();
DataSet ds = new DataSet();
ds = personAddress.LoadAddress(id, AddressID);
txtStreet1.Text = ds.Tables[0].Rows[0]["Street1"].ToString();
txtStreet2.Text = ds.Tables[0].Rows[0]["Street2"].ToString();
txtCity.Text = ds.Tables[0].Rows[0]["City"].ToString();
txtState.Text = ds.Tables[0].Rows[0]["State"].ToString();
txtZip.Text = ds.Tables[0].Rows[0]["Zip"].ToString();
txtNotes.Text = ds.Tables[0].Rows[0]["Notes"].ToString();
txtDescription.Text = ds.Tables[0].Rows[0]["Description"].ToString();
//DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds2 = new DataSet();
//ds2 = pad.FetchAddressTypes();
//ddlAddressTypeID.DataSource = ds2.Tables[0];
BusinessObjects.PersonAddress pa = new BusinessObjects.PersonAddress();
ds2 = pa.FetchDataTypes();
ddlAddressTypeID.DataSource = ds2.Tables[0];
//The DataTextField is the value of what will show in the ddl
// the DataValueField is the Value of the
ddlAddressTypeID.DataTextField = "Name";
ddlAddressTypeID.DataValueField = "AddressTypeID";
ddlAddressTypeID.DataBind();
// DataPortal.PersonAddressData pad = new DataPortal.PersonAddressData();
// //DataManager.DataAccess da = new DataManager.DataAccess();
// DataSet ds = new DataSet();
// //DataSet dsPersons = new DataSet();
/////// int PersonID = Convert.ToInt32(txtID.Text);
// int AddressID = Convert.ToInt32(txtAID.Text);
// ds = pad.Fetch(PersonID, AddressID);
// // txtFirstName.Text =
// object s1 = ds.Tables[0].Rows[0]["Street1"];
// object s2 = ds.Tables[0].Rows[0]["Street2"];
// txtStreet1.Text = s1.ToString();
// txtStreet2.Text = s2.ToString();
//gvPersonName.DataSource = dsPersons;
//gvPersonName.DataBind();
}
}
}
}
private void LoadPerson()
{
this.txtID.Text = Request.QueryString["PersonID"];
int PersonID = Convert.ToInt32(txtID.Text);
DataManager.DataAccess da = new DataManager.DataAccess();
DataSet ds = da.FetchPerson(PersonID);
object pi = ds.Tables[0].Rows[0]["PersonID"];
object fn = ds.Tables[0].Rows[0]["FirstName"];
object ln = ds.Tables[0].Rows[0]["LastName"];
txtID.Text = pi.ToString();
txtFirstName.Text = fn.ToString();
txtLastName.Text = ln.ToString();
String FirstName = txtFirstName.Text;
String LastName = txtLastName.Text;
// add an else, set the NameDisplayLabel to empty string, and i
NameDisplayLabel.Text = FirstName + " " + LastName + " has been added to the database.";
}
