public void GetCarDealershipByName() { var data = new List <CarDealership> { new CarDealership { Name = "CarDealership1" }, new CarDealership { Name = "CarDealership2" }, new CarDealership { Name = "CarDealership3" }, }.AsQueryable(); var mockSet = new Mock <DbSet <CarDealership> >(); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.Provider).Returns(data.Provider); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.Expression).Returns(data.Expression); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.ElementType).Returns(data.ElementType); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator()); var mockContext = new Mock <CarDealershipContext>(); mockContext.Setup(m => m.CarDealerships).Returns(mockSet.Object); var service = new CarDealershipBusiness(mockContext.Object); var dealershipFound = service.GetCarDealershipByName("CarDealership1"); Assert.AreEqual("CarDealership1", dealershipFound.Name); }
public void SortDealershipsByNameDescending() { var data = new List <CarDealership> { new CarDealership { Name = "DealershipA" }, new CarDealership { Name = "DealershipC" }, new CarDealership { Name = "DealershipB" }, }.AsQueryable(); var mockSet = new Mock <DbSet <CarDealership> >(); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.Provider).Returns(data.Provider); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.Expression).Returns(data.Expression); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.ElementType).Returns(data.ElementType); mockSet.As <IQueryable <CarDealership> >().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator()); var mockContext = new Mock <CarDealershipContext>(); mockContext.Setup(m => m.CarDealerships).Returns(mockSet.Object); var service = new CarDealershipBusiness(mockContext.Object); var sortedDealerships = service.SortDealershipsByNameDescending(); Assert.AreEqual("DealershipC", sortedDealerships[0].Name); Assert.AreEqual("DealershipB", sortedDealerships[1].Name); Assert.AreEqual("DealershipA", sortedDealerships[2].Name); }
//Get logic// //Sort logic// /// <summary> /// Populate the data grid with information sorted by car dealerships' name in ascending order /// </summary> private void PopulateDataGridViewSortDealershipsByNameAscending() { dataGridView.Rows.Clear(); CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); var dealershipList = carDealershipBusiness.SortDealershipsByNameAscending(); DataPopulator(dealershipList); }
/// <summary> /// Populate the data grid with information about car dealership with given car dealership's town name /// </summary> private void PopulateDataGridViewGetDealershipsByTown() { dataGridView.Rows.Clear(); CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); var dealershipList = carDealershipBusiness.GetDealershipsByTown(txtGet.Text); DataPopulator(dealershipList); }
/// <summary> /// Populate the data grid with information about car dealership with given car dealership name /// </summary> private void PopulateDataGridViewGetCarDealershipByName() { dataGridView.Rows.Clear(); CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); var dealership = carDealershipBusiness.GetCarDealershipByName(txtGet.Text); DataPopulatorSingle(dealership); }
//Main logic// //Get logic// /// <summary> /// Populate the data grid with information about all existing car dealerships in the database /// </summary> private void PopulateDataGridViewDefault() { dataGridView.Rows.Clear(); CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); var dealershipList = carDealershipBusiness.GetAllCarDealerships(); DataPopulator(dealershipList); }
/// <summary> /// Update the input text boxes with information for a selected car dealership /// </summary> /// <param name="Id">The ID of a selected car dealership</param> private void UpdateTextBoxes(int Id) { CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); CarDealership carDealership = carDealershipBusiness.GetCarDealershipById(Id); txtName.Text = carDealership.Name; txtTown.Text = carDealership.TownId.ToString(); }
/// <summary> /// Populate the data grid with information about car dealership with given car dealership Id /// </summary> private void PopulateDataGridViewGetCarDealershipById() { dataGridView.Rows.Clear(); CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); int.TryParse(txtGet.Text, out int dealershipId); var dealership = carDealershipBusiness.GetCarDealershipById(dealershipId); DataPopulatorSingle(dealership); }
private void btnSave_Click(object sender, EventArgs e) { CarDealership carDealership = GetEditedCarDealership(); CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); carDealershipBusiness.Update(carDealership); PopulateDataGridViewDefault(); ResetSelect(); ToggleSaveUpdate(); ClearTextBoxes(); }
/// <summary> /// Populate the data grid with information for a single car dealership /// </summary> /// <param name="dealership">A single car dealership used to populate the data grid</param> private void DataPopulatorSingle(CarDealership dealership) { CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); string[] row = { dealership.Id.ToString(), dealership.Name, carDealershipBusiness.GetTownName(dealership.TownId) }; dataGridView.Rows.Add(row); }
private void btnDelete_Click(object sender, EventArgs e) { if (dataGridView.SelectedRows.Count > 0) { var dealership = dataGridView.SelectedRows[0].Cells; var dealershipId = int.Parse(dealership[0].Value.ToString()); CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); carDealershipBusiness.Delete(dealershipId); PopulateDataGridViewDefault(); ResetSelect(); } }
//Buttons + attached logic// //Data populators// /// <summary> /// Populate the data grid wiht information about car dealerships /// </summary> /// <param name="carDealerships">A list of car dealerships used to populate the data grid</param> private void DataPopulator(List <CarDealership> carDealerships) { foreach (var dealership in carDealerships) { CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); string[] row = { dealership.Id.ToString(), dealership.Name, carDealershipBusiness.GetTownName(dealership.TownId) }; dataGridView.Rows.Add(row); } }
public void AddCarDealership() { var mockSet = new Mock <DbSet <CarDealership> >(); var mockContext = new Mock <CarDealershipContext>(); mockContext.Setup(m => m.CarDealerships).Returns(mockSet.Object); var service = new CarDealershipBusiness(mockContext.Object); service.Add(new CarDealership()); mockSet.Verify(m => m.Add(It.IsAny <CarDealership>()), Times.Once()); mockContext.Verify(m => m.SaveChanges(), Times.Once()); }
//cbGet and cbSort// //Buttons + attached logic// private void btnAdd_Click(object sender, EventArgs e) { var name = txtName.Text; int.TryParse(txtTown.Text, out int town); CarDealership carDealership = new CarDealership(); carDealership.Name = name; carDealership.TownId = town; CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); carDealershipBusiness.Add(carDealership); PopulateDataGridViewDefault(); ClearTextBoxes(); }
private void btnDealerships_Click(object sender, EventArgs e) { HideSpecificInfo(); lblInfoDealership.Visible = true; btnNewDealership.Visible = true; dataGridView.Rows.Clear(); dataGridView.ColumnCount = 4; dataGridView.Columns[0].Name = "ID"; dataGridView.Columns[1].Name = "Име"; dataGridView.Columns[2].Name = "ID на град"; dataGridView.Columns[3].Name = "Град"; dataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.DisplayedCellsExceptHeaders; dataGridView.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single; dataGridView.CellBorderStyle = DataGridViewCellBorderStyle.Single; dataGridView.RowHeadersVisible = false; dataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridView.MultiSelect = false; CarDealershipBusiness carDealershipBusiness = new CarDealershipBusiness(); var dealershipList = carDealershipBusiness.GetAllCarDealerships(); foreach (var dealership in dealershipList) { string[] row = { dealership.Id.ToString(), dealership.Name, dealership.TownId.ToString(), carDealershipBusiness.GetTownName(dealership.TownId) }; dataGridView.Rows.Add(row); } }