public void AddRoleToUserForAllUtility(User user)
{
var allUtilities = _utilityService.GetAllUtilities();
var userRole = _roleService.GetRoleByRoleName("User");
foreach (var utility in allUtilities)
{
_commonDBContext.Add(new UtilityUserRoles {
UtilityId = utility.Id, UserId = user.ID, RoleId = userRole.ID
});
}
}
public void SaveUtilityRole(UtilityRoleViewModel newUtilityRole)
{
var existingUtilityRoles = GetAllRolesForAnUtility(newUtilityRole.UtilityId);
var newRolesForUtility = new List <UtilityRole>();
foreach (var item in newUtilityRole.RoleIds)
{
if (existingUtilityRoles.Find(x => x.RoleID == item) == null)
{
_commmonDBContext.Add(new UtilityRole {
UtilityID = newUtilityRole.UtilityId, RoleID = item
});
}
}
RemoveRolesFromUtility(newUtilityRole);
}
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);
}
}