private void RemoveKiThi()
{
try
{
if (System.Windows.Forms.MessageBox.Show("Xác nhận xoá? ", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
KI_THI k = data.KI_THIs.Single(item => item.MaKiThi == txt_id_kt.Text);
data.KI_THIs.DeleteOnSubmit(k);
//var id = data.DETHIs.Where(u => u.MaDeThi == int.Parse(cb_dethi.Text)).SingleOrDefault<DETHI>();
//if (id != null)
//{
// DETHI d = data.DETHIs.Single(item => item.MaKiThi == txt_id_kt.Text);
// data.DETHIs.DeleteOnSubmit(d);
//}
data.SubmitChanges();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
GetData_Kithi();
}
}
private void UpdateKithi()
{
KI_THI k = (data.KI_THIs.Where(t => t.MaKiThi == txt_id_kt.Text).SingleOrDefault <KI_THI>());
try
{
k.TenKiThi = txt_kithi.Text;
data.SubmitChanges();
tb_thongbao.Text = "Chỉnh sửa thành công!";
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message, "Lỗi");
}
finally
{
GetData_Kithi();
}
}
private void AddKiThi()
{
var id = data.KI_THIs.Where(u => u.MaKiThi == txt_id_kt.Text.Trim()).SingleOrDefault <KI_THI>();
if (id != null)
{
tb_thongbao.Text = "Mã Kì thi đã tồn tại.";
return;
}
else
{
KI_THI k = new KI_THI();
k.MaKiThi = txt_id_kt.Text;
k.TenKiThi = txt_kithi.Text;
data.KI_THIs.InsertOnSubmit(k);
data.SubmitChanges();
tb_thongbao.Text = "Thêm kì thi thành công";
}
}
private void kithi_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
int rowindex = kithi.SelectedIndex;
if (rowindex == -1)
{
Clear();
}
else
{
KI_THI a = (KI_THI)kithi.SelectedItem;
txt_id_kt.Text = a.MaKiThi;
txt_kithi.Text = a.TenKiThi;
GetData_DeThi();
}
}
catch (Exception ex)
{
}
}
