public void DeleteStudent(int studentId) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var student = con.Students.Where(x => x.StudentId == studentId).FirstOrDefault(); if (student != null) { con.Students.Remove(student); con.SaveChanges(); } } }
public void DeleteEnrollment(int courseId, int studentId) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var enrollment = con.Enrollments.Where(x => x.CourseId == courseId && x.StudentId == studentId).FirstOrDefault(); if (enrollment != null) { con.Enrollments.Remove(enrollment); con.SaveChanges(); } } }
public void DeleteCourse(int courseId) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var course = con.Courses.Where(x => x.CourseId == courseId).FirstOrDefault(); if (course != null) { con.Courses.Remove(course); con.SaveChanges(); } } }
public void DeleteAll() { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var students = con.Students; if (students != null) { foreach (var s in students) { con.Students.Remove(s); } con.SaveChanges(); } } }
public void AddStudent(StudentData studentData) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var student = new Student { FirstName = studentData.FirstName, LastName = studentData.LastName, DateCreated = studentData.DateCreated }; con.Students.Add(student); con.SaveChanges(); } }
public void DeleteAll() { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var enrollments = con.Enrollments; if (enrollments != null) { foreach (var e in enrollments) { con.Enrollments.Remove(e); } con.SaveChanges(); } } }
public void AddEnrollment(EnrollmentData enrollmentData) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var enrollment = new Enrollment { CourseId = enrollmentData.CourseId, StudentId = enrollmentData.StudentId }; con.Enrollments.Add(enrollment); con.SaveChanges(); } }
public void DeleteAll() { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var courses = con.Courses; if (courses != null) { foreach (var c in courses) { con.Courses.Remove(c); } con.SaveChanges(); } } }
public void AddCourse(CourseData courseData) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var course = new Course { Title = courseData.Title, StartDate = courseData.StartDate, MaxEnrollmentCount = courseData.MaxEnrollmentCount }; con.Courses.Add(course); con.SaveChanges(); } }
public bool UpdateStudent(StudentData studentData) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var student = con.Students.Where(x => x.StudentId == studentData.StudentId).FirstOrDefault(); if (student != null) { student.FirstName = studentData.FirstName; student.LastName = studentData.LastName; student.DateCreated = studentData.DateCreated; con.SaveChanges(); return true; } } return false; }
public bool UpdateEnrollment(EnrollmentData enrollmentData) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var enrollment = con.Enrollments.Where(x => x.EnrollmentId == enrollmentData.EnrollmentId).FirstOrDefault(); if (enrollment != null) { enrollment.StudentId = enrollmentData.StudentId; enrollment.CourseId = enrollmentData.CourseId; con.SaveChanges(); return true; } } return false; }
public bool UpdateCourse(CourseData courseData) { using (KaplanTestPrepEntities con = new KaplanTestPrepEntities()) { var course = con.Courses.Where(x => x.CourseId == courseData.CourseId).FirstOrDefault(); if (course != null) { course.Title = courseData.Title; course.StartDate = courseData.StartDate; course.MaxEnrollmentCount = courseData.MaxEnrollmentCount; con.SaveChanges(); return true; } } return false; }