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.CourseStudents = course.CourseStudents; } } dbContext.SaveChanges(); }
public static void Populate(IApplicationBuilder app) { CourseHelperDBContext context = app.ApplicationServices.GetRequiredService <CourseHelperDBContext>(); context.Database.Migrate(); if (!context.Courses?.Any() ?? true) { addSeedCourses(context); addSeedStudents(context); } context.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(); }