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);
}
public static List<Answer> GetListOfAnswers(long questionId)
{
var tableAdapter = new AnswerTableAdapter();
var dataTable = tableAdapter.GetListOfAnswers(questionId);
var answers = new List<Answer>();
foreach (var row in dataTable) {
var answer = new Answer
{
answerText = row.Text,
ID = row.AnswerId,
isCorrect = row.IsCorrect,
questionID = questionId
};
answers.Add(answer);
}
return answers;
/*using (var connection = new SqlConnection(ConnectionString))
{
var answers = new List<Answer>();
connection.Open();
var questionCmd = new SqlCommand("SELECT * FROM Answer WHERE QuestionID = @ID",
connection);
questionCmd.Parameters.Add(@"ID", SqlDbType.BigInt).Value = questionId;
questionCmd.Prepare();
var reader = questionCmd.ExecuteReader();
while (reader.Read())
{
var answer = new Answer
{
answerText = (string) reader["Text"],
ID = (long) reader["AnswerId"],
isCorrect = (Boolean) reader["IsCorrect"],
questionID = (long) reader["QuestionID"]
};
answers.Add(answer);
}
return answers;
}*/
}
public static void AddAnswerToDb(Answer answer)
{
var tableAdapter = new AnswerTableAdapter();
tableAdapter.Insert(answer.answerText, answer.isCorrect, answer.questionID);
}
public static Answer GetAnswer(long answerId)
{
var tableAdapter = new AnswerTableAdapter();
var dataTable = tableAdapter.SelectAnswer(answerId);
foreach (var row in dataTable)
{
var answer = new Answer
{
ID = answerId,
answerText = row.Text,
isCorrect = row.IsCorrect,
questionID = row.QuestionId
};
return answer;
}
return null;
}