public void AddRolesToUserForAUtility(UtilityUserRoleViewModel newUserRole)
{
var newUserRoles = new UtilityUserRoles();
foreach (var userId in newUserRole.UserId)
{
var userRole = _commonDBContext.Query <UtilityUserRoles>().FirstOrDefault(x => x.UserId == userId && x.UtilityId == newUserRole.UtilityId && x.RoleId == newUserRole.RoleId);
if (userRole != null)
{
userRole.IsActive = true;
_commonDBContext.Update(userRole);
}
else
{
newUserRoles.UtilityId = newUserRole.UtilityId;
newUserRoles.RoleId = newUserRole.RoleId;
newUserRoles.UserId = userId;
newUserRoles.IsActive = true;
_commonDBContext.Add(newUserRoles);
}
if (HttpContext.Current.Request.IsLocal)
{
ServicePointManager.ServerCertificateValidationCallback = delegate { return(true); };
}
string url = ConfigurationManager.AppSettings["Addreviewer"] + userId;
HttpClient client = new HttpClient();
client.BaseAddress = new Uri(url);
var response = client.GetAsync(url).Result;
}
RemoveRolesOfUserFromUtility(newUserRole);
}
public ActionResult AddRolesToUserForAUtility(UtilityUserRoleViewModel newUserRole)
{
if (newUserRole.RoleId != 0)
{
_userService.AddRolesToUserForAUtility(new UtilityUserRoleViewModel {
UtilityId = newUserRole.UtilityId, RoleId = newUserRole.RoleId, UserId = newUserRole.UserId
});
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
private void RemoveRolesOfUserFromUtility(UtilityUserRoleViewModel utilitiUserRoles)
{
var existingUtilityUserRoles = _commonDBContext.Query <UtilityUserRoles>().Where(x => x.UtilityId == utilitiUserRoles.UtilityId && x.RoleId == utilitiUserRoles.RoleId).ToList();
foreach (var existingUtilityUserRole in existingUtilityUserRoles)
{
if (utilitiUserRoles.UserId.All(x => x != existingUtilityUserRole.UserId))
{
var recordToDelete = _commonDBContext.Query <UtilityUserRoles>().FirstOrDefault(x => x.UserId == existingUtilityUserRole.UserId && x.UtilityId == utilitiUserRoles.UtilityId && x.RoleId == utilitiUserRoles.RoleId);
if (recordToDelete != null)
{
recordToDelete.IsActive = false;
_commonDBContext.Update(recordToDelete);
}
}
}
}
public ActionResult AddRolesToUserForAUtility()
{
var newUserRole = new UtilityUserRoleViewModel();
// ViewData["User"] = new SelectList(_userService.GetAllUsers(), "ID", "DisplayName", "Select");
var selectListItems = _userService.GetAllUsers().Select(u => new SelectListItem()
{
Text = u.ID.ToString(), Value = u.DisplayName
}).ToList();
ViewData["User"] = selectListItems;
ViewData["Utilities"] = new SelectList(_utilityService.GetAllUtilities(), "Id", "Name", "Select");
ViewData["Roles"] = new SelectList(_roleService.GetAllRoles(), "ID", "Name", "Select");
//var role = _roleService.GetAllRoles();
return(View(newUserRole));
}
public void AddRolesToUserForAUtility(UtilityUserRoleViewModel newUserRole)
{
var myNewUserRole = new UtilityUserRoles();
foreach (var item in newUserRole.UserId)
{
var userRole = _commonDBContext.Query <UtilityUserRoles>().Where(x => x.UserId == item && x.UtilityId == newUserRole.UtilityId).FirstOrDefault();
if (userRole != null)
{
_commonDBContext.Delete(userRole);
}
myNewUserRole.UtilityId = newUserRole.UtilityId;
myNewUserRole.RoleId = newUserRole.RoleId;
myNewUserRole.UserId = item;
_commonDBContext.Add(myNewUserRole);
}
}
