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