// Method for test purposes public int CountStudentsInGroup(string title) { TestDBAccess dBAccess = new TestDBAccess(); DataTable dataTable = dBAccess.SQLGetTableData("SELECT COUNT(*) FROM STUDENTS JOIN GROUPS ON STUDENTS.GROUP_ID = GROUPS.ID WHERE GROUPS.TITLE = \"" + title + "\";"); if (dataTable.Rows.Count > 0) { return(Convert.ToInt32(dataTable.Rows[0].ItemArray[0])); } return(0); }
// Method for test purposes public int GetMaxIDOfStudent() { TestDBAccess dBAccess = new TestDBAccess(); DataTable dataTable = dBAccess.SQLGetTableData("SELECT MAX(ID) FROM STUDENTS;"); if (dataTable.Rows.Count > 0) { return(Convert.ToInt32(dataTable.Rows[0].ItemArray[0])); } return(0); }
// Method for test purposes public int GetMaxAccountID(string role) { TestDBAccess dBAccess = new TestDBAccess(); DataTable dataTable = dBAccess.SQLGetTableData("SELECT MAX(ID) FROM ACCOUNTS WHERE ROLE = \"" + role + "\";"); if (dataTable.Rows.Count > 0) { return(Convert.ToInt32(dataTable.Rows[0].ItemArray[0])); } return(0); }
// Method for test purposes public Teacher GetTeacherWithMaxID() { TestDBAccess dbaccess = new TestDBAccess(); DataTable dataTable = dbaccess.SQLGetTableData("SELECT * FROM TEACHERS JOIN ACCOUNTS ON TEACHERS.ID = ACCOUNTS.USER_ID WHERE ACCOUNTS.ROLE = \"teacher\" AND TEACHERS.ID = (SELECT MAX(ID) FROM TEACHERS);"); if (dataTable.Rows.Count > 0) { Teacher teacher = new Teacher(Convert.ToString(dataTable.Rows[0].ItemArray[1]), Convert.ToString(dataTable.Rows[0].ItemArray[2]), Convert.ToString(dataTable.Rows[0].ItemArray[3]), Convert.ToString(dataTable.Rows[0].ItemArray[5])); return(teacher); } return(null); }
// Method for test purposes public Student GetStudentWithMaxID() { TestDBAccess dBAccess = new TestDBAccess(); DataTable dataTable = dBAccess.SQLGetTableData("SELECT * FROM STUDENTS JOIN ACCOUNTS ON ACCOUNTS.USER_ID = STUDENTS.ID " + "JOIN GROUPS ON STUDENTS.GROUP_ID = GROUPS.ID WHERE ROLE = \"student\" AND STUDENTS.ID = (SELECT MAX(ID) FROM STUDENTS);"); if (dataTable.Rows.Count > 0) { Student student = new Student(Convert.ToString(dataTable.Rows[0].ItemArray[1]), Convert.ToString(dataTable.Rows[0].ItemArray[2]), Convert.ToString(dataTable.Rows[0].ItemArray[3]), Convert.ToString(dataTable.Rows[0].ItemArray[4]), Convert.ToString(dataTable.Rows[0].ItemArray[12]), Convert.ToString(dataTable.Rows[0].ItemArray[7])); return(student); } return(null); }