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);
}
}
