public ActionResult Create(TraineeUserViewModel trainee) { var traineeinDb = (from te in _context.Roles where te.Name.Contains("Trainee") select te).FirstOrDefault(); var traineeUser = _context.Users.Where(u => u.Roles.Select(us => us.RoleId).Contains(traineeinDb.Id)).ToList(); if (ModelState.IsValid) { var checkTraineeExist = _context.TraineeUsers.Include(t => t.Trainee).Where(t => t.Trainee.Id == trainee.TraineeUser.TraineeID); //GET TraineeID if (checkTraineeExist.Count() > 0) //list ID comparison, if count == 0. jump to else // if (checkTraineeExist.Any()) { ModelState.AddModelError("", "Trainee Already Exists."); } else { _context.TraineeUsers.Add(trainee.TraineeUser); _context.SaveChanges(); return(RedirectToAction("Index")); } } TraineeUserViewModel traineeUserView = new TraineeUserViewModel() { Trainees = traineeUser, TraineeUser = trainee.TraineeUser }; return(View(traineeUserView)); }
public ActionResult Create() { //Get Account Trainee var userInDb = (from r in _context.Roles where r.Name.Contains("Trainee") select r).FirstOrDefault(); var users = _context.Users.Where(x => x.Roles.Select(y => y.RoleId).Contains(userInDb.Id)).ToList(); var traineeUser = _context.TraineeUsers.ToList(); var viewModel = new TraineeUserViewModel { Trainees = users, TraineeUser = new TraineeUser() }; return(View(viewModel)); }