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(); }