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