public void PayrollTracker_DeleteButtonClickedEventHandler(object sender, EventArgs e)
        {
            PickupDropoffRepository repository = new PickupDropoffRepository();
            foreach (KeyValuePair<int, PickupDropoff> entry in deleteObjectsMap)
            {
                PickupDropoff pickupDropoff = entry.Value;

                if (pickupDropoff.PickupDropoffId != null)
                {
                    repository.Remove(pickupDropoff);
                }
            }

            deleteObjectsMap = new Dictionary<int, PickupDropoff>();
            refreshDisplayFromDatabase();
        }
        public void Can_add_new_pickupDropoff()
        {
            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 pickupDropoff = new PickupDropoff(date, _dog1, _user1);
            IPickupDropoffRepository repository = new PickupDropoffRepository();
            repository.Add(pickupDropoff);

            // use session to try to load the pickupDropoff
            using (ISession session = _sessionFactory.OpenSession())
            {
                var fromDb = session.Get<PickupDropoff>(pickupDropoff.PickupDropoffId);
                // Test that the pickupDropoff was successfully inserted
                Assert.IsNotNull(fromDb);
                Assert.AreNotSame(pickupDropoff, fromDb);
                Assert.AreEqual(pickupDropoff.Date, fromDb.Date);
                Assert.AreEqual(pickupDropoff.Dog, fromDb.Dog);
                Assert.AreEqual(pickupDropoff.User, fromDb.User);
            }

            repository.Remove(pickupDropoff);
        }
        private void DeleteInitialData()
        {
            IPickupDropoffRepository pickupDropoffRepository = new PickupDropoffRepository();
            foreach (var pickupDropoff in _pickupDropoffs)
            {
                PickupDropoff fromDb = pickupDropoffRepository.GetById(pickupDropoff.PickupDropoffId);
                if (fromDb != null)
                {
                    pickupDropoffRepository.Remove(pickupDropoff);
                }
            }

            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(_pickupCost);
            costRepository.Remove(_dropoffCost);
            costRepository.Remove(_newPickupCost);
        }
        public void Can_remove_existing_pickupDropoff()
        {
            var pickupDropoff = _pickupDropoffs[0];
            IPickupDropoffRepository repository = new PickupDropoffRepository();
            repository.Remove(pickupDropoff);

            using (ISession session = _sessionFactory.OpenSession())
            {
                var fromDb = session.Get<PickupDropoff>(pickupDropoff.PickupDropoffId);
                Assert.IsNull(fromDb);
            }
        }