// GET: Courses/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
var course = _context.Course.Where(m => m.Id == id).Include(m => m.Students).First();
course = await _context.Course.FindAsync(id);
if (course == null)
{
return(NotFound());
}
CourseStudentEditViewModel viewmodel = new CourseStudentEditViewModel
{
Course = course,
StudentList = new MultiSelectList(_context.Student.OrderBy(s => s.Id), "Id", "FirstName"),
SelectedStudents = course.Students.Select(sa => sa.StudentId)
};
if (viewmodel == null)
{
return(NotFound());
}
return(View(viewmodel));
}
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
var course = _context.Course.Where(m => m.Id == id).Include(m => m.Students).First();
if (course == null)
{
return(NotFound());
}
var students = _context.Student.AsEnumerable();
students = students.OrderBy(s => s.FullName);
CourseStudentEditViewModel viewmodel = new CourseStudentEditViewModel
{
Course = course,
StudentList = new MultiSelectList(students, "Id", "FullName"),
SelectedStudents = course.Students.Select(sa => sa.StudentId)
};
ViewData["FirstTeacherId"] = new SelectList(_context.Set <Teacher>(), "Id", "FullName", course.FirstTeacherId);
ViewData["SecondTeacherId"] = new SelectList(_context.Set <Teacher>(), "Id", "FullName", course.SecondTeacherId);
return(View(viewmodel));
}
public async Task <IActionResult> Edit(int id, CourseStudentEditViewModel viewmodel)
{
if (id != viewmodel.Course.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(viewmodel.Course);
await _context.SaveChangesAsync();
IEnumerable <int> listStudents = viewmodel.SelectedStudents;
IQueryable <Enrollment> toBeRemoved = _context.Enrollment.Where(s => !listStudents.Contains(s.StudentId) && s.CourseId == id);
_context.Enrollment.RemoveRange(toBeRemoved);
IEnumerable <int> existStudents = _context.Enrollment.Where(s => listStudents.Contains(s.StudentId) && s.CourseId == id).Select(s => s.StudentId);
IEnumerable <int> newStudents = listStudents.Where(s => !existStudents.Contains(s));
foreach (int studentId in newStudents)
{
_context.Enrollment.Add(new Enrollment {
StudentId = studentId, CourseId = id
});
}
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CourseExists(viewmodel.Course.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["FirstTeacherId"] = new SelectList(_context.Set <Teacher>(), "Id", "FullName", viewmodel.Course.FirstTeacherId);
ViewData["SecondTeacherId"] = new SelectList(_context.Set <Teacher>(), "Id", "FullName", viewmodel.Course.SecondTeacherId);
return(View(viewmodel));
}
public async Task <IActionResult> PutCourse([FromRoute] int id, [FromBody] CourseStudentEditViewModel model)
{
if (id != model.Course.Id)
{
return(BadRequest());
}
_context.Entry(model.Course).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
IEnumerable <double> listStudents = model.SelectedStudents;
IQueryable <Enrollment> toBeRemoved = _context.Enrollment.Where(s => !listStudents.Contains(s.StudentId) && s.CourseId == id);
_context.Enrollment.RemoveRange(toBeRemoved);
IEnumerable <double> existStudents = _context.Enrollment.Where(s => listStudents.Contains(s.StudentId) && s.CourseId == id).Select(s => s.StudentId);
IEnumerable <double> newStudents = listStudents.Where(s => !existStudents.Contains(s));
foreach (int studentId in newStudents)
{
_context.Enrollment.Add(new Enrollment {
StudentId = studentId, CourseId = id
});
}
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CourseExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
