/// <summary>
/// Xoa cau hoi trong listview & database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnXoa_Click(object sender, EventArgs e)
{
if (txtNoiDungCauHoi.Text == "" ||
txtDapAnA.Text == "" ||
txtDapAnB.Text == "" ||
txtDapAnC.Text == "" ||
txtDapAnD.Text == "")
{
DialogResult r = MessageBox.Show("Vui lòng nhập đầy đủ nội dung câu hỏi và đáp án! ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (rbA.Checked == false && rbB.Checked == false && rbC.Checked == false && rbD.Checked == false)
{
DialogResult r = MessageBox.Show("Bạn chưa chọn đáp án đúng cho câu hỏi. ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (cbbChuDe.SelectedIndex < 0)
{
DialogResult r = MessageBox.Show("Vui lòng chọn chủ đề cho câu hỏi.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (lvHienThiCauHoi.SelectedItems.Count > 0)
{
int ma_CauHoi = (int)lvHienThiCauHoi.SelectedItems[0].Tag;
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
CauHoi cauHoi = db.CauHois.Single(ch => ch.maCauHoi == ma_CauHoi);
db.CauHois.DeleteOnSubmit(cauHoi);
db.SubmitChanges();
LoadDuLieu_SoanCauHoi();
XoaTruongDuLieu();
}
}
}
private void HienDapAnDung()
{
int ma_CauHoi = (int)lvHienThiCauHoi.SelectedItems[0].Tag;
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
CauHoi cauHoi = db.CauHois.Single(ch => ch.maCauHoi == ma_CauHoi);
int dapAn = (int)cauHoi.dapAnDung;
switch (dapAn)
{
case 1:
rbA.Checked = true;
break;
case 2:
rbB.Checked = true;
break;
case 3:
rbC.Checked = true;
break;
case 4:
rbD.Checked = true;
break;
}
}
/// <summary>
/// Them cau hoi
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnThem_Click(object sender, EventArgs e)
{
if (txtNoiDungCauHoi.Text == "" ||
txtDapAnA.Text == "" ||
txtDapAnB.Text == "" ||
txtDapAnC.Text == "" ||
txtDapAnD.Text == "")
{
DialogResult r = MessageBox.Show("Vui lòng nhập đầy đủ nội dung câu hỏi và đáp án! ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (rbA.Checked == false && rbB.Checked == false && rbC.Checked == false && rbD.Checked == false)
{
DialogResult r = MessageBox.Show("Bạn chưa chọn đáp án đúng cho câu hỏi. ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (cbbChuDe.SelectedIndex < 0)
{
DialogResult r = MessageBox.Show("Vui lòng chọn chủ đề cho câu hỏi.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
CauHoi cauHoi = new CauHoi();
int ma_ChuDe = cbbChuDe.SelectedIndex;
//cauHoi.maChuDe = ma_ChuDe + 1;
cauHoi.maChuDe = listChuDe[ma_ChuDe];
cauHoi.noiDung = txtNoiDungCauHoi.Text;
cauHoi.dapAnA = txtDapAnA.Text;
cauHoi.dapAnB = txtDapAnB.Text;
cauHoi.dapAnC = txtDapAnC.Text;
cauHoi.dapAnD = txtDapAnD.Text;
if (rbA.Checked == true)
{
cauHoi.dapAnDung = 1;
}
else if (rbB.Checked == true)
{
cauHoi.dapAnDung = 2;
}
else if (rbC.Checked == true)
{
cauHoi.dapAnDung = 3;
}
else
{
cauHoi.dapAnDung = 4;
}
db.CauHois.InsertOnSubmit(cauHoi);
db.SubmitChanges();
LoadDuLieu_SoanCauHoi();
XoaTruongDuLieu();
}
}
private void btnTaodeThi_Click(object sender, EventArgs e)
{
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
SaveFileDialog d = new SaveFileDialog();
d.Filter = "Luu file xml|*.xml";
if (d.ShowDialog() == DialogResult.OK)
{
XmlDocument doc = new XmlDocument();
XmlElement root = doc.CreateElement("DeThi");
doc.AppendChild(root);
foreach (ListViewItem lvi in lvChonCauHoi.Items)
{
if (lvi.Checked == true)
{
int ma_CauHoi = (int)lvi.Tag;
CauHoi cauhoi = db.CauHois.Single(c => c.maCauHoi == ma_CauHoi);
XmlElement noodCau = doc.CreateElement("CauHoi");
root.AppendChild(noodCau);
XmlElement nodeNoiDung = doc.CreateElement("NoiDung");
noodCau.AppendChild(nodeNoiDung);
nodeNoiDung.InnerText = cauhoi.noiDung;
XmlElement nodeDapAnA = doc.CreateElement("DapAnA");
noodCau.AppendChild(nodeDapAnA);
nodeDapAnA.InnerText = cauhoi.dapAnA;
XmlElement nodeDapAnB = doc.CreateElement("DapAnB");
noodCau.AppendChild(nodeDapAnB);
nodeDapAnB.InnerText = cauhoi.dapAnB;
XmlElement nodeDapAnC = doc.CreateElement("DapAnC");
noodCau.AppendChild(nodeDapAnC);
nodeDapAnC.InnerText = cauhoi.dapAnC;
XmlElement nodeDapAnD = doc.CreateElement("DapAnD");
noodCau.AppendChild(nodeDapAnD);
nodeDapAnD.InnerText = cauhoi.dapAnD;
XmlElement nodeDapAnDung = doc.CreateElement("DapAnDung");
noodCau.AppendChild(nodeDapAnDung);
nodeDapAnDung.InnerText = cauhoi.dapAnDung.ToString();
}
}
doc.Save(d.FileName);
}
}
/// <summary>
/// Hien thi du lieu khi chon trong listview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lvHienThiCauHoi_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)
{
if (lvHienThiCauHoi.SelectedItems.Count > 0)
{
btnThem.Enabled = false;
int ma_CauHoi = (int)lvHienThiCauHoi.SelectedItems[0].Tag;
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
CauHoi cauHoi = db.CauHois.Single(ch => ch.maCauHoi == ma_CauHoi);
txtNoiDungCauHoi.Text = cauHoi.noiDung;
txtDapAnA.Text = cauHoi.dapAnA;
txtDapAnB.Text = cauHoi.dapAnB;
txtDapAnC.Text = cauHoi.dapAnC;
txtDapAnD.Text = cauHoi.dapAnD;
HienDapAnDung();
int temp = (int)cauHoi.maChuDe;
ChuDe chuDe = db.ChuDes.Single(cd => cd.maChuDe == cauHoi.maChuDe);
cbbChuDe.Text = chuDe.tenChuDe;
//cbbChuDe.Items[temp - 1];
}
}
/// <summary>
/// Cap nhat cau hoi
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCapNhat_Click(object sender, EventArgs e)
{
if (lvHienThiCauHoi.SelectedItems.Count > 0)
{
int ma_CauHoi = (int)lvHienThiCauHoi.SelectedItems[0].Tag;
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
CauHoi cauHoi = db.CauHois.Single(ch => ch.maCauHoi == ma_CauHoi);
txtNoiDungCauHoi.Focus();
int ma_ChuDe = cbbChuDe.SelectedIndex;
//cauHoi.maChuDe = ma_ChuDe + 1;
cauHoi.maChuDe = listChuDe[ma_ChuDe];
cauHoi.noiDung = txtNoiDungCauHoi.Text;
cauHoi.dapAnA = txtDapAnA.Text;
cauHoi.dapAnB = txtDapAnB.Text;
cauHoi.dapAnC = txtDapAnC.Text;
cauHoi.dapAnD = txtDapAnD.Text;
if (rbA.Checked == true)
{
cauHoi.dapAnDung = 1;
}
else if (rbB.Checked == true)
{
cauHoi.dapAnDung = 2;
}
else if (rbC.Checked == true)
{
cauHoi.dapAnDung = 3;
}
else
{
cauHoi.dapAnDung = 4;
}
db.SubmitChanges();
LoadDuLieu_SoanCauHoi();
XoaTruongDuLieu();
}
}
private void detach_CauHois(CauHoi entity)
{
this.SendPropertyChanging();
entity.ChuDe = null;
}
private void attach_CauHois(CauHoi entity)
{
this.SendPropertyChanging();
entity.ChuDe = this;
}
partial void DeleteCauHoi(CauHoi instance);
partial void UpdateCauHoi(CauHoi instance);
partial void InsertCauHoi(CauHoi instance);
