private static void AddCourse() { using (DBModelContainer context = new DBModelContainer()) { Course c = new Course(); Console.Write("Course Code: "); c.Code = Console.ReadLine(); Console.Write("Cousre Name: "); c.Name = Console.ReadLine(); context.Courses.Add(c); context.SaveChanges(); } }
private static void AddStudent() { using (DBModelContainer context = new DBModelContainer()) { Student s = new Student(); Console.Write("Student First Name: "); s.FirstName = Console.ReadLine(); Console.Write("Student Last Name: "); s.LastName = Console.ReadLine(); Console.Write("Student Registration Number: "); s.Number = Console.ReadLine(); context.Students.Add(s); context.SaveChanges(); } }
private static void AddStudentToCourse() { using (DBModelContainer context = new DBModelContainer()) { Console.WriteLine("Student Registration Number: "); string srn = Console.ReadLine(); Student student =( from s in context.Students where s.Number == srn select s).FirstOrDefault(); if (student != null) { DisplayStudent(student); Console.WriteLine("Course Code: "); string cc = Console.ReadLine(); Course course = (from c in context.Courses where c.Code == cc select c).FirstOrDefault(); if(course !=null) { DisplayCourse(course); student.Courses.Add(course); context.SaveChanges(); } else { Console.WriteLine("Invalid Course Code."); } } else { Console.WriteLine("Invalid Student Registration Number."); } } }