public void UpdateStudent(Person newP) { schoolDB = new SchoolEntities(); Person personInDB = schoolDB.People.First(s => s.PersonID == newP.PersonID); personInDB.FirstName = newP.FirstName; personInDB.LastName = newP.LastName; personInDB.EnrollmentDate = newP.EnrollmentDate; schoolDB.SaveChanges(); }
public void DeleteStudent(int studentId) { schoolDB = new SchoolEntities(); var student = schoolDB.StudentGrades.Where(s => s.StudentID == studentId); schoolDB.StudentGrades.RemoveRange(student); var person = schoolDB.People.First(p => p.PersonID == studentId); schoolDB.People.Remove(person); schoolDB.SaveChanges(); }
public void ChangeCourseAssignment(int instId, int oldCourse, int newCourse) { schoolDB = new SchoolEntities(); var oldCi = schoolDB.CourseInstructors.Find(oldCourse, instId); CourseInstructor newCi = new CourseInstructor(); newCi.CourseID = newCourse; newCi.PersonID = instId; schoolDB.CourseInstructors.Remove(oldCi); schoolDB.CourseInstructors.Add(newCi); schoolDB.SaveChanges(); }
public List <StudentGrade> GetAllStudents() { schoolDB = new SchoolEntities(); return(schoolDB.StudentGrades.GroupBy(sg => new { sg.StudentID, sg.Person.FirstName, sg.Person.LastName }) .Select(sg => sg.FirstOrDefault()).OrderBy(sg => sg.StudentID).ToList()); }
public List <CourseInstructor> GetAllInstructorCourses() { schoolDB = new SchoolEntities(); return(schoolDB.CourseInstructors.ToList()); }
public List <StudentGrade> GetStudentGrades(int courseId) { schoolDB = new SchoolEntities(); return(schoolDB.StudentGrades.Where(sg => sg.CourseID == courseId).ToList()); }
public void EnrollStudentToCourse(StudentGrade sg) { schoolDB = new SchoolEntities(); schoolDB.StudentGrades.Add(sg); schoolDB.SaveChanges(); }
public Person GetInstructor(int pid) { schoolDB = new SchoolEntities(); return(schoolDB.People.Find(pid)); }
public void AssignCourseToInstructor(CourseInstructor ci) { schoolDB = new SchoolEntities(); schoolDB.CourseInstructors.Add(ci); schoolDB.SaveChanges(); }
public List <Department> GetAllDepartments() { schoolDB = new SchoolEntities(); return(schoolDB.Departments.ToList()); }
public List <Course> GetAllCourses() { schoolDB = new SchoolEntities(); return(schoolDB.Courses.ToList()); }
public void AddNewCourse(Course course) { schoolDB = new SchoolEntities(); schoolDB.Courses.Add(course); schoolDB.SaveChanges(); }
public void AddNewOfficeAssignment(OfficeAssignment instructor) { schoolDB = new SchoolEntities(); schoolDB.OfficeAssignments.Add(instructor); schoolDB.SaveChanges(); }
public List <CourseInstructor> GetCoursesOfInstructor(int id) { schoolDB = new SchoolEntities(); return(schoolDB.CourseInstructors.Where(ci => ci.PersonID == id).ToList()); }
public bool StudentExists(int studentId) { schoolDB = new SchoolEntities(); return(schoolDB.StudentGrades.Any(s => s.StudentID == studentId)); }
public bool CourseExists(int courseId) { schoolDB = new SchoolEntities(); return(schoolDB.Courses.Any(c => c.CourseID == courseId)); }
public Person GetStudent(int studentId) { schoolDB = new SchoolEntities(); return(schoolDB.People.First(s => s.PersonID == studentId)); }