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);
}
