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