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 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 Used()
{
InventoryUsedVM VM = new InventoryUsedVM();
VehicleSearchCM form = new VehicleSearchCM();
var repo = new VehicleRepositoryADO();
VM.Vehicles = repo.Search(form, false);
VM.SetYear();
VM.SetPrice();
return(View(VM));
}
public ActionResult Vehicle()
{
AdminVehiclesVM VM = new AdminVehiclesVM();
var repo = new VehicleRepositoryADO();
VehicleSearchCM form = new VehicleSearchCM();
VM.Vehicles = repo.Search(form, null);
VM.SetYear();
VM.SetPrice();
return(View(VM));
}
/// <summary>
/// Search database for vehicles
/// </summary>
/// <param name="form">
/// isNew = true - new
/// isNew = false - used
/// isNew = null - all
/// </param>
/// <param name="isNew"></param>
/// <returns></returns>
public List <Vehicles> Search(VehicleSearchCM form, bool?isNew = null)
{
List <Vehicles> result = new List <Vehicles>();
using (SqlConnection conn = new SqlConnection(Settings.GetConnectionString()))
{
var sql = @" SELECT Vehicle.vehicleId, Vehicle.vin, Vehicle.year, Vehicle.bodyStyle, Vehicle.transmission, Vehicle.type, Vehicle.mileage, Vehicle.color, Vehicle.interior, Vehicle.description, Vehicle.msrp, Vehicle.salePrice, Make.makeId,
Model.modelId, Make.make, Model.model
FROM Vehicle INNER JOIN
Model ON Vehicle.modelId = Model.modelId INNER JOIN
Make ON Model.makeId = Make.makeId
WHERE 1 = 1";
switch (isNew)
{
case null:
break;
case true:
sql += " AND type = 'new'";
break;
case false:
sql += " AND type = 'used'";
break;
}
SqlCommand cmd = new SqlCommand(sql, conn);
if (!string.IsNullOrEmpty(form.Input))
{
sql += " AND ( year LIKE @input";
sql += " OR model LIKE @input";
sql += " OR make LIKE @input )";
cmd.Parameters.AddWithValue("@input", form.Input);
}
if (form.YearMin.HasValue)
{
sql += " AND year >= @yearMin";
cmd.Parameters.AddWithValue("@yearMin", form.YearMin);
}
if (form.YearMax.HasValue)
{
sql += " AND year <= @yearMax";
cmd.Parameters.AddWithValue("@yearMax", form.YearMax);
}
if (form.PriceMin.HasValue)
{
sql += " AND salePrice >= @priceMin";
cmd.Parameters.AddWithValue("@priceMin", form.PriceMin);
}
if (form.PriceMax.HasValue)
{
sql += " AND salePrice <= @priceMax";
cmd.Parameters.AddWithValue("@priceMax", form.PriceMax);
}
cmd.CommandText = sql;
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Vehicles currentVehicle = new Vehicles();
currentVehicle.VehicleId = (int)dr["VehicleId"];
currentVehicle.Vin = dr["Vin"].ToString();
currentVehicle.Year = dr["Year"].ToString();
currentVehicle.BodyStyle = dr["BodyStyle"].ToString();
currentVehicle.Transmission = dr["Transmission"].ToString();
currentVehicle.Mileage = (int)dr["Mileage"];
currentVehicle.Color = dr["Color"].ToString();
currentVehicle.Interior = dr["Interior"].ToString();
currentVehicle.Msrp = (decimal)dr["Msrp"];
currentVehicle.SalePrice = (decimal)dr["SalePrice"];
currentVehicle.MakeId = (int)dr["MakeId"];
currentVehicle.ModelId = (int)dr["ModelId"];
result.Add(currentVehicle);
}
}
conn.Close();
}
return(result);
}
public SalesIndexVM()
{
VehicleSearchCM Form = new VehicleSearchCM();
}
public InventoryNewVM()
{
VehicleSearchCM Form = new VehicleSearchCM();
}
public AdminVehiclesVM()
{
VehicleSearchCM Form = new VehicleSearchCM();
}
public List <Vehicles> Search(VehicleSearchCM form, bool?isUsed = null)
{
throw new NotImplementedException();
}
public List <Vehicles> Search(VehicleSearchCM form)
{
throw new NotImplementedException();
}
