public ActionResult Create(TraineeCourseViewModel model) { //get trainer var role = (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(role.Id)).ToList(); //get topic var courses = _context.Courses.ToList(); if (ModelState.IsValid) { _context.TraineeCourses.Add(model.TraineeCourse); _context.SaveChanges(); return(RedirectToAction("Index")); } var TrainerTopicVM = new TraineeCourseViewModel() { Courses = courses, Trainees = users, TraineeCourse = new TraineeCourse() }; return(View(TrainerTopicVM)); }
public ActionResult Create(TraineeCourseViewModel model) { var role = (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(role.Id)).ToList(); var courses = _context.Courses.ToList(); if (!ModelState.IsValid) { return(View()); } var traineeeCourses = _context.TraineeCourses.ToList(); var courseId = model.TraineeCourse.CourseId; var checkTraineeInCourse = traineeeCourses.SingleOrDefault(c => c.CourseId == courseId && c.TraineeId == model.TraineeCourse.TraineeId); if (checkTraineeInCourse != null) { return(RedirectToAction("Create")); } var traineeCourse = new TraineeCourseViewModel() { Courses = courses, Trainees = users, TraineeCourse = new TraineeCourse() }; _context.TraineeCourses.Add(model.TraineeCourse); _context.SaveChanges(); return(RedirectToAction("index")); }
public ActionResult AssignCourseToTrainee(TraineeCourseViewModel model) { var IfCourseExist = _context.TraineeCourses.SingleOrDefault(t => t.TraineeId == model.TraineeId && t.CourseId == model.CourseId); if (IfCourseExist != null) { var viewModel = new TraineeCourseViewModel() { Trainees = _context.Users.OfType <Trainee>().ToList(), Courses = _context.Courses.ToList() }; ViewBag.message = "This Course had been assigned to this trainee"; return(View(viewModel)); } else { var traineeCourses = new TraineeCourses() { TraineeId = model.TraineeId, CourseId = model.CourseId }; _context.TraineeCourses.Add(traineeCourses); _context.SaveChanges(); return(RedirectToAction("AllCourseOfTrainee", "TraineeRelated", new { traineeId = model.TraineeId })); } }
public ActionResult Create() { var viewModel = new TraineeCourseViewModel { Courses = _context.Courses.ToList() }; return(View(viewModel)); }
public ActionResult ReassignedTraineeToCourse(TraineeCourseViewModel model) { var traineeCourse = _context.TraineeCourses.SingleOrDefault(t => t.Id == model.TraineeCourse.Id); traineeCourse.CourseId = model.TraineeCourse.CourseId; _context.SaveChanges(); return(RedirectToAction("AllCourseOfTrainee", "TraineeRelated", new { traineeId = model.TraineeId })); }
public ActionResult AssignCourseToTrainee() { var viewModel = new TraineeCourseViewModel() { Trainees = _context.Users.OfType <Trainee>().ToList(), Courses = _context.Courses.ToList() }; return(View(viewModel)); }
public ActionResult ReassignedTraineeToCourse(int Id) { var traineeCourse = _context.TraineeCourses.SingleOrDefault(t => t.Id == Id); var traineeId = traineeCourse.TraineeId; TraineeCourseViewModel model = new TraineeCourseViewModel { TraineeCourse = traineeCourse, Courses = _context.Courses.ToList(), TraineeId = traineeId }; return(View(model)); }
public ActionResult Create() { var role = (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(role.Id)).ToList(); var courses = _context.Courses.ToList(); var TrainerTopicVM = new TraineeCourseViewModel() { Courses = courses, Trainees = users, TraineeCourse = new TraineeCourse() }; return(View(TrainerTopicVM)); }
public ActionResult Edit(int id) { var tcInDb = _context.TraineeCourses.SingleOrDefault(p => p.Id == id); if (tcInDb == null) { return(HttpNotFound()); } var viewModel = new TraineeCourseViewModel { TraineeCourse = tcInDb, Courses = _context.Courses.ToList(), }; return(View(viewModel)); }
public async Task <IActionResult> Create(TraineeCourseViewModel model) { var traineeRoleId = await _db.Roles.Where(t => t.Name == SD.Trainee).Select(t => t.Id).FirstAsync(); var listTraineeId = await _db.UserRoles .Where(t => t.RoleId == traineeRoleId) .Select(t => t.UserId) .ToArrayAsync(); List <ApplicationUser> traineeUsers = await _db.ApplicationUsers .Where(t => listTraineeId .Any(name => name.Equals(t.Id))) .ToListAsync(); if (ModelState.IsValid) { var doesTraineeCourseExists = _db.TraineeCourses.Include(t => t.Course).Include(t => t.User) .Where(t => t.Course.Id == model.TraineeCourse.CourseId && t.User.Id == model.TraineeCourse.TraineeId); if (doesTraineeCourseExists.Count() > 0) { //Error StatusMessage = "Error: The Trainee has bene assigned under " + doesTraineeCourseExists.First().Course.Name + " Course. Please assigned another trainee."; } else { _db.TraineeCourses.Add(model.TraineeCourse); await _db.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } } TraineeCourseViewModel modelVM = new TraineeCourseViewModel() { Courses = await _db.Courses.ToListAsync(), TraineeCourse = model.TraineeCourse, StatusMessage = StatusMessage, Users = traineeUsers }; return(View(modelVM)); }
public ActionResult Create() { //Get Trainee var role = (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(role.Id)) .ToList(); //Get Course var courses = _context.Courses.ToList(); var newTraineeTopic = new TraineeCourseViewModel { Courses = courses, Trainees = users, ManageTrainee = new ManageTrainee() }; return(View(newTraineeTopic)); }
public async Task <IActionResult> Create() { var traineeRoleId = await _db.Roles.Where(t => t.Name == SD.Trainee).Select(t => t.Id).FirstAsync(); var listTraineeId = await _db.UserRoles .Where(t => t.RoleId == traineeRoleId) .Select(t => t.UserId) .ToArrayAsync(); List <ApplicationUser> traineeUsers = await _db.ApplicationUsers .Where(t => listTraineeId .Any(name => name.Equals(t.Id))) .ToListAsync(); TraineeCourseVM = new TraineeCourseViewModel() { Courses = await _db.Courses.ToListAsync(), Users = traineeUsers, TraineeCourse = new Models.TraineeCourse(), }; return(View(TraineeCourseVM)); }