/// <summary>
/// filter incomplete tests by subject
/// </summary>
/// <param name="candidateID">to get incomplete tests and to set take orders for each test</param>
/// <param name="subject">subject for filtering</param>
/// <returns>
/// arraylist of tests
/// </returns>
public static ArrayList getAllIncompleteTestsBySubject(int candidateID, int subject)
{
CTVIATBankDataSet.IncompleteTestsCandidatesDataTable table =
new IncompleteTestsCandidatesTableAdapter().GetAllIncompleteTests(candidateID);
ArrayList tests = new ArrayList();
foreach (DataRow row in table.Rows)
{
int testID = Convert.ToInt32(row["testID"]);
Test test = getIncompleteTestById(candidateID, testID);
if (test.Subject == subject)
{
test.StartQuestionNo = Convert.ToInt32(row["questionID"]);
test.TakeOrder = Convert.ToInt32(row["takeOrder"]);
DataRow r = testsTimeAdapter.GetTime(candidateID, testID, test.TakeOrder).Rows[0];
test.Time = Convert.ToInt32(r["time"]);
test.Date = Convert.ToDateTime(r["date"]);
getAnswersOfTest(candidateID, test);
tests.Add(test);
}
}
return(tests);
}
/// <summary>
/// filter incomplete tests by subject
/// </summary>
/// <param name="candidateID">to get incomplete tests and to set take orders for each test</param>
/// <param name="subject">subject for filtering</param>
/// <returns>
/// arraylist of tests
/// </returns>
public static ArrayList getAllIncompleteTestsBySubject(int candidateID, int subject)
{
CTVIATBankDataSet.IncompleteTestsCandidatesDataTable table =
new IncompleteTestsCandidatesTableAdapter().GetAllIncompleteTests(candidateID);
ArrayList tests = new ArrayList();
foreach (DataRow row in table.Rows)
{
int testID = Convert.ToInt32(row["testID"]);
Test test = getIncompleteTestById(candidateID, testID);
if (test.Subject == subject)
{
test.StartQuestionNo = Convert.ToInt32(row["questionID"]);
test.TakeOrder = Convert.ToInt32(row["takeOrder"]);
DataRow r = testsTimeAdapter.GetTime(candidateID, testID, test.TakeOrder).Rows[0];
test.Time = Convert.ToInt32(r["time"]);
test.Date = Convert.ToDateTime(r["date"]);
getAnswersOfTest(candidateID, test);
tests.Add(test);
}
}
return tests;
}
