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);
}
protected void StudentIdDBValidate(object source, ServerValidateEventArgs args)
{
// validate if the student record is existed the selected course in database
List <Course> courses = (List <Course>)Session["courses"];
Course selectedCourse = courses.Find(c => c.Code == drpCourseSelection.SelectedValue);
using (StudentRecordEntities entities = new StudentRecordEntities())
{
AcademicRecord academicRecord = (from r in entities.AcademicRecords
where r.StudentId == txtStudentNumber.Text && r.CourseCode == selectedCourse.Code
select r).FirstOrDefault <AcademicRecord>();
if (academicRecord != null)
{
args.IsValid = false;
}
else
{
args.IsValid = true;
}
}
displayStudentRecordTable(selectedCourse);
}
