public void Add(TimeCard timeCard)
{
using (ISession session = NHibernateHelper.OpenSession())
using (ITransaction transaction = session.BeginTransaction())
{
session.Save(timeCard);
transaction.Commit();
}
}
public void Can_add_multiple_new_timeCards()
{
ISession session = _sessionFactory.OpenSession();
int countBefore = getTimeCardTableSize(session);
ITransaction tx = session.BeginTransaction();
TimeCard timeCard1 = new TimeCard();
timeCard1.TimeIn = DateTime.Now;
timeCard1.TimeOut = timeCard1.TimeIn.AddHours(8);
timeCard1.User = _user;
session.Save(timeCard1);
TimeCard timeCard2 = new TimeCard();
timeCard2.TimeIn = DateTime.Now.AddDays(1);
timeCard2.TimeOut = timeCard2.TimeIn.AddHours(8);
timeCard2.User = _user;
session.Save(timeCard2);
TimeCard timeCard3 = new TimeCard();
timeCard3.TimeIn = DateTime.Now.AddDays(2);
timeCard3.TimeOut = timeCard3.TimeIn.AddHours(8);
timeCard3.User = _user;
session.Save(timeCard3);
tx.Commit();
Assert.AreEqual(countBefore + 3, getTimeCardTableSize(session));
tx = session.BeginTransaction();
session.Delete(timeCard1);
session.Delete(timeCard2);
session.Delete(timeCard3);
tx.Commit();
session.Close();
}
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);
}
private void timeInButton_Click(object sender, System.EventArgs e)
{
TimeCardRepository timeCardRepository = new TimeCardRepository();
TimeCard timeCard = new TimeCard();
timeCard.User = session.GetUser();
timeCard.TimeIn = DateTime.Now;
timeCardRepository.Add(timeCard);
// disable time in button now that time in has been
// entered, and enable time out button.
this.timeInButton.Visible = false;
this.timeOutButton.Visible = true;
// call the time card user control's time out
// button clicked method.
timeCardUserControl.PayrollTracker_TimeOutButtonClickedEventHandler(this, e);
}
private bool IsInCollection(TimeCard timeCard, ICollection<TimeCard> fromDb)
{
bool result = false;
foreach (var item in fromDb)
{
if (timeCard.TimeCardId == item.TimeCardId)
{
result = true;
break;
}
}
return result;
}
