private static void displayStudent() { Console.WriteLine("List of Students"); using (SRSDBPracticeEntities db = new SRSDBPracticeEntities()) { List <Student> StudentList = db.Students.ToList(); foreach (Student s in StudentList) { Console.WriteLine($"{s.Id} {s.FirstName} {s.LastName}"); } } }
private static void displayCourses() { Console.WriteLine("List of Courses"); using (SRSDBPracticeEntities db = new SRSDBPracticeEntities()) { var q = from c in db.Courses select c; foreach (Course c in q) { Console.WriteLine($"{c.Id} {c.Code} {c.Title}"); } } }
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 displayCourseEnrollmentList() { Console.WriteLine("Course Enrollment List"); using (SRSDBPracticeEntities db = new SRSDBPracticeEntities()) { List <Student> students = db.Students.ToList(); foreach (Student s in students) { Console.WriteLine($"{s.Id}: {s.FirstName} {s.LastName}"); List <Course> courses = s.Courses.ToList(); foreach (Course c in courses) { Console.WriteLine($" {c.Code} {c.Title}"); } Console.WriteLine(); } } }
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(); } }