public ActionResult Index()
{
var user = UserManager.FindById(User.Identity.GetUserId());
var parent = db.Parents.Where(c => c.UserId == user.Id).SingleOrDefault();
var Rel = db.ParentStudentRelations.Where(c => c.ParentId == parent.ParentId).ToList();
var collection = new CollectionOfAllViewModel
{
Rel = Rel,
Hostels = db.Hostels.ToList(),
News = db.News.ToList(),
Notices = db.Notices.ToList()
};
return(View(collection));
//return View();
}
public ActionResult Index()
{
var user = UserManager.FindById(User.Identity.GetUserId());
var teacher = db.Instructors.Where(c => c.UserId == user.Id).SingleOrDefault();
var DptRel = db.DepartmentInstructorRelations.Where(c => c.InstructorId == teacher.InstructorId).SingleOrDefault();
var department = db.Departments.Where(c => c.DepartmentId == DptRel.DepartmentId).SingleOrDefault();
var Rel = db.InstructorCourseRelations.Where(c => c.InstructorId == teacher.InstructorId).ToList();
var collection = new CollectionOfAllViewModel
{
Rel2 = Rel,
Hostels = db.Hostels.ToList(),
News = db.News.ToList(),
Notices = db.Notices.ToList(),
Department = department
};
return(View(collection));
}
public ActionResult Index()
{
var user = UserManager.FindById(User.Identity.GetUserId());
var student = db.Students.Where(c => c.UserId == user.Id).SingleOrDefault();
var DptRel = db.DepartmentStudentRelations.Where(c => c.StudentId == student.StudentId).SingleOrDefault();
var department = db.Departments.Where(c => c.DepartmentId == DptRel.DepartmentId).SingleOrDefault();
var PrtRel = db.ParentStudentRelations.Where(c => c.StudentId == student.StudentId).SingleOrDefault();
var Parent = db.Parents.Where(c => c.ParentId == PrtRel.ParentId).SingleOrDefault();
var CompRel = db.StudentcomplaintRelations.Where(c => c.StudentId == student.StudentId).ToList();
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 ComplaintList = ComplaintsList.Distinct();
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 courseList = coursesList.Distinct();
var EvntRel = 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 EvntRel)
{
if (item.EventId == item1.EventId)
{
EventList.Add(item);
}
}
}
var evntList = EventList.Distinct();
var HostelRel = db.StudentHostelRelations.Where(c => c.StudentId == student.StudentId).FirstOrDefault();
var hostel = db.Hostels.FirstOrDefault();
if (HostelRel != null)
{
hostel = db.Hostels.Where(c => c.HostelId == HostelRel.HostelId).FirstOrDefault();
}
else
{
hostel = null;
}
var collection = new CollectionOfAllViewModel
{
Complaints = ComplaintList,
Parent = Parent,
Department = department,
Courses = courseList,
Events = evntList,
News = db.News.ToList(),
Notices = db.Notices.ToList(),
Hostel = hostel
};
return(View(collection));
}
