public bool IsUserInRole(string roleName, string userName) { var securityGroupRepo = new SecurityGroupRepository(); var userRepo = new UserRepository(); var role = securityGroupRepo.GetGroupByTitle(roleName); if (role != null) { var user = userRepo.GetCredentials(userName); if (user != null) return role.sec_gro_id == user.sec_gro_id; } return false; }