public ActionResult Index()
{
ICarDealerRepository _repo = RepositoryFactory.Create();
VehicleSearch search = new VehicleSearch();
return(View(search));
}
public IEnumerable <Vehicle> Execute(VehicleSearch request)
{
var keyword = request.Keyword;
var query = AiContext.Vehicles
.AsQueryable()
.Where(x => x.IsDeleted == 0);
if (keyword != null)
{
query = query
.Where(x => x.Model.ToLower().Contains(keyword.ToLower()));
}
return(query);
// .Select(x => new VehicleResponseDTO
// {
// Id = x.Id,
// Model = x.Model,
// CostPerDay = x.CostPerDay,
// Color = x.Color,
// FuelTankCapacity = x.FuelTankCapacity,
// VehicleType = x.VehicleType.Name,
// VehicleBrand = x.Brand.Name,
//Automatic = x.Automatic,
//Rented = x.Rented
// });
}
public IHttpActionResult Used(VehicleSearch search)
{
ICarDealerRepository _repo = RepositoryFactory.Create();
IEnumerable <Car> usedInventory = _repo.GetInventory("UsedVehicleSearch", search);
return(Ok(usedInventory));
}
public IHttpActionResult New(VehicleSearch search)
{
ICarDealerRepository _repo = RepositoryFactory.Create();
IEnumerable <Car> newInventory = _repo.GetInventory("NewVehicleSearch", search);
return(Ok(newInventory));
}
public ActionResult Vehicles()
{
ViewBag.ReturnUrl = "/Admin/Vehicles";
ICarDealerRepository _repo = RepositoryFactory.Create();
VehicleSearch search = new VehicleSearch();
return(View(search));
}
public IHttpActionResult Admin(VehicleSearch search)
{
ICarDealerRepository _repo = RepositoryFactory.Create();
IEnumerable <Car> salesInventory = _repo.GetInventory("AdminVehicleSearch", search);
return(Ok(salesInventory));
}
public IHttpActionResult Sales(VehicleSearch search)
{
ICarDealerRepository _repo = RepositoryFactory.Create();
IEnumerable <Car> salesInventory = _repo.GetInventory("SelectAllUnsoldVehicles", search);
return(Ok(salesInventory));
}
public ActionResult DeleteConfirmed(int id)
{
VehicleSearch vehicleSearch = db.VehicleSearches.Find(id);
db.VehicleSearches.Remove(vehicleSearch);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Regnr,Color")] VehicleSearch vehicleSearch)
{
if (ModelState.IsValid)
{
db.Entry(vehicleSearch).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vehicleSearch));
}
public ActionResult Create([Bind(Include = "Id,Regnr,Color")] VehicleSearch vehicleSearch)
{
if (ModelState.IsValid)
{
db.VehicleSearches.Add(vehicleSearch);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vehicleSearch));
}
public List <SearchModel> GetUsedVehicles(VehicleSearch vehicleSearch)
{
List <SearchModel> newOrUsedVehicles = new List <SearchModel>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetUsedVehicles";
cmd.Parameters.AddWithValue("@SearchString", vehicleSearch.searchString);
cmd.Parameters.AddWithValue("@NewOrUsed", vehicleSearch.newOrUsed);
cmd.Parameters.AddWithValue("@minPrice", vehicleSearch.minPrice);
cmd.Parameters.AddWithValue("@maxPrice", vehicleSearch.maxPrice);
cmd.Parameters.AddWithValue("@minYear", vehicleSearch.minYear);
cmd.Parameters.AddWithValue("@maxYear", vehicleSearch.maxYear);
conn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
SearchModel currentRow = new SearchModel();
currentRow.vehicle_ID = (int)dr["vehicle_ID"];
currentRow.year = (int)dr["year"];
currentRow.make = dr["make"].ToString();
currentRow.model = dr["model"].ToString();
currentRow.carType = dr["carType"].ToString();
currentRow.bodyStyle = dr["bodyStyle"].ToString();
currentRow.transmission = dr["transmission"].ToString();
currentRow.outerColor = dr["color"].ToString();
currentRow.interior = dr["interior"].ToString();
currentRow.mileage = (int)dr["mileage"];
currentRow.vin = dr["vinNumber"].ToString();
currentRow.msrp = (decimal)dr["msrp"];
currentRow.salePrice = (decimal)dr["salePrice"];
currentRow.picture = dr["picture"].ToString();
currentRow.description = null;
newOrUsedVehicles.Add(currentRow);
}
}
}
return(newOrUsedVehicles);
}
public ActionResult <IEnumerable <VehicleResponseDTO> > Get([FromQuery] VehicleSearch search)
{
try
{
var vehicles = _getVehicles.Execute(search);
var vehicleList = _mapper.Map <IEnumerable <VehicleResponseDTO> >(vehicles);
return(Ok(vehicleList));
}
catch (Exception)
{
return(StatusCode(500, "Server error"));
}
}
// GET: VehicleSearches/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VehicleSearch vehicleSearch = db.VehicleSearches.Find(id);
if (vehicleSearch == null)
{
return(HttpNotFound());
}
return(View(vehicleSearch));
}
public IEnumerable <Car> GetInventory(string sproc, VehicleSearch search)
{
List <Car> vehicles = new List <Car>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
SqlCommand cmd = new SqlCommand(sproc, cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@stringMakeModelOrYear", search.StringMakeModelOrYear);
cmd.Parameters.AddWithValue("@minPrice", search.MinPrice);
cmd.Parameters.AddWithValue("@maxPrice", search.MaxPrice);
cmd.Parameters.AddWithValue("@minYear", search.MinYear);
cmd.Parameters.AddWithValue("@maxYear", search.MaxYear);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Car vehicle = new Car();
vehicle.CarId = (int)dr["CarId"];
vehicle.Image = dr["Image"].ToString();
vehicle.Make = dr["Make"].ToString();
vehicle.Model = dr["Model"].ToString();
vehicle.BodyStyle = dr["BodyStyle"].ToString();
vehicle.Transmission = dr["Transmission"].ToString();
vehicle.ExteriorColor = dr["ExteriorColor"].ToString();
vehicle.InteriorColor = dr["InteriorColor"].ToString();
vehicle.Mileage = (int)dr["Mileage"];
vehicle.VIN = dr["VIN"].ToString();
vehicle.Price = (decimal)dr["Price"];
vehicle.MSRP = (decimal)dr["MSRP"];
vehicle.Year = (int)dr["Year"];
vehicles.Add(vehicle);
}
}
}
return(vehicles);
}
public bool SearchBasedOnVehicle()
{
if (string.IsNullOrEmpty(VehicleSearch))
{
return(false);
}
if (RegisteredVehicles == null)
{
return(false);
}
var vehicle = new List <VehicleModel>();
vehicle = RegisteredVehicles?.Vehicles?.Where(t => t.Nickname.ToLowerInvariant().Equals(VehicleSearch.ToLowerInvariant())).ToList();
if (vehicle.Count == 0)
{
vehicle = RegisteredVehicles?.Vehicles?.Where(t => t.Make.ToLowerInvariant().Equals(VehicleSearch.ToLowerInvariant())).ToList();
if (vehicle.Count == 0)
{
return(false);
}
}
VehicleModels = vehicle;
return(true);
}
