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