public void PayrollTracker_SaveButtonClickedEventHandler(object sender, EventArgs e)
{
DogRepository repository = new DogRepository();
foreach (KeyValuePair<int, Dog> entry in dirtyDogsMap)
{
Dog dog = entry.Value;
bool isValid = dataGridView1_RowValidating(entry.Key, dog);
if (isValid)
{
if (dog.DogId == null)
{
repository.Add(dog);
}
else
{
repository.Update(dog);
}
if (DogAddedOrUpdatedEvent != null)
{
DogAddedOrUpdatedEvent(this, e);
}
dirtyDogsMap = new Dictionary<int, Dog>();
refreshDisplayFromDatabase();
}
else
{
dataGridView1.Refresh();
}
}
}
public void dogAddedOrUpdated(object sender, System.EventArgs e)
{
DogRepository dogRepository = new DogRepository();
IList<Dog> dataSourceDogsList = dogRepository.GetAllDogs();
// Update the DogName column. This updates
// after a dog's name is modified or a new dog is added.
DogNameColumn.DataSource = dataSourceDogsList;
}
public void Can_add_new_dog()
{
var dog = new Dog { FirstName = "Adam", LastName = "Patel" };
IDogRepository repository = new DogRepository();
repository.Add(dog);
// use session to try to load the dog
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Dog>(dog.DogId);
// Test that the dog was successfully inserted
Assert.IsNotNull(fromDb);
Assert.AreNotSame(dog, fromDb);
Assert.AreEqual(dog.FirstName, fromDb.FirstName);
Assert.AreEqual(dog.LastName, fromDb.LastName);
}
repository.Remove(dog);
}
public void Can_remove_existing_dog()
{
var dog = _dogs[0];
IDogRepository repository = new DogRepository();
repository.Remove(dog);
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Dog>(dog.DogId);
Assert.IsNull(fromDb);
}
}
public void Can_get_existing_dog_by_id()
{
IDogRepository repository = new DogRepository();
var fromDb = repository.GetById(_dogs[1].DogId);
Assert.IsNotNull(fromDb);
Assert.AreNotSame(_dogs[1], fromDb);
Assert.AreEqual(_dogs[1].FirstName, fromDb.FirstName);
Assert.AreEqual(_dogs[1].LastName, fromDb.LastName);
}
private void DeleteInitialData()
{
IGroomingRepository groomingRepository = new GroomingRepository();
foreach (var grooming in _groomings)
{
Grooming fromDb = groomingRepository.GetById(grooming.GroomingId);
if (fromDb != null)
{
groomingRepository.Remove(grooming);
}
}
IUserRepository userRepository = new UserRepository();
userRepository.Remove(_user1);
userRepository.Remove(_user2);
IDogRepository dogRepository = new DogRepository();
dogRepository.Remove(_dog1);
dogRepository.Remove(_dog2);
IGroomingTypeRepository groomingTypeRepository = new GroomingTypeRepository();
groomingTypeRepository.Remove(_groomingType1);
groomingTypeRepository.Remove(_groomingType2);
}
private void DeleteInitialData()
{
ITrainingRepository trainingRepository = new TrainingRepository();
foreach (var training in _trainings)
{
Training fromDb = trainingRepository.GetById(training.TrainingId);
if (fromDb != null)
{
trainingRepository.Remove(training);
}
}
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(_classCost);
costRepository.Remove(_preK9DaycareCost);
costRepository.Remove(_newClassCost);
ICostTypeRepository costTypeRepository = new CostTypeRepository();
costTypeRepository.Remove(_classType);
}
private void DeleteInitialData()
{
IDaycareRepository daycareRepository = new DaycareRepository();
foreach (var daycare in _daycares)
{
Daycare fromDb = daycareRepository.GetById(daycare.DaycareId);
if (fromDb != null)
{
daycareRepository.Remove(daycare);
}
}
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(_daycareCost);
}
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);
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.IsCurrentCellDirty)
{
if (dirtyObjectsMap.Keys.Contains(e.RowIndex))
{
dirtyObjectsMap.Remove(e.RowIndex);
}
PickupDropoff pickupDropoff = new PickupDropoff();
DateTime date = (DateTime)dataGridView1.Rows[e.RowIndex].Cells["DateColumn"].Value;
pickupDropoff.Date = date;
string dogId = (string)dataGridView1.Rows[e.RowIndex].Cells["DogNameColumn"].Value;
DogRepository dogRepository = new DogRepository();
if (dogId != null)
{
Dog dog = dogRepository.GetById(dogId);
pickupDropoff.Dog = dog;
}
CostRepository costRepository = new CostRepository();
string pickupCostId = (string)dataGridView1.Rows[e.RowIndex].Cells["PickupCostColumn"].Value;
if (pickupCostId != null)
{
Cost cost = costRepository.GetById(pickupCostId);
pickupDropoff.PickupCost = cost;
}
string dropoffCostId = (string)dataGridView1.Rows[e.RowIndex].Cells["DropoffCostColumn"].Value;
if (dropoffCostId != null)
{
Cost cost = costRepository.GetById(dropoffCostId);
pickupDropoff.DropoffCost = cost;
}
pickupDropoff.User = user;
string pickupDropoffId = (string)dataGridView1.Rows[e.RowIndex].Cells["PickupDropoffIdColumn"].Value;
pickupDropoff.PickupDropoffId = pickupDropoffId;
// Add object to dirty objects map.
dirtyObjectsMap.Add(e.RowIndex, pickupDropoff);
// Remove the entry from the delete map, if
// an entry for the Daycare exists in the
// delete map already.
if (deleteObjectsMap.Keys.Contains(e.RowIndex))
{
deleteObjectsMap.Remove(e.RowIndex);
}
var isSelected = dataGridView1.Rows[e.RowIndex].Cells["SelectColumn"].Value;
if (isSelected != null && (bool)isSelected)
{
deleteObjectsMap.Add(e.RowIndex, pickupDropoff);
}
}
}
public void Can_update_existing_dog()
{
var dog = _dogs[1];
dog.FirstName = "Mango";
IDogRepository repository = new DogRepository();
repository.Update(dog);
// use session to try to load the dog
using (ISession session = _sessionFactory.OpenSession())
{
var fromDb = session.Get<Dog>(dog.DogId);
Assert.AreEqual(dog.FirstName, fromDb.FirstName);
}
}
private void BoardingUserControl_Load(object sender, EventArgs e)
{
this.dataGridView1.AutoResizeRows();
DogRepository dogRepository = new DogRepository();
IList<Dog> dataSourceDogsList = dogRepository.GetAllDogs();
DogNameColumn.DataSource = dataSourceDogsList;
DogNameColumn.DisplayMember = "FullName";
DogNameColumn.ValueMember = "DogId";
CostTypeRepository costTypeRepository = new CostTypeRepository();
CostType boardingRateCostType = costTypeRepository.GetByCostName(BOARDING_RATE_COST_TYPE);
IList<Cost> possibleCosts1 = boardingRateCostType.PossibleCosts;
ArrayList.Adapter((IList)possibleCosts1).Sort();
BoardingRateColumn.DataSource = possibleCosts1;
BoardingRateColumn.DisplayMember = "CostValue";
BoardingRateColumn.ValueMember = "CostId";
CostType sundayDaycareCostType = costTypeRepository.GetByCostName(SUNDAY_DAYCARE_COST_TYPE);
IList<Cost> possibleCosts2 = sundayDaycareCostType.PossibleCosts;
ArrayList.Adapter((IList)possibleCosts2).Sort();
SundayDaycareColumn.DataSource = possibleCosts2;
SundayDaycareColumn.DisplayMember = "CostValue";
SundayDaycareColumn.ValueMember = "CostId";
refreshDisplayFromDatabase();
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.IsCurrentCellDirty)
{
if (dirtyBoardingsMap.Keys.Contains(e.RowIndex))
{
dirtyBoardingsMap.Remove(e.RowIndex);
}
Boarding boarding = new Boarding();
DateTime date = (DateTime)dataGridView1.Rows[e.RowIndex].Cells["DateColumn"].Value;
boarding.Date = date;
string daycareNonDaycare = (string)dataGridView1.Rows[e.RowIndex].Cells["DaycareOrNonDaycareColumn"].Value;
bool isDaycare = "Daycare".Equals(daycareNonDaycare) ? true : false;
boarding.IsDaycare = isDaycare;
string dogId = (string)dataGridView1.Rows[e.RowIndex].Cells["DogNameColumn"].Value;
DogRepository dogRepository = new DogRepository();
if (dogId != null)
{
Dog dog = dogRepository.GetById(dogId);
boarding.Dog = dog;
}
CostRepository costRepository = new CostRepository();
string boardingCostId = (string)dataGridView1.Rows[e.RowIndex].Cells["BoardingRateColumn"].Value;
if (boardingCostId != null)
{
Cost boardingCost = costRepository.GetById(boardingCostId);
boarding.BoardingCost = boardingCost;
}
string sundayDaycareCostId = (string)dataGridView1.Rows[e.RowIndex].Cells["SundayDaycareColumn"].Value;
if (sundayDaycareCostId != null)
{
Cost sundayDaycareCost = costRepository.GetById(sundayDaycareCostId);
boarding.SundayDaycareCost = sundayDaycareCost;
}
string tipStr = (string)dataGridView1.Rows[e.RowIndex].Cells["TipColumn"].Value;
try
{
Double tip = Convert.ToDouble(tipStr);
boarding.Tip = tip;
}
catch (FormatException exception)
{
//Catch this exception quietly for now.
}
boarding.User = user;
string boardingId = (string)dataGridView1.Rows[e.RowIndex].Cells["BoardingIdColumn"].Value;
boarding.BoardingId = boardingId;
dirtyBoardingsMap.Add(e.RowIndex, boarding);
// Remove the entry from the delete map, if
// an entry for the Boarding exists in the
// delete map already.
if (deleteBoardingsMap.Keys.Contains(e.RowIndex))
{
deleteBoardingsMap.Remove(e.RowIndex);
}
var isSelected = dataGridView1.Rows[e.RowIndex].Cells["SelectColumn"].Value;
if (isSelected != null && (bool)isSelected)
{
deleteBoardingsMap.Add(e.RowIndex, boarding);
}
}
}
private void initializeDataGridComponentsDatasources()
{
DogRepository dogRepository = new DogRepository();
IList<Dog> dataSourceDogsList = dogRepository.GetAllDogs();
DogNameColumn.DataSource = dataSourceDogsList;
DogNameColumn.DisplayMember = "FullName";
DogNameColumn.ValueMember = "DogId";
GroomingTypeRepository groomingTypeRepository = new GroomingTypeRepository();
IList<GroomingType> groomingTypes = groomingTypeRepository.GetAllGroomingTypes();
GroomTypeColumn.DataSource = groomingTypes;
GroomTypeColumn.DisplayMember = "TypeName";
GroomTypeColumn.ValueMember = "GroomingTypeId";
}
private void groomingDataGridView_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (groomingDataGridView.IsCurrentCellDirty)
{
if (dirtyObjectsMap.Keys.Contains(e.RowIndex))
{
dirtyObjectsMap.Remove(e.RowIndex);
}
Grooming grooming = new Grooming();
DateTime date = (DateTime)groomingDataGridView.Rows[e.RowIndex].Cells["DateColumn"].Value;
grooming.Date = date;
string dogId = (string)groomingDataGridView.Rows[e.RowIndex].Cells["DogNameColumn"].Value;
DogRepository dogRepository = new DogRepository();
if (dogId != null)
{
Dog dog = dogRepository.GetById(dogId);
grooming.Dog = dog;
}
GroomingTypeRepository groomingTypeRepository = new GroomingTypeRepository();
string groomingTypeId = (string)groomingDataGridView.Rows[e.RowIndex].Cells["GroomTypeColumn"].Value;
if (groomingTypeId != null)
{
GroomingType groomingType = groomingTypeRepository.GetById(groomingTypeId);
grooming.GroomingType = groomingType;
}
string costStr = (string)groomingDataGridView.Rows[e.RowIndex].Cells["CostColumn"].Value;
if (costStr != null)
{
try
{
Double cost = Convert.ToDouble(costStr);
grooming.Cost = cost;
}
catch (FormatException exception)
{
//Catch this exception quietly.
}
}
string tipStr = (string)groomingDataGridView.Rows[e.RowIndex].Cells["TipColumn"].Value;
if (tipStr != null)
{
try
{
Double tip = Convert.ToDouble(tipStr);
grooming.Tip = tip;
}
catch (FormatException exception)
{
//Catch this exception quietly.
}
}
grooming.User = user;
string groomingId = (string)groomingDataGridView.Rows[e.RowIndex].Cells["GroomingIdColumn"].Value;
grooming.GroomingId = groomingId;
// Add object to dirty objects map.
dirtyObjectsMap.Add(e.RowIndex, grooming);
// Remove the entry from the delete map, if
// an entry for the Daycare exists in the
// delete map already.
if (deleteObjectsMap.Keys.Contains(e.RowIndex))
{
deleteObjectsMap.Remove(e.RowIndex);
}
var isSelected = groomingDataGridView.Rows[e.RowIndex].Cells["SelectColumn"].Value;
if (isSelected != null && (bool)isSelected)
{
deleteObjectsMap.Add(e.RowIndex, grooming);
}
}
}
private void initializeDataGridComponentsDatasources()
{
DogRepository dogRepository = new DogRepository();
IList<Dog> dataSourceDogsList = dogRepository.GetAllDogs();
DogNameColumn.DataSource = dataSourceDogsList;
DogNameColumn.DisplayMember = "FullName";
DogNameColumn.ValueMember = "DogId";
CostTypeRepository costTypeRepository = new CostTypeRepository();
IList<CostType> trainingCostTypes = costTypeRepository.GetAllSimilarCostTypes(CLASS_COST_TYPE);
ClassColumn.DataSource = trainingCostTypes;
ClassColumn.DisplayMember = "CostName";
ClassColumn.ValueMember = "CostTypeId";
CostType preK9DaycareCostType = costTypeRepository.GetByCostName(PRE_K9_DAYCARE_COST_TYPE);
IList<Cost> possibleCosts1 = preK9DaycareCostType.PossibleCosts;
ArrayList.Adapter((IList)possibleCosts1).Sort();
PreK9DaycareCostColumn.DataSource = possibleCosts1;
PreK9DaycareCostColumn.DisplayMember = "CostValue";
PreK9DaycareCostColumn.ValueMember = "CostId";
CostOfClassColumn.DataSource = bindingSource;
}
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.IsCurrentCellDirty)
{
if (dirtyObjectsMap.Keys.Contains(e.RowIndex))
{
dirtyObjectsMap.Remove(e.RowIndex);
}
Training training = new Training();
DateTime date = (DateTime)dataGridView1.Rows[e.RowIndex].Cells["DateColumn"].Value;
training.Date = date;
string dogId = (string)dataGridView1.Rows[e.RowIndex].Cells["DogNameColumn"].Value;
DogRepository dogRepository = new DogRepository();
if (dogId != null)
{
Dog dog = dogRepository.GetById(dogId);
training.Dog = dog;
}
CostRepository costRepository = new CostRepository();
CostTypeRepository costTypeRepository = new CostTypeRepository();
string classTypeId = (string)dataGridView1.Rows[e.RowIndex].Cells["ClassColumn"].Value;
if (classTypeId != null)
{
CostType costType = costTypeRepository.GetById(classTypeId);
training.ClassType = costType;
// If Class column value is Pre-K9, then enable Pre-K9 Daycare
// Cost column.
if (TRAINING_CLASS_PRE_K9.Equals(costType.CostName))
{
DataGridViewComboBoxCell preK9DaycareComboBoxCell = (DataGridViewComboBoxCell)dataGridView1.Rows[e.RowIndex].Cells["PreK9DaycareCostColumn"];
preK9DaycareComboBoxCell.ReadOnly = false;
}
else
{
DataGridViewComboBoxCell preK9DaycareComboBoxCell = (DataGridViewComboBoxCell)dataGridView1.Rows[e.RowIndex].Cells["PreK9DaycareCostColumn"];
preK9DaycareComboBoxCell.ReadOnly = true;
}
// Has Class column combobox value changed?
if (e.ColumnIndex == 3)
{
// Yes, Class column value has changed, so update
// Class Cost column combobox with appropriate
// values for new Class.
// Sort the costs.
IList<Cost> possibleCosts1 = costType.PossibleCosts;
ArrayList.Adapter((IList)possibleCosts1).Sort();
DataGridViewComboBoxCell cell = (DataGridViewComboBoxCell)(dataGridView1.Rows[e.RowIndex].Cells["CostOfClassColumn"]);
// Now that a class type has been selected, we can populate
// the cost of class drop down box appropriately.
cell.Value = null;
cell.DataSource = null;
if (cell.Items != null)
{
cell.Items.Clear();
}
cell.DataSource = possibleCosts1;
cell.DisplayMember = "CostValue";
cell.ValueMember = "CostId";
}
}
string classCostId = (string)dataGridView1.Rows[e.RowIndex].Cells["CostOfClassColumn"].Value;
if (classCostId != null)
{
Cost cost = costRepository.GetById(classCostId);
training.ClassCost = cost;
}
string preK9DaycareCostId = (string)dataGridView1.Rows[e.RowIndex].Cells["PreK9DaycareCostColumn"].Value;
if (preK9DaycareCostId != null)
{
Cost cost = costRepository.GetById(preK9DaycareCostId);
training.PreK9DaycareCost = cost;
}
training.User = user;
string trainingId = (string)dataGridView1.Rows[e.RowIndex].Cells["TrainingIdColumn"].Value;
training.TrainingId = trainingId;
// Add object to dirty objects map.
if (!dirtyObjectsMap.Keys.Contains(e.RowIndex))
{
dirtyObjectsMap.Add(e.RowIndex, training);
}
// Remove the entry from the delete map, if
// an entry for the Daycare exists in the
// delete map already.
if (deleteObjectsMap.Keys.Contains(e.RowIndex))
{
deleteObjectsMap.Remove(e.RowIndex);
}
var isSelected = dataGridView1.Rows[e.RowIndex].Cells["SelectColumn"].Value;
if (isSelected != null && (bool)isSelected)
{
deleteObjectsMap.Add(e.RowIndex, training);
}
}
}
private void initializeDataGridComponentsDatasources()
{
DogRepository dogRepository = new DogRepository();
IList<Dog> dataSourceDogsList = dogRepository.GetAllDogs();
DogNameColumn.DataSource = dataSourceDogsList;
DogNameColumn.DisplayMember = "FullName";
DogNameColumn.ValueMember = "DogId";
CostTypeRepository costTypeRepository = new CostTypeRepository();
CostType pickupCostType = costTypeRepository.GetByCostName(PICKUP_COST_TYPE);
IList<Cost> possibleCosts1 = pickupCostType.PossibleCosts;
ArrayList.Adapter((IList)possibleCosts1).Sort();
PickupCostColumn.DataSource = possibleCosts1;
PickupCostColumn.DisplayMember = "CostValue";
PickupCostColumn.ValueMember = "CostId";
CostType dropoffCostType = costTypeRepository.GetByCostName(DROPOFF_COST_TYPE);
IList<Cost> possibleCosts2 = dropoffCostType.PossibleCosts;
ArrayList.Adapter((IList)possibleCosts2).Sort();
DropoffCostColumn.DataSource = possibleCosts2;
DropoffCostColumn.DisplayMember = "CostValue";
DropoffCostColumn.ValueMember = "CostId";
}
private void DeleteInitialData()
{
IDogRepository repository = new DogRepository();
foreach (var dog in _dogs)
{
Dog fromDb = repository.GetById(dog.DogId);
if (fromDb != null)
{
repository.Remove(dog);
}
}
}
private void refreshDisplayFromDatabase()
{
this.dataGridView1.Rows.Clear();
DogRepository repository = new DogRepository();
IList<Dog> dogsList = repository.GetAllDogs();
foreach (Dog dog in dogsList)
{
int index = this.dataGridView1.Rows.Add();
dataGridView1.Rows[index].Cells["DogFirstNameColumn"].Value = dog.FirstName;
dataGridView1.Rows[index].Cells["DogLastNameColumn"].Value = dog.LastName;
dataGridView1.Rows[index].Cells["DogIdColumn"].Value = dog.DogId;
}
}
public void Can_get_existing_dogs_by_first_name()
{
IDogRepository repository = new DogRepository();
var fromDb = repository.GetByFirstName(_dogs[1].FirstName);
Assert.AreEqual(1, fromDb.Count);
Assert.IsTrue(IsInCollection(_dogs[1], fromDb));
}
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);
}
