private static void assignCourseToStudent() { displayCourses(); Console.WriteLine("Course ID: "); int cID = Convert.ToInt32(Console.ReadLine()); displayStudent(); Console.WriteLine("Student ID: "); int sID = Convert.ToInt32(Console.ReadLine()); using (SRSDBEntities db = new SRSDBEntities()) { var queryCourse = from c in db.Courses where c.Id == cID select c; Course course = queryCourse.First(); Student student = (from s in db.Students where s.Id == sID select s).First(); student.Courses.Add(course); db.SaveChanges(); } }
private static void addNewCourse() { Console.Write("Course Code: "); string Code = Console.ReadLine(); Console.Write("Course Title: "); string Title = Console.ReadLine(); using (SRSDBEntities db = new SRSDBEntities()) { db.Courses.Add(new Course() { Code = Code, Title = Title }); db.SaveChanges(); } }
private static void addNewStudent() { Console.Write("FirstName: "); string FirstName = Console.ReadLine(); Console.Write("Last Name: "); string LastName = Console.ReadLine(); Student s = new Student(); s.FirstName = FirstName; s.LastName = LastName; using (SRSDBEntities db = new SRSDBEntities()) { db.Students.Add(s); db.SaveChanges(); } }
private static void enrollStudentToCourse() { displayStudent(); Console.WriteLine("Student ID: "); int sID = Convert.ToInt32(Console.ReadLine()); displayCourses(); Console.WriteLine("Course ID: "); int cID = Convert.ToInt32(Console.ReadLine()); using (SRSDBEntities db = new SRSDBEntities()) { Student student = db.Students.Where(s => s.Id == sID).First(); Course course = db.Courses.Find(cID); course.Students.Add(student); db.SaveChanges(); } }