public List <VehicleRentalPriceDTO> Get(VehicleRentalPriceFilter filter) { var items = (from p in Context.VehicleRentalPrice.Include(x => x.Vehicle.VehicleModel.VehicleBrand) .Include(x => x.RentalPeriod) where p.VehicleId == filter.VehicleId && ( filter.Date.HasValue == false || (filter.Date.HasValue == true && p.StartDate <= filter.Date.Value && p.EndDate >= filter.Date.Value) ) orderby p.StartDate descending select new VehicleRentalPriceDTO { Id = p.Id, StartDate = p.StartDate, EndDate = p.EndDate, Price = p.Price, RentalPeriodId = p.RentalPeriodId, RentalPeriodName = p.RentalPeriod.Name, VehicleId = p.VehicleId, VehicleModelName = p.Vehicle.VehicleModel.Name, VehicleBrandName = p.Vehicle.VehicleModel.VehicleBrand.Name }).ToList(); return(items); }
// GET: VehicleRentalPriceController public ActionResult Index(int vehicleId) { VehicleRentalPriceFilter filter = new VehicleRentalPriceFilter(vehicleId); var items = VehicleRentalPriceService.Get(filter); SetVehicleToViewBag(vehicleId); return(View(items)); }