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); } }
public List <T> Query <T>(Dictionary <string, string> DS) { string table = typeof(T).Name; try { return(WillORM.GetDBSource(table, WillORM.QueryBuilder(null, table, DS, null)).Cast <T>().ToList()); } catch (Exception e) { return(new List <T>()); } }
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); } }
public static List <QE_USER> getActiveUsers() { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("QE_USER", WillORM.QueryBuilder(null, "QE_USER", Ds, null)).Cast <QE_USER>().ToList()); } catch { return(new List <QE_USER>()); } }
public static List <HOMEWORK_SUBMISSION_LIST> getSubmission(int work_id) { Dictionary <string, string> condistions = new Dictionary <string, string>() { { "HOMEWORK", work_id.ToString() } }; try { return(WillORM.GetDBSource("HOMEWORK_SUBMISSION_LIST", WillORM.QueryBuilder(null, "HOMEWORK_SUBMISSION_LIST", condistions, null)).Cast <HOMEWORK_SUBMISSION_LIST>().ToList()); } catch { return(null); } }
public static USER_GROUP GetGroup(int id) { Dictionary <string, string> DS = new Dictionary <string, string>() { { "ID", id.ToString() } }; try { return(WillORM.GetDBSource("USER_GROUP", WillORM.QueryBuilder(null, "v", DS, null)).Cast <USER_GROUP>().FirstOrDefault()); } catch { return(null); } }
public static HOMEWORK_TYPE getType(int type_id) { Dictionary <string, string> DS = new Dictionary <string, string>() { { "ID", type_id.ToString() } }; try { return(WillORM.GetDBSource("HOMEWORK_TYPE", WillORM.QueryBuilder(null, "HOMEWORK_TYPE", DS, null)).Cast <HOMEWORK_TYPE>().FirstOrDefault()); } catch { return(null); } }
public static List <STUDENT_GROUP> GetGroups() { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("STUDENT_GROUP", WillORM.QueryBuilder(null, "STUDENT_GROUP", Ds, null)).Cast <STUDENT_GROUP>().ToList()); } catch (Exception e) { return(null); } }
public static List <HOMEWORK_TYPE> GetTypes() { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("HOMEWORK_TYPE", WillORM.QueryBuilder(null, "HOMEWORK_TYPE", Ds, null)).Cast <HOMEWORK_TYPE>().ToList()); } catch { return(null); } }
public static List <STUDENT_GROUP_STUDENT_LIST> GetGroupStudentMap(int group_id) { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "STUDENT_GROUP", group_id.ToString() }, { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("STUDENT_GROUP_STUDENT_LIST", WillORM.QueryBuilder(null, "STUDENT_GROUP_STUDENT_LIST", Ds, null)).Cast <STUDENT_GROUP_STUDENT_LIST>().ToList()); } catch (Exception e) { return(null); } }
public static List <STUDENT_GROUP> GetStudentGroupByTerm(int term_id) { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "TERM", term_id.ToString() }, { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("STUDENT_GROUP", WillORM.QueryBuilder(null, "STUDENT_GROUP", Ds, null)).Cast <STUDENT_GROUP>().ToList()); } catch (Exception e) { return(null); } }
public static CLASS_STUDENT_LIST getClassStudentListByStudent(int student_id) { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "STUDENT", student_id.ToString() }, { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("CLASS_STUDENT_LIST", WillORM.QueryBuilder(null, "CLASS_STUDENT_LIST", Ds, null)).Cast <CLASS_STUDENT_LIST>().FirstOrDefault()); } catch { return(null); } }
public static HOMEWORK GetWork(int id) { Dictionary <string, string> DS = new Dictionary <string, string>() { { "ID", id.ToString() }, { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("HOMEWORK", WillORM.QueryBuilder(null, "HOMEWORK", DS, null)).Cast <HOMEWORK>().FirstOrDefault()); } catch { return(null); } }
public static List <QE_CLASS> GetClassesByTerm(int term) { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "TERM", term.ToString() }, { "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); } }
public static QE_CLASS GetClass(int class_id) { Dictionary <string, string> Ds = new Dictionary <string, string>() { { "ID", class_id.ToString() }, { "ACTIVE", "1" } }; try { return(WillORM.GetDBSource("QE_CLASS", WillORM.QueryBuilder(null, "QE_CLASS", Ds, new string[] { "FORM", "NAME" })).Cast <QE_CLASS>().ToList().FirstOrDefault()); } catch { return(null); } }
public static List <HOMEWORK> GetFilteredWorks(int term_id, int group_id, int type_id) { List <MutliQuery> groupPram = new List <MutliQuery>(); if (term_id > 0) { groupPram.Add(new MutliQuery() { field1 = "TERM", field2 = term_id.ToString(), function = null }); } if (group_id > 0) { groupPram.Add(new MutliQuery() { field1 = "ID", field2 = group_id.ToString(), function = null }); groupPram.Add(new MutliQuery() { field1 = "active", field2 = "1", function = null }); } string typeParm = type_id > 0? WillORM.QueryBuilder("ID", "HOMEWORK_TYPE", new List <MutliQuery>() { new MutliQuery() { field1 = "ID", field2 = type_id.ToString(), function = null } }, null) : null; List <MutliQuery> workParm = new List <MutliQuery>(); if (groupPram.Any()) { workParm.Add(new MutliQuery() { field1 = "STUDENT_GROUP", field2 = "(" + WillORM.QueryBuilder("ID", "STUDENT_GROUP", groupPram, null) + ")", function = "in" }); } if (!string.IsNullOrEmpty(typeParm)) { workParm.Add(new MutliQuery() { field1 = "HOMEWORK_TYPE", field2 = "(" + typeParm + ")", function = "in" }); } workParm.Add(new MutliQuery() { field1 = "ACTIVE", field2 = "1", function = null }); try { return(WillORM.GetDBSource("HOMEWORK", WillORM.QueryBuilder(null, "HOMEWORK", workParm, null)).Cast <HOMEWORK>().ToList()); } catch { return(null); } }
public static TERM GetCurrentTerm() { List <MutliQuery> MQ = new List <MutliQuery>() { { new MutliQuery("ACTIVE", "=", "1") }, { new MutliQuery("TERM_START", "<=", "CURRENT_TIMESTAMP") }, { new MutliQuery("TERM_END", ">=", "CURRENT_TIMESTAMP") } }; try { return(WillORM.GetDBSource("TERM", WillORM.QueryBuilder(null, "TERM", MQ, null)).Cast <TERM>().First()); } catch (Exception e) { return(new TERM()); } }
public static List <STUDENT> GetStudents(int term_id, int class_id) { string first = WillORM.QueryBuilder(null, "QE_CLASS", new List <MutliQuery>() { new MutliQuery() { field1 = "ID", field2 = class_id.ToString(), function = null }, new MutliQuery() { field1 = "TERM", field2 = term_id.ToString(), function = null }, new MutliQuery() { field1 = "active", field2 = "1", function = null } }, null); string second = WillORM.QueryBuilder("STUDENT", "CLASS_STUDENT_LIST", new List <MutliQuery>() { new MutliQuery() { field1 = "QE_CLASS", field2 = "(" + first + ")", function = "in" }, new MutliQuery() { field1 = "active", field2 = "1", function = null } }, null); string third = WillORM.QueryBuilder(null, "STUDENT", new List <MutliQuery>() { new MutliQuery() { field1 = "ID", field2 = "(" + second + ")", function = "in" }, new MutliQuery() { field1 = "active", field2 = "1", function = null } }, null); try { return(WillORM.GetDBSource("STUDENT", third).Cast <STUDENT>().ToList()); } catch { return(new List <STUDENT>()); } }
public static List <STUDENT> GetActiveStudentsByClass(int qe_class) { string first = WillORM.QueryBuilder("STUDENT", "CLASS_STUDENT_LIST", new List <MutliQuery>() { new MutliQuery() { field1 = "QE_CLASS", field2 = qe_class.ToString(), function = null } }, null); string second = WillORM.QueryBuilder(null, "STUDENT", new List <MutliQuery>() { new MutliQuery() { field1 = "ID", field2 = "(" + first + ")", function = "in" }, new MutliQuery() { field1 = "active", field2 = "1", function = null } }, null); try { return(WillORM.GetDBSource("STUDENT", second).Cast <STUDENT>().ToList()); } catch { return(new List <STUDENT>()); } }
public static List <USER_GROUP_USER_LIST> GetGroupUsers() { try { return(WillORM.GetDBSource("USER_GROUP_USER_LIST").Cast <USER_GROUP_USER_LIST>().ToList()); } catch { return(null); } }
public static List <QE_USER> GetAllUser() { try { return(WillORM.GetDBSource("QE_USER").Cast <QE_USER>().ToList()); } catch { return(new List <QE_USER>()); } }
public static List <CLASS_STUDENT_LIST> getClassStudentMap(int class_id, int student_id, int term_id) { try { return(WillORM.GetDBSource("CLASS_STUDENT_LIST", "select * from CLASS_STUDENT_LIST where QE_CLASS in (select ID from QE_CLASS where ID = " + class_id + " and TERM = " + term_id + " and active=1) and STUDENT =" + student_id + " and active=1").Cast <CLASS_STUDENT_LIST>().ToList()); } catch { return(null); } }
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); } }
public static QE_CLASS GetClassesByStudent(int student_id) { try { return(WillORM.GetDBSource("QE_CLASS", "select * from QE_CLASS where ID in (select QE_CLASS from CLASS_STUDENT_LIST where STUDENT = " + student_id + " and active = 1) and active = 1").Cast <QE_CLASS>().FirstOrDefault()); } catch { return(null); } }
public static List <USER_GROUP> GetGroup() { try { return(WillORM.GetDBSource("USER_GROUP").Cast <USER_GROUP>().ToList()); } catch { return(null); } }
public static List <USER_GROUP_RIGHT> GetGroupRights() { try { return(WillORM.GetDBSource("USER_GROUP_RIGHT").Cast <USER_GROUP_RIGHT>().ToList()); } catch { return(null); } }