public void Search(string searchText, int expected)
{
var connection = Helpers.SetupConnection();
var entryDataAdapter = new EntryDataAdapter();
var phoneBookDataAdapter = new PhoneBookDataAdapter();
var phoneBook = phoneBookDataAdapter.Insert("MyPhoneBook", connection);
var myEntry = entryDataAdapter.Insert(new Entry()
{
Name = "MyEntry", PhoneBookId = phoneBook.Id
}, connection);
var myOtherEntry = entryDataAdapter.Insert(new Entry()
{
Name = "MyOtherEntry", PhoneBookId = phoneBook.Id
}, connection);
var someEntry = entryDataAdapter.Insert(new Entry()
{
Name = "SomeEntry", PhoneBookId = phoneBook.Id
}, connection);
var searchResult = entryDataAdapter.Search(searchText, phoneBook.Id, connection);
Assert.Equal(expected, searchResult.Count);
}
public void CantInsertInvalidPhoneBookId()
{
var connection = Helpers.SetupConnection();
var entryDataAdapter = new EntryDataAdapter();
Assert.Throws <Exception>(() => entryDataAdapter.Insert(new Entry()
{
Name = "MyEntry", PhoneNumber = "012 555 55555", PhoneBookId = new Guid("82D890A1-0685-4C3C-A964-90EA3DA58859")
}, connection));
}
public void CanInsertAndRetrieve()
{
var connection = Helpers.SetupConnection();
var entryDataAdapter = new EntryDataAdapter();
var phonebookDataAdapter = new PhoneBookDataAdapter();
var phoneBook = phonebookDataAdapter.Insert("MyPhoneBook", connection);
var entry = entryDataAdapter.Insert(new Entry()
{
Name = "MyEntry", PhoneNumber = "012 555 55555", PhoneBookId = phoneBook.Id
}, connection);
var retrieved = entryDataAdapter.Get(entry.Id, connection);
Assert.NotNull(retrieved);
}
