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();
}
}
}
private static int getEmployeeNumberFromUserName(string username)
{
int result = -1;
try
{
LussisEntities context = new LussisEntities();
aspnet_Users userDetail = context.aspnet_Users.Where(user => user.UserName.Equals(username)).FirstOrDefault();
if (userDetail != null)
{
result = Convert.ToInt32(userDetail.aspnet_Profile.PropertyValuesString);
}
}
catch (Exception)
{
result = -2;
}
return(result);
}
