public ActionResult EditVehicle(int id)
{
var model = new EditVehicleViewModel();
var makeRepo = new MakeRepositoryADO();
var modelRepo = new ModelRepositoryADO();
var typeRepo = new TypeRepositoryADO();
var bodystyleRepo = new BodyStyleRepositoryADO();
var transmissionRepo = new TransmissionRepositoryADO();
var colorRepo = new ColorRepositoryADO();
var interiorRepo = new InteriorRepositoryADO();
var vehicleRepo = new VehicleRepositoryADO();
model.Makes = new SelectList(makeRepo.GetAll(), "MakeID", "MakeName");
model.Models = new SelectList(modelRepo.GetAll(), "ModelID", "ModelName");
model.Types = new SelectList(modelRepo.GetAll(), "TypeID", "TypeName");
model.BodyStyles = new SelectList(modelRepo.GetAll(), "BodyID", "BodyStyleName");
model.Transmissions = new SelectList(modelRepo.GetAll(), "TransmissionID", "TransmissionType");
model.Colors = new SelectList(modelRepo.GetAll(), "ColorID", "ColorName");
model.Interiors = new SelectList(modelRepo.GetAll(), "InteriorID", "InteriorColor");
model.Vehicle = vehicleRepo.GetByID(id);
return(View(model));
}
public void ADOCanDeleteVehicle()
{
var repo = new VehicleRepositoryADO();
var vehicle = new Vehicle();
vehicle.ModelId = 9;
vehicle.BodyStyleId = 4;
vehicle.InteriorColorId = 2;
vehicle.ExteriorColorId = 5;
vehicle.SaleId = null;
vehicle.IsUsed = true;
vehicle.IsAutomatic = false;
vehicle.IsFeatured = false;
vehicle.UserId = "00000000-0000-0000-0000-000000000000";
vehicle.VIN = "9012345678ABCDEFG";
vehicle.Description = "Added vehicle";
vehicle.Image = "added.jpg";
vehicle.SalePrice = 15000m;
vehicle.MSRP = 16000m;
vehicle.Mileage = 90000m;
repo.Insert(vehicle);
var loaded = repo.GetById(3);
Assert.IsNotNull(loaded);
repo.Delete(3);
loaded = repo.GetById(3);
Assert.IsNull(loaded);
}
public static void CanCreateAndDeleteVehicle()
{
VehicleRepositoryADO repo = new VehicleRepositoryADO();
Vehicle vehicle = new Vehicle()
{
Vin = "0000000000",
Color = "Blue",
Description = "Notes and stuff",
Interior = "Black",
Style = "Car",
MakeId = 1,
ModelId = 1,
Mileage = 500,
MSRP = 15000M,
SalePrice = 12000M,
Sold = false,
Transmission = "Auto",
Type = "New",
Year = 2015
};
var createdvehicle = repo.Create(vehicle);
Assert.AreNotEqual(null, createdvehicle);
var resultId = createdvehicle.VehicleId;
repo.Delete(resultId);
var deletedVehicle = repo.GetById(resultId);
Assert.AreEqual(null, deletedVehicle.Vin);
}
public void CanAddVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.VehicleYear = 2016;
vehicleToAdd.MakeID = 3;
vehicleToAdd.ModelID = 1;
vehicleToAdd.Price = 24000;
vehicleToAdd.Mileage = 1000;
vehicleToAdd.Vin = "1GNDU23W27D181467";
vehicleToAdd.MSRP = 26000;
vehicleToAdd.VehicleDescription = "Beauty";
vehicleToAdd.VehicleType = "New";
vehicleToAdd.ImageFileName = "placeholder.png";
vehicleToAdd.BodyStyleID = 1;
vehicleToAdd.TransmissionID = 2;
vehicleToAdd.BodyColorID = 3;
vehicleToAdd.InteriorColorID = 2;
vehicleToAdd.SaleStatus = true;
vehicleToAdd.IsFeatured = true;
repo.Insert(vehicleToAdd);
Assert.AreEqual(9, vehicleToAdd.VehicleID);
}
public static void zCanGetFeatures()
{
VehicleRepositoryADO repo = new VehicleRepositoryADO();
var result = repo.GetAllFeatures();
Assert.GreaterOrEqual(1, result.features.Count);
}
public void NotFoundVehicleReturnsNull()
{
var repo = new VehicleRepositoryADO();
var vehicle = repo.GetbyId(1000000);
Assert.IsNull(vehicle);
}
public ActionResult Purchase(SalesIndexPuchaseCM form)
{
if (ModelState.IsValid)
{
Purchases purchase = new Purchases();
var repo = new PurchaseRepositoryADO();
var vRepo = new VehicleRepositoryADO();
purchase.VehicleId = form.VehicleId;
purchase.Phone = form.Phone;
purchase.Email = form.Email;
purchase.StreetOne = form.StreetOne;
purchase.StreetTwo = form.StreetTwo;
purchase.City = form.City;
purchase.ZipCode = form.Zipcode;
purchase.State = form.State;
purchase.PurchasePrice = form.PurchasePrice;
purchase.PurchaseType = form.PurchaseType;
purchase.EmployeeId = form.EmployeeId;
repo.CreatePurchase(purchase);
return(RedirectToAction("Index"));
}
else
{
SalesIndexPuchaseVM VM = new SalesIndexPuchaseVM();
var vehicle = new VehicleRepositoryADO();
VM.Vehicles = vehicle.ReadAllVehicle();
VM.Form = form;
return(View(VM));
}
}
public ActionResult Purchase(int id)
{
SalesIndexPuchaseVM VM = new SalesIndexPuchaseVM();
var vehicle = new VehicleRepositoryADO();
var vehicles = vehicle.ReadByVehicleId(id);
VM.Make = vehicles.MakeId.ToString();
VM.Make = vehicles.Make;
VM.Model = vehicles.ModelId.ToString();
VM.Model = vehicles.Model;
VM.Type = vehicles.Type;
VM.BodyStyle = vehicles.BodyStyle;
VM.Year = vehicles.Year;
VM.Transmission = vehicles.Transmission;
VM.Color = vehicles.Color;
VM.Interior = vehicles.Interior;
VM.Mileage = vehicles.Mileage;
VM.Vin = vehicles.Vin;
VM.Msrp = vehicles.Msrp;
VM.SalePrice = vehicles.SalePrice;
VM.Description = vehicles.Description;
VM.States();
VM.PurchaseTypes();
return(View(VM));
}
public static void CanFailCreateVehicle12()
{
VehicleRepositoryADO repo = new VehicleRepositoryADO();
Vehicle vehicle = new Vehicle()
{
Vin = "0000000000",
Color = "Blue",
Description = "Notes and stuff",
Style = "Car",
Interior = "Black",
MakeId = 1,
ModelId = 1,
Mileage = 500,
MSRP = 15000M,
SalePrice = 12000M,
Sold = false,
Transmission = "Auto",
Type = "New",
Year = 2050
};
var createdvehicle = repo.Create(vehicle);
Assert.AreEqual(null, createdvehicle);
}
public void CanAddVehicle()
{
var vehicle = new Vehicle();
vehicle.MakeID = 1;
vehicle.ModelID = 1;
vehicle.TypeID = 1;
vehicle.Year = 2020;
vehicle.TransmissionID = 1;
vehicle.ColorID = 1;
vehicle.InteriorID = 1;
vehicle.BodyStyleID = 1;
vehicle.Mileage = 50;
vehicle.VIN = "A12B";
vehicle.MSRP = 20000;
vehicle.SalePrice = 18000;
vehicle.Description = "This real-deal is a complete steal!";
vehicle.ImageFileName = "placeholder.png";
// vehicle.Featured = false;
var repo = new VehicleRepositoryADO();
repo.Add(vehicle);
Assert.AreEqual(8, vehicle.ID);
}
public void CanDeleteVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.VIN = "9870987fhej320nf";
vehicleToAdd.ModelID = 1;
vehicleToAdd.ConditionID = 1;
vehicleToAdd.VehicleTypeID = 1;
vehicleToAdd.Year = "2018";
vehicleToAdd.TransmissionTypeID = 1;
vehicleToAdd.CarColor = 1;
vehicleToAdd.Interior = 1;
vehicleToAdd.Mileage = "567";
vehicleToAdd.MSRP = 28000M;
vehicleToAdd.SalesPrice = 26500M;
vehicleToAdd.Description = "Its a green car!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
repo.Insert(vehicleToAdd);
var loaded = repo.GetById(9);
Assert.IsNotNull(loaded);
repo.Delete(9);
loaded = repo.GetById(9);
Assert.IsNull(loaded);
}
public void CanGetVehicleDetails()
{
var repo = new VehicleRepositoryADO();
var vehicle = repo.GetDetails(1);
//(VehicleID, Year, Mileage, MSRP, UserID, SalesPrice, [Description], Picture, Featured, VIN, ModelID, ColorID, TypeID, TransmissionID, InteriorID)
//(1, 2017, 0, 55450, '00000000-1111-1111-0000-000000000000', 52980, 'Great car, makes you feel alive!', null, 1, 'WBAVL1C50EVR93551', 1, 3, 1, 1, 2), --corvette
Assert.AreEqual(1, vehicle.VehicleID);
Assert.AreEqual(2017, vehicle.Year);
Assert.AreEqual(0, vehicle.Mileage);
Assert.AreEqual(55450, vehicle.MSRP);
Assert.AreEqual(52980, vehicle.SalesPrice);
Assert.AreEqual("Great car, makes you feel alive!", vehicle.Description);
Assert.AreEqual("placeholder.png", vehicle.Picture);
Assert.AreEqual("WBAVL1C50EVR93551", vehicle.VIN);
Assert.AreEqual(1, vehicle.ModelID);
Assert.AreEqual(3, vehicle.ColorID);
Assert.AreEqual(1, vehicle.TransmissionID);
Assert.AreEqual(2, vehicle.InteriorID);
//break
Assert.AreEqual(1, vehicle.MakeID);
Assert.AreEqual(3, vehicle.BodyID);
Assert.AreEqual("Chevy", vehicle.MakeName);
Assert.AreEqual("Corvette", vehicle.ModelName);
Assert.AreEqual(2, vehicle.InteriorID);
Assert.AreEqual("Coupe", vehicle.BodyStyleName);
Assert.AreEqual("Grey", vehicle.InteriorColor);
Assert.AreEqual("Automatic", vehicle.TransmissionType);
Assert.AreEqual("Green", vehicle.ColorName);
}
public ActionResult Used(VehicleSearchCM form)
{
if (ModelState.IsValid)
{
InventoryUsedVM VM = new InventoryUsedVM();
var repo = new VehicleRepositoryADO();
VM.Vehicles = repo.Search(form, false);
VM.SetYear();
VM.SetPrice();
VM.Form = form;
return(View(VM));
}
else
{
InventoryUsedVM VM = new InventoryUsedVM();
var repo = new VehicleRepositoryADO();
VM.Vehicles = repo.Search(form, false);
VM.SetYear();
VM.SetPrice();
VM.Form = form;
return(View(VM));
}
}
public void CanDeleteVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.Year = 2018;
vehicleToAdd.Mileage = 0;
vehicleToAdd.MSRP = 50011;
vehicleToAdd.SalesPrice = 49875;
vehicleToAdd.Description = "The meanest on the streets!";
vehicleToAdd.Picture = "placeholder.png";
vehicleToAdd.Featured = true;
vehicleToAdd.VIN = "KMHHT6KD1CU079023";
//vehicleToAdd.MakeID = 2;
vehicleToAdd.BodyID = 5;
vehicleToAdd.ModelID = 3;
vehicleToAdd.ColorID = 2;
vehicleToAdd.TypeID = 1;
vehicleToAdd.TransmissionID = 1;
vehicleToAdd.InteriorID = 3;
vehicleToAdd.UserID = "00000000-1111-1111-0000-000000000000";
repo.Insert(vehicleToAdd);
var loaded = repo.GetByID(9);
Assert.IsNotNull(loaded);
repo.Delete(9);
loaded = repo.GetByID(9);
Assert.IsNull(loaded);
}
public void CanAddPurchase()
{
var purchase = new PurchaseDetails();
purchase.Name = "Andrew Galvin";
purchase.Email = "*****@*****.**";
purchase.Street1 = "20 Stable Court";
purchase.City = "Wilmington";
purchase.State = "DE";
purchase.ZipCode = "19803";
purchase.PurchasePrice = 17995;
purchase.PurchaseType = "Cash";
purchase.UserID = "00000000-0000-0000-0000-000000000000";
var repo = new VehicleRepositoryADO();
int id = 3;
repo.Purchase(purchase, id);
Assert.AreEqual(2, purchase.PurchaseID);
var vehicle = repo.GetDetails(id);
Assert.AreEqual(2, vehicle.PurchaseID);
}
public ActionResult Vehicle(VehicleSearchCM form)
{
if (ModelState.IsValid)
{
AdminVehiclesVM VM = new AdminVehiclesVM();
var repo = new VehicleRepositoryADO();
VM.Vehicles = repo.Search(form, null);
VM.SetYear();
VM.SetPrice();
VM.Form = form;
return(View(VM));
}
else
{
AdminVehiclesVM VM = new AdminVehiclesVM();
var repo = new VehicleRepositoryADO();
VM.Vehicles = repo.Search(form, null);
VM.SetYear();
VM.SetPrice();
VM.Form = form;
return(View(VM));
}
}
public ActionResult EditVehicle(int id)
{
AdminEditVehicleVM VM = new AdminEditVehicleVM();
var repo = new VehicleRepositoryADO();
var modelRepo = new VehicleModelRepositoryADO();
var makeRepo = new MakeRepositoryADO();
var vehicles = repo.ReadByVehicleId(id);
VM.Form.VehicleId = vehicles.VehicleId;
VM.Form.Make = vehicles.Make;
VM.Form.Model = vehicles.Model;
VM.Form.Type = vehicles.Type;
VM.Form.BodyStyle = vehicles.BodyStyle;
VM.Form.Year = vehicles.Year;
VM.Form.Transmission = vehicles.Transmission;
VM.Form.Color = vehicles.Color;
VM.Form.Interior = vehicles.Interior;
VM.Form.Mileage = vehicles.Mileage;
VM.Form.Vin = vehicles.Vin;
VM.Form.Msrp = vehicles.Msrp;
VM.Form.SalePrice = vehicles.SalePrice;
VM.Form.Description = vehicles.Description;
VM.SetAvailableMakes(makeRepo.ReadAllMakes());
VM.SetAvailableModels(modelRepo.ReadAllModel());
VM.BodyStyles();
VM.Colors();
VM.Interiors();
VM.Types();
return(View(VM));
}
public IHttpActionResult Search(decimal?minPrice, decimal?maxPrice, decimal?minYear, decimal?maxYear, string makeName = null, string modelName = null, string year = null)
{
var repo = new VehicleRepositoryADO();
try
{
var parameters = new VehicleSearchParams()
{
MinPrice = minPrice,
MaxPrice = maxPrice,
MakeName = makeName,
ModelName = modelName,
Year = year,
MinYear = minYear,
MaxYear = maxYear
};
var result = repo.Search(parameters);
return(Ok(result));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public void NoVehicleReturnsNull()
{
var repo = new VehicleRepositoryADO();
var vehicle = repo.GetByID(1000000000);
Assert.IsNull(vehicle);
}
public void CanGetVehicleById()
{
var repo = new VehicleRepositoryADO();
Vehicle vehicle = repo.GetById(1);
Assert.AreEqual(1, vehicle.VehicleID);
}
public void CanLoadSpecials()
{
var repo = new VehicleRepositoryADO();
var specials = repo.GetSpecials().ToList();
Assert.AreEqual(3, specials.Count);
Assert.AreEqual("GuildCars Huge Sale!!!", specials[0].SpecialTitle);
}
public void CanAddVehicle()
{
Vehicle vehicleToAdd = new Vehicle();
var repo = new VehicleRepositoryADO();
vehicleToAdd.Type = "USED";
vehicleToAdd.BodyStyle = "SUV";
}
public void CanLoadFeatured()
{
var repo = new VehicleRepositoryADO();
var featured = repo.GetFeatured().ToList();
Assert.AreEqual(5, featured.Count);
Assert.AreEqual("Audi", featured[0].Make);
Assert.AreEqual("F150", featured[1].Model);
}
public void CanLoadVehicle()
{
var repo = new VehicleRepositoryADO();
var vehicle = repo.GetById(1);
Assert.IsNotNull(vehicle);
Assert.AreEqual(1, vehicle.VehicleId);
Assert.AreEqual("Leather", vehicle.Interior);
}
public void CanLoadVehicles()
{
var repo = new VehicleRepositoryADO();
var vehicles = repo.GetVehicles();
Assert.AreEqual(6, vehicles.Count());
Assert.AreEqual("1HGCM82613A006357", vehicles[0].VinNumber);
Assert.AreEqual(false, vehicles[4].IsFeatured);
}
public ActionResult Inventory()
{
ReportsInventoryVM VM = new ReportsInventoryVM();
var vehicle = new VehicleRepositoryADO();
VM.NewVehicles = vehicle.ReadAllVehicle().Where(m => m.Type == true).ToList();
VM.UsedVehicles = vehicle.ReadAllVehicle().Where(m => m.Type == false).ToList();
return(View(VM));
}
public void CanSearchOnYear()
{
var repo = new VehicleRepositoryADO();
var found = repo.Search(new VehicleSearchParams {
Year = "2018"
});
Assert.AreEqual(5, found.Count());
}
public void CanSearchOnMake()
{
var repo = new VehicleRepositoryADO();
var found = repo.Search(new VehicleSearchParams {
MakeName = "Subaru"
});
Assert.AreEqual(8, found.Count());
}
public void CanSearchOnModel()
{
var repo = new VehicleRepositoryADO();
var found = repo.Search(new VehicleSearchParams {
ModelName = "Outb"
});
Assert.AreEqual(4, found.Count());
}
public void CanSearchOnMaxYeare()
{
var repo = new VehicleRepositoryADO();
var found = repo.Search(new VehicleSearchParams {
MaxYear = 2018
});
Assert.AreEqual(8, found.Count());
}
