public static List <Quiz> GetQuizByUserID(int subID)
{
QuizTableAdapter quizData = new QuizTableAdapter();
QuestionTableAdapter questionData = new QuestionTableAdapter();
AnswerTableAdapter answerData = new AnswerTableAdapter();
List <Quiz> quizzes = new List <Quiz>();
List <Question> questions = new List <Question>();
List <Answer> answers = new List <Answer>();
foreach (MultipleChoiceDataSet.QuizRow q in quizData.GetData())
{
if (q.By_user == subID)
{
quizzes.Add(new Quiz(q.Title, q.Subject_id, q.By_user));
foreach (MultipleChoiceDataSet.QuestionRow question in questionData.GetDataByQuizID(q.Quiz_id))
{
if (question.Quiz_id == q.Quiz_id)
{
Question tempq = new Question(question.Question, question.By_user, question.Subject_id, DateTime.Now);
//questions.Add(new Question(question.Question, question.By_user, question.Subject_id, DateTime.Now));
foreach (MultipleChoiceDataSet.AnswerRow an in answerData.GetDataBy(question.Question_id))
{
//answers.Add(new Answer(an.Answer,an.Correct));
tempq.AddAnswer(new Answer(an.Answer, an.Correct));
}
quizzes[quizzes.Count - 1].AddQuestion(tempq, question.Subject_id);
}
}
}
}
return(quizzes);
}
