public void PayrollTracker_DeleteButtonClickedEventHandler(object sender, EventArgs e)
{
BoardingRepository boardingRepository = new BoardingRepository();
foreach (KeyValuePair<int, Boarding> entry in deleteBoardingsMap)
{
Boarding boarding = entry.Value;
if (boarding.BoardingId != null)
{
boardingRepository.Remove(boarding);
}
}
deleteBoardingsMap = new Dictionary<int, Boarding>();
refreshDisplayFromDatabase();
}
public void PayrollTracker_SaveButtonClickedEventHandler(object sender, EventArgs e)
{
BoardingRepository boardingRepository = new BoardingRepository();
foreach (KeyValuePair<int, Boarding> entry in dirtyBoardingsMap)
{
Boarding boarding = entry.Value;
bool isValid = dataGridView1_RowValidating(entry.Key, boarding);
if (isValid)
{
if (boarding.BoardingId == null)
{
boardingRepository.Add(boarding);
}
else
{
boardingRepository.Update(boarding);
}
dirtyBoardingsMap = new Dictionary<int, Boarding>();
refreshDisplayFromDatabase();
}
}
}
public void Can_add_new_boarding()
{
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 boarding = new Boarding(date, true, _dog1, _boardingCost, _user1);
IBoardingRepository repository = new BoardingRepository();
repository.Add(boarding);
// use session to try to load the boarding
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Boarding>(boarding.BoardingId);
// Test that the boarding was successfully inserted
Assert.IsNotNull(fromDb);
Assert.AreNotSame(boarding, fromDb);
Assert.AreEqual(boarding.Date, fromDb.Date);
Assert.AreEqual(boarding.IsDaycare, fromDb.IsDaycare);
Assert.AreEqual(boarding.Dog, fromDb.Dog);
Assert.AreEqual(boarding.BoardingCost, fromDb.BoardingCost);
Assert.AreEqual(boarding.SundayDaycareCost, fromDb.SundayDaycareCost);
Assert.AreEqual(boarding.User, fromDb.User);
}
repository.Remove(boarding);
}
private void refreshDisplayFromDatabase()
{
this.dataGridView1.Rows.Clear();
BoardingRepository boardingRepository = new BoardingRepository();
IList<Boarding> boardingsList = boardingRepository.GetRecentBoardings(user, payrollStartDate, payrollEndDate);
foreach (Boarding boarding in boardingsList)
{
int index = this.dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells["DateColumn"].Value = boarding.Date;
dataGridView1.Rows[index].Cells["DogNameColumn"].Value = boarding.Dog.DogId;
string daycareOrNonDaycare = "Non-daycare";
if (boarding.IsDaycare)
{
daycareOrNonDaycare = "Daycare";
}
dataGridView1.Rows[index].Cells["DaycareOrNonDaycareColumn"].Value = daycareOrNonDaycare;
dataGridView1.Rows[index].Cells["BoardingRateColumn"].Value = boarding.BoardingCost.CostId;
if (boarding.SundayDaycareCost != null)
{
dataGridView1.Rows[index].Cells["SundayDaycareColumn"].Value = boarding.SundayDaycareCost.CostId;
}
dataGridView1.Rows[index].Cells["TipColumn"].Value = boarding.Tip.ToString();
dataGridView1.Rows[index].Cells["BoardingIdColumn"].Value = boarding.BoardingId;
}
}
private void DeleteInitialData()
{
IBoardingRepository boardingRepository = new BoardingRepository();
foreach (var boarding in _boardings)
{
Boarding fromDb = boardingRepository.GetById(boarding.BoardingId);
if (fromDb != null)
{
boardingRepository.Remove(boarding);
}
}
IUserRepository userRepository = new UserRepository();
userRepository.Remove(_user1);
userRepository.Remove(_user2);
IDogRepository dogRepository = new DogRepository();
dogRepository.Remove(_dog1);
dogRepository.Remove(_dog2);
ICostRepository costRepository = new CostRepository();
costRepository.Remove(_boardingCost);
costRepository.Remove(_sundayDaycareCost);
}
public void Can_update_existing_boarding()
{
var boarding = _boardings[1];
boarding.Tip = 30.00;
IBoardingRepository repository = new BoardingRepository();
repository.Update(boarding);
// use session to try to load the boarding
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Boarding>(boarding.BoardingId);
Assert.AreEqual(boarding.Tip, fromDb.Tip);
}
}
public void Can_remove_existing_boarding()
{
var boarding = _boardings[0];
IBoardingRepository repository = new BoardingRepository();
repository.Remove(boarding);
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Boarding>(boarding.BoardingId);
Assert.IsNull(fromDb);
}
}
public void Can_get_existing_boarding_by_id()
{
IBoardingRepository repository = new BoardingRepository();
var fromDb = repository.GetById(_boardings[1].BoardingId);
Assert.IsNotNull(fromDb);
Assert.AreNotSame(_boardings[1], fromDb);
Assert.AreEqual(_boardings[1].Date, fromDb.Date);
Assert.AreEqual(_boardings[1].IsDaycare, fromDb.IsDaycare);
Assert.AreEqual(_boardings[1].Dog, fromDb.Dog);
Assert.AreEqual(_boardings[1].BoardingCost, fromDb.BoardingCost);
Assert.AreEqual(_boardings[1].SundayDaycareCost, fromDb.SundayDaycareCost);
Assert.AreEqual(_boardings[1].User, fromDb.User);
}
public void Can_get_existing_boardings_by_user_id()
{
IBoardingRepository repository = new BoardingRepository();
var fromDb = repository.GetByUser(_boardings[1].User);
Assert.AreEqual(2, fromDb.Count);
Assert.IsTrue(IsInCollection(_boardings[1], fromDb));
}