/// <summary> /// /// </summary> /// <param name="groupname"></param> /// <param name="add"></param> /// <param name="del"></param> /// <param name="up"></param> /// <param name="view"></param> /// <param name="doituong"></param> /// <returns></returns> public int delquyen_group(string groupname, Boolean add, Boolean del, Boolean up, Boolean view, string doituong)//khi tao moi thi kiem tra { try { Quyen_group listgroup = new Quyen_group(); dbConnect.Open(); listgroup = (from Quyen_group p in dbConnect.db where p.Group == groupname && p.Doituong == doituong select p).SingleOrDefault(); if (listgroup != null) { listgroup.Add = add; listgroup.Del = del; listgroup.Up = up; listgroup.View = view; dbConnect.db.Store(listgroup); } return(1); } catch { return(0); } finally { dbConnect.Close(); } }
public void capnhat_user_groupup(string tengroup, string doituong) { try { dbConnect.Open(); List <Quyen_user> quser = (from Quyen_user p in dbConnect.db where p.Group == tengroup select p).ToList(); if (quser != null) { //chi nhung group da dc them quyen moi gan cho user Quyen_user kt = (from Quyen_user p in dbConnect.db where p.Group == tengroup && p.Doituong == doituong select p).FirstOrDefault(); Quyen_group tdtgroup = (from Quyen_group p in dbConnect.db where p.Group == tengroup && p.Doituong == doituong select p).FirstOrDefault(); if (tdtgroup != null && kt != null) { foreach (var i in quser) { i.Add = tdtgroup.Add; i.Del = tdtgroup.Del; i.Up = tdtgroup.Up; i.View = tdtgroup.View; dbConnect.db.Store(i); } } else if (kt == null) { foreach (var i in quser) { Quyen_user adduser = new Quyen_user(); adduser.User = i.User; adduser.Group = tengroup; adduser.Doituong = tdtgroup.Doituong; adduser.Add = tdtgroup.Add; adduser.Del = tdtgroup.Del; adduser.Up = tdtgroup.Up; adduser.View = tdtgroup.View; dbConnect.db.Store(adduser); } } } } catch { } finally { dbConnect.Close(); } }
private void gthem_SelectedValueChanged(object sender, EventArgs e) { Quyen_group qg = new Quyen_group(); if (cgroup.Text.Trim() != "") { qg = qg.timquyen_group(cgroup.Text, gthem.Text); if (qg != null) { cthem.Checked = qg.Add; cxoa.Checked = qg.Del; csua.Checked = qg.Up; cxem.Checked = qg.View; } } }
private void button1_Click(object sender, EventArgs e) { try { dbConnect.Open(); List <Quyen_group> qg = new List <Quyen_group>(); qg = ( from Quyen_group p in dbConnect.db where p.Group == timgroup.Text select p).ToList(); dataGridView1.DataSource = qg; } finally { dbConnect.db.Close(); } }
/// <summary> /// /// </summary> /// <param name="groupname"></param> /// <param name="doituong"></param> /// <returns></returns> public Quyen_group timquyen_group(string groupname, string doituong) { try { Quyen_group listgroup = new Quyen_group(); dbConnect.Open(); listgroup = (from Quyen_group p in dbConnect.db where p.Group == groupname && p.Doituong == doituong select p).SingleOrDefault(); if (listgroup != null) { return(listgroup); } else { return(null); } } catch { return(null); } finally { dbConnect.Close(); } }