public void AddCourseStudents(CourseStudent courseStudent)
{
CourseStudent dbcs = dbContext.CourseStudents.FirstOrDefault(cs => cs.CourseId == courseStudent.CourseId && cs.StudentId == courseStudent.StudentId);
if (dbcs == null)
{
dbContext.CourseStudents.Add(dbcs);
}
dbContext.SaveChanges();
}
public void SavaReview(Review review)
{
if (review.ReviewId == 0)
{
dbContext.Reviews.Add(review);
}
else
{
Review dbReview = dbContext.Reviews.FirstOrDefault(r => r.ReviewId == review.ReviewId);
if (dbReview != null)
{
dbReview.CourseCode = review.CourseCode;
dbReview.CourseName = review.CourseName;
dbReview.Semester = review.Semester;
dbReview.Comment = review.Comment;
dbReview.CreatorName = review.CreatorName;
dbReview.CreateTime = review.CreateTime;
}
}
dbContext.SaveChanges();
}
public void SaveCourse(Course course)
{
if (course.CourseId == 0)
{
dbContext.Courses.Add(course);
}
else
{
Course dbCourse = dbContext.Courses.FirstOrDefault(c => c.CourseId == course.CourseId);
if (dbCourse != null)
{
dbCourse.Code = course.Code;
dbCourse.Description = course.Description;
dbCourse.Faculty = course.Faculty;
dbCourse.Name = course.Name;
dbCourse.Season = course.Season;
dbCourse.MaxSize = course.MaxSize;
dbCourse.CourseStudents = course.CourseStudents;
}
}
dbContext.SaveChanges();
}
public void SaveStudent(Student student)
{
if (student.StudentId == 0)
{
dbContext.Students.Add(student);
}
else
{
Student dbStudent = dbContext.Students.FirstOrDefault(s => s.StudentId == student.StudentId);
if (dbStudent != null)
{
dbStudent.FirstName = student.FirstName;
dbStudent.CourseStudents = student.CourseStudents;
dbStudent.IsRegistered = student.IsRegistered;
dbStudent.LastName = student.LastName;
dbStudent.MiddleName = student.MiddleName;
dbStudent.Semester = student.Semester;
dbStudent.Status = student.Status;
dbStudent.StudentNumber = student.StudentNumber;
}
}
dbContext.SaveChanges();
}
