public ActionResult Select(Teacher teacher) { var teacherInDb = _context.Teachers.SingleOrDefault(t => t.TeacherId == teacher.TeacherId); var subjectAllocator = new SubjectAllocator() { TeacherId = teacherInDb.TeacherId }; var subjects = _context.Subjects.Where(s => s.DepartmentId == teacherInDb.DepartmentId).ToList(); var subjectAllocViewModel = new SubjectAllocatorViewModel() { SubjectAllocator = subjectAllocator, Subjects = subjects }; return(View("AllocationForm", subjectAllocViewModel)); }
public ActionResult Save(SubjectAllocator subjectAllocator) { var checkTeacherInDb = _context.SubjectAllocators.SingleOrDefault(t => t.TeacherId == subjectAllocator.TeacherId); if (subjectAllocator.Id == 0 && checkTeacherInDb == null) { _context.SubjectAllocators.Add(subjectAllocator); } else { var getSubAllocation = _context.SubjectAllocators.Single(t => t.TeacherId == subjectAllocator.TeacherId); int getId = getSubAllocation.Id; var subjectAllocInDb = _context.SubjectAllocators.Single(c => c.Id == getId); subjectAllocInDb.TeacherId = subjectAllocator.TeacherId; subjectAllocInDb.SubjectId1 = subjectAllocator.SubjectId1; subjectAllocInDb.SubjectId2 = subjectAllocator.SubjectId2; subjectAllocInDb.SubjectId3 = subjectAllocator.SubjectId3; subjectAllocInDb.SubjectId4 = subjectAllocator.SubjectId4; } _context.SaveChanges(); return(RedirectToAction("Index", "Allocator")); }