private static void addNewCourse() { Console.WriteLine("Plesae enter the course Code: "); string Code = Console.ReadLine(); Console.WriteLine("Please enter the course Title: "); string Title = Console.ReadLine(); using (SRSDBPracticeEntities db = new SRSDBPracticeEntities()) { db.Courses.Add(new Course { Title = Title, Code = Code }); db.SaveChanges(); } }
private static void enrollStudentToCourse() { displayStudent(); Console.WriteLine("Please enter Student ID"); int sID = Convert.ToInt32(Console.ReadLine()); displayCourses(); Console.Write("Plesae enter course Id"); int cid = Convert.ToInt32(Console.ReadLine()); using (SRSDBPracticeEntities db = new SRSDBPracticeEntities()) { Course selectedcourse = db.Courses.Where(x => x.Id == cid).First(); Student studentToEnroll = db.Students.Where(x => x.Id == sID).First(); selectedcourse.Students.Add(studentToEnroll); db.SaveChanges(); } }
private static void addNewStudent() { Console.Write("Plesee enter your firstname: "); string FirstName = Console.ReadLine(); Console.Write("Plesee enter your Lastname: "); string LastName = Console.ReadLine(); Student s = new Student(); s.FirstName = FirstName; s.LastName = LastName; using (SRSDBPracticeEntities db = new SRSDBPracticeEntities()) { db.Students.Add(s); db.SaveChanges(); } }