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(); }