internal void AddPermission(string username, Permission permission)
{
var roleName = GetRoleName(permission);
var roleId = QM.QueryInteger(connection, "select agr_role_id from agr_role where agr_role=:0", roleName);
if (roleId == null)
{
throw new Exception($"role not found {roleName}");
}
var userId = NUserPack.GetUserId(connection, username.ToUpper());
if (AgrAppPkg.UserHasRole(connection, userId, (int)roleId))
{
return;
}
AgrCorePkg.GrantRoleToUser(connection, (int)roleId, userId, true);
}
public void SetSessionUser(int userid)
{
var username = NUserPack.GetUsernameById(connection, userid);
AgrAppPkg.SetSessionUser(connection, username);
}
