public ActionResult AvailableCrew() { var userid = User.Identity.GetUserId(); //Get all garages for logged in user: //var garages = db.WorkerGarages.Where(a => a.CrewLeaderId == userid).ToList(); var garages = db.WorkerGarages.FirstOrDefault(a => a.CrewLeaderId == userid); CrewMemberAssignment crewMembers = new CrewMemberAssignment { AvailableMembers = db.WorkerGarages.Where(a => a.IsLeader == false && a.GarageID == garages.GarageID).ToList() }; return(View(crewMembers)); }
public ActionResult MyCrew() { var userid = User.Identity.GetUserId(); //Get all garages for logged in user: //var garages = db.WorkerGarages.Where(a => a.CrewLeaderId == userid).ToList(); var garages = db.WorkerGarages.FirstOrDefault(a => a.CrewLeaderId == userid); CrewMemberAssignment crewMembers = new CrewMemberAssignment { PickedMembers = db.LeaderMembers.Where(a => a.CrewLeaderID == userid).ToList() }; return(View(crewMembers)); }