public bool them(QLNDNHOMND pmh) { try { da.QLNDNHOMNDs.InsertOnSubmit(pmh); da.SubmitChanges(); return(true); } catch { return(false); } }
public bool xoa(QLNDNHOMND pmh) { try { QLNDNHOMND mh = da.QLNDNHOMNDs.Where(t => t.TENDN == pmh.TENDN.ToString() && t.MANHOM == pmh.MANHOM.ToString()).FirstOrDefault(); da.QLNDNHOMNDs.DeleteOnSubmit(mh); da.SubmitChanges(); return(true); } catch { return(false); } }
public bool sua(QLNDNHOMND pmh) { try { QLNDNHOMND thanhvien = da.QLNDNHOMNDs.Where(t => t.TENDN == pmh.TENDN.ToString() && t.MANHOM == pmh.MANHOM.ToString()).FirstOrDefault(); thanhvien.MANHOM = pmh.MANHOM; thanhvien.GHICHU = pmh.GHICHU; da.SubmitChanges(); return(true); } catch { return(false); } }
public bool ktkc(QLNDNHOMND ma) { int r = da.QLNDNHOMNDs.Count(t => t.TENDN == ma.TENDN.ToString() && t.MANHOM == ma.MANHOM.ToString()); try { if (r == 0) { return(true); } return(false); } catch { return(false); } }
private void button1_Click(object sender, EventArgs e) { QLNDNHOMND ndnnd = new QLNDNHOMND(); ndnnd.TENDN = dataGridView_NDNhomND.CurrentRow.Cells[0].Value.ToString(); ndnnd.MANHOM = cbo_NHomND.SelectedValue.ToString(); if (bll_ndnnd.ktkc(ndnnd) == false) { if (bll_ndnnd.xoandnnd(ndnnd) == true) { MessageBox.Show("thành công"); dataGridView_NDNhomND.DataSource = bll.Load_NDnhomND(); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("dữ liệu không tồn tại"); } }
private void btn_ThemND_Click(object sender, EventArgs e) { QLNDNHOMND ndnnd = new QLNDNHOMND(); ndnnd.TENDN = dataGridView_QLND.CurrentRow.Cells[4].Value.ToString(); ndnnd.MANHOM = cbo_NHomND.SelectedValue.ToString(); ndnnd.GHICHU = textBox1.Text.ToString(); if (bll_ndnnd.ktkc(ndnnd) == true) { if (bll_ndnnd.themndnnd(ndnnd) == true) { MessageBox.Show("thêm thành công"); dataGridView_NDNhomND.DataSource = bll.Load_NDnhomND(); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("trùng mã"); } }
public bool suandndn(QLNDNHOMND n) { return(dl.sua(n)); }
public bool xoandnnd(QLNDNHOMND n) { return(dl.xoa(n)); }
public bool themndnnd(QLNDNHOMND n) { return(dl.them(n)); }
public bool ktkc(QLNDNHOMND n) { return(dl.ktkc(n)); }