public void DBConnectorTestGetUsername()
{
DBConnector testConnection = new DBConnector();
try
{
testConnection.connectToDB();
Assert.AreEqual("jbuena", testConnection.getConnectedUser("349ADEAA08EA"));
testConnection.disconnectFromDB();
}
catch
{
Assert.Inconclusive();
}
}
public void DBConnectorTestGetData()
{
DBConnector testConnection = new DBConnector();
try
{
testConnection.connectToDB();
Dictionary<string, string> testinfo = new Dictionary<string, string>();
testinfo = testConnection.getUserData("jbuena");
Assert.AreEqual(testinfo["firstName"], "Jamar");
Assert.AreEqual(testinfo["lastName"], "Buena");
Assert.AreEqual(testinfo["userName"], "jbuena");
Assert.AreEqual(testinfo["city"], "Conshohocken");
Assert.AreEqual(testinfo["department"], "Creative");
Assert.AreEqual(testinfo["email"], "*****@*****.**");
testConnection.disconnectFromDB();
}
catch
{
Assert.Inconclusive();
}
}
public void DBConnecterTestErrorHanding()
{
DBConnector testConnection2 = new DBConnector("notaserver.com","notadatabase","yes","notauid","notthepassword");
Assert.Throws<System.Data.SqlClient.SqlException>(new TestDelegate(testConnection2.connectToDB));
}
public void DBConnectorTestConnection()
{
DBConnector testConnection = new DBConnector();
Assert.DoesNotThrow(new TestDelegate(testConnection.connectToDB));
Assert.DoesNotThrow(new TestDelegate(testConnection.disconnectFromDB));
}
public JSONBuilder()
{
dbcon = new DBConnector();
}
