public void Can_add_new_daycare() { DateTime date = DateTime.Now; // Set the Milliseconds to 0 since MySQL DATETIME does not support milliseconds. date = DateTime.ParseExact(date.ToString(), "M/d/yyyy h:mm:ss tt", null); var daycare = new Daycare(date, _dog1, _daycareCost, _user1); IDaycareRepository repository = new DaycareRepository(); repository.Add(daycare); // use session to try to load the daycare using (ISession session = _sessionFactory.OpenSession()) { var fromDb = session.Get<Daycare>(daycare.DaycareId); // Test that the daycare was successfully inserted Assert.IsNotNull(fromDb); Assert.AreNotSame(daycare, fromDb); Assert.AreEqual(daycare.Date, fromDb.Date); Assert.AreEqual(daycare.Dog, fromDb.Dog); Assert.AreEqual(daycare.DaycareCost, fromDb.DaycareCost); Assert.AreEqual(daycare.User, fromDb.User); } repository.Remove(daycare); }
public void Update(Daycare daycare) { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction transaction = session.BeginTransaction()) { session.Update(daycare); transaction.Commit(); } }
public void Can_add_multiple_new_daycares() { ISession session = _sessionFactory.OpenSession(); int countBefore = getDaycareTableSize(session); ITransaction tx = session.BeginTransaction(); Daycare daycare1 = new Daycare(); daycare1.Date = DateTime.Now; daycare1.Dog = _dog1; daycare1.DaycareCost = _daycareCost; daycare1.User = _user1; session.Save(daycare1); Daycare daycare2 = new Daycare(); daycare2.Date = DateTime.Now; daycare2.Dog = _dog2; daycare2.DaycareCost = _daycareCost; daycare2.User = _user2; session.Save(daycare2); Daycare daycare3 = new Daycare(); daycare3.Date = DateTime.Now; daycare3.Dog = _dog1; daycare3.DaycareCost = _daycareCost; daycare3.User = _user1; session.Save(daycare3); tx.Commit(); Assert.AreEqual(countBefore + 3, getDaycareTableSize(session)); tx = session.BeginTransaction(); session.Delete(daycare1); session.Delete(daycare2); session.Delete(daycare3); tx.Commit(); session.Close(); }
private bool IsInCollection(Daycare daycare, ICollection<Daycare> fromDb) { bool result = false; foreach (var item in fromDb) { if (daycare.DaycareId == item.DaycareId) { result = true; break; } } return result; }
private void CreateInitialData() { using (ISession session = _sessionFactory.OpenSession()) using (ITransaction transaction = session.BeginTransaction()) { // Save the user to populate its UserId. session.Save(_user1); session.Save(_user2); session.Save(_dog1); session.Save(_dog2); session.Save(_daycareCost); // Get rid of milliseconds to make comparisons work, since MySQL // DateTime does not support milliseconds. DateTime date = DateTime.ParseExact(DateTime.Now.ToString(), "M/d/yyyy h:mm:ss tt", null); _daycares = new Daycare [4]; _daycares[0] = new Daycare(date, _dog1, _daycareCost, _user1); _daycares[1] = new Daycare(date, _dog1, _daycareCost, _user2); _daycares[2] = new Daycare(date, _dog2, _daycareCost, _user1); _daycares[3] = new Daycare(date, _dog2, _daycareCost, _user2); foreach (var daycare in _daycares) { session.Save(daycare); } transaction.Commit(); } }