public ActionResult CreateClass() { var role = (from r in _context.Roles where r.Name.Contains("Marketing Coordinator") select r) .FirstOrDefault(); var listCoordinator = _context.Users.Where(x => x.Roles.Select(y => y.RoleId) .Contains(role.Id)) .ToList(); var listFaculty = _context.Faculties.ToList(); var dropDownListCoordinatorFaculty = new CoordinatorFacultyViewModel { Faculties = listFaculty, Coordinators = listCoordinator, }; return(View(dropDownListCoordinatorFaculty)); }
public ActionResult Create() { //get all account in coordinator role var role = (from r in _context.Roles where r.Name.Contains("Marketing Coodinator") select r) .FirstOrDefault(); var showCoordinator = _context.Users.Where(x => x.Roles.Select(y => y.RoleId) .Contains(role.Id)) .ToList(); var showFaculty = _context.Faculties.ToList(); var newFacultyViewModel = new CoordinatorFacultyViewModel { Faculties = showFaculty, Coordinators = showCoordinator }; return(View(newFacultyViewModel)); }