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