//LOAD QUESTION public void LoadQuestion() { QuestionBL QuestionBL = new QuestionBL(); Catalogue Cat = new Catalogue(); Cat.IDCatalogue = IDCat; List<DO.Question> QuestionList; QuestionList = QuestionBL.GetQuestionByCatalogue(Cat); if (QuestionList != null) dgv_Question1.DataSource = QuestionList; dgv_Question1.Columns["IDCatalogue"].Visible = false; dgv_Question1.Columns["IDQuestion"].Visible = false; dgv_Question1.Columns["AnswerContent"].Visible = false; dgv_Question1.Columns["Catalogue"].Visible = false; dgv_Question1.Columns["Date"].Visible = false; dgv_Question1.Columns["Sequence"].HeaderText = "STT"; dgv_Question1.Columns["QuestionTitle"].HeaderText = "Tên câu Hỏi"; dgv_Question1.Columns["NameQuestion"].HeaderText = "Nội dung câu Hỏi"; dgv_Question1.Columns["TypeQuestion"].HeaderText = "Loại Câu Hỏi"; dgv_Question1.Columns["NameCatalogue"].HeaderText = "Tên Chủ Đề"; dgv_Question1.Columns["Sequence"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question1.Columns["NameCatalogue"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question1.Columns["TypeQuestion"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question1.Columns["QuestionTitle"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; }
//SELECT ITEM IN COMMOBOX private void cmb_Catalogue_SelectedIndexChanged(object sender, EventArgs e) { //dgv_Question.Columns.Clear(); Catalogue catalogue = new Catalogue(); CatalogueBL CatBL = new CatalogueBL(); List<DO.Catalogue> CatList; CatList = CatBL.GetCatalogue(); if (CatList != null) for (int i = 0; i < CatList.Count; i++) { if (cmb_Catalogue.SelectedItem.ToString() == CatList.ElementAt(i).NameCatalogue) { catalogue.IDCatalogue = CatList.ElementAt(i).IDCatalogue; } } QuestionBL QuestionBL = new QuestionBL(); List<DO.Question> QuestionList; QuestionList = QuestionBL.GetQuestionByCatalogue(catalogue); if (QuestionList != null) { dgv_Question.DataSource = QuestionList; dgv_Question.Columns["IDCatalogue"].Visible = false; dgv_Question.Columns["IDQuestion"].Visible = false; dgv_Question.Columns["AnswerContent"].Visible = false; dgv_Question.Columns["Catalogue"].Visible = false; dgv_Question.Columns["NameCatalogue"].Visible = false; dgv_Question.Columns["Date"].Visible = false; } chk_CheckAll.Checked = false; }
//Select question follow catalogue private void cmb_Catalogue_SelectedIndexChanged(object sender, EventArgs e) { dgv_Question.Columns.Clear(); Catalogue catalogue = new Catalogue(); CatalogueBL CatBL = new CatalogueBL(); List<DO.Catalogue> CatList; CatList = CatBL.GetCatalogue(); if (CatList != null) for (int i = 0; i < CatList.Count; i++) { if (cmb_Catalogue.SelectedItem.ToString() == CatList.ElementAt(i).NameCatalogue) { catalogue.IDCatalogue = CatList.ElementAt(i).IDCatalogue; } } QuestionBL QuestionBL = new QuestionBL(); List<DO.Question> QuestionList; QuestionList = QuestionBL.GetQuestionByCatalogue(catalogue); if (QuestionList != null) { dgv_Question.DataSource = QuestionList; } dgv_Question.Columns["IDCatalogue"].Visible = false; dgv_Question.Columns["IDQuestion"].Visible = false; dgv_Question.Columns["AnswerContent"].Visible = false; dgv_Question.Columns["Date"].Visible = false; dgv_Question.Columns["NameCatalogue"].Visible = false; dgv_Question.Columns["Catalogue"].Visible = false; dgv_Question.Columns["Sequence"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question.Columns["TypeQuestion"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question.Columns["NameCatalogue"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question.Columns["QuestionTitle"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question.Columns["Sequence"].HeaderText = "STT"; dgv_Question.Columns["TypeQuestion"].HeaderText = "Loại Câu Hỏi"; dgv_Question.Columns["NameQuestion"].HeaderText = "Nội Dung Câu Hỏi"; dgv_Question.Columns["QuestionTitle"].HeaderText = "Tên Câu Hỏi"; dgv_Question.Columns["Sequence"].ReadOnly = true; dgv_Question.Columns["TypeQuestion"].ReadOnly = true; dgv_Question.Columns["NameQuestion"].ReadOnly = true; dgv_Question.Columns["QuestionTitle"].ReadOnly = true; DataGridViewCheckBoxColumn CheckColumn = new DataGridViewCheckBoxColumn(); CheckColumn.Name = "Check"; dgv_Question.Columns.Add(CheckColumn); dgv_Question.Columns["Check"].HeaderText = "Chọn"; dgv_Question.Columns["Check"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; chk_CheckAll.Checked = false; }
private void txt_SearchCatalogue_TextChanged(object sender, EventArgs e) { //QuestionBL questionBL = new QuestionBL(); //List<DO.Question> ListQuestion = questionBL.GetQuestion(); QuestionBL QuestionBL = new QuestionBL(); Catalogue Cat = new Catalogue(); Cat.IDCatalogue = IDCat; List<DO.Question> QuestionList; QuestionList = QuestionBL.GetQuestionByCatalogue(Cat); //if (QuestionList != null) //dgv_Question1.DataSource = QuestionList; //loadQuestion(); ListtoDataTableConverter converter = new ListtoDataTableConverter(); DataTable dt = converter.ToDataTable(QuestionList); dgv_Question1.DataSource = dt; dt.DefaultView.RowFilter = string.Format("NameQuestion LIKE '%{0}%' or TypeQuestion LIKE '%{0}%' or NameCatalogue LIKE '%{0}%' or QuestionTitle LIKE '%{0}%'or Sequence LIKE '%{0}%'", txt_SearchCatalogue.Text); dgv_Question1.Columns["IDCatalogue"].Visible = false; dgv_Question1.Columns["IDQuestion"].Visible = false; dgv_Question1.Columns["IDCatalogue"].Visible = false; dgv_Question1.Columns["AnswerContent"].Visible = false; dgv_Question1.Columns["AnswerList"].Visible = false; dgv_Question1.Columns["Date"].Visible = false; dgv_Question1.Columns["Sequence"].HeaderText = "STT"; dgv_Question1.Columns["NameQuestion"].HeaderText = "Tên Câu Hỏi"; dgv_Question1.Columns["NameCatalogue"].HeaderText = "Tên chủ Đề"; dgv_Question1.Columns["TypeQuestion"].HeaderText = "Loại Câu hỏi"; dgv_Question1.Columns["Sequence"].ReadOnly = true; dgv_Question1.Columns["NameQuestion"].ReadOnly = false; dgv_Question1.Columns["NameCatalogue"].ReadOnly = true; dgv_Question1.Columns["TypeQuestion"].ReadOnly = true; dgv_Question1.Columns["Sequence"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question1.Columns["NameCatalogue"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; dgv_Question1.Columns["TypeQuestion"].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells; }