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); }