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 IEnumerable<Quiz> GetAllQuizes()
{
var tableAdapter = new QuizTableAdapter();
var dataTable = tableAdapter.GetData();
foreach (var row in dataTable)
{
var quiz = new Quiz
{
Id = row.QuizId,
MadeById = row.UserId,
Quizname = row.Name
};
yield return quiz;
}
}
public static long GetUserId(long quizId)
{
var tableAdapter = new QuizTableAdapter();
var dataTable = tableAdapter.GetUserId(quizId);
foreach (var row in dataTable)
{
return row.UserId;
}
return -1;
/*using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var questionCmd = new SqlCommand("SELECT UserId FROM [Quiz] WHERE QuizId = @quizid",
connection);
questionCmd.Parameters.Add(@"quizid", SqlDbType.BigInt).Value = quizId;
questionCmd.Prepare();
var reader = questionCmd.ExecuteReader();
while (reader.Read())
{
return (long) reader["UserId"];
}
return -1;
}*/
}
public static string GetQuizName(long quizId)
{
var tableAdapter = new QuizTableAdapter();
var dataTable = tableAdapter.GetQuizName(quizId);
foreach (var row in dataTable)
{
return row.Name;
}
return "";
/*using (var connection = new SqlConnection(ConnectionString))
{
connection.Open();
var quizCmd = new SqlCommand("SELECT Name FROM Quiz WHERE QuizId = @ID", connection);
quizCmd.Parameters.Add(@"ID", SqlDbType.BigInt).Value = quizId;
quizCmd.Prepare();
var reader = quizCmd.ExecuteReader();
while (reader.Read())
{
return (string) reader["Name"];
}
return "";
}*/
}
public static List<Quiz> GetQuizes(long userId)
{
var tableAdapter = new QuizTableAdapter();
var dataTable = tableAdapter.GetQuizes(userId);
var quizes = new List<Quiz>();
foreach (var row in dataTable)
{
var quiz = new Quiz
{
Id = row.QuizId,
MadeById = userId,
Quizname = row.Name
};
quizes.Add(quiz);
}
return quizes;
/*using (var connection = new SqlConnection(ConnectionString))
{
var quizes = new List<Quiz>();
connection.Open();
var questionCmd = new SqlCommand("SELECT * FROM Quiz WHERE UserId = @ID",
connection);
questionCmd.Parameters.Add(@"ID", SqlDbType.BigInt).Value = userId;
questionCmd.Prepare();
var reader = questionCmd.ExecuteReader();
while (reader.Read())
{
var quiz = new Quiz
{
Id = (long) reader["QuizId"],
MadeById = (long) reader["UserId"],
Quizname = (string) reader["Name"]
};
quizes.Add(quiz);
}
return quizes;
}*/
}
public static void AddNewQuizToDb(Quiz quiz)
{
var tableAdapter = new QuizTableAdapter();
tableAdapter.Insert(quiz.Quizname, quiz.MadeById);
}
