//Secretary Section
//Load
private void dataGrid1_Loaded(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.secretariesTableAdapter secAdp = new DataSet1TableAdapters.secretariesTableAdapter();
DataTable dt = secAdp.getSecretaries();
this.dataGrid1.ItemsSource = dt.DefaultView;
}
public void updateSec()
{
DataSet1TableAdapters.secretariesTableAdapter secAdp = new DataSet1TableAdapters.secretariesTableAdapter();
DataTable dt = secAdp.getSecretaries();
this.dataGrid1.ItemsSource = dt.DefaultView;
}
private void editSecretary_Click(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.usersTableAdapter userAdo = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.secretariesTableAdapter secAdp = new DataSet1TableAdapters.secretariesTableAdapter();
int?id = (int?)userAdo.getUserID(userName.Text);
secAdp.UpdateSec(FName.Text, LName.Text, (int)id);
MessageBox.Show("modified successfully");
updateSec();
}
//Implemented buttons
private void addSecretary_Click_1(object sender, RoutedEventArgs e)
{
if (userName.Text == string.Empty || userPass.Text == string.Empty || FName.Text == string.Empty || LName.Text == string.Empty)
{
MessageBox.Show("Something missing, please retry");
return;
}
else
{
DataSet1TableAdapters.usersTableAdapter userAdp = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.secretariesTableAdapter secAdp = new DataSet1TableAdapters.secretariesTableAdapter();
userAdp.addUser(userName.Text, userPass.Text, "secretary");
int?id = (int?)userAdp.getUserID(userName.Text);
secAdp.addSecretary(id, FName.Text, LName.Text);
MessageBox.Show("Added successfully");
}
updateSec();
}
