public ActionResult UsersAndTeachers(int?id) // user id { checkLogin(); List <QE_USER> list = DBS.findActiveRecords <QE_USER>(); Session["userList"] = list; QE_USER displayingUser = id != null?list.Where(l => l.ID == (int)id).FirstOrDefault() : new QE_USER(); UsersAndTeachersViewModel ViewModel = new UsersAndTeachersViewModel(list, displayingUser); return(View(ViewModel)); }
public ActionResult HomeworkType() { checkLogin(); HomeworkTypeViewModel HTVM = new HomeworkTypeViewModel() { types = DBS.findActiveRecords <HOMEWORK_TYPE>() }; return(View(HTVM)); }
public static List <SubjectAndSSubjects> getSubjectAndSSubjectsList(int term_id) { List <SubjectAndSSubjects> SubjectAndSSubjectsList = new List <SubjectAndSSubjects>(); List <SUBJECT> subjects = DBS.findActiveRecordsBySingleParm <SUBJECT>("TERM", term_id); List <SSUBJECT> ssubjects = DBS.findActiveRecords <SSUBJECT>(); foreach (var subject in subjects) { List <SSUBJECT> ss = ssubjects.FindAll(s => s.SUBJECT == subject.ID); SubjectAndSSubjectsList.Add(new SubjectAndSSubjects(subject, ss)); } return(SubjectAndSSubjectsList); }
public static List <ClassView> getClassViews(int term) { try { List <ClassView> list = new List <ClassView>(); List <QE_USER> users = DBS.findActiveRecords <QE_USER>(); foreach (var c in GetClassesByTerm(term)) { string name = users.Exists(u => u.ID == c.TEACHER) ? users.Where(u => u.ID == c.TEACHER).FirstOrDefault().USER_NAME : string.Empty; string name2 = users.Exists(u => u.ID == c.TEACHER_2) ? users.Where(u => u.ID == c.TEACHER_2).FirstOrDefault().USER_NAME : string.Empty; ClassView CV = new ClassView(c, name, name2); list.Add(CV); } return(list); } catch (Exception e) { return(null); } }