private void DataGridTr_Loaded(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
DataTable dt = stAdp.getCsharpSt();
DataGridTr.ItemsSource = dt.DefaultView;
}
public void updateCsRecords()
{
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
DataTable dt = stAdp.getCsharpSt();
DataG1.ItemsSource = dt.DefaultView;
}
public void updateFBRecords()
{
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
DataTable dt = stAdp.GetFEBESt();
this.DataG2.ItemsSource = dt.DefaultView;
}
private void DataG2_Loaded(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
DataTable dt = stAdp.GetFEBESt();
this.DataG2.ItemsSource = dt.DefaultView;
}
public void updateJee()
{
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
DataTable dt = stAdp.GetJeeSt();
DataG3.ItemsSource = dt.DefaultView;
}
private void addSt_Click(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.usersTableAdapter userAdp = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
userAdp.addUser(userName.Text, userPass.Text, userType.Text);
int?id = (int?)userAdp.getUserID(userName.Text);
stAdp.addStudent(id, FName.Text, LName.Text);
}
private void editStudent_Click(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.usersTableAdapter userAdo = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
int?id = (int?)userAdo.getUserID(userName.Text);
stAdp.UpdateStudent(FName.Text, LName.Text, Class.Text, (int)id);
MessageBox.Show("modified successfully");
updateCsRecords();
updateFBRecords();
updateJee();
}
private void deleteStudent_Click_1(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.usersTableAdapter userAdo = new DataSet1TableAdapters.usersTableAdapter();
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
int?id = (int?)userAdo.getUserID(userName.Text);
stAdp.DeleteStudent(id);
userAdo.DeleteUser((int)id);
MessageBox.Show("Deleted successfully");
updateCsRecords();
updateFBRecords();
updateJee();
}
//Implemented Buttons
private void addStudent_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.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
userAdp.addUser(userName.Text, userPass.Text, "student");
int?id = (int?)userAdp.getUserID(userName.Text);
stAdp.AddStudent(id, FName.Text, LName.Text, Class.Text);
MessageBox.Show("Added successfully");
}
updateCsRecords();
updateFBRecords();
updateJee();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DataSet1TableAdapters.studentsTableAdapter stAdp = new DataSet1TableAdapters.studentsTableAdapter();
DataSet1TableAdapters.absenceTableAdapter absAdp = new DataSet1TableAdapters.absenceTableAdapter();
DataRowView row = DataGridTr.SelectedItem as DataRowView;
string Fname = row.Row[2].ToString();
string Lname = row.Row[3].ToString();
int?id = (int?)stAdp.getStId(Fname, Lname);
if (SelectedSt.Text != string.Empty)
{
if (Absent.IsChecked == true)
{
string absDate = datepicker.SelectedDate.Value.Date.ToShortDateString();
absAdp.InsertAbs((int)id, absDate);
}
}
}
