protected void SubmitNewQuiz(object sender, EventArgs e) { var quiz = new Quiz { Quizname = QuizTextBox.Text, MadeById = GameMaster.GetUserId(Membership.GetUser().UserName), }; GameMaster.AddNewQuizToDb(quiz); Response.Redirect("EditQuizForm.aspx"); }
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 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); }
public static void AddNewQuizToDb(Quiz quiz) { DataAccessMachine.AddNewQuizToDb(quiz); }