//************************************ ORGANIZATION USER CLIENT ***************************************
public IActionResult OrgUserClients(int id)
{
T_PRT_ORG_USERS _orgUser = _DbPortal.GetT_PRT_ORG_USERS_ByOrgUserID(id);
if (_orgUser != null)
{
var model = new OrgUserEditViewModel
{
OrgUserIDX = id,
OrgUserClients = _DbPortal.GetT_PRT_ORG_USERS_CLIENT_ByOrgUserID(id),
UserIDX = _orgUser.Id,
ddl_Clients = _DbPortal.GetT_PRT_CLIENTS().Select(x => new SelectListItem
{
Value = x.CLIENT_ID,
Text = x.CLIENT_NAME
})
};
return(View(model));
}
else
{
TempData["Error"] = "No matching record found.";
return(RedirectToAction("UserList"));
}
}
//************************************ ORGANIZATION USER CLIENT (non-Global Admin) ***************************************
public IActionResult ManageUsers(int?id)
{
//********* id = OrgUserClientID
string _UserIDX = _userManager.GetUserId(User);
var model = new ManageUsersViewModel
{
ddl_AdminOfOrgClients = _DbPortal.GetT_PRT_ORG_USERS_CLIENT_AdminByUserID(_UserIDX).Select(x => new SelectListItem
{
Value = x.ORG_USER_CLIENT_IDX.ToString(),
Text = x.ORG_CLIENT_ALIAS + " - " + x.CLIENT_ID
})
};
//get users currently listed for the org/client
//get users for the organization
if (id != null)
{
model.selOrgUserClient = id;
T_PRT_ORG_USER_CLIENT _ouc = _DbPortal.GetT_PRT_ORG_USERS_CLIENT_ByID((int)id);
if (_ouc != null)
{
T_PRT_ORG_USERS _ou = _DbPortal.GetT_PRT_ORG_USERS_ByOrgUserID(_ouc.ORG_USER_IDX);
if (_ou != null)
{
model.client_id = _ouc.CLIENT_ID;
model.selOrg = _ou.ORG_ID;
model.OrgUserClients = _DbPortal.GetT_PRT_ORG_USERS_CLIENT_ByOrgIDandClientID(_ou.ORG_ID, _ouc.CLIENT_ID, false);
model.ddl_Users = _DbPortal.GetT_PRT_ORG_USERS_ByOrgID(_ou.ORG_ID).Select(x => new SelectListItem
{
Value = x.ORG_USER_IDX.ToString(),
Text = x.USER_NAME
});
}
}
}
;
return(View(model));
}
public async Task <JsonResult> OrgUserDelete(int id, string id2)
{
T_PRT_ORG_USERS orgUser = _DbPortal.GetT_PRT_ORG_USERS_ByOrgUserID(id);
int succId = _DbPortal.DeleteT_PRT_ORG_USERS(orgUser);
if (succId > 0)
{
WordPressHelper.SetUserManager(_userManager);
ApplicationUser appUser = await WordPressHelper.GetApplicationUser(orgUser.Id);
WordPressHelper wordPressHelper = new WordPressHelper(_userManager, _DbPortal, _log, _emailSender);
int orgUserCount = _DbPortal.GetOrgUsersCount(orgUser.Id);
if (orgUserCount == 0)
{
//if we have user in wordpress, make it inactive
if (appUser.WordPressUserId > 0)
{
//string wordPressUri = wordPressHelper.SetWordPressUri(orgUser.ORG_ID);
// string userName = wordPressHelper.GetUserName();
// string password = wordPressHelper.GetPassword();
int.TryParse(appUser.WordPressUserId.ToString(), out var wpuid);
//WordPressClient wordPressClient = await wordPressHelper.GetAuthenticatedWordPressClient(wordPressUri, userName, password);
WordPressClient wordPressClient = await wordPressHelper.GetAuthenticatedWordPressClient(orgUser.ORG_ID);
bool isUserUpdated = await wordPressHelper.UpdateWordPressUser(appUser, wordPressClient, wpuid, "inactive");
}
}
else
{
//revoke access from the site/organization from wordpress
int.TryParse(appUser.WordPressUserId.ToString(), out var wpuid);
wordPressHelper.AddRemoveUserSite(wpuid, orgUser.ORG_ID, 0);
}
return(Json("Success"));
}
else
{
return(Json("Unable to delete user from organization."));
}
}
public async Task <int> SetupWordPressAccess(string uidx, string orgId, string accessLevel, string statusInd)
{
_log.InsertT_PRT_SYS_LOG("Info", "SetupWordPressAccess called.");
int actResult = 1;
try
{
ApplicationUser user = await _userManager.FindByIdAsync(uidx);
if (user != null)
{
//_log.InsertT_PRT_SYS_LOG("Info", "we have a valid user.");
int orgUserCount = _DbPortal.GetOrgUsersCount(uidx);
SetWordPressUri(orgId);
//_log.InsertT_PRT_SYS_LOG("Info", WordPressUri);
WordPressClient wordPressClient = await GetAuthenticatedWordPressClient(WordPressUri, UserName, Password);
var isTokenValid = await wordPressClient.IsValidJWToken();
if (isTokenValid)
{
//_log.InsertT_PRT_SYS_LOG("Info", "Token is valid.");
if (accessLevel == "A" && statusInd == "A")
{
//_log.InsertT_PRT_SYS_LOG("Info", "AccessLevel/Status is A");
int.TryParse(user.WordPressUserId.ToString(), out var wpuid);
if (orgUserCount > 0)
{
T_PRT_ORG_USERS orgUser = _DbPortal.GetUserOrg(uidx, orgId);
if (orgUser == null)
{
//This situation is unlikely to occur, since we do an upsert before reaching here
actResult = 0;
_log.InsertT_PRT_SYS_LOG("ERROR", "Org-User not found.");
}
else
{
if (wpuid > 0)
{
//_log.InsertT_PRT_SYS_LOG("Info", "User already exists, update as administrator.");
await UpdateWordPressUser(user, wordPressClient, wpuid, "administrator");
AddRemoveUserSite(wpuid, orgId, 1);
}
else
{
//_log.InsertT_PRT_SYS_LOG("Info", "User does not exist, add new user as administrator.");
User createdUser = await CreateWordPressUser(user, wordPressClient, orgId);
if (createdUser != null)
{
_DbPortal.UpdateT_PRT_USERS_WordPressUserId(user, createdUser.Id);
}
else
{
actResult = 0;
_log.InsertT_PRT_SYS_LOG("ERROR", "New user could not be added.");
}
}
}
}
else
{
if (wpuid > 0)
{
//_log.InsertT_PRT_SYS_LOG("Info", "User already exist, update as administrator.");
await UpdateWordPressUser(user, wordPressClient, wpuid, "administrator");
AddRemoveUserSite(wpuid, orgId, 1);
}
else
{
//_log.InsertT_PRT_SYS_LOG("Info", "User does not exist, add new user as administrator.");
User createdUser = await CreateWordPressUser(user, wordPressClient, orgId);
_DbPortal.UpdateT_PRT_USERS_WordPressUserId(user, createdUser.Id);
}
}
}
else
{
//_log.InsertT_PRT_SYS_LOG("Info", "AccessLevel/Status is NOT A");
if (Int32.TryParse(user.WordPressUserId.ToString(), out var wuid) && wuid > 0)
{
if (orgUserCount > 1)
{
AddRemoveUserSite(wuid, orgId, 0);
}
else
{
await UpdateWordPressUser(user, wordPressClient, wuid, "inactive");
}
}
else
{
actResult = 0;
_log.InsertT_PRT_SYS_LOG("ERROR", "Issue with WordPress user id.");
}
}
}
else
{
actResult = 0;
_log.InsertT_PRT_SYS_LOG("ERROR", "JWT token is not valid.");
}
}
else
{
actResult = 0;
_log.InsertT_PRT_SYS_LOG("ERROR", "user is null.");
}
}
catch (Exception ex)
{
actResult = 0;
_log.InsertT_PRT_SYS_LOG("ERROR", ex.Message + " : " + ex.StackTrace);
//Log errors
}
return(actResult);
}
public JsonResult AccessRightsRequest(int?orgUser, string client)
{
string _UserIDX = _userManager.GetUserId(User);
T_PRT_ORG_USERS _ou = _DbPortal.GetT_PRT_ORG_USERS_ByOrgUserID(orgUser ?? -1);
if (_ou != null)
{
int SuccID = _DbPortal.InsertUpdateT_PRT_ORG_USERS_CLIENT(null, orgUser, client, false, "R", _UserIDX);
//return response
if (SuccID > 0)
{
//send email
List <string> _emailRecipients = new List <string>();
//**************first try to send to org / client admins
List <OrgUserClientDisplayType> _orgUserClientAdmins = _DbPortal.GetT_PRT_ORG_USERS_CLIENT_ByOrgIDandClientID(_ou.ORG_ID, client, true);
if (_orgUserClientAdmins != null && _orgUserClientAdmins.Count > 0)
{
foreach (OrgUserClientDisplayType _orgUserClientAdmin in _orgUserClientAdmins)
{
ApplicationUser _u = _userManager.FindByIdAsync(_orgUserClientAdmin.UserID).Result;
if (_u != null)
{
_emailRecipients.Add(_u.Email);
}
}
}
//**************if none found, then send to org admins
//**************finally send to portal admins
if (_emailRecipients.Count == 0)
{
IdentityRole _r = _roleManager.FindByNameAsync("PortalAdmin").Result;
IEnumerable <ApplicationUser> _us = _DbPortal.GetT_PRT_USERS_BelongingToRole(_r.Id);
if (_us != null)
{
foreach (ApplicationUser _u in _us)
{
_emailRecipients.Add(_u.Email);
}
}
}
string _UserName = _userManager.GetUserName(User);
//construct email parameters
List <emailParam> emailParams = new List <emailParam>()
{
new emailParam()
{
PARAM_NAME = "userName", PARAM_VAL = _UserName
},
new emailParam()
{
PARAM_NAME = "client", PARAM_VAL = client
},
new emailParam()
{
PARAM_NAME = "orgID", PARAM_VAL = _ou.ORG_ID
}
};
foreach (string _emailRecipient in _emailRecipients)
{
_emailSender.SendEmail(null, _emailRecipient, null, null, null, null, "ACCESS_REQUEST", emailParams);
}
return(Json(new
{
msg = "Success",
redirectUrl = Url.Action("AccessRights", "Manage")
}));
}
}
//if got this far, it failed
return(Json(new { msg = "Unable to request access." }));
}
