//checks if user uses wrong credentials
public void FailedLogin()
{
string username = "******";
string password = "******";
string query = "SELECT * FROM 17agileteam6db.users WHERE staff_no ='" + username + "' AND pass = '******'";
DBTest db = new DBTest();
bool login = false;
MySql.Data.MySqlClient.MySqlDataReader reader = db.Select(query);
while (reader.HasRows && reader.Read())
{
string info = reader.GetString(reader.GetOrdinal("role"));
}
if (reader.HasRows)
{
login = true;
}
else
{
login = false;
}
reader.Close();
Assert.AreEqual(false, login);
}
public void SuccessHistory()
{
string user = "******";
string query = "SELECT * FROM 17agileteam6db.history WHERE user = '******'";
DBTest db = new DBTest();
string info = "";
MySql.Data.MySqlClient.MySqlDataReader reader = db.Select(query);
while (reader.HasRows && reader.Read())
{
info = reader.GetString(reader.GetOrdinal("projectAction"));
}
Assert.AreEqual("Upload", info);
}
