public void AddVehicle(AddVehicleObject vehicle)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
// create parameter object
var parameters = new DynamicParameters();
parameters.Add("@VehicleId", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@Make", vehicle.Make);
parameters.Add("@Model", vehicle.Model);
parameters.Add("@Type", vehicle.Type);
parameters.Add("@BodyStyle", vehicle.BodyStyle);
parameters.Add("@Year", vehicle.Year);
parameters.Add("@Transmission", vehicle.Transmission);
parameters.Add("@Color", vehicle.Color);
parameters.Add("@Interior", vehicle.Interior);
parameters.Add("@Mileage", vehicle.Mileage);
parameters.Add("@VIN", vehicle.VIN);
parameters.Add("@MSRP", vehicle.MSRP);
parameters.Add("@SalePrice", vehicle.SalePrice);
parameters.Add("@Description", vehicle.Description);
cn.Execute("AddVehicle",
parameters, commandType: CommandType.StoredProcedure);
vehicle.VehicleId = parameters.Get <int>("@VehicleId");
}
}
public void CanAddVehicle()
{
AddVehicleObject vehicle = new AddVehicleObject()
{
VIN = "1GC0KXCG9DF173160",
Interior = "White",
Transmission = "Automatic",
Mileage = "11223",
MSRP = 12000,
SalePrice = 10455,
Color = "Black",
BodyStyle = "Sedan",
Description = "Nice well maintained and hardly driven car",
Make = "Dodge",
Model = "Charger",
Type = "Used",
Year = 2001
};
var repo = new VehicleRepository();
repo.AddVehicle(vehicle);
// Now check in the DB if the record was added
}
public ActionResult AddVehicle(AddVehicleViewModel viewModel)
{
if (ModelState.IsValid)
{
try
{
var newVehicle = new AddVehicleObject()
{
Make = viewModel.Make,
Model = viewModel.Model,
Type = viewModel.Type,
BodyStyle = viewModel.BodyStyle,
Year = viewModel.Year,
Transmission = viewModel.Transmission,
Color = viewModel.Color,
Interior = viewModel.Interior,
Mileage = viewModel.Mileage,
VIN = viewModel.VIN,
MSRP = viewModel.MSRP,
SalePrice = viewModel.SalePrice,
Description = viewModel.Description
};
var repo = VehicleRepositoryFactory.GetVehicleRepository();
repo.AddVehicle(newVehicle);
var savepath = Server.MapPath("~/Images/Vehicles");
string extension = Path.GetExtension(viewModel.ImageUpload.FileName);
var filePath = Path.Combine(savepath, "inventory-" + newVehicle.VehicleId.ToString() + extension);
viewModel.ImageUpload.SaveAs(filePath);
var fileName = Path.GetFileName(filePath);
repo.AddVehicleFileName(fileName, newVehicle.VehicleId);
return(RedirectToAction("EditVehicle", new { id = newVehicle.VehicleId }));
}
catch (Exception ex)
{
throw ex;
}
}
else
{
var vehicleViewObject = new AddVehicleViewModel();
return(View(vehicleViewObject));
}
}
