private void saveGradeButton_Click(object sender, EventArgs e)
{
Enrollment selectedEnrollment = (Enrollment)this.enrollmentsListBox.SelectedValue;
Assignment selectedAssignment = (Assignment)this.assignmentsListBox.SelectedValue;
if (selectedEnrollment != null && selectedAssignment != null)
{
AssignmentGrade grade = selectedEnrollment.FindAssignmentGrade(selectedAssignment.Assign);
if (grade == null)
{
short points = 0;
Int16.TryParse(this.pointsTextBox.Text, out points);
grade = new AssignmentGrade(points, DateTime.Now,
selectedEnrollment, selectedAssignment);
}
else
{
short points = 0;
Int16.TryParse(this.pointsTextBox.Text, out points);
grade.Points = points;
grade.DateCompleted = DateTime.Now;
}
this.dbContext.SaveChanges();
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.DisableEventHandlers();
this.dbContext = new StudentInfoModelContainer();
this.school = this.dbContext.Schools.First();
this.school.Departments = this.dbContext.Departments.ToList();
this.departmentsDropDownList.DisplayMember = "DeptName";
this.departmentsDropDownList.DataSource = this.school.Departments;
Department comc = this.school.FindDepartment("COMC");
this.departmentsDropDownList.SelectedItem = comc;
comc.Courses = this.dbContext.Courses.Where(c =>
c.Department.Id == comc.Id).ToList();
this.coursesDropDownList.DisplayMember = "CourseTitle";
this.coursesDropDownList.DataSource = comc.Courses;
Course comc2750 = comc.FindCourse("2750");
this.coursesDropDownList.SelectedItem = comc2750;
this.school.Terms = this.dbContext.Terms.ToList();
this.termsDropDownList.DisplayMember = "DisplayString";
this.termsDropDownList.DataSource = this.school.Terms;
Term spr2020 = this.school.FindTerm(2020, TermsEnum.Spr);
this.termsDropDownList.SelectedItem = spr2020;
comc2750.Sections = this.dbContext.Sections.Where(s =>
s.Course.Id == comc2750.Id &&
s.Term.Id == spr2020.Id).ToList();
this.sectionsDropDownList.DisplayMember = "Id";
this.sectionsDropDownList.DataSource = comc2750.Sections;
Section section2750 = comc2750.Sections.Last();
this.sectionsDropDownList.SelectedItem = section2750;
section2750.Assignments = this.dbContext.Assignments.Where(a =>
a.Section.Id == section2750.Id).ToList();
this.assignmentsListBox.DisplayMember = "DisplayString";
this.assignmentsListBox.DataSource = section2750.Assignments;
section2750.Enrollments = this.dbContext.Enrollments.Include("Student").Where(enr =>
enr.Section.Id == section2750.Id).ToList();
this.enrollmentsListBox.DisplayMember = "DisplayString";
this.enrollmentsListBox.DataSource = section2750.Enrollments;
Enrollment selectedEnrollment = (Enrollment)this.enrollmentsListBox.SelectedValue;
Assignment selectedAssignment = (Assignment)this.assignmentsListBox.SelectedValue;
AssignmentGrade grade = this.dbContext.AssignmentGrades.Where(g =>
g.Enrollment.Id == selectedEnrollment.Id &&
g.Assignment.Id == selectedAssignment.Id).SingleOrDefault();
this.pointsTextBox.Text = grade.Points.ToString();
this.dateTextBox.Text = grade.DateCompleted.ToShortDateString();
this.EnableEventHandlers();
}
public AssignmentGrade FindAssignmentGrade(string assign)
{
AssignmentGrade foundGrade = null;
foreach (AssignmentGrade g in this.AssignmentGrades)
{
if (g.Assignment.Assign == assign)
{
foundGrade = g;
break;
}
}
return(foundGrade);
}
public AssignmentGrade FindAssignmentGrade(int studentId)
{
AssignmentGrade foundGrade = null;
foreach (AssignmentGrade g in this.AssignmentGrades)
{
if (g.Enrollment.Student.Id == studentId)
{
foundGrade = g;
break;
}
}
return(foundGrade);
}
private void assignmentsListBox_SelectedValueChanged(object sender, EventArgs e)
{
this.pointsTextBox.Text = "";
this.dateTextBox.Text = "";
Enrollment selectedEnrollment = (Enrollment)this.enrollmentsListBox.SelectedItem;
Assignment selectedAssignment = (Assignment)this.assignmentsListBox.SelectedItem;
if (selectedEnrollment != null && selectedAssignment != null)
{
AssignmentGrade grade = this.dbContext.AssignmentGrades.Where(g =>
g.Enrollment.Id == selectedEnrollment.Id &&
g.Assignment.Id == selectedAssignment.Id).SingleOrDefault();
if (grade != null)
{
this.pointsTextBox.Text = grade.Points.ToString();
this.dateTextBox.Text = grade.DateCompleted.ToShortDateString();
}
}
}
