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