public static bool ClearAllUserPermessions(int usrid)
{
db = new UcasProEntities();
UserPermession tb = new UserPermession();
var lst = (from u in db.UserPermessions where u.UserID == usrid select u).ToList();
List<int> IDes = new List<int>();
IDes.Clear();
foreach (var i in lst )
{
IDes.Add(i.ID );
}
foreach (var item in IDes )
{
tb = db.UserPermessions.Where(x => x.ID == item ).Single();
db.UserPermessions.Remove(tb);
db.SaveChanges();
}
return true;
}
public static bool EditPermessionValue(UserPermession u,int xxUserID)
{
var q = db.UserPermessions.Where(p => p.ID == u.ID && p.UserID == xxUserID ).SingleOrDefault();
try
{
if (q.ID != 0)
{
q.PermessioID = u.PermessioID;
q.PermessionValue = u.PermessionValue;
q.UserID = u.UserID;
db.SaveChanges();
return true;
}
return false;
}
catch (Exception)
{
return false;
}
}
public static void SaveUserPermession(UserPermession p)
{
db.UserPermessions.Add(p);
db.SaveChanges();
}
public static bool UserPermessioSave(UserPermession u)
{
db = new UcasProEntities();
db.UserPermessions.Add(u);
return true;
}
