public void NotFoundCarReturnsNull()
{
var repo = new CarRepositoryADO();
var car = repo.GetById(100000);
Assert.IsNull(car);
}
public void CanDeleteCar()
{
Car carToAdd = new Car();
var repo = new CarRepositoryADO();
carToAdd.CarColor = "Blue";
carToAdd.CarDescription = "This is a test car";
carToAdd.CarMakeId = 1;
carToAdd.CarModelId = 4;
carToAdd.BodyStyle = "Sedan";
carToAdd.CarPrice = 3500M;
carToAdd.CarSalePrice = 2500M;
carToAdd.CarYear = 2009;
carToAdd.CategoryId = 1;
carToAdd.InteriorColor = "Black";
carToAdd.IsFeatured = true;
carToAdd.Mileage = 135000;
carToAdd.Transmission = "Automatic";
carToAdd.VinNumber = "1G4AH5346S6460154";
carToAdd.ImageFileName = "stockcar.jpg";
carToAdd.IsSold = false;
repo.Insert(carToAdd);
var loaded = repo.GetById(31);
Assert.IsNotNull(loaded);
repo.Delete(31);
loaded = repo.GetById(31);
Assert.IsNull(loaded);
}
public void CanDeleteCar()
{
Car carToAdd = new Car();
var repo = new CarRepositoryADO();
carToAdd.CarId = 1;
carToAdd.Body = "SUV";
carToAdd.Year = 2010;
carToAdd.ExColor = "Black";
carToAdd.IntColor = "Tan";
carToAdd.Transmission = "true";
carToAdd.Type = "Used";
carToAdd.MSRP = 40000;
carToAdd.Price = 45000;
carToAdd.Make.MakeName = "Honda";
carToAdd.Model.ModelName = "Accord";
carToAdd.ImageFileName = "Car1.PNG";
repo.Insert(carToAdd);
var loaded = repo.GetById(2);
Assert.IsNotNull(loaded);
repo.Delete(2);
loaded = repo.GetById(2);
Assert.IsNull(loaded);
}
public void CanSearchUsedInventoryOnMaxPrice()
{
var repo = new CarRepositoryADO();
var found = repo.SearchUsedInventory(new CarSearchParameters {
MaxPrice = 9000M
});
Assert.AreEqual(8, found.Count());
}
public void CanSearchOnPriceRange()
{
var repo = new CarRepositoryADO();
var found = repo.SearchAll(new CarSearchParameters {
MaxPrice = 20000M, MinPrice = 8000M
});
Assert.AreEqual(13, found.Count());
}
public void CanSearchNewInventoryOnCarMakeName()
{
var repo = new CarRepositoryADO();
var found = repo.SearchNewInventory(new CarSearchParameters {
CarMakeName = "Toyota"
});
Assert.AreEqual(1, found.Count());
}
public void CanSearchNewInventoryOnMinPrice()
{
var repo = new CarRepositoryADO();
var found = repo.SearchNewInventory(new CarSearchParameters {
MinPrice = 8000M
});
Assert.AreEqual(17, found.Count());
}
public void CanLoadInteriorColor()
{
var repo = new CarRepositoryADO();
var interiorColor = repo.GetInteriorColor();
Assert.AreEqual(5, interiorColor.Count);
Assert.AreEqual("Beige", interiorColor[0].InteriorColor);
Assert.AreEqual("Black", interiorColor[1].InteriorColor);
}
public void CanLoadTransmission()
{
var repo = new CarRepositoryADO();
var transmission = repo.GetTransmission();
Assert.AreEqual(2, transmission.Count);
Assert.AreEqual("Automatic", transmission[0].Transmission);
Assert.AreEqual("Manual", transmission[1].Transmission);
}
public void CanLoadCarColor()
{
var repo = new CarRepositoryADO();
var carColor = repo.GetCarColor();
Assert.AreEqual(5, carColor.Count);
Assert.AreEqual("Black", carColor[0].CarColor);
Assert.AreEqual("Blue", carColor[1].CarColor);
}
public void CanLoadCategory()
{
var repo = new CarRepositoryADO();
var category = repo.GetCarCategory();
Assert.AreEqual(2, category.Count);
Assert.AreEqual(2, category[0].CategoryId);
Assert.AreEqual("New", category[0].CategoryName);
}
public void CanLoadBodyStyle()
{
var repo = new CarRepositoryADO();
var bodyStyle = repo.GetBodyStyle();
Assert.AreEqual(4, bodyStyle.Count);
Assert.AreEqual("Car", bodyStyle[0].BodyStyle);
Assert.AreEqual("SUV", bodyStyle[1].BodyStyle);
}
public void CanLoadFavoriteCars()
{
var repo = new CarRepositoryADO();
List <CarDetailsFeaturedItem> cars = repo.GetFeatured().ToList();
Assert.AreEqual(8, cars.Count());
Assert.AreEqual(3, cars[1].CarId);
Assert.AreEqual("Kia", cars[1].CarMakeName);
Assert.AreEqual("Optima", cars[1].CarModelName);
Assert.AreEqual(10504M, cars[1].CarPrice);
Assert.AreEqual(2012, cars[1].CarYear);
Assert.AreEqual("stockcar.jpg", cars[1].ImageFileName);
}
public void CanLoadCarById()
{
var repo = new CarRepositoryADO();
var car = repo.GetById(1);
Assert.IsNotNull(car);
Assert.AreEqual(1, car.CarId);
Assert.AreEqual("5FNRL5H4XCB032138", car.VinNumber);
Assert.AreEqual(2010, car.CarYear);
Assert.AreEqual("Automatic", car.Transmission);
Assert.AreEqual("Black", car.CarColor);
Assert.AreEqual("Black", car.InteriorColor);
Assert.AreEqual(165000, car.Mileage);
Assert.AreEqual("This is a blue car with black leather interior", car.CarDescription);
Assert.AreEqual(5200M, car.CarPrice);
Assert.AreEqual("stockcar.jpg", car.ImageFileName);
}
public void CanLoadCarDetails()
{
var repo = new CarRepositoryADO();
List <CarDetailsItem> car = repo.GetDetails().ToList();
Assert.IsNotNull(car);
Assert.AreEqual(1, car[0].CarId);
Assert.AreEqual("Ford", car[0].CarMakeName);
Assert.AreEqual("Escape", car[0].CarModelName);
Assert.AreEqual("5FNRL5H4XCB032138", car[0].VinNumber);
Assert.AreEqual(2010, car[0].CarYear);
Assert.AreEqual("Automatic", car[0].Transmission);
Assert.AreEqual("Black", car[0].CarColor);
Assert.AreEqual("Black", car[0].InteriorColor);
Assert.AreEqual(165000, car[0].Mileage);
Assert.AreEqual("This is a blue car with black leather interior", car[0].CarDescription);
Assert.AreEqual(5200M, car[0].CarPrice);
Assert.AreEqual("stockcar.jpg", car[0].ImageFileName);
}
public void CanAddCar()
{
Car carToAdd = new Car();
var repo = new CarRepositoryADO();
carToAdd.CarId = 1;
carToAdd.Body = "SUV";
carToAdd.Year = 2010;
carToAdd.ExColor = "Black";
carToAdd.IntColor = "Tan";
carToAdd.Transmission = "Auto";
carToAdd.Type = "Used";
carToAdd.MSRP = 40000;
carToAdd.Price = 45000;
carToAdd.Make.MakeName = "Honda";
carToAdd.Model.ModelName = "Accord";
carToAdd.ImageFileName = "Car1.PNG";
repo.Insert(carToAdd);
Assert.AreEqual(2, carToAdd.CarId);
}
public void CanUpdateCar()
{
Car carToAdd = new Car();
var repo = new CarRepositoryADO();
carToAdd.CarId = 1;
carToAdd.Body = "SUV";
carToAdd.Year = 2010;
carToAdd.ExColor = "Black";
carToAdd.IntColor = "Tan";
carToAdd.Transmission = "Manual";
carToAdd.Type = "Used";
carToAdd.MSRP = 40000;
carToAdd.Price = 45000;
carToAdd.Make.MakeName = "Honda";
carToAdd.Model.ModelName = "Accord";
carToAdd.ImageFileName = "Car1.PNG";
repo.Insert(carToAdd);
carToAdd.ExColor = "Silver";
carToAdd.IntColor = "Grey";
carToAdd.Year = 2013;
carToAdd.Body = "Sedan";
carToAdd.Transmission = "false";
carToAdd.ImageFileName = "Car2.PNG";
repo.Update(carToAdd);
var updatedCar = repo.GetById(2);
Assert.AreEqual("Silver", updatedCar.ExColor);
Assert.AreEqual("Grey", updatedCar.IntColor);
Assert.AreEqual(2013, updatedCar.Year);
Assert.AreEqual("Sedanr", updatedCar.Body);
Assert.AreEqual(false, updatedCar.Transmission);
Assert.AreEqual("Car2.PNG", updatedCar.ImageFileName);
}
public void CanLoadCar()
{
var repo = new CarRepositoryADO();
var car = repo.GetById(1);
Assert.IsNotNull(car);
//values (1, 'SUV', '2010', 'Black', 'Tan', '3500', '1',
//'Used', '40000', '45000','1', '1', 'Car1'),
Assert.AreEqual(1, car.CarId);
Assert.AreEqual("SUV", car.Body);
Assert.AreEqual("2010", car.Year);
Assert.AreEqual("Black", car.ExColor);
Assert.AreEqual("Tan", car.IntColor);
Assert.AreEqual("3500", car.Mileage);
Assert.AreEqual("1", car.Transmission);
Assert.AreEqual("Used", car.Type);
Assert.AreEqual("40000", car.MSRP);
Assert.AreEqual("45000", car.Price);
Assert.AreEqual("Honda", car.Make.MakeName);
Assert.AreEqual("Accord", car.Model.ModelName);
Assert.AreEqual("Car1", car.ImageFileName);
}
