public void AfterTest4() { DatabaseConnector db = new DatabaseConnector(); DateTime dt = new DateTime(2011, 09, 30); db.ApplyFilters(false, false, true, dt); var dbConnection = new DatabaseConnector().GetConnection; dbConnection.Open(); var sql = "SELECT * FROM orders WHERE order_date >= '2011-09-30'"; var expectedResult = dbConnection.Query(sql); dbConnection.Close(); Assert.AreEqual(db.TotalOrderList.Count, expectedResult.Count()); }
public void BeforeTest3() { DatabaseConnector db = new DatabaseConnector(); DateTime dt = new DateTime(2010, 12, 17); db.ApplyFilters(true, false, false, dt); var dbConnection = new DatabaseConnector().GetConnection; dbConnection.Open(); var sql = "SELECT * FROM orders WHERE order_date <= '2010-12-17'"; var expectedResult = dbConnection.Query(sql); dbConnection.Close(); Assert.AreEqual(db.TotalOrderList.Count, expectedResult.Count()); }