public List<string> getAllCourses()
{
using (var context = new CourseDbContext())
{
return context.Courses.Select(c => c.Description).ToList<string>();
}
}
public void AddCourse(string courseName)
{
using (var context = new CourseDbContext())
{
DE.Course course = new DE.Course();
course.Description = courseName;
context.Courses.Add(course);
context.SaveChanges();
}
}
public int getCourseID(string courseName)
{
int Id = 0;
using (var context = new CourseDbContext())
{
DE.Course course = context.Courses.Where(a => a.Description == courseName).FirstOrDefault<DE.Course>();
if (course != null)
{
Id = course.CourseID;
}
}
return Id;
}
public void AddCoursewithPreRequiste(string courseName, string PreRequisite)
{
using (var context = new CourseDbContext())
{
DE.PrerequisiteCourse preReq = new DE.PrerequisiteCourse();
preReq.Id_Course = this.getCourseID(courseName);
int preReqId = this.getCourseID(PreRequisite);
if (preReqId > 0)
{
preReq.Id_Prereq_Course = preReqId;
}
context.PrerequisiteCourses.Add(preReq);
context.SaveChanges();
}
}
