public static void removeRoleFromEmployee(LussisEntities context, int employeeNo, LUSSISRoles roleToRemove)
{
if (context == null)
{
return;
}
String roleSelected = LUSSISRolesString[(int)roleToRemove];
Employee employee = context.Employees
.Where(emp => emp.EmpNo == employeeNo)
.FirstOrDefault();
aspnet_Roles selectedRole = context
.aspnet_Roles
.Where(role =>
role
.RoleName
.Equals(roleSelected))
.FirstOrDefault();
if (employee != null)
{
String empNoToFind = employee.EmpNo.ToString();
aspnet_Profile userProfile = null;
foreach (aspnet_Profile profile in context.aspnet_Profile)
{
if (profile.PropertyValuesString.Equals(empNoToFind))
{
userProfile = profile;
break;
}
}
if (userProfile != null && selectedRole != null)
{
Guid userId = userProfile.UserId;
aspnet_Users userDetail = context.aspnet_Users.Where(user => user.UserId.Equals(userId)).FirstOrDefault();
userDetail.aspnet_Roles.Remove(selectedRole);
context.SaveChanges();
}
}
}
public static String[] getRolesOfEmployee(LussisEntities context, int employeeNo)
{
String[] result = null;
if (context == null)
{
return(result);
}
Employee employee = context.Employees
.Where(emp => emp.EmpNo == employeeNo)
.FirstOrDefault();
if (employee != null)
{
String empNoToFind = employee.EmpNo.ToString();
aspnet_Profile userProfile = null;
foreach (aspnet_Profile profile in context.aspnet_Profile)
{
if (profile.PropertyValuesString.Equals(empNoToFind))
{
userProfile = profile;
break;
}
}
if (userProfile != null)
{
Guid userId = userProfile.UserId;
result = context.aspnet_Users
.Where(user => user.UserId.Equals(userId))
.First()
.aspnet_Roles
.Select(role => role.RoleName)
.ToArray();
}
}
return(result);
}
