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