public void Can_get_all()
{
IAccountCategoryRepository repository = new AccountCategoryRepository();
var fromDb = repository.GetAll();
Assert.AreEqual(4, fromDb.Count);
Assert.IsTrue(IsInCollection(_accountCategories[0], fromDb));
Assert.IsTrue(IsInCollection(_accountCategories[1], fromDb));
Assert.IsTrue(IsInCollection(_accountCategories[2], fromDb));
Assert.IsTrue(IsInCollection(_accountCategories[3], fromDb));
}
private static void ExportAccountCategories(OleDbConnection dbConnection)
{
OleDbCommand createTable = new OleDbCommand("CREATE TABLE `AccountCategories` (" +
"`Name` LongText, " +
"`Colour` LongText, " +
"`IsValid` LongText" +
")", dbConnection);
createTable.ExecuteNonQuery();
AccountCategoryRepository repository = new AccountCategoryRepository();
var accountCategories = repository.GetAll();
foreach (AccountCategory a in accountCategories)
{
string insertStatement = "INSERT INTO [AccountCategories] ([Name], [Colour], [IsValid]) VALUES ('" +
a.Name + "', '" +
a.Colour + "', '" +
a.IsValid + "')";
OleDbCommand insert = new OleDbCommand(insertStatement, dbConnection);
insert.ExecuteNonQuery();
}
}
