///TODO CHECK WITH MARK H IF STILL NEEDED
        public void CheckCorrectUserDetailsViaRipleyWithNewSSOAccount()
        {
            DnaTestURLRequest request = new DnaTestURLRequest("h2g2");
            request.SetCurrentUserAs("ultimatetester", "123456789", 0, "34b89e32918c500eba6e575aa1cae216753ff7752853802bb1b76ebdd5e9e9ae00", false);
            request.SignUserIntoSSOViaWebRequest(DnaTestURLRequest.usertype.CURRENTSETTINGS);
            request.RequestPage("?skin=purexml");

            XmlDocument doc = request.GetLastResponseAsXML();
            Assert.IsNotNull(doc.SelectSingleNode("//VIEWING-USER/USER/USERNAME"), "User name is not correct");
            Assert.AreEqual("ultimatetester", doc.SelectSingleNode("//VIEWING-USER/USER/USERNAME").InnerText, "User name is not correct");
        }
        public void CheckMigratedUserDetailsViaRipley()
        {
            using (IDnaDataReader reader = DnaMockery.CreateDatabaseInputContext().CreateDnaDataReader(""))
            {
                string sql = "SELECT * FROM Users WHERE UserID = " + TestUserAccounts.GetNormalUserAccount.UserID;
                reader.ExecuteDEBUGONLY(sql);
                Assert.IsTrue(reader.Read());
                Assert.AreEqual(TestUserAccounts.GetNormalUserAccount.UserName, reader.GetString("username"));
            }

            string identityUserID;
            Assert.IsTrue(TestUserCreator.CreateIdentityUser(_userName, _password, _dob, _email, _displayName, true, TestUserCreator.IdentityPolicies.Adult, true, TestUserAccounts.GetNormalUserAccount.UserID, out _cookie, out _secureCookie, out identityUserID), "Failed to create test identity user");
            DnaTestURLRequest request = new DnaTestURLRequest("identity606");
            request.SetCurrentUserAs(_userName, _password, TestUserAccounts.GetNormalUserAccount.UserID, _cookie.Value, true);
            request.RequestPage("?skin=purexml");

            XmlDocument doc = request.GetLastResponseAsXML();
            Assert.IsNotNull(doc.SelectSingleNode("//VIEWING-USER/USER/USERNAME"), "User name is not correct");
            Assert.AreEqual(_cppDisplayName, doc.SelectSingleNode("//VIEWING-USER/USER/USERNAME").InnerText, "User name is not correct");
            Assert.IsNotNull(doc.SelectSingleNode("//VIEWING-USER/SIGNINNAME"), "login name is not correct");
            Assert.AreEqual(_userName, doc.SelectSingleNode("//VIEWING-USER/SIGNINNAME").InnerText, "login name is not correct");

            using (IDnaDataReader reader = DnaMockery.CreateDatabaseInputContext().CreateDnaDataReader(""))
            {
                string sql = "SELECT * FROM Users WHERE UserID = " + TestUserAccounts.GetNormalUserAccount.UserID;
                reader.ExecuteDEBUGONLY(sql);
                Assert.IsTrue(reader.Read());
                Assert.AreEqual(_displayName, reader.GetString("username"));
                Assert.AreEqual(_userName, reader.GetString("loginname"));
            }
        }