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); }
}
