Ejemplo n.º 1
0
        public void UserDALTest()
        {
            string joesUsername = "******";
            string joesPassword = "******";

            User someUser = new User();

            someUser.Username      = joesUsername;
            someUser.Password      = joesPassword;
            someUser.Administrator = false;
            someUser.Researcher    = false;
            someUser.Technician    = false;
            someUser.Partneruser   = false;


            UserSqlDAL dalObject = new UserSqlDAL(connectionString);

            dalObject.SaveUser(someUser);

            //checking if a username exists
            Assert.AreEqual(true, dalObject.UsernameExists(joesUsername));
            Assert.AreEqual(false, dalObject.UsernameExists("000"));

            //checking that a password is correct
            Assert.AreEqual(true, dalObject.PasswordIsCorrect(joesUsername, joesPassword));
            Assert.AreEqual(false, dalObject.PasswordIsCorrect(joesUsername, "000"));
            Assert.AreEqual(false, dalObject.PasswordIsCorrect("000", joesPassword));

            //checking roles for a user
            Assert.AreEqual(false, dalObject.IsAdmin(joesUsername));
            Assert.AreEqual(false, dalObject.IsResearcher(joesUsername));
            Assert.AreEqual(false, dalObject.IsTechnician(joesUsername));
            Assert.AreEqual(false, dalObject.IsPartner(joesUsername));

            //adding and removing roles for a user
            dalObject.AddAdminRole(joesUsername);
            Assert.AreEqual(true, dalObject.IsAdmin(joesUsername));
            Assert.AreEqual(false, dalObject.IsResearcher(joesUsername));
            Assert.AreEqual(false, dalObject.IsTechnician(joesUsername));
            Assert.AreEqual(false, dalObject.IsPartner(joesUsername));

            dalObject.RemoveAdminRole(joesUsername);
            dalObject.AddResearchRole(joesUsername);
            Assert.AreEqual(false, dalObject.IsAdmin(joesUsername));
            Assert.AreEqual(true, dalObject.IsResearcher(joesUsername));
            Assert.AreEqual(false, dalObject.IsTechnician(joesUsername));
            Assert.AreEqual(false, dalObject.IsPartner(joesUsername));

            dalObject.RemoveResearchRole(joesUsername);
            dalObject.AddTechRole(joesUsername);
            Assert.AreEqual(false, dalObject.IsAdmin(joesUsername));
            Assert.AreEqual(false, dalObject.IsResearcher(joesUsername));
            Assert.AreEqual(true, dalObject.IsTechnician(joesUsername));
            Assert.AreEqual(false, dalObject.IsPartner(joesUsername));

            dalObject.RemoveTechRole(joesUsername);
            dalObject.AddPartnerRole(joesUsername);
            Assert.AreEqual(false, dalObject.IsAdmin(joesUsername));
            Assert.AreEqual(false, dalObject.IsResearcher(joesUsername));
            Assert.AreEqual(false, dalObject.IsTechnician(joesUsername));
            Assert.AreEqual(true, dalObject.IsPartner(joesUsername));

            dalObject.RemovePartnerRole(joesUsername);
            Assert.AreEqual(false, dalObject.IsAdmin(joesUsername));
            Assert.AreEqual(false, dalObject.IsResearcher(joesUsername));
            Assert.AreEqual(false, dalObject.IsTechnician(joesUsername));
            Assert.AreEqual(false, dalObject.IsPartner(joesUsername));

            //Changing a user's password
            joesPassword = "******";
            dalObject.ChangeUsersPassword(joesUsername, joesPassword);
            Assert.AreEqual(true, dalObject.PasswordIsCorrect(joesUsername, joesPassword));
        }