private void button1_Click(object sender, EventArgs e) { QLPHANQUYEN pq = new QLPHANQUYEN(); pq.MANHOM = dgv_nhomnd.CurrentRow.Cells[0].Value.ToString(); pq.MAMANHINH = cb_danhmucmh.SelectedValue.ToString(); if (radioButton1.Checked == true) { pq.COQUYEN = true; } else { pq.COQUYEN = false; } if (bb_pq.ktkc(pq) == true) { if (bb_pq.thempq(pq) == true) { MessageBox.Show("thêm thành công"); dgv_quyentruycap.DataSource = bb_pq.Load_phanquyen(); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("nhóm đã tồn tại"); } }
//Thêm public bool them_QLPHANQUYEN(QLPHANQUYEN phanquyen) { try { data.QLPHANQUYENs.InsertOnSubmit(phanquyen); data.SubmitChanges(); return(true); } catch { return(false); } }
public bool them(QLPHANQUYEN pmh) { try { data.QLPHANQUYENs.InsertOnSubmit(pmh); data.SubmitChanges(); return(true); } catch { return(false); } }
//Xóa public bool xoa_QLPHANQUYEN(string pMaNhom, string pmamh) { try { QLPHANQUYEN manhom = data.QLPHANQUYENs.Where(t => t.MANHOM == pMaNhom && t.MAMANHINH == pmamh).FirstOrDefault(); data.QLPHANQUYENs.DeleteOnSubmit(manhom); data.SubmitChanges(); return(true); } catch { return(false); } }
public bool xoa(QLPHANQUYEN pmh) { try { QLPHANQUYEN mh = data.QLPHANQUYENs.Where(t => t.MANHOM == pmh.MANHOM.ToString() && t.MAMANHINH == pmh.MAMANHINH).FirstOrDefault(); data.QLPHANQUYENs.DeleteOnSubmit(mh); data.SubmitChanges(); return(true); } catch { return(false); } }
public bool sua(QLPHANQUYEN pmh) { try { QLPHANQUYEN thanhvien = data.QLPHANQUYENs.Where(t => t.MANHOM == pmh.MANHOM.ToString() && t.MAMANHINH == pmh.MAMANHINH).FirstOrDefault(); thanhvien.MANHOM = pmh.MANHOM; thanhvien.MAMANHINH = pmh.MAMANHINH; data.SubmitChanges(); return(true); } catch { return(false); } }
//Sửa public bool sua_QLPHANQUYEN(QLPHANQUYEN pQLPHANQUYEN) { try { QLPHANQUYEN phanquyen = data.QLPHANQUYENs.Where(t => t.MANHOM == pQLPHANQUYEN.MANHOM).FirstOrDefault(); if (phanquyen != null) { phanquyen.COQUYEN = pQLPHANQUYEN.COQUYEN; data.SubmitChanges(); } return(true); } catch { return(false); } }
public bool ktkc(QLPHANQUYEN ma) { int r = data.QLPHANQUYENs.Count(t => t.MANHOM == ma.MANHOM.ToString() && t.MAMANHINH == ma.MAMANHINH); try { if (r == 0) { return(true); } return(false); } catch { return(false); } }
private void btn_them_Click(object sender, EventArgs e) { if (cboMaMH.Text == "" || cboMaNhom.Text == "") { MessageBox.Show("Không được để trống"); return; } QLPHANQUYEN ct = new QLPHANQUYEN(); var kt = from s in db.QLPHANQUYENs where s.MANHOM == cboMaNhom.Text && s.MAMANHINH == cboMaMH.Text select s; if (kt.Count() > 0) { MessageBox.Show("Trùng khóa chính"); return; } ct.MANHOM = cboMaNhom.Text; ct.MAMANHINH = cboMaMH.Text; ct.COQUYEN = txtCoquyen.Text; db.QLPHANQUYENs.InsertOnSubmit(ct); db.SubmitChanges(); frm_QLPhanQuyen_Load(sender, e); MessageBox.Show("thành công"); }
private void button2_Click(object sender, EventArgs e) { QLPHANQUYEN pq = new QLPHANQUYEN(); pq.MANHOM = dgv_quyentruycap.CurrentRow.Cells[0].Value.ToString(); pq.MAMANHINH = dgv_quyentruycap.CurrentRow.Cells[3].Value.ToString(); if (bb_pq.ktkc(pq) == false) { if (bb_pq.xoapq(pq) == true) { MessageBox.Show("xóa thành công"); dgv_quyentruycap.DataSource = bb_pq.Load_phanquyen(); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("dữ liệu không tồn tại"); } }
public bool suapq(QLPHANQUYEN n) { return(pq.sua(n)); }
public bool xoapq(QLPHANQUYEN n) { return(pq.xoa(n)); }
public bool thempq(QLPHANQUYEN n) { return(pq.them(n)); }
public bool ktkc(QLPHANQUYEN n) { return(pq.ktkc(n)); }
//Sửa public bool sua_QLPHANQUYEN(QLPHANQUYEN pQLPHANQUYEN) { return(phanquyen.sua_QLPHANQUYEN(pQLPHANQUYEN)); }
//Thêm public bool them_QLPHANQUYEN(QLPHANQUYEN pQLPHANQUYEN) { return(phanquyen.them_QLPHANQUYEN(pQLPHANQUYEN)); }