public void Update(VehicleListing listing)
{
using (var cn = new SqlConnection())
{
cn.ConnectionString = Settings.GetConnectionString();
var parameters = new DynamicParameters();
parameters.Add("@VehicleListingId", listing.VehicleListingId);
parameters.Add("@VehicleMakeId", listing.VehicleMakeId);
parameters.Add("@VehicleModelId", listing.VehicleModelId);
parameters.Add("@VehicleTypeId", listing.VehicleTypeId);
parameters.Add("@BodyStyleId", listing.BodyStyleId);
parameters.Add("@TransmissionTypeId", listing.TransmissionTypeId);
parameters.Add("@Year", listing.Year);
parameters.Add("@ColorId", listing.ColorId);
parameters.Add("@InteriorColorId", listing.InteriorColorId);
parameters.Add("@Mileage", listing.Mileage);
parameters.Add("@VIN", listing.VIN);
parameters.Add("@MSRP", listing.MSRP);
parameters.Add("@SalePrice", listing.SalePrice);
parameters.Add("@Description", listing.Description);
parameters.Add("@FeaturedVehicle", listing.FeaturedVehicle);
parameters.Add("@ImageFileName", listing.ImageFileName);
parameters.Add("@Sold", listing.Sold);
cn.Execute("UpdateVehicleListing",
parameters,
commandType: CommandType.StoredProcedure);
}
}
public void Update(VehicleListing listing)
{
_vehicleListings.RemoveAll(x => x.VehicleListingId == listing.VehicleListingId);
VehicleListing newListing = new VehicleListing()
{
VehicleListingId = listing.VehicleListingId,
VehicleMakeId = listing.VehicleMakeId,
VehicleModelId = listing.VehicleModelId,
VehicleTypeId = listing.VehicleTypeId,
BodyStyleId = listing.BodyStyleId,
TransmissionTypeId = listing.TransmissionTypeId,
Year = listing.Year,
ColorId = listing.ColorId,
InteriorColorId = listing.InteriorColorId,
Mileage = listing.Mileage,
VIN = listing.VIN,
MSRP = listing.MSRP,
SalePrice = listing.SalePrice,
FeaturedVehicle = listing.FeaturedVehicle,
ImageFileName = listing.ImageFileName,
Description = listing.Description,
Sold = listing.Sold
};
_vehicleListings.Add(newListing);
}
public void DeleteVehicleListings_ShouldDeleteOneVehicleListings_WhenVehicleMultipleListingsExists()
{
//Given
var options = new DbContextOptionsBuilder <CarDealerContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
var dbContext = new CarDealerContext(options);
var vehicleListingService = new VehicleListingService(dbContext);
var vehicle = new Vehicle {
Id = 1, Make = "Toyota", MarketValue = 20000, Model = "Camry", VinNumber = "4T1BF3EK5BU638805", Year = 2020
};
var vehicle1 = new Vehicle {
Id = 2, Make = "Toyota", MarketValue = 20000, Model = "Camry", VinNumber = "1GNEK13Z93R293940", Year = 2020
};
var vehicleListing = new VehicleListing {
Price = 50000, Vehicle = vehicle
};
var vehicleListing1 = new VehicleListing {
Price = 50000, Vehicle = vehicle1
};
dbContext.VehicleListings.Add(vehicleListing);
dbContext.VehicleListings.Add(vehicleListing1);
dbContext.SaveChanges();
dbContext.VehicleListings.Count().Should().Be(2);
//When
vehicleListingService.DeleteVehicleListings("4T1BF3EK5BU638805");
//Then
dbContext.VehicleListings.Count().Should().Be(1);
}
public void AddToVehicleListings_ShouldAddTodbContext_WhenPassedVehicleListing()
{
//Given
var options = new DbContextOptionsBuilder <CarDealerContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
var dbContext = new CarDealerContext(options);
var vehicleListingService = new VehicleListingService(dbContext);
var vehicle = new Vehicle {
Make = "toyoya", MarketValue = 20000, Model = "camry", VinNumber = "jksndfjsnfjnui32", Year = 2020
};
dbContext.VehicleInventory.Add(vehicle);
dbContext.SaveChanges();
var vehicleId = dbContext.VehicleInventory.FirstOrDefault(x => x.VinNumber == "jksndfjsnfjnui32").Id;
var vehicleListing = new VehicleListing()
{
VehicleId = vehicleId, Vehicle = vehicle
};
//When
vehicleListingService.AddToVehicleListing(vehicleListing);
//Then
dbContext.VehicleListings.Count().Should().Be(1);
}
public VehicleListing GetById(int listingId)
{
VehicleListing listing = null;
listing = (from vehicleListing in _vehicleListings
where vehicleListing.VehicleListingId == listingId
select vehicleListing).FirstOrDefault();
return(listing);
}
public int AddToVehicleListing(VehicleListing vehicle)
{
if (vehicle == null)
{
throw new System.ArgumentNullException(nameof(vehicle), "The vehicle you are trying to add is null");
}
_db.VehicleListings.Add(vehicle);
_db.SaveChanges();
return(vehicle.Id);
}
public void Insert(VehicleListing listing)
{
if (listing.VehicleListingId == 0)
{
var lastId = _vehicleListings.MaxBy(x => x.VehicleListingId).FirstOrDefault();
int newId = lastId.VehicleListingId + 1;
listing.VehicleListingId = newId;
}
_vehicleListings.Add(listing);
}
public void CanUpdateListing()
{
var repo = new VehicleListingRepoQA();
VehicleListing car = new VehicleListing()
{
VehicleMakeId = 2,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 1,
Year = 1997,
ColorId = 2,
InteriorColorId = 4,
Mileage = 20000,
VIN = "11111111111111111",
MSRP = 40000.00M,
SalePrice = 36000.00M,
Description = "Ultimate",
FeaturedVehicle = true,
Sold = false,
ImageFileName = "placeholder.png"
};
repo.Insert(car);
var listingToUpdate = repo.GetById(5);
listingToUpdate.TransmissionTypeId = 2;
listingToUpdate.ColorId = 3;
listingToUpdate.InteriorColorId = 1;
listingToUpdate.Mileage = 1000;
listingToUpdate.MSRP = 60000.00M;
listingToUpdate.SalePrice = 48000.00M;
listingToUpdate.Description = "Updated sport utility vehicle";
repo.Update(listingToUpdate);
var updatedListing = repo.GetById(5);
Assert.AreEqual(2, updatedListing.TransmissionTypeId);
Assert.AreEqual(3, updatedListing.ColorId);
Assert.AreEqual(1, updatedListing.InteriorColorId);
Assert.AreEqual(1000, updatedListing.Mileage);
Assert.AreEqual(48000.00M, updatedListing.SalePrice);
Assert.AreEqual(60000.00M, updatedListing.MSRP);
Assert.AreEqual("Updated sport utility vehicle", updatedListing.Description);
Assert.AreEqual(true, updatedListing.FeaturedVehicle);
Assert.AreEqual("11111111111111111", updatedListing.VIN);
}
public void CanInsertVehicleListing()
{
var repo = new VehicleListingRepository();
VehicleListing test = new VehicleListing()
{
VehicleMakeId = 1,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 2,
Year = 2020,
ColorId = 3,
InteriorColorId = 1,
Mileage = 0,
VIN = "test",
MSRP = 99000M,
SalePrice = 92000M,
Description = "New Car",
FeaturedVehicle = true,
ImageFileName = "test.png",
Sold = false
};
repo.Insert(test);
var vehicle = repo.GetById(9);
Assert.AreEqual(1, vehicle.VehicleMakeId);
Assert.AreEqual(1, vehicle.VehicleModelId);
Assert.AreEqual(2, vehicle.VehicleTypeId);
Assert.AreEqual(3, vehicle.BodyStyleId);
Assert.AreEqual(2, vehicle.TransmissionTypeId);
Assert.AreEqual(2020, vehicle.Year);
Assert.AreEqual(3, vehicle.ColorId);
Assert.AreEqual(1, vehicle.InteriorColorId);
Assert.AreEqual(0, vehicle.Mileage);
Assert.AreEqual("test", vehicle.VIN);
Assert.AreEqual(99000M, vehicle.MSRP);
Assert.AreEqual(92000M, vehicle.SalePrice);
Assert.AreEqual("New Car", vehicle.Description);
Assert.AreEqual(true, vehicle.FeaturedVehicle);
Assert.AreEqual("test.png", vehicle.ImageFileName);
Assert.AreEqual(false, vehicle.Sold);
}
public VehicleListing GetById(int listingId)
{
VehicleListing listing = null;
using (var cn = new SqlConnection())
{
cn.ConnectionString = Settings.GetConnectionString();
var parameters = new DynamicParameters();
parameters.Add("@VehicleListingId", listingId);
listing = cn.Query <VehicleListing>("ListingsSelectById",
parameters,
commandType: CommandType.StoredProcedure).FirstOrDefault();
}
return(listing);
}
public void CanInsertListing()
{
var repo = new VehicleListingRepoQA();
VehicleListing car = new VehicleListing()
{
VehicleMakeId = 1,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 5,
TransmissionTypeId = 1,
Year = 1997,
ColorId = 2,
InteriorColorId = 4,
Mileage = 20000,
VIN = "11111111111111111",
MSRP = 40000.00M,
SalePrice = 36000.00M,
Description = "Ultimate sport utility vehicle",
FeaturedVehicle = true,
Sold = false,
ImageFileName = "placeholder.png"
};
repo.Insert(car);
var addedListing = repo.GetById(5);
Assert.AreEqual(5, addedListing.VehicleListingId);
Assert.AreEqual(1, addedListing.VehicleMakeId);
var featuredListings = repo.GetFeatured().ToList();
Assert.AreEqual(3, featuredListings.Count());
Assert.AreEqual(5, featuredListings[2].VehicleListingId);
Assert.AreEqual(1997, featuredListings[2].Year);
Assert.AreEqual("Ford", featuredListings[2].VehicleMakeName);
Assert.AreEqual("Explorer", featuredListings[2].VehicleModelName);
}
public void CanDeleteVehicleListing()
{
var repo = new VehicleListingRepository();
VehicleListing test = new VehicleListing()
{
VehicleMakeId = 1,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 2,
Year = 2020,
ColorId = 3,
InteriorColorId = 1,
Mileage = 0,
VIN = "test",
MSRP = 99000M,
SalePrice = 92000M,
Description = "New Car",
FeaturedVehicle = true,
ImageFileName = "test.png",
Sold = false
};
repo.Insert(test);
var vehicle = repo.GetById(9);
Assert.IsNotNull(vehicle);
repo.Delete(9);
vehicle = repo.GetById(9);
Assert.IsNull(vehicle);
}
public void CanDeleteListing()
{
var repo = new VehicleListingRepoQA();
VehicleListing car = new VehicleListing()
{
VehicleMakeId = 2,
VehicleModelId = 1,
VehicleTypeId = 2,
BodyStyleId = 3,
TransmissionTypeId = 1,
Year = 1997,
ColorId = 2,
InteriorColorId = 4,
Mileage = 20000,
VIN = "11111111111111111",
MSRP = 40000.00M,
SalePrice = 36000.00M,
Description = "Ultimate",
FeaturedVehicle = true,
Sold = false,
ImageFileName = "placeholder.png"
};
repo.Insert(car);
var listing = repo.GetById(5);
Assert.IsNotNull(listing);
repo.Delete(5);
listing = repo.GetById(5);
Assert.IsNull(listing);
}
public IActionResult AddToVehicleListing([FromBody] VehicleListing vehicle)
{
_service.TrueForNonDuplicateVins(vehicle.Vehicle.VinNumber);
_service.AddToVehicleListing(vehicle);
return(Ok(new { message = "Created new vehicle" }));
}
