public ActionResult LectureNotes(int Id = 0) { List <LectureNoteItem> lectureNotes = new List <LectureNoteItem>(); using (EastWoodEntities db = new EastWoodEntities()) { List <LectureNote> items = new List <LectureNote>(); if (Id == 0) { items = db.LectureNotes.ToList(); } else { items = db.LectureNotes.Where(w => w.SubjectId == Id).ToList(); } foreach (var item in items) { LectureNoteItem note = new LectureNoteItem(); note.LectureNote = item; note.Subject = item.Subject; note.Attachments = db.Attachments. Where(w => w.AttachmentReferenceId == item.LectureNoteid && w.AttachmentReferenceType == AttachmentReferenceTypes.LECTURE_NOTE) .ToList(); lectureNotes.Add(note); } } ViewBag.SubjectId = Id; return(View(lectureNotes)); }
public ActionResult LectureNotes(int Id = 0) { int userId = int.Parse(Session["UserId"].ToString()); List <LectureNoteItem> lectureNotes = new List <LectureNoteItem>(); using (EastWoodEntities db = new EastWoodEntities()) { List <LectureNote> items = new List <LectureNote>(); if (Id == 0) { int studentId = db.Students.Where(w => w.UserId == userId).Select(s => s.StudentId).FirstOrDefault(); if (studentId == 0) { items = db.LectureNotes.ToList(); } else { items = db.LectureNotes .Where(w => w.Subject.Semester.Course.StudentCourses.Where(w2 => w2.StudentId == studentId).Count() > 0) .ToList(); } } else { items = db.LectureNotes.Where(w => w.SubjectId == Id).ToList(); } foreach (var item in items) { LectureNoteItem note = new LectureNoteItem(); note.LectureNote = item; note.Subject = item.Subject; note.Attachments = db.Attachments. Where(w => w.AttachmentReferenceId == item.LectureNoteid && w.AttachmentReferenceType == AttachmentReferenceTypes.LECTURE_NOTE) .ToList(); lectureNotes.Add(note); } } ViewBag.SubjectId = Id; return(View(lectureNotes)); }