private void RemoveRolesFromUtility(UtilityRoleViewModel newUtilityRole)
{
var existingUtilityrRoles = GetAllRolesForAnUtility(newUtilityRole.UtilityId);
foreach (var existingUtilityrRole in existingUtilityrRoles)
{
var result = newUtilityRole.RoleIds.Find(x => x.Equals(existingUtilityrRole.RoleID));
if (result == 0)
{
var recordToDelete = _commmonDBContext.Query <UtilityRole>().Where(x => x.UtilityID == existingUtilityrRole.UtilityID &&
x.RoleID == existingUtilityrRole.RoleID).FirstOrDefault();
_commmonDBContext.Delete(recordToDelete);
}
}
}
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);
}
}