protected void AddStudentButton_Click(object sender, EventArgs e) { if (AddStudentTextBox.Text != "") { using (var context = new GradebookDataEntities()) { Course course = context.Courses.FirstOrDefault(c => c.CourseNumber == CourseNumberDropDownList.SelectedValue); Student student = context.Students.FirstOrDefault(s => s.Email == AddStudentTextBox.Text); course.Students.Add(student); context.SaveChanges(); var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses; var courses = l2equery.FirstOrDefault(); courseGridView.DataSource = courses; courseGridView.DataBind(); } } else { string email = studentGridView.Rows[studentGridView.SelectedIndex].Cells[0].Text.ToString(); ; using (var context = new GradebookDataEntities()) { Course course = context.Courses.FirstOrDefault(c => c.CourseNumber == CourseNumberDropDownList.SelectedValue); Student student = context.Students.FirstOrDefault(s => s.Email == email); course.Students.Add(student); context.SaveChanges(); var l2equery = from s in context.Students where s.Email.Contains(searchStudentsTextBox.Text) select s.Courses; var courses = l2equery.FirstOrDefault(); courseGridView.DataSource = courses; courseGridView.DataBind(); } } }
protected void registerStudentCourseButton_Click(object sender, EventArgs e) { if(courseID != 0) using(var context = new GradebookDataEntities()) { Course course = context.Courses.FirstOrDefault(c => c.CourseID == courseID); Student student = context.Students.FirstOrDefault(s => s.Email == email); course.Students.Add(student); context.SaveChanges(); } studentCourseGridViewFill(); }