public async Task <IActionResult> Create([Bind("CourseName,ParticipantsAllowed,HandinDeadline,TeacherAUID")] Assignment assignment) { _context.Add(assignment); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
public static async Task <Student> GetStudent(int studentId, BlackboardDbContext context) { var student = await context.Students.FindAsync(studentId); await context.SaveChangesAsync(); return(student); }
//TODO: Grade assignment public static async Task GradeAssignment(Assignment assignment, BlackboardDbContext context) { var entity = await context.Assignments.FindAsync(assignment.AssignmentId); entity.Grade = assignment.Grade; context.Update(entity); await context.SaveChangesAsync(); }
public static async Task <IEnumerable <Student> > GetStudents(BlackboardDbContext context) { var students = await context.Students.ToListAsync(); await context.SaveChangesAsync(); return(students); }
//TODO: Add assignment public static async Task AddAssignment(Assignment assignment, BlackboardDbContext context) { if (!(await context.Courses.AnyAsync(a => a.Assignments.Contains(assignment)))) { await context.Assignments.AddAsync(assignment); await context.SaveChangesAsync(); } }
public static async Task AddCourse(Course course, BlackboardDbContext context) { if (!(await context.Courses.AnyAsync(c => c.CourseName == course.CourseName))) { await context.Courses.AddAsync(course); await context.SaveChangesAsync(); } }
public static async Task AddStudent(Student student, BlackboardDbContext context) { if (!(await context.Students.AnyAsync(s => s.AUID == student.AUID))) { await context.Students.AddAsync(student); await context.SaveChangesAsync(); } }
public static async Task AddCourseStudent(CourseStudent courseStudent, BlackboardDbContext context) { if (!(await context.CourseStudents.AnyAsync( cs => (cs.CourseName == courseStudent.CourseName) && (cs.StudentAUID == courseStudent.StudentAUID)))) { await context.CourseStudents.AddAsync(courseStudent); await context.SaveChangesAsync(); } }
public static async Task <IEnumerable <Course> > GetCourses(BlackboardDbContext context) { if (await context.Courses.AnyAsync()) { var courses = await context.Courses.ToListAsync(); await context.SaveChangesAsync(); return(courses); } return(null); }
public static async Task <IEnumerable <Assignment> > GetAssignments(BlackboardDbContext context) { if (await context.Assignments.AnyAsync()) { var assignments = await context.Assignments.ToListAsync(); await context.SaveChangesAsync(); return(assignments); } return(null); }
public static async Task <IEnumerable <CourseStudent> > GetCourseStudentByStudentId(int auId, BlackboardDbContext context) { if (await context.CourseStudents.AnyAsync(cs => cs.StudentAUID == auId)) { var courseStudents = await context.CourseStudents .Where(cs => cs.StudentAUID == auId) .ToListAsync(); await context.SaveChangesAsync(); return(courseStudents); } return(null); }
public static async Task <IEnumerable <CourseStudent> > GetCourseStudentByCourseName(string courseName, BlackboardDbContext context) { if (await context.CourseStudents.AnyAsync(cs => cs.CourseName == courseName)) { var teacherCourses = await context.CourseStudents .Where(cs => cs.CourseName == courseName) .ToListAsync(); await context.SaveChangesAsync(); return(teacherCourses); } return(null); }
public static async Task <IEnumerable <TeacherCourse> > GetTeacherCoursesByCourseName(string courseName, BlackboardDbContext context) { if (await context.TeacherCourses.AnyAsync(tc => tc.CourseName == courseName)) { var teacherCourses = await context.TeacherCourses .Where(tc => tc.CourseName == courseName) .ToListAsync(); await context.SaveChangesAsync(); return(teacherCourses); } return(null); }
public static async Task <IEnumerable <AssignmentStudent> > GetAssignmentByStudentId(int auId, BlackboardDbContext context) { if (await context.AssignmentStudents.AnyAsync(as_ => as_.StudentAUID == auId)) { var assignmentStudents = await context.AssignmentStudents .Where(as_ => as_.StudentAUID == auId) .ToListAsync(); await context.SaveChangesAsync(); return(assignmentStudents); } return(null); }
public static async Task <IEnumerable <Assignment> > GetStudentAssignmentsByCourseIDAndStudentID(string courseName, int auId, BlackboardDbContext context) { var assignmentStudents = await context.AssignmentStudents .Where(as_ => as_.StudentAUID == auId) .Where(cn_ => cn_.Assignment.CourseName == courseName) .ToListAsync(); await context.SaveChangesAsync(); List <Assignment> matchingAssignment = new List <Assignment>(); foreach (var entity in assignmentStudents) { matchingAssignment = await context.Assignments. Where(a => a.AssignmentId == entity.AssignmentId). ToListAsync(); } return(matchingAssignment); }