|
public GetQuestionByCatalogue ( |
||
| Catalogue | ||
| Résultat | List |
|
//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;
}
