public List<BirdA> GetAnswers(BirdQ question) { var birdAnswers = new List<BirdA>(); using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["BirdSteps"].ConnectionString)) { var cmd = new SqlCommand("GetAnswers", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@QuestionID", question.QuestionID); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var temp = new BirdA(); temp.AnswerID = dr.GetInt32(0); temp.Answer = dr.GetString(1); temp.QuestionID = dr.GetInt32(2); temp.IsCorrect = dr.GetInt32(3); birdAnswers.Add(temp); } } } return birdAnswers; }
public List<BirdQ> GetQuestions() { var birdQuestions = new List<BirdQ>(); using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["BirdSteps"].ConnectionString)) { var cmd = new SqlCommand("GetQuestions", cn); cmd.CommandType = CommandType.StoredProcedure; cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { var temp = new BirdQ(); temp.QuestionID = dr.GetInt32(0); temp.Question = dr.GetString(1); birdQuestions.Add(temp); } } } return birdQuestions; }