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