private void btn_SaveImport_Click(object sender, EventArgs e)
{
try
{
if (txt_FilePath.Text == "")
{
MessageBox.Show("Vui lòng chọn đường dẫn đến tập tin trước khi lưu!", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
int count = 0;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells["Check"].Value != null && (bool)row.Cells["Check"].Value== true)
{
count++;
}
}
if (count>0)
{
int CheckQuestion = 0;
Question question = new Question();
Answer answer = new Answer();
QuestionBL questionBL = new QuestionBL();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Cells["Check"].Value != null && (bool)row.Cells["Check"].Value == true)
{
if (row.Cells["TypeQuestion"].Value.ToString().Trim() == "shortanswer")
{
string[] AnswerContent = row.Cells["AnswerContent"].Value.ToString().Trim().Split(new string[] { "</answer>" }, StringSplitOptions.None);
string[] AnswerItem = AnswerContent[0].Split(new string[] { "---" }, StringSplitOptions.None);
//question.QuestionTitle =
question.QuestionTitle = row.Cells["QuestionTitle"].Value.ToString().Trim();
question.NameQuestion = row.Cells["NameQuestion"].Value.ToString().Trim();
question.TypeQuestion = row.Cells["TypeQuestion"].Value.ToString().Trim();
question.IDCatalogue = IDCat;
question.Date = DateTime.Now;
questionBL.AddQuestion(question);
//answer.IsCorrect = true;
answer.Check = 1;
answer.ContentAnswer = AnswerItem[1].ToString().Trim();
answer.IDQuestion = questionBL.MaxIDQuestion();
answer.IDCatalogue = IDCat;
questionBL.AddAnswer(answer);
CheckQuestion++;
}
else
{
string[] AnswerContent = row.Cells["AnswerContent"].Value.ToString().Trim().Split(new string[] { "</answer>" }, StringSplitOptions.None);
//ADD QUESTION MULTIPLE CHOICE
question.QuestionTitle = row.Cells["QuestionTitle"].Value.ToString().Trim();
question.NameQuestion = row.Cells["NameQuestion"].Value.ToString().Trim();
question.TypeQuestion = "";
question.IDCatalogue = IDCat;
question.Date = DateTime.Now;
questionBL.AddQuestion(question);
CheckQuestion++;
int countMultipleChoice = 0;
for (int i = 0; i < AnswerContent.Length - 1; i++)
{
string[] AnswerItem = AnswerContent[i].Split(new string[] { "---" }, StringSplitOptions.None);
if (Convert.ToInt32(AnswerItem[0].ToString().Trim()) > 0)
{
//answer.IsCorrect = true;
answer.Check = 1;
answer.ContentAnswer = AnswerItem[1].ToString().Trim();
answer.IDQuestion = questionBL.MaxIDQuestion();
answer.IDCatalogue = IDCat;
questionBL.AddAnswer(answer);
countMultipleChoice++;
}
else
{
//answer.IsCorrect = false;
answer.Check = 0;
answer.ContentAnswer = AnswerItem[1].ToString().Trim();
answer.IDQuestion = questionBL.MaxIDQuestion();
answer.IDCatalogue = IDCat;
questionBL.AddAnswer(answer);
}//end if
}//end for
//UPDATE QUESTION TYPE
if (countMultipleChoice == 1)
{
question.TypeQuestion = "onechoice";
question.IDQuestion = questionBL.MaxIDQuestion();
questionBL.EditQuestionTypebyID(question);
}
else
{
question.TypeQuestion = "multichoice";
question.IDQuestion = questionBL.MaxIDQuestion();
questionBL.EditQuestionTypebyID(question);
}
}
}
}//end foreach
//CLOSE FORM
if (CheckQuestion > 0)
{
MessageBox.Show("Nhập " + CheckQuestion + " câu hỏi từ file thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
CheckQuestion = 0;
Form FindForm = this.FindForm();
FindForm.Close();
}
}
else
{
MessageBox.Show("Vui lòng chọn câu hỏi trước khi lưu!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception)
{
MessageBox.Show("Hệ thống lưu không thành công vì do định dạng file không đúng!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}