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(); }