public ActionResult CompliantsList(int id)
{
var CompRel = db.StudentcomplaintRelations.Where(c => c.StudentId == id).ToList();
var student = db.Students.Where(c => c.StudentId == id).SingleOrDefault();
List <complaint> ComplaintsList = new List <complaint>();
var complaints = db.complaints.ToList();
foreach (var item in complaints)
{
foreach (var item1 in CompRel)
{
if (item.complaintId == item1.complaintId)
{
ComplaintsList.Add(item);
}
}
}
var ComplintsList = ComplaintsList;
var model = new ParentAdminStudentRelationViewModel
{
Complaints = ComplintsList,
Student = student
};
return(View(model));
}
public ActionResult EventsList(int id)
{
var student = db.Students.Where(c => c.StudentId == id).FirstOrDefault();
var Rel = db.StudentEventRelations.Where(c => c.StudentId == student.StudentId).ToList();
List <Event> EventList = new List <Event>();
var events = db.Events.ToList();
foreach (var item in events)
{
foreach (var item1 in Rel)
{
if (item.EventId == item1.EventId)
{
EventList.Add(item);
}
}
}
var cor = EventList.Distinct();
var model = new ParentAdminStudentRelationViewModel
{
Events = cor.ToList(),
Student = student
};
return(View(model));
}
public ActionResult HostelsList(int id)
{
var student = db.Students.Where(c => c.StudentId == id).FirstOrDefault();
var Rel = db.StudentHostelRelations.Where(c => c.StudentId == student.StudentId).ToList();
List <Hostel> HostelList = new List <Hostel>();
var hostels = db.Hostels.ToList();
foreach (var item in hostels)
{
foreach (var item1 in Rel)
{
if (item.HostelId == item1.HostelId)
{
HostelList.Add(item);
}
}
}
var cor = HostelList.Distinct();
var model = new ParentAdminStudentRelationViewModel
{
Hostels = cor.ToList(),
Student = student
};
return(View(model));
}
public ActionResult CoursesList(int id)
{
var student = db.Students.Where(c => c.StudentId == id).FirstOrDefault();
var Rel = db.StudentRegSubjectRelations.Where(c => c.StudentId == student.StudentId).ToList();
List <Course> coursesList = new List <Course>();
var course = db.Courses.ToList();
foreach (var item in course)
{
foreach (var item1 in Rel)
{
if (item.CourseId == item1.SubjectId)
{
coursesList.Add(item);
}
}
}
var cor = coursesList.Distinct();
var model = new ParentAdminStudentRelationViewModel
{
Courses = cor.ToList(),
Student = student
};
return(View(model));
}
public ActionResult AvailableHostelsList(int id)
{
var student = db.Students.Where(c => c.StudentId == id).FirstOrDefault();
var hostels = db.Hostels.ToList();
var model = new ParentAdminStudentRelationViewModel
{
Hostels = hostels,
Student = student
};
return(View(model));
}
