private void btnAdd_Click(object sender, EventArgs e)
{
QLDT_LINQDataContext db = new QLDT_LINQDataContext();
try
{
DeTai insDetai = new DeTai();
insDetai.MaDeTai = txtMa.Text.Trim();
insDetai.TenDeTai = txtTen.Text.Trim();
if (rdHThanh.Checked)
{
insDetai.TinhTrang = true;
}
else
{
insDetai.TinhTrang = false;
}
insDetai.NgayNhanDeTai = dpkNgayNhan.Value;
insDetai.MaCapDeTai = db.CapDeTais.Where(p => p.TenCapDeTai.Equals(cbbCapDeTai.SelectedItem.ToString())).Select(p => p.MaCapDeTai).SingleOrDefault().ToString();
insDetai.ChuNhiem = cbbChuNhiem.SelectedItem.ToString();
db.DeTais.InsertOnSubmit(insDetai);
}
finally
{
db.SubmitChanges();
MessageBox.Show("Success!!");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
QLDT_LINQDataContext db = new QLDT_LINQDataContext();
var xoa = db.DeTais.Where(p => p.MaDeTai.Equals(dataGrid.CurrentRow.Cells[0].Value.ToString()));
foreach (var i in xoa)
{
db.DeTais.DeleteOnSubmit(i);
db.SubmitChanges();
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
QLDT_LINQDataContext db = new QLDT_LINQDataContext();
var DeTaiUpdate = db.DeTais.Single(p => p.MaDeTai == dataGrid.CurrentRow.Cells[0].Value.ToString());
DeTaiUpdate.TenDeTai = txtTen.Text.Trim();
if (rdHThanh.Checked)
{
DeTaiUpdate.TinhTrang = true;
}
else
{
DeTaiUpdate.TinhTrang = false;
}
DeTaiUpdate.NgayNhanDeTai = dpkNgayNhan.Value;
DeTaiUpdate.MaCapDeTai = db.CapDeTais.Where(p => p.TenCapDeTai.Equals(cbbCapDeTai.SelectedItem.ToString())).Select(p => p.MaCapDeTai).SingleOrDefault().ToString();
DeTaiUpdate.ChuNhiem = cbbChuNhiem.SelectedItem.ToString();
db.SubmitChanges();
}
