public void GetAllUsersTest() { UsersSqlDAO dao = new UsersSqlDAO(connectionString); IList <User> allUsers = dao.GetAllUsers(); int testResult = allUsers.Count; int expectedResult = GetRowCount("users"); Assert.AreEqual(expectedResult, testResult); }
public void UpdateUserTest() { UsersSqlDAO dao = new UsersSqlDAO(connectionString); string updatedFirstName = "Jane"; string updatedLastName = "Doe"; string updatedRole = "Admin"; User testUser = new User(); testUser.FirstName = "John"; testUser.LastName = "Smith"; testUser.Username = "******"; testUser.Role = "User"; testUser.Password = "******"; testUser.Salt = "salt"; dao.AddUser(testUser); User updatedTestUser = new User(); updatedTestUser.FirstName = "Jane"; updatedTestUser.LastName = "Doe"; updatedTestUser.Username = "******"; updatedTestUser.Role = "Admin"; updatedTestUser.Password = "******"; updatedTestUser.Salt = "salt"; dao.UpdateUser(updatedTestUser); User finalUser = new User(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); SqlCommand cmd = new SqlCommand(getUserSql, conn); cmd.Parameters.AddWithValue("@userName", testUser.Username); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { User tempUser = new User(); tempUser.Role = Convert.ToString(reader["role"]); tempUser.FirstName = Convert.ToString(reader["firstname"]); tempUser.LastName = Convert.ToString(reader["lastname"]); finalUser = tempUser; } } Assert.AreEqual(updatedRole, finalUser.Role); Assert.AreEqual(updatedFirstName, finalUser.FirstName); Assert.AreEqual(updatedLastName, finalUser.LastName); }
public void AddUserTest() { int originalRowCount = GetRowCount("users"); UsersSqlDAO dao = new UsersSqlDAO(connectionString); User testUser = new User(); testUser.FirstName = "John"; testUser.LastName = "Smith"; testUser.Username = "******"; testUser.Role = "User"; testUser.Password = "******"; testUser.Salt = "salt"; dao.AddUser(testUser); int expectedRowCount = GetRowCount("users"); Assert.AreEqual(originalRowCount + 1, expectedRowCount); }