private void ButtonSearch_Click(object sender, EventArgs e)
{
ConnectDB EMRDatabase = new ConnectDB();
user = EMRDatabase.ViewUser(this.textSearch.Text);
userAccount = EMRDatabase.ViewAccount(this.textSearch.Text);
this.resetAll();
if (user[0].Count > 0)
{
this.textSetSSN.Text = user[0][0];
this.textSetFirstName.Text = user[1][0];
this.textSetLastName.Text = user[2][0];
this.textSetEmail.Text = user[3][0];
this.textSetAddress.Text = user[4][0];
this.textSetPhoneNumber.Text = user[5][0];
this.comboSetPosition.SelectedItem = user[6][0];
}
if (userAccount[0].Count > 0)
{
this.textSetUsername.Text = userAccount[0][0];
this.textSetPassword.Text = userAccount[1][0];
this.comboSetPrivilege.SelectedItem = userAccount[2][0];
this.comboSetStatus.SelectedItem = userAccount[3][0];
}
this.enableAll();
}
