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