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