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