// GET: Principle/Edit/5
public ActionResult Edit(int?id)
{
loadcountry();
PrincipleViewModel pricipleViewModel = principleServices.GetByID(id);
return(View(pricipleViewModel));
}
public IActionResult DeleteTeacher(int id)
{
//In order to delte the teacher, you need to delete the class room, students, grades first
PrincipleViewModel principle = new PrincipleViewModel();
principle.teachers = _context.Teachers.Where(x => x.Id == id).ToList();
principle.classrooms = _context.Classrooms.Where(x => x.TeacherId == id).ToList();
foreach (Classrooms c in principle.classrooms)
{
DeleteStudentsGradesUsers(c.Id);
DeleteClassroom(c.Id);
}
var foundTeacher = _context.Teachers.Find(id);
if (foundTeacher != null)
{
_context.Teachers.Remove(foundTeacher);
_context.SaveChanges();
//deleting the user
principle.users = _context.AspNetUsers.Where(x => x.Id == foundTeacher.UserId).ToList();
foreach (AspNetUsers a in principle.users)
{
if (a != null)
{
_context.AspNetUsers.Remove(a);
_context.SaveChanges();
}
}
}
return(RedirectToAction("DisplayTeachers"));
}
public IActionResult DisplayStudents()
{
PrincipleViewModel principal = new PrincipleViewModel();
principal.students = _context.Students.ToList();
principal.classrooms = _context.Classrooms.ToList();
return(View(principal));
}
public void Create(PrincipleViewModel PrincipleViewModel)
{
var Principle = new Principle
{
Principle_name = PrincipleViewModel.Principle_name,
CountryId = PrincipleViewModel.CountryId
};
unitOfWork.PrincipleRepository.Insert(Principle);
unitOfWork.Save();
}
public IActionResult DisplayClassrooms()
{
PrincipleViewModel principle = new PrincipleViewModel();
principle.grades = _context.Grades.ToList();
principle.classrooms = _context.Classrooms.ToList();
principle.students = _context.Students.ToList();
principle.quizes = _context.Quizes.ToList();
principle.teachers = _context.Teachers.ToList();
return(View(principle));
}
public IActionResult DisplayUsers()
{
PrincipleViewModel principle = new PrincipleViewModel();
principle.users = _context.AspNetUsers.ToList();
principle.roles = _context.AspNetRoles.ToList();
principle.userRoles = _context.AspNetUserRoles.ToList();
principle.students = _context.Students.ToList();
principle.teachers = _context.Teachers.ToList();
return(View(principle));
}
public ActionResult Create(PrincipleViewModel pricipleViewModel)
{
try
{
// TODO: Add insert logic here
principleServices.Create(pricipleViewModel);
TempData["message"] = "Inserted Successfully";
return(RedirectToAction("Index"));
}
catch
{
return(View(pricipleViewModel));
}
}
public IActionResult Index()
{
PrincipleViewModel principle = new PrincipleViewModel();
//Displaying the Deans list and the students who needs support
principle.studentsWithDifficulty = _context.Students.Where(x => x.AverageGrade < 60).OrderBy(x => x.AverageGrade).ToList();
principle.studentsOnDeansList = _context.Students.Where(x => x.AverageGrade > 80).OrderByDescending(x => x.AverageGrade).ToList();
principle.classrooms = _context.Classrooms.Where(x => x.Teacher != null).ToList();
principle.students = _context.Students.ToList();
principle.teachers = _context.Teachers.ToList();
principle.grades = _context.Grades.ToList();
principle.roles = _context.AspNetRoles.ToList();
principle.userRoles = _context.AspNetUserRoles.ToList();
principle.users = _context.AspNetUsers.ToList();
return(View(principle));
}
public ActionResult Edit(PrincipleViewModel principleViewModel)
{
if (ModelState.IsValid)
{
try
{
// TODO: Add update logic here
principleServices.Update(principleViewModel);
TempData["message"] = "Update Successfully";
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
loadcountry();
return(View());
}
public void DeleteStudentsGradesUsers(int id)
{
PrincipleViewModel principle = new PrincipleViewModel();
principle.students = _context.Students.Where(x => x.ClassroomId == id).ToList();
for (int i = 0; i < principle.students.Count; i++)
{
principle.grades = _context.Grades.Where(x => x.StudentId == principle.students[i].Id).ToList();
foreach (Grades g in principle.grades)
{
if (g != null)
{
_context.Grades.Remove(g);
_context.SaveChanges();
}
}
}
foreach (Students s in principle.students)
{
if (s != null)
{
_context.Students.Remove(s);
_context.SaveChanges();
}
principle.users = _context.AspNetUsers.Where(x => x.Id == s.UserId).ToList();
foreach (AspNetUsers a in principle.users)
{
if (a != null)
{
_context.AspNetUsers.Remove(a);
_context.SaveChanges();
}
}
}
}
public IActionResult DeleteStudent(int id)
{
PrincipleViewModel principle = new PrincipleViewModel();
principle.students = _context.Students.Where(x => x.Id == id).ToList();
principle.grades = _context.Grades.Where(x => x.StudentId == principle.students[0].Id).ToList();
foreach (Grades g in principle.grades)
{
if (g != null)
{
_context.Grades.Remove(g);
_context.SaveChanges();
}
}
foreach (Students s in principle.students)
{
if (s != null)
{
_context.Students.Remove(s);
_context.SaveChanges();
}
principle.users = _context.AspNetUsers.Where(x => x.Id == s.UserId).ToList();
foreach (AspNetUsers a in principle.users)
{
if (a != null)
{
_context.AspNetUsers.Remove(a);
_context.SaveChanges();
}
}
}
return(RedirectToAction("DisplayStudents"));
}
