public async Task <JsonResult> GetAsync(string courseId) { DelftContext context = new DelftContext(); var course = context.Courses.FirstOrDefault(i => i.CourseCode == courseId); var courseTags = context.CourseToTag.Where(i => i.CourseCode == courseId); var course2Instructors = context.CourseToInstructor.Where(i => i.CourseCode == courseId); course.Tags = context.Tags.Where(i => courseTags.Any(j => j.TagName == i.TagName)).ToList(); course.ResponsibleInstructor = course2Instructors.Where(i => !i.IsResposible).Select(i => new Instructor { Email = i.Email }).ToList(); course.OtherInstructors = course2Instructors.Where(i => i.IsResposible).Select(i => new Instructor { Email = i.Email }).ToList(); //course.Tags = context.Tags.ToList(); //IEPCourse newC = (IEPCourse)course; //newC.CourseTags = newC.Tags.Select(i => i.TagName).ToList(); //newC.ResponsibleInstructor = course2Instructors.Where(i => i.IsResposible).Select(i => context.Persons.FirstOrDefault(j => j.Email == i.Email)).ToList(); //newC.OtherInstructors = course2Instructors.Where(i => !i.IsResposible).Select(i => context.Persons.FirstOrDefault(j => j.Email == i.Email)).ToList(); return(Json(course)); }
public async Task <JsonResult> GetAsync() { DelftContext context = new DelftContext(); foreach (var course in context.Courses) { course.Tags = context.CourseToTag.Where(i => i.CourseCode == course.CourseCode).Select(i => new Tag { TagName = i.TagName }).ToList(); } return(Json(context.Courses)); }
public async Task <JsonResult> GetAsync() { DelftContext context = new DelftContext(); return(Json(context.Tags)); }
public async Task <JsonResult> GetAsync(string email) { DelftContext context = new DelftContext(); return(Json(context.Persons.FirstOrDefault(i => i.Email == email))); }