CapDemo.BL.QuestionBL.GetQuestion C# (CSharp) Méthode

        public List<Question> GetQuestion()
        {
            List<Question> QuestionList = new List<Question>();
            string query = "SELECT q.Question_ID,q.Question_Title, q.Question_Name, q.Question_Type, q.Catalogue_ID, c.Catalogue_Name, q.Question_Title, q.[Date_Create]"
                         + " FROM Question q"
                         + " INNER JOIN Catalogue c ON c.Catalogue_ID = q.Catalogue_ID";

            DataTable dt = DA.SelectDatabase(query);
            int i = 1;
            if (dt != null)
            {
                foreach (DataRow item in dt.Rows)
                {
                    Question Question = new Question();
                    Question.IDQuestion = Convert.ToInt32(item["Question_ID"]);
                    Question.QuestionTitle = item["Question_Title"].ToString();
                    Question.NameQuestion = item["Question_Name"].ToString();
                    Question.TypeQuestion = item["Question_Type"].ToString();
                    Question.IDCatalogue = Convert.ToInt32(item["Catalogue_ID"]);
                    //Question.NameCatalogue = item["Catalogue_Name"].ToString();
                    Question.Date = (DateTime)item["Date_Create"];
                    Question.Sequence = i;
                    Question.Catalogue.NameCatalogue = item["Catalogue_Name"].ToString();
                    //Question.Catalogue.IDCatalogue = Convert.ToInt32(item["Catalogue_ID"]);
                    QuestionList.Add(Question);
                    i++;
                }
            }
            return QuestionList;
        }

        //LOAD FORM
        private void ViewQuestionMultiple_Load(object sender, EventArgs e)
        {
            //GET QUESTION BY ID Question
            QuestionBL QuestionBL = new QuestionBL();
            List<DO.Question> QuestionList;
            Question question = new Question();
            QuestionList = QuestionBL.GetQuestion();
            if (QuestionList != null)
            {
                for (int i = 0; i < QuestionList.Count; i++)
                {
                    if (QuestionList.ElementAt(i).IDQuestion == IDQuestion)
                    {
                        txt_Catalogue.Text = QuestionList.ElementAt(i).NameCatalogue;
                        txt_ContentQuestion.Text = QuestionList.ElementAt(i).NameQuestion;
                        txt_QuestionType.Text = QuestionList.ElementAt(i).TypeQuestion;
                        txt_Date.Text = QuestionList.ElementAt(i).Date.ToString("d");
                    }

                }
                //GET ANSWER BY ID QUESTION
                List<DO.Answer> AnswerList;
                Answer answer = new Answer();
                question.IDQuestion = IDQuestion;
                AnswerList = QuestionBL.GetAnswerByQuestionID(question);
                if (AnswerList != null)
                {
                    for (int j = 0; j < AnswerList.Count; j++)
                    {
                        Answer_MultiSelect MultiChoiceAnswer = new Answer_MultiSelect();
                        i++;
                        MultiChoiceAnswer.Tag = i;
                        MultiChoiceAnswer.ID_Answer = i;
                        MultiChoiceAnswer.onDelete += OneChoiceAnswer_onDelete;
                        MultiChoiceAnswer.chk_Check.Text = Convert.ToChar(a + j).ToString();

                        MultiChoiceAnswer.txt_AnswerContent.Text = AnswerList.ElementAt(j).ContentAnswer;
                        MultiChoiceAnswer.chk_Check.Checked = AnswerList.ElementAt(j).IsCorrect;

                        MultiChoiceAnswer.txt_AnswerContent.ReadOnly = true;
                        MultiChoiceAnswer.chk_Check.Enabled = false;
                        MultiChoiceAnswer.btn_DelAnswer.Visible = false;
                        flp_Answer.Controls.Add(MultiChoiceAnswer);
                    }
                }
            }
        }