private void btnSua_Click(object sender, EventArgs e)
{
if (lvChuDe.SelectedItems.Count > 0)
{
int ma_ChuDe = (int)lvChuDe.SelectedItems[0].Tag;
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
ChuDe chuDe = db.ChuDes.Single(cd => cd.maChuDe == ma_ChuDe);
txtNoiDungChuDe.Focus();
chuDe.tenChuDe = txtNoiDungChuDe.Text;
db.SubmitChanges();
LoadDuLieu();
txtNoiDungChuDe.ResetText();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
if (lvChuDe.SelectedItems.Count > 0)
{
int ma_ChuDe = (int)lvChuDe.SelectedItems[0].Tag;
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
ChuDe chuDe = db.ChuDes.Single(cd => cd.maChuDe == ma_ChuDe);
var ds = from cauHoi in db.CauHois where cauHoi.maChuDe == ma_ChuDe select cauHoi;
db.CauHois.DeleteAllOnSubmit(ds);
db.ChuDes.DeleteOnSubmit(chuDe);
db.SubmitChanges();
LoadDuLieu();
}
}
/// <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];
}
}
private void btnThem_Click(object sender, EventArgs e)
{
_0864186_TracNghiemDataContext db = new _0864186_TracNghiemDataContext();
ChuDe chuDe = new ChuDe();
if (txtNoiDungChuDe.Text == "")
{
DialogResult r = MessageBox.Show("Vui lòng nhập nội dung chủ đề", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
//int temp = TaoMaChuDe();
//chuDe.maChuDe = temp;
chuDe.tenChuDe = txtNoiDungChuDe.Text;
db.ChuDes.InsertOnSubmit(chuDe);
db.SubmitChanges();
LoadDuLieu();
txtNoiDungChuDe.ResetText();
}
}
partial void DeleteChuDe(ChuDe instance);
partial void UpdateChuDe(ChuDe instance);
partial void InsertChuDe(ChuDe instance);