public ActionResult Index(TeacherTeachesStudentModel classViewModel)
{
ttsmodel.Sub_Code = classViewModel.Sub_Code;
ttsmodel.Department_DID = classViewModel.Department_DID;
ttsmodel.Sem = classViewModel.Sem;
ttsmodel.Section = classViewModel.Section;
AttendanceManagementDBEntities1 db = new AttendanceManagementDBEntities1();
var customer = db.AspNetUsers.FirstOrDefault(u => u.Email == User.Identity.Name);
var teacher = db.Teachers.FirstOrDefault(u => u.REFID == customer.Id);
classViewModel.Students = db.Students.Where(u => u.Section == classViewModel.Section).Where(u => u.Sem == classViewModel.Sem).Where(u => u.Department_DID == classViewModel.Department_DID).ToList();
for (int i = 0; i < classViewModel.Students.Count; i++)
{
Student_Studies_Subject student_studies_subject = new Student_Studies_Subject();
Teacher_Teaches_Student teacherTeachesStudent = new Teacher_Teaches_Student();
teacherTeachesStudent.Teacher_TID = teacher.TID;
teacherTeachesStudent.Subject_SubCode = classViewModel.Sub_Code;
teacherTeachesStudent.Student_USN = classViewModel.Students[i].USN;
student_studies_subject.SubCode = classViewModel.Sub_Code;
student_studies_subject.USN = classViewModel.Students[i].USN;
db.Teacher_Teaches_Student.Add(teacherTeachesStudent);
db.Student_Studies_Subject.Add(student_studies_subject);
db.SaveChanges();
}
return(RedirectToAction("Index", "TeachersPortal"));
}
public ActionResult DeleteConfirmed(string id)
{
Teacher teacher = db.Teachers.Find(id);
Teacher_Teaches_Student teacher_teaches_student = new Teacher_Teaches_Student();
var subjects_taught_by_teacher = db.Teacher_Teaches_Student.Where(u => u.Teacher_TID == id).Select(u => u.Subject_SubCode).ToList();
var uniqueSubjects = new HashSet <String>(subjects_taught_by_teacher).ToList();
for (int i = 0; i < uniqueSubjects.Count; i++)
{
var subject = uniqueSubjects[i];
var student = db.Student_Studies_Subject.Where(u => u.SubCode == subject).ToList();
for (int j = 0; j < student.Count; j++)
{
db.Student_Studies_Subject.Remove(student[j]);
}
}
// Removes all the students that are taught by the Teacher with given Teacher Id i.e. id
var TTS = db.Teacher_Teaches_Student.Where(u => u.Teacher_TID == id).ToList();
for (int i = 0; i < TTS.Count(); i++)
{
db.Teacher_Teaches_Student.Remove(TTS[i]);
}
var att = db.Attendances.Where(u => u.Teacher_TID == id).ToList();
for (int i = 0; i < att.Count(); i++)
{
db.Attendances.Remove(att[i]);
}
db.Teachers.Remove(teacher);
db.SaveChanges();
return(RedirectToAction("Index"));
}
