protected void address_add(object sender, EventArgs e)
{
//Insert Validation
//Create Address Class
Classes.Address usr_address = new Classes.Address();
usr_address.Street = street.Text;
if (suite.Text.Length > 0)
{
usr_address.Suite = suite.Text;
}
else
{
usr_address.Suite = "N/A";
}
usr_address.City = city.Text;
usr_address.State = state.Text;
if (zip.Text.Length > 0)
{
usr_address.Zip = int.Parse(zip.Text);
}
addresses.Items.Add(new ListItem(usr_address.ToString(), usr_address.GetAddress()));
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
if (id != null && indexvalue.Value == "")
{
//Initiate A Switch Function For Multiple Search Methods.
SqlConnection conn = new SqlConnection();
conn.ConnectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename='|DataDirectory|\Database.mdf';Integrated Security=True";
conn.Open();
indexvalue.Value = id;
//Populate Person Information
SqlCommand cmd = new SqlCommand("GetPersonInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Index", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
firstname.Text = reader["First Name"].ToString();
lastname.Text = reader["Last Name"].ToString();
title.Text = reader["Title"].ToString();
company.Text = reader["Company"].ToString();
}
reader.Close();
///Populate Emails
cmd = new SqlCommand("GetEmails", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Index", id);
reader = cmd.ExecuteReader();
while (reader.Read())
{
emails.Items.Add(new ListItem(reader["Email"].ToString(), reader["Email"].ToString()));
}
reader.Close();
///Populate Phone Numbers
cmd = new SqlCommand("GetPhoneNumbers", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Index", id);
reader = cmd.ExecuteReader();
while (reader.Read())
{
string itemvalue = "Phone | " + reader["number"];
numbers.Items.Add(new ListItem(itemvalue, itemvalue));
}
reader.Close();
///Populate Fax Numbers
cmd = new SqlCommand("GetFaxNumbers", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Index", id);
reader = cmd.ExecuteReader();
while (reader.Read())
{
string itemvalue = "Fax | " + reader["number"];
numbers.Items.Add(new ListItem(itemvalue, itemvalue));
}
reader.Close();
///Populate Addresses
cmd = new SqlCommand("GetAddresses", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Index", id);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Classes.Address usr_address = new Classes.Address();
usr_address.Street = reader["Street"].ToString();
usr_address.Suite = reader["Suite"].ToString();
usr_address.City = reader["City"].ToString();
usr_address.State = reader["State"].ToString();
if (zip.Text.Length > 0)
{
usr_address.Zip = int.Parse(reader["Zip"].ToString());
}
addresses.Items.Add(new ListItem(usr_address.ToString(), usr_address.GetAddress()));
}
reader.Close();
conn.Close();
}
}