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