private void DeleteInitialData() { ITimeCardRepository timeCardRepository = new TimeCardRepository(); foreach (var timeCard in _timeCards) { TimeCard fromDb = timeCardRepository.GetById(timeCard.TimeCardId); if (fromDb != null) { timeCardRepository.Remove(timeCard); } } IUserRepository userRepository = new UserRepository(); userRepository.Remove(_user); }
public void Can_add_new_timeCard() { DateTime timeIn = DateTime.Now; // Set the Milliseconds to 0 since MySQL DATETIME does not support milliseconds. timeIn = DateTime.ParseExact(timeIn.ToString(), "M/d/yyyy h:mm:ss tt", null); DateTime timeOut = timeIn.AddHours(8); var timeCard = new TimeCard { TimeIn = timeIn, TimeOut = timeOut, User = _user }; ITimeCardRepository repository = new TimeCardRepository(); repository.Add(timeCard); // use session to try to load the timeCard using (ISession session = _sessionFactory.OpenSession()) { var fromDb = session.Get<TimeCard>(timeCard.TimeCardId); // Test that the timeCard was successfully inserted Assert.IsNotNull(fromDb); Assert.AreNotSame(timeCard, fromDb); Assert.AreEqual(timeCard.TimeIn, fromDb.TimeIn); Assert.AreEqual(timeCard.TimeOut, fromDb.TimeOut); Assert.AreEqual(timeCard.User, fromDb.User); } repository.Remove(timeCard); }
public void Can_remove_existing_timeCard() { var timeCard = _timeCards[0]; ITimeCardRepository repository = new TimeCardRepository(); repository.Remove(timeCard); using (ISession session = _sessionFactory.OpenSession()) { var fromDb = session.Get<TimeCard>(timeCard.TimeCardId); Assert.IsNull(fromDb); } }