protected void btnAddCourse_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
List <Course> courses = (List <Course>)Session["courses"];
using (StudentRecordEntities entities = new StudentRecordEntities())
{
Course course = new Course();
course.Code = txtCourseNumber.Text;
course.Title = txtCourseName.Text;
entities.Courses.Add(course);
entities.SaveChanges();
//courses.Add(course);
// add new course to the session, use insert to display the course at top
courses.Insert(0, course);
}
Session["courses"] = courses;
DisplayCourseTable(courses);
}
protected void btnAddStudentRecord_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
List <Course> courses = (List <Course>)Session["courses"];
Course selectedCourse = courses.Find(c => c.Code == drpCourseSelection.SelectedValue);
using (StudentRecordEntities entities = new StudentRecordEntities())
{
Student student = (from s in entities.Students
where s.Id == txtStudentNumber.Text
select s).FirstOrDefault <Student>();
if (student == null)
{
student = new Student();
student.Id = txtStudentNumber.Text;
student.Name = txtStudentName.Text;
entities.Students.Add(student);
entities.SaveChanges();
}
AcademicRecord academicRecord = new AcademicRecord();
academicRecord.CourseCode = drpCourseSelection.SelectedValue;
//academicRecord.StudentId = txtStudentNumber.Text;
academicRecord.Grade = int.Parse(txtGrade.Text);
//academicRecord.Course = selectedCourse;
academicRecord.Student = student;
Course course = (from c in entities.Courses
where c.Code == selectedCourse.Code
select c).FirstOrDefault <Course>();
course.AcademicRecords.Add(academicRecord);
entities.SaveChanges();
}
displayStudentRecordTable(selectedCourse);
}
