private void btnDeleteStudent_Click(object sender, EventArgs e)
{
//ensure a student is selected
if (lstStudentRoster.SelectedIndex < 0)
{
MessageBox.Show("Please select a student");
return;
}
DialogResult res = MessageBox
.Show("Are you sure?",
string.Empty,
MessageBoxButtons.YesNo,
MessageBoxIcon.Warning);
if (res == DialogResult.Yes)
{
//get selected student
Student selStu =
lstStudentRoster.SelectedItem as Student;
//delete student by SID
if (StudentDB.DeleteStudent(selStu.StudentID))
{
MessageBox.Show($"{selStu.FirstName} was deleted");
//PopulateStudentListBox();
//This removes the student from the listbox
//and is more efficient then talking to DB again
lstStudentRoster.Items.Remove(selStu);
}
}
}
private void PopulateStudentListBox()
{
List <Student> stuList =
StudentDB.GetAllStudents();
lstStudentRoster.Items.Clear();
foreach (Student s in stuList)
{
lstStudentRoster.Items.Add(s);
}
}
private void btnUpdateStudent_Click(object sender, EventArgs e)
{
//update student with new data
stu.FirstName = txtName.Text;
stu.Major = txtMajor.Text;
stu.DateOfBirth =
Convert.ToDateTime(txtDateOfBirth.Text);
if (StudentDB.UpdateStudent(stu))
{
MessageBox.Show("Updated!");
Close();
}
}
private void btnAddStudent_Click(object sender, EventArgs e)
{
if (IsDataValid())
{
string name = txtName.Text;
DateTime dob = Convert.ToDateTime(txtDateOfBirth.Text);
string major = txtMajor.Text;
//add all data to student object
//METHOD 1: POPULATE OBJECT PROPERTY BY PROPERTY
var addStu = new Student();
addStu.FirstName = name;
addStu.DateOfBirth = dob;
addStu.Major = major;
addStu.StudentID = txtStudentID.Text;
////database will generate SID
////METHOD 2: Object Initialization Syntax
//var addStu2 = new Student()
//{
// FirstName = name,
// DateOfBirth = dob,
// Major = major
//};
//METHOD 3: Use the constructor!
//var addStu3 =
// new Student(name, dob, major);
//add student object to database
if (StudentDB.AddStudent(addStu))
{
MessageBox.Show("Student Added!");
//ignore passing the name back to the
//main form
this.Tag = name;
this.StudentName = name;
this.stu = name;
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Stu cannot be added at this time!");
}
}
}