public void SetUp()
{
respiratory = CSVimporter.ImportCSV(Resources.TestCategories, Resources.TestProducts, Resources.TestOrders, Resources.TestOrder_details);
Program.ConsoleLock.Clear();
northWind = new NorthWind(respiratory);
}
private void ConnectToDatabase()
{
try
{
var db = new NORTHWNDEntities();
Console.WriteLine("Connecting NORTHWND.MDF");
db.Database.Connection.Open();
Console.WriteLine("Connected");
var respiratory = new Respiratory(db);
northWind = new NorthWind(respiratory);
Console.WriteLine("Preparing database meta data");
//Dummy query
northWind.Products().Take(0);
Console.WriteLine("Ready");
}
catch
{
}
}
public void TestFirst5Products()
{
Program.ConsoleLock.Clear();
Product[] products = new Product[6];
for (int i = 0; i < 6; i++)
{
products[i] = new Product("name" + i,null,null,""+i,i,i,i,i,i);
}
Respiratory respiratory = new Respiratory(products, new Category[0], new Order[0], new OrderDetails[0]);
NorthWind northWind = new NorthWind(respiratory);
Program.First5Products(northWind);
for (int i = 0; i < 5; i++)
{
Assert.AreEqual("name" + i, Program.ConsoleLock[i]);
}
}
public void TestOrdersByShippingCountry()
{
Program.ConsoleLock.Clear();
Order[] orders = new Order[5];
for (int i = 0; i < 3; i++)
{
orders[i] = new Order(0,
null, null,
DateTime.Parse("1996-07-08 00:00:00"),
DateTime.Parse("1996-07-08 00:00:00"),
DateTime.Parse("1996-07-08 00:00:00"),
1, 2d,
"name", "address", "city", "region", "pcode", "DK");
}
for (int i = 0; i < 2; i++)
{
orders[i+3] = new Order(0,
null, null,
DateTime.Parse("1996-07-08 00:00:00"),
DateTime.Parse("1996-07-08 00:00:00"),
DateTime.Parse("1996-07-08 00:00:00"),
1, 2d,
"name", "address", "city", "region", "pcode", "ENG");
}
Respiratory respiratory = new Respiratory(new Product[0], new Category[0], orders, new OrderDetails[0]);
NorthWind northWind = new NorthWind(respiratory);
Program.OrdersByShippingCountry(northWind);
Assert.AreEqual("ENG : 2", Program.ConsoleLock[0]);
Assert.AreEqual("DK : 3", Program.ConsoleLock[1]);
}
