public Form1(int intPersonV2_ID)
{
InitializeComponent();
PersonV2 temp = new PersonV2();
SqlDataReader dr = temp.FindOnePersonV2(intPersonV2_ID);
while (dr.Read())
{
lblPersonV2_ID.Text = dr["PersonV2_ID"].ToString();
txtFirstName.Text = dr["FirstName"].ToString();
txtMiddleName.Text = dr["MiddleName"].ToString();
txtLastName.Text = dr["LastName"].ToString();
txtStreet1.Text = dr["Street1"].ToString();
txtCity.Text = dr["City"].ToString();
txtState.Text = dr["State"].ToString();
txtZipCode.Text = dr["ZipCode"].ToString();
txtStreet2.Text = dr["Street1"].ToString();
txtPhoneNumber.Text = dr["PhoneNumber"].ToString();
txtEmail.Text = dr["Email"].ToString();
txtCellPhone.Text = dr["CellPhone"].ToString();
txtInstagram.Text = dr["Instagram"].ToString();
lblPersonV2_ID.Text = dr["PersonV2_ID"].ToString();
}
}
private void btnAddPerson_Click(object sender, EventArgs e)
{
PersonV2 temp = new PersonV2();
temp.Feedback = "";
temp.FirstName = txtFirstName.Text;
temp.MiddleName = txtMiddleName.Text;
temp.LastName = txtLastName.Text;
temp.Street1 = txtStreet1.Text;
temp.City = txtCity.Text;
temp.State = txtState.Text;
temp.ZipCode = txtZipCode.Text;
temp.Street2 = txtStreet2.Text;
temp.PhoneNumber = txtPhoneNumber.Text;
temp.Email = txtEmail.Text;
temp.CellPhone = txtCellPhone.Text;
temp.Instagram = txtInstagram.Text;
if (temp.Feedback.Contains("ERROR:"))
{
lblFeedback.Text = temp.Feedback;
}
else
{
lblFeedback.Text = temp.AddARecord();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
PersonV2 temp = new PersonV2();
DataSet ds = temp.SearchPersonV2(txtLastName.Text, txtPhoneNumber.Text, txtCellPhone.Text);
dgvResults.DataSource = ds;
dgvResults.DataMember = ds.Tables["PersonV2_Temp"].ToString();
}