public JsonResult Save_user(List <string> role_id, string usergroupid, string username, List <string> role_id_uncheck)
{
List <Group_Permission> lst = db.Group_Permission.Where(n => n.UserGroupID == usergroupid).ToList();
List <User_Permission> l = db.User_Permission.Where(n => n.UserName == username).ToList();
foreach (var i in role_id)
{
if (!l.Any(n => n.RoleID.Contains(i)))
{
User_Permission p = new User_Permission();
p.UserName = username;
p.RoleID = i;
db.User_Permission.Add(p);
}
}
db.SaveChanges();
if (role_id_uncheck != null)
{
foreach (var j in role_id_uncheck)
{
if (l.Any(n => n.RoleID.Contains(j)))
{
User_Permission per = db.User_Permission.Single(n => n.RoleID == j && n.UserName == username);
db.User_Permission.Remove(per);
db.SaveChanges();
}
}
}
return(Json("ok", JsonRequestBehavior.AllowGet));
}
public IActionResult DeleteUserPermission(User_Permission permission, string user_ID)
{
if (!user_ID.Equals(User.FindFirst(ClaimTypes.NameIdentifier).Value))
{
return(Unauthorized());
}
_repo.DeleteUserPermission(permission);
return(Ok());
}
public void DeleteUserPermission(User_Permission permission)
{
string query = @"Delete From dbo.User_Permission_View Where
User_ID = @user_ID AND Group_ID = @group_ID";
base.DbConnection.Execute(query, new
{
@group_ID = permission.Group_ID,
@user_ID = permission.User_ID
});
}
public JsonResult Save_Group(List <string> role_id, string usergroupid, List <string> role_id_uncheck)
{
List <NguoiDung> lnd = db.NguoiDung.Where(n => n.UserGroupID == usergroupid).ToList();
List <Group_Permission> lst = db.Group_Permission.Where(n => n.UserGroupID == usergroupid).ToList();
foreach (var i in role_id)
{
if (!lst.Any(n => n.RoleID.Contains(i)))
{
Group_Permission p = new Group_Permission();
p.UserGroupID = usergroupid;
p.RoleID = i;
db.Group_Permission.Add(p);
foreach (var nd in lnd)
{
List <User_Permission> lpu = db.User_Permission.Where(n => n.UserName == nd.UserName).ToList();
if (!lpu.Any(n => n.RoleID.Contains(i)))
{
User_Permission pu = new User_Permission();
pu.RoleID = i;
pu.UserName = nd.UserName;
db.User_Permission.Add(pu);
}
}
}
}
db.SaveChanges();
if (role_id_uncheck != null)
{
foreach (var j in role_id_uncheck)
{
if (lst.Any(n => n.RoleID.Contains(j)))
{
Group_Permission per = db.Group_Permission.Single(n => n.RoleID == j && n.UserGroupID == usergroupid);
foreach (var nd in lnd)
{
List <User_Permission> lperu = db.User_Permission.Where(n => n.UserName == nd.UserName && n.RoleID == j).ToList();
foreach (var peru in lperu)
{
db.User_Permission.Remove(peru);
}
}
db.Group_Permission.Remove(per);
db.SaveChanges();
}
}
}
return(Json("ok", JsonRequestBehavior.AllowGet));
}
public void UpdatePermissionUser(string lstRoleSelected, int userId)
{
string[] arrRole = lstRoleSelected.Split('*');
IEnumerable <User_Permission> lstUserPermission = db.User_Permission.Where(x => x.UserID == userId);
db.User_Permission.RemoveRange(lstUserPermission);
db.SaveChanges();
for (int i = 0; i < arrRole.Length; i++)
{
if (arrRole[i].Length > 0)
{
User_Permission up = new User_Permission();
up.UserID = userId;
up.RoleId = arrRole[i];
db.User_Permission.Add(up);
}
}
db.SaveChanges();
}
// Execution ValheimPermissions.ValheimDB.AddUserPermission(STEAMID, PERMISSION_NODE)
// Important Note: You need to send the SteamID in STRING format instead of the default LONG format. use SteamID.ToString() before sending.
// Results: Will return false if the permission already exists
// Or: WIll return true if the add was successful
// NOTE: Results will be returned to you in BOOL format (true/false)
public static bool AddUserPermission(string SteamID, string permission)
{
permission = permission.ToLower();
using (var db = new LiteDatabase(DatabaseLocation))
{
var permissions = db.GetCollection <User_Permission>("User_Permission");
var _permission = new User_Permission
{
SteamID = SteamID.ToString(),
permission = permission.ToLower()
};
var pexists = permissions.FindOne(Query.And(Query.EQ("SteamID", SteamID), Query.EQ("permission", permission)));
if (pexists != null)
{
return(false);
}
permissions.Insert(_permission);
return(true);
}
}
private void frmEditeProductByCat_Load(object sender, EventArgs e)
{
this.btLoadJobSP.Text += QT.Users.User.UserName;
this.btLoadCatMyJob.Text += QT.Users.User.UserName;
this.productDetailTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.job_SPGocNhapLieuLogTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.job_NhapLieuStatusConstTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.job_SPGocNhapLieuTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.propertiesConfig_PropertiesTableAdapter.Connection.ConnectionString = Server.ConnectionString;
this.job_NhapLieuStatusTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.productStatusTableAdapter.Connection.ConnectionString = Server.ConnectionString;
this.propertiesValueTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.propertiesTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.listClassification_PropertiesTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.product_PropertiesTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.listClassificationTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.productTableAdapter.Connection.ConnectionString = QT.Entities.Server.ConnectionString;
this.productStatusTableAdapter.Fill(this.dBProperties.ProductStatus);
this.listClassificationTableAdapter.FillBy_DaMapConfig(this.dBProperties.ListClassification);
this.job_NhapLieuStatusTableAdapter.Fill(this.dBJob.Job_NhapLieuStatus);
this.job_NhapLieuStatusConstTableAdapter.Fill(this.dBProperties.Job_NhapLieuStatusConst);
var per = new User_Permission();
if (per.CheckPermission(QT.Users.User.UserID, Permission.ADMIN) ||
per.CheckPermission(QT.Users.User.UserID, Permission.PhanCongNhapDuLieu))
{
this.cboJobStatus.Enabled = true;
this.btCheck.Enabled = true;
this.btLoad.Visible = true;
}
else
{
this.cboJobStatus.Enabled = false;
this.btCheck.Enabled = false;
this.btLoad.Visible = false;
}
}
