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();
}
}
