public static bool SaveRoleAction(int roleId, IList <int> listActionId)
{
using (MainDataContext dbContext = new MainDataContext())
{
List <B_ROLE_ACTION> list = dbContext.B_ROLE_ACTION.Where(t => t.RoleID == roleId).ToList();
foreach (B_ROLE_ACTION b in list)
{
//dbContext.B_ROLE_ACTION.Load();
dbContext.B_ROLE_ACTION.DeleteOnSubmit(b);
}
foreach (int actionid in listActionId)
{
B_ROLE_ACTION b = new B_ROLE_ACTION();
b.RoleID = roleId;
b.ActionID = actionid;
dbContext.B_ROLE_ACTION.InsertOnSubmit(b);
}
dbContext.SubmitChanges();
return(true);
}
}
public static bool SaveRoleAction(int roleId, IList <int> listActionId, IList <string> listRangeId)
{
using (MainDataContext dbContext = new MainDataContext())
{
List <B_ROLE_ACTION> list = dbContext.B_ROLE_ACTION.Where(t => t.RoleID == roleId).ToList();
foreach (B_ROLE_ACTION b in list)
{
//dbContext.B_ROLE_ACTION.Load();
dbContext.B_ROLE_ACTION.DeleteOnSubmit(b);
}
foreach (int actionid in listActionId)
{
B_ROLE_ACTION b = new B_ROLE_ACTION();
b.RoleID = roleId;
b.ActionID = actionid;
dbContext.B_ROLE_ACTION.InsertOnSubmit(b);
}
List <B_ROLE_Range> listr = dbContext.B_ROLE_Range.Where(t => t.RoleID == roleId).ToList();
foreach (B_ROLE_Range r in listr)
{
dbContext.B_ROLE_Range.DeleteOnSubmit(r);
}
foreach (string s in listRangeId)
{
B_ROLE_Range b = new B_ROLE_Range();
int i = s.IndexOf('-');
b.RoleID = roleId;
b.ActionID = int.Parse(s.Substring(0, i));
b.Range = s.Substring(i + 1);
dbContext.B_ROLE_Range.InsertOnSubmit(b);
}
dbContext.SubmitChanges();
return(true);
}
}
