Exemple #1
0
        public static List <QE_CLASS> GetClasses(Dictionary <string, string> Ds)
        {
            Ds.Add("TERM", TermService.GetCurrentTerm().ID.ToString());
            Ds.Add("ACTIVE", "1");

            try { return(WillORM.GetDBSource("QE_CLASS", WillORM.QueryBuilder(null, "QE_CLASS", Ds, new string[] { "FORM", "NAME" })).Cast <QE_CLASS>().ToList()); }
            catch { return(null); }
        }
Exemple #2
0
 public static List <STUDENT> GetStudents(int term) // get students by term
 {
     try { return(KennyORM.GetDBSource("STUDENT", "select * from STUDENT where ID in (select STUDENT from CLASS_STUDENT_LIST where ID in (select ID from QE_CLASS where TERM = " + TermService.GetCurrentTerm().ID + " and active=1 order by FORM, NAME) and active=1) and active=1").Cast <STUDENT>().ToList()); }
     catch { return(new List <STUDENT>()); }
 }
Exemple #3
0
        public static List <STUDENT> getStudentByGroup(int group_id)
        {
            string query = "select * from STUDENT where ID in (select STUDENT from STUDENT_GROUP_STUDENT_LIST where STUDENT_GROUP in (select ID from STUDENT_GROUP where ID = " + group_id + " and TERM = " + TermService.GetCurrentTerm().ID + ")) and active=1";

            try { return(WillORM.GetDBSource("STUDENT", query).Cast <STUDENT>().ToList()); }
            catch { return(null); }
        }
Exemple #4
0
 public static List <HOMEWORK> GetWorks()
 {
     try { return(WillORM.GetDBSource("HOMEWORK", "select * from HOMEWORK where STUDENT_GROUP in (select ID from STUDENT_GROUP where TERM='" + TermService.GetCurrentTerm().ID + "' and active=1) and active=1").Cast <HOMEWORK>().ToList()); }
     catch { return(null); }
 }
Exemple #5
0
 public static List <HOMEWORK> GetHomeworksByType(int homework_type)
 {
     try { return(KennyORM.GetDBSource("HOMEWORK", "select * from HOMEWORK where STUDENT_GROUP in (select ID from STUDENT_GROUP where TERM='" + TermService.GetCurrentTerm().ID + "' and active=1) and HOMEWORK_TYPE=" + homework_type + " and active=1").Cast <HOMEWORK>().ToList()); }
     catch { return(null); }
 }
Exemple #6
0
 public static List <STUDENT_GROUP> GetStudentGroups(int subject)
 {
     try { return(KennyORM.GetDBSource("STUDENT_GROUP", "select * from STUDENT_GROUP where TERM='" + TermService.GetCurrentTerm().ID + "' and SUBJECT=" + subject + " and active=1").Cast <STUDENT_GROUP>().ToList()); }
     catch { return(null); }
 }
Exemple #7
0
 public static List <QE_CLASS> GetClassesByForm(int form)
 {
     try { return(KennyORM.GetDBSource("QE_CLASS", "select * from QE_CLASS where TERM = '" + TermService.GetCurrentTerm().ID + "' and active=1 and FORM = " + form + " order by FORM, NAME").Cast <QE_CLASS>().ToList()); }
     catch { return(null); }
 }
Exemple #8
0
 public static QE_CLASS GetClass(int form, string name)
 {
     try { return(KennyORM.GetDBSource("QE_CLASS", "select * from QE_CLASS where TERM = '" + TermService.GetCurrentTerm().ID + "' and active=1 and FORM = " + form + " and NAME = '" + name + "'").Cast <QE_CLASS>().First()); }
     catch { return(null); }
 }