public ActionResult Assign(int id) { var student = studentService.GetStudent(id); var courses = courseService.GetAllStudent(); ViewBag.courses = new SelectList(courses, "CourseId", "CourseName"); StudentCourseViewModel studentCourseVM = new StudentCourseViewModel(); studentCourseVM.student = student; return(View(studentCourseVM)); }
public ActionResult Enroll(StudentCourseViewModel model) { var student = db.Students.Find(model.StudentId); var course = db.Courses.Find(model.CourseId); if (student != null && course != null) { student.Courses = new List <Course>(); student.Courses.Add(course); db.SaveChanges(); return(RedirectToAction("Details", new { id = student.Id })); } return(View()); }
public IActionResult Create() { var item = _context.Courses.ToList(); StudentCourseViewModel model = new StudentCourseViewModel(); model.AvailableCourses = item.Select(vm => new CheckBoxItem() { Id = vm.Id, Title = vm.Title, IsChecked = false }).ToList(); return(View(model)); }
public ActionResult Create(FormCollection collection) { var item = db.Courses.ToList(); StudentCourseViewModel m1 = new StudentCourseViewModel(); m1.AvailableCourses = item.Select(vm => new CheckBoxItem() { CourseId = vm.CourseId, CourseName = vm.CourseName, IsChecked = false }).ToList(); return(View(m1)); }
public ActionResult Edit(int id, StudentCourseViewModel SCVM, Student students, StudentsEnrollment enroll) { List <StudentsEnrollment> ste = new List <StudentsEnrollment>(); students.StudentName = SCVM.StudentName; students.Address = SCVM.Address; students.Email = SCVM.Email; students.StudentId = SCVM.StudentId; db.Students.Attach(students); //check attach wrk or not db.ObjectStateManager.ChangeObjectState(students, EntityState.Modified); db.SaveChanges(); int studentid = students.StudentId; foreach (var item in SCVM.AvailableCourses) { if (item.IsChecked == true) { ste.Add(new StudentsEnrollment() { StudentId = studentid, CourseId = item.CourseId }); } } var dbtable = db.StudentsEnrollments.Where(a => a.StudentId == studentid).ToList(); var result = dbtable.Except(ste).ToList(); foreach (var item in result) { db.StudentsEnrollments.DeleteObject(item); db.SaveChanges(); } var getcourseid = db.StudentsEnrollments.Where(a => a.StudentId == studentid).ToList(); foreach (var item in ste) { if (!getcourseid.Contains(item)) { ; } { db.StudentsEnrollments.AddObject(item); db.SaveChanges(); } } return(RedirectToAction("Index")); }
public IActionResult Edit(StudentCourseViewModel studentCourseViewModel, Student student, StudentCourse studentCourse) { List <StudentCourse> _studentCourse = new List <StudentCourse>(); // Set student values student.FirstName = studentCourseViewModel.FirstName; student.LastName = studentCourseViewModel.LastName; student.RollNumber = studentCourseViewModel.RollNumber; student.Email = studentCourseViewModel.Email; _context.Students.Update(student); _context.SaveChanges(); int studentId = student.Id; foreach (var item in studentCourseViewModel.AvailableCourses) { if (item.IsChecked == true) { _studentCourse.Add(new StudentCourse { StudentId = studentId, CourseId = item.Id }); } } var databaseTable = _context.StudentCourses.Where(s => s.StudentId == studentId).ToList(); var resultList = databaseTable.Except(_studentCourse).ToList(); foreach (var item in resultList) { _context.StudentCourses.Remove(item); _context.SaveChanges(); } var getCourseId = _context.StudentCourses.Where(a => a.StudentId == studentId).ToList(); foreach (var item in _studentCourse) { if (!getCourseId.Contains(item)) { _context.StudentCourses.Add(item); _context.SaveChanges(); } } return(RedirectToAction("Index", "Student")); }
public ActionResult RemoveStudent(int?studentId, int?courseId) { if (studentId == null || courseId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var model = new StudentCourseViewModel() { CourseId = courseId.Value, StudentId = studentId.Value }; return(View(model)); }
// GET: Student public async Task <IActionResult> Index(bool hasPaid, string studentCourse, string searchString) { //Use LINQ to go list of courses IQueryable <string> courseQuery = from m in _context.Student orderby m.Course select m.Course; IQueryable <bool> ifPaid = from p in _context.Student orderby p.Paid select p.Paid; var students = from m in _context.Student select m; if (!String.IsNullOrEmpty(searchString)) { students = students.Where(s => s.Name.Contains(searchString)); } if (!String.IsNullOrEmpty(studentCourse)) { students = students.Where(x => x.Course == studentCourse); } // LINQ for boolean model.Paid if (hasPaid && !hasPaid) { students = students.Where(s => s.Paid && !s.Paid); } else if (hasPaid) { students = students.Where(s => s.Paid); } // else if(!hasPaid) // { // students = students.Where(s => !s.Paid); // } var studentCourseVM = new StudentCourseViewModel(); studentCourseVM.courses = new SelectList(await courseQuery.Distinct().ToListAsync()); studentCourseVM.students = await students.ToListAsync(); studentCourseVM.paid = new SelectList(await ifPaid.Distinct().ToListAsync()); return(View(studentCourseVM)); }
public ActionResult UnEnroll(StudentCourseViewModel model) { var student = db.Students.Include(s => s.Courses).FirstOrDefault(s => s.Id == model.StudentId); var course = db.Courses.Find(model.CourseId); if (student != null) { if (!student.Courses.Contains(course)) { return(RedirectToAction("Index")); } student.Courses.Remove(course); db.SaveChanges(); return(RedirectToAction("Details", new { id = student.Id })); } return(View()); }
public async Task <PartialViewResult> Student(StudentViewModel model) { if (ModelState.IsValid) { //save await _studentRepository.AddStudentAsync(model.Student); await _studentRepository.SaveAsync(); } else { //error } var students = _studentRepository.GetAllStudents(); var viewModel = new StudentCourseViewModel() { Students = students }; return(PartialView("_SelectedStudent", viewModel)); }
//------------------------------------------------------------------------- public List <StudentCourseViewModel> RegNoDropdown() { query = "SELECT * FROM RegisterStudentTable"; Command = new SqlCommand(query, Connection); List <StudentCourseViewModel> StudentList = new List <StudentCourseViewModel>(); Connection.Open(); Reader = Command.ExecuteReader(); while (Reader.Read()) { StudentCourseViewModel student = new StudentCourseViewModel() { Id = Convert.ToInt32(Reader["Id"]), RegNo = Reader["RegNo"].ToString() }; StudentList.Add(student); } Connection.Close(); return(StudentList); }
public IActionResult Edit(int id) { StudentCourseViewModel studentCourseView = new StudentCourseViewModel(); var student = _context.Students.Include(s => s.StudentCourse) .ThenInclude(c => c.Course) .AsNoTracking().SingleOrDefault(m => m.Id == id); var allCourse = _context.Courses.Select(vm => new CheckBoxItem() { Id = vm.Id, Title = vm.Title, IsChecked = vm.StudentCourse.Any(x => x.StudentId == student.Id) ? true : false }).ToList(); studentCourseView.FirstName = student.FirstName; studentCourseView.LastName = student.LastName; studentCourseView.Email = student.Email; studentCourseView.RollNumber = student.RollNumber; studentCourseView.AvailableCourses = allCourse; return(View(studentCourseView)); }
//------------------------------------------------------------------------- public StudentCourseViewModel studentById(int studentId) { query = "SELECT * FROM RegNoDropdownView WHERE ID=" + studentId; Command = new SqlCommand(query, Connection); Connection.Open(); Reader = Command.ExecuteReader(); Reader.Read(); StudentCourseViewModel student = new StudentCourseViewModel() { Id = Convert.ToInt32(Reader["Id"]), Name = Reader["Name"].ToString(), Email = Reader["Email"].ToString(), DepartmentId = Convert.ToInt32(Reader["DepartmentId"]), DepartmentName = Reader["DepartmentName"].ToString() }; Connection.Close(); return(student); }
// GET: Students public async Task <IActionResult> Index(string SearchStudentId, string SearchFirstName, string SearchLastName) { IQueryable <Student> students = _context.Student.AsQueryable(); if (!string.IsNullOrEmpty(SearchStudentId)) { students = students.Where(s => s.StudentId.Contains(SearchStudentId)); } if (!string.IsNullOrEmpty(SearchFirstName)) { students = students.Where(s => s.FirstName.Contains(SearchFirstName)); } if (!string.IsNullOrEmpty(SearchLastName)) { students = students.Where(s => s.LastName.Contains(SearchLastName)); } var studentCourseVM = new StudentCourseViewModel { Students = await students.ToListAsync() }; return(View(studentCourseVM)); }
public async Task <IActionResult> Update([FromBody] StudentCourseViewModel studentCourseViewModel) { try { StudentCourse studentCourseMapped = mapper.Map <StudentCourse>(studentCourseViewModel); studentCourseMapped.DateTime = DateTime.Now; await studentCourseRepository.Update(studentCourseMapped); return(Ok(new { Results = studentCourseMapped })); } catch (Exception e) { Console.WriteLine($"ErrorMesages: {e}"); return(BadRequest(new { Errors = new { Code = "InvalidInputParameters", Description = "Invalid Input Parameters!" } })); } }
public IActionResult Create(StudentCourseViewModel studentCourseViewModel, Student student, StudentCourse studentCourse) { List <StudentCourse> stc = new List <StudentCourse>(); // Set student values student.FirstName = studentCourseViewModel.FirstName; student.LastName = studentCourseViewModel.LastName; student.RollNumber = studentCourseViewModel.RollNumber; student.Email = studentCourseViewModel.Email; _context.Students.Add(student); _context.SaveChanges(); int studentId = student.Id; // set courses to StudentCourseTable foreach (var item in studentCourseViewModel.AvailableCourses) { if (item.IsChecked == true) { stc.Add(new StudentCourse() { StudentId = studentId, CourseId = item.Id }); } } foreach (var item in stc) { _context.StudentCourses.Add(item); } _context.SaveChanges(); return(RedirectToAction("Index", "Student")); }
public async Task <IActionResult> Edit(int id, [Bind("CourseId,StudentId,CourseName")] StudentCourseViewModel studentCourse) { try { if (id != studentCourse.CourseId) { return(NotFound()); } if (ModelState.IsValid) { try { var result = await StudentCourseService.UpdateAsync(new StudentCourse { StudentId = studentCourse.StudentId, CourseId = studentCourse.CourseId }); } catch (DbUpdateConcurrencyException) { if (!StudentCourseExists(studentCourse.CourseId)) { return(NotFound()); } else { ViewBag.error = "Record could not be added"; } } return(RedirectToAction(nameof(Index))); } ViewData["CourseName"] = new SelectList(CourseService.GetAllAsync().Result, "CourseName", "CourseName"); ViewData["StudentId"] = new SelectList(StudentService.GetAllAsync().Result, "StudentId", "StudentId"); }catch (Exception ex) { ViewBag.error = ex.Message; } return(View(studentCourse)); }
public IActionResult EnrollCourse() { var currentUserName = _userManager.GetUserAsync(HttpContext.User).Result.FullName; var allCourses = _courseRepository.GetAllCourses(); var studentCourses = new List <AddStudentCourseViewModel>(); foreach (var c in allCourses) { studentCourses.Add(new AddStudentCourseViewModel { CourseId = c.CourseId, CourseName = c.CourseName, Instructor = c.Instructor, IsEnrolled = _studentCourseRepository.FindStudentCourse(currentUserName, c.CourseId) == null ? false : true }); } var viewModel = new StudentCourseViewModel { AddStudentCourseViewModels = studentCourses }; return(View(viewModel)); }
public IActionResult Index() { var allStudents = _studentRepository.GetAllStudents(); var students = new List <Student>(); foreach (var s in allStudents) { students.Add(new Student { StudentId = s.StudentId, Email = s.Email, Gender = s.Gender, EnrollmentDate = s.EnrollmentDate, FullName = s.FullName }); } var viewModel = new StudentCourseViewModel { Students = students }; return(View(viewModel)); }
public ActionResult editStudent(short id) { if (Session["username"] != null && Session["role"].Equals("admin")) { var student = _context.studentDb.SingleOrDefault(c => c.id == id); var listCheckedCourses = student.courseModel.ToList(); var viewModel = new StudentCourseViewModel { student = student, courses = _context.courseDb.ToList(), checkedCourses = listCheckedCourses }; if (student == null) { return(HttpNotFound()); } return(View("editStudent", viewModel)); } return(RedirectToAction("Login", "Home")); }
public JsonResult StudentById(int studentId) { StudentCourseViewModel students = enrollCoursesManager.studentById(studentId); return(Json(students)); }
private StudentCourseViewModel SetModelModulesData(StudentCourseViewModel model, List <Module> modules) { model.Modules = new List <ModuleDetailsViewModel>(); modules.ForEach(m => model.Modules.Add(_mapper.Map <ModuleDetailsViewModel>(m))); return(model); }