public void SetPermissionForUser(string userName, int functionID, int permission)
{
dtb_permission newPermis = new dtb_permission();
newPermis.username = userName;
newPermis.function_id = functionID;
newPermis.permission = permission;
db.dtb_permissions.InsertOnSubmit(newPermis);
db.SubmitChanges();
}
public void EditPermissionForUser(string userName, int functionID, int permission)
{
if (db.dtb_permissions.Any(x => (x.function_id == functionID && x.username == userName)))
{
dtb_permission f = db.dtb_permissions.Where(s => (s.function_id == functionID && s.username == userName)).Single();
if (f == null)
{
return;
}
f.permission = permission;
db.SubmitChanges();
}
else
{
SetPermissionForUser(userName, functionID, permission);
}
}
