//Trainer section
//Load Trainer DataGrid
private void dataGrid_Loaded(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.trainersTableAdapter trAdp = new DataSet1TableAdapters.trainersTableAdapter();
DataTable dt = trAdp.GetTrainers();
this.dataGrid.ItemsSource = dt.DefaultView;
}
public void updateTr()
{
DataSet1TableAdapters.trainersTableAdapter trAdp = new DataSet1TableAdapters.trainersTableAdapter();
DataTable dt = trAdp.GetTrainers();
this.dataGrid.ItemsSource = dt.DefaultView;
}
private void editTeacher_Click(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.usersTableAdapter userAdo = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.trainersTableAdapter traAdp = new DataSet1TableAdapters.trainersTableAdapter();
int?id = (int?)userAdo.getUserID(userName.Text);
traAdp.UpdateTrainer(FName.Text, LName.Text, Class.Text, (int)id);
MessageBox.Show("modified successfully");
updateTr();
}
private void deleteTeacher_Click(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.usersTableAdapter userAdo = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.trainersTableAdapter traAdp = new DataSet1TableAdapters.trainersTableAdapter();
int?id = (int?)userAdo.getUserID(userName.Text);
traAdp.DeleteTrainer(id);
userAdo.DeleteUser((int)id);
MessageBox.Show("Deleted successfully");
updateTr();
}
//Implemented Buttons
private void addTeacher_Click(object sender, RoutedEventArgs e)
{
if (userName.Text == string.Empty || userPass.Text == string.Empty || FName.Text == string.Empty || LName.Text == string.Empty || Class.Text == string.Empty)
{
MessageBox.Show("Something missing, please retry");
return;
}
else
{
DataSet1TableAdapters.usersTableAdapter userAdp = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.trainersTableAdapter trAdp = new DataSet1TableAdapters.trainersTableAdapter();
userAdp.addUser(userName.Text, userPass.Text, "trainer");
int?id = (int?)userAdp.getUserID(userName.Text);
trAdp.addTrainer(id, FName.Text, LName.Text, Class.Text);
MessageBox.Show("Added successfully");
}
updateTr();
}
