// OVERLOADED CONSTRUCTOR - Meant to pull in existing data
public Form1(Int32 intPerson_ID)
{
InitializeComponent();
/*************************************************************
* Extra-Credit: Fill in the ComboBox *****************/
//FillPersons();
/************************************************************/
// Gather info about this one person and store it in a datareader
Person temp = new Person();
SqlDataReader dr = temp.FindOnePerson(intPerson_ID);
/**
* Use that info to fill out the form
* Loop thru the records stored in the reader 1 record at a time
* Note that since this is based on one person's ID, then we
* should only have one record
*/
while (dr.Read())
{
// Take the Name(s) from the DataReader and copy them
// into the appropriate text fields
txtFName.Text = dr["FName"].ToString();
txtMName.Text = dr["MName"].ToString();
txtLName.Text = dr["LName"].ToString();
txtStreet1.Text = dr["Street1"].ToString();
txtStreet2.Text = dr["Street2"].ToString();
txtCity.Text = dr["City"].ToString();
// Select the appropriate State for this person
cmbState.SelectedItem = dr["State"].ToString();
txtZipCode.Text = dr["Zipcode"].ToString();
txtCountry.Text = dr["Country"].ToString();
txtPhone.Text = dr["Phone"].ToString();
txtEmail.Text = dr["Email"].ToString();
// We added this one to store the ID in a new label
lblPerson_ID.Text = dr["Person_ID"].ToString();
/*
* bool blnFound = false;
* int intIndex = 0;
* while (blnFound == false)
* {
* if (((ComboBoxItem)cmbWho.Items[intIndex]).Value == intPerson_ID)
* {
* blnFound = true;
* cmbWho.SelectedIndex = intIndex;
* }
* intIndex++;
* }
*/
}
chkEmployee.Visible = false;
chkEmployee.Checked = false;
lblEmployeeID.Visible = false;
txtEmployeeID.Visible = false;
lblHourlyRate.Visible = false;
txtHourlyRate.Visible = false;
btnSubmit.Visible = false;
}
// OVERLOADED CONSTRUCTOR - Meant to pull in existing data
public Form1(Int32 intPerson_ID)
{
InitializeComponent();
chkEmployee.Visible = false;
chkEmployee.Checked = false;
lblEmployeeID.Visible = false;
txtEmployeeID.Visible = false;
lblHourlyRate.Visible = false;
txtHourlyRate.Visible = false;
btnSubmit.Visible = false;
// Gather info about this one person and store it in a datareader
Person temp = new Person();
SqlDataReader dr = temp.FindOnePerson(intPerson_ID);
/**
* Use that info to fill out the form
* Loop thru the records stored in the reader 1 record at a time
* Note that since this is based on one person's ID, then we
* should only have one record
*/
while (dr.Read())
{
// Take the Name(s) from the DataReader and copy them
// into the appropriate text fields
txtFName.Text = dr["FName"].ToString();
txtMName.Text = dr["MName"].ToString();
txtLName.Text = dr["LName"].ToString();
txtStreet1.Text = dr["Street1"].ToString();
txtStreet2.Text = dr["Street2"].ToString();
txtCity.Text = dr["City"].ToString();
txtState.Text = dr["State"].ToString();
txtZipCode.Text = dr["ZipCode"].ToString();
txtCountry.Text = dr["Country"].ToString();
txtPhone.Text = dr["Phone"].ToString();
txtEmail.Text = dr["Email"].ToString();
// We added this one to store the ID in a new label
lblPerson_ID.Text = dr["Person_ID"].ToString();
}
}
