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