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(); }