public void can_add_new_person_with_phone_number() { GenerateDatabaseSchema(); Person p = new Person() { Id = 1, Forename = "Jimmy", Surname = "Choo", BirthdayDay = 1, BirthdayMonth = 1 }; PhoneNumber num = new PhoneNumber(1, "12345678"); p.AddPhoneNumber(num); IPersonRepository repository = new PersonRepository(); repository.Add(p); using (ISession session = _sessionFactory.OpenSession()) { Person databasePerson; databasePerson = session.Get<Person>(p.Id); Assert.IsNotNull(databasePerson, "Person not loaded from Database"); Assertions.AssertPeopleAreEqual(p, databasePerson); Assert.AreEqual(1, databasePerson.PhoneNumbers.Count, "List does not contain one phone number"); foreach (PhoneNumber number in databasePerson.PhoneNumbers) { Assert.AreEqual(num.Id, number.Id, "Id of phone number not equal"); Assert.AreEqual(num.Number, number.Number, "Id of phone number not equal"); } } }
public void can_add_new_person() { GenerateDatabaseSchema(); Person p = new Person() { Id = 1, Forename = "Jimmy", Surname = "Choo", BirthdayDay = 1, BirthdayMonth = 1 }; IPersonRepository repository = new PersonRepository(); repository.Add(p); using (ISession session = _sessionFactory.OpenSession()) { Person databasePerson; databasePerson = session.Get<Person>(p.Id); Assert.IsNotNull(databasePerson, "Person not loaded from Database"); Assertions.AssertPeopleAreEqual(p, databasePerson); } }
public void can_add_new_person_with_email() { GenerateDatabaseSchema(); Person p = new Person() { Id = 1, Forename = "Jimmy", Surname = "Choo", BirthdayDay = 1, BirthdayMonth = 1 }; p.AddEmail("*****@*****.**"); IPersonRepository repository = new PersonRepository(); repository.Add(p); using (ISession session = _sessionFactory.OpenSession()) { Person databasePerson; databasePerson = session.Get<Person>(p.Id); Assert.IsNotNull(databasePerson, "Person not loaded from Database"); Assertions.AssertPeopleAreEqual(p, databasePerson); Assert.IsTrue(databasePerson.EmailAddresses.Contains("*****@*****.**"), "Email address not found"); } }
public void can_save_person_list() { GenerateDatabaseSchema(); ICollection<Person> personList = new List<Person>(); personList.Add(new Person() { Id = 1, Forename = "Jimmy", Surname = "Choo", BirthdayDay = 1, BirthdayMonth = 1 }); personList.Add(new Person() { Id = 2, Forename = "Sammy", Surname = "Davis", BirthdayDay = 31, BirthdayMonth = 12 }); personList.Add(new Person() { Id = 3, Forename = "Patsy", Surname = "Kensit", BirthdayDay = 1, BirthdayMonth = 1 }); IPersonRepository repository = new PersonRepository(); repository.SaveList(personList); using (ISession session = _sessionFactory.OpenSession()) { foreach (Person p in personList) { Person databasePerson = session.Get<Person>(p.Id); Assert.IsNotNull(databasePerson, "Person not loaded from database"); Assertions.AssertPeopleAreEqual(p, databasePerson); } } }
public void can_get_all() { GenerateDatabaseSchema(); Person[] people = new Person[3]; people[0] = new Person() { Id = 1, Forename = "Jimmy", Surname = "Choo", BirthdayDay = 1, BirthdayMonth = 1 }; people[1] = new Person() { Id = 2, Forename = "Sammy", Surname = "Davis", BirthdayDay = 31, BirthdayMonth = 12 }; people[2] = new Person() { Id = 3, Forename = "Patsy", Surname = "Kensit", BirthdayDay = 1, BirthdayMonth = 1 }; AddPersonToDatabase(people[0]); AddPersonToDatabase(people[1]); AddPersonToDatabase(people[2]); IPersonRepository repository = new PersonRepository(); ICollection<Person> databasePeople = repository.GetAll(); Assert.IsNotNull(databasePeople, "Person not loaded from Database"); Assert.AreEqual(3, databasePeople.Count, "Wrong number of people loaded from database"); int arrayPerson = 0; foreach (Person p in databasePeople) { Assertions.AssertPeopleAreEqual(people[arrayPerson++], p); } }
public void can_get_by_id() { GenerateDatabaseSchema(); Person p = new Person() { Id = 1, Forename = "Jimmy", Surname = "Choo", BirthdayDay = 1, BirthdayMonth = 1 }; AddPersonToDatabase(p); IPersonRepository repository = new PersonRepository(); Person databasePerson = repository.GetById(p.Id); Assert.IsNotNull(databasePerson, "Person not loaded from Database"); Assertions.AssertPeopleAreEqual(p, databasePerson); }
public void can_remove_person() { GenerateDatabaseSchema(); Person p = new Person() { Id = 1, Forename = "Jimmy", Surname = "Choo", BirthdayDay = 1, BirthdayMonth = 1 }; AddPersonToDatabase(p); IPersonRepository repository = new PersonRepository(); repository.Remove(p); using (ISession session = _sessionFactory.OpenSession()) { Person databasePerson = session.Get<Person>(p.Id); Assert.IsNull(databasePerson, "Person found in Database when they shouldn't be"); } }