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