public List<SearchResult> getResults(String vehiclecategory, String bodystyle, String avail_city, String sort)
{
dc = new LINQDBDataContext();
List<SearchResult> r;
if (sort == "Daily hire rate")
r = (from v in dc.Vehicles
join m in dc.Manufacturers on v.manufacturer_code equals m.manufacturer_code
join vc in dc.VehicleCategories on v.vehicle_category_code equals vc.vehicle_category_code
join mdl in dc.Models on v.model_code equals mdl.model_code
where vc.vehicle_category_description == vehiclecategory && mdl.body_style == bodystyle && v.current_city == avail_city
orderby v.daily_hire_rate ascending
select new SearchResult { vehicle_id = v.vehicle_id, registration_number = v.registration_number, manufacturer_name = m.manufacturer_name, model_code = v.model_code, manufacturing_date = v.manufacturing_date, daily_hire_rate = v.daily_hire_rate }).ToList();
else if (sort == "Manufacturer Name")
r = (from v in dc.Vehicles
join m in dc.Manufacturers on v.manufacturer_code equals m.manufacturer_code
join vc in dc.VehicleCategories on v.vehicle_category_code equals vc.vehicle_category_code
join mdl in dc.Models on v.model_code equals mdl.model_code
where vc.vehicle_category_description == vehiclecategory && mdl.body_style == bodystyle && v.current_city == avail_city
orderby m.manufacturer_name ascending
select new SearchResult { vehicle_id = v.vehicle_id, registration_number = v.registration_number, manufacturer_name = m.manufacturer_name, model_code = v.model_code, manufacturing_date = v.manufacturing_date, daily_hire_rate = v.daily_hire_rate }).ToList();
else
r = (from v in dc.Vehicles
join m in dc.Manufacturers on v.manufacturer_code equals m.manufacturer_code
join vc in dc.VehicleCategories on v.vehicle_category_code equals vc.vehicle_category_code
join mdl in dc.Models on v.model_code equals mdl.model_code
where vc.vehicle_category_description == vehiclecategory && mdl.body_style == bodystyle && v.current_city == avail_city
orderby v.manufacturing_date ascending
select new SearchResult { vehicle_id = v.vehicle_id, registration_number = v.registration_number, manufacturer_name = m.manufacturer_name, model_code = v.model_code, manufacturing_date = v.manufacturing_date, daily_hire_rate = v.daily_hire_rate }).ToList();
return r;
}
public IEnumerable<Vehicle> getPickUp()
{
dc = new LINQDBDataContext();
List<Vehicle> pickup = (from v in dc.Vehicles
select new Vehicle { current_city = v.current_city }).Distinct().ToList();
return pickup;
}
public IEnumerable<VehicleCategory> getCategory()
{
dc = new LINQDBDataContext();
List<VehicleCategory> vc = (from vct in dc.VehicleCategories
select new VehicleCategory { vehicle_category_code = vct.vehicle_category_code.ToString(), vehicle_category_description = vct.vehicle_category_description.ToString() }).ToList();
return vc;
}
public IEnumerable<Model> getBodyStyle()
{
dc = new LINQDBDataContext();
List<Model> bs = (from mdt in dc.Models
select new Model { body_style = mdt.body_style}).Distinct().ToList();
return bs;
}
public ReviewModel getReview(int vehicle_id)
{
LINQDBDataContext dc = new LINQDBDataContext();
List<ReviewModel> rm = (from v in dc.Vehicles
join mdl in dc.Models on v.model_code equals mdl.model_code
join vc in dc.VehicleCategories on v.vehicle_category_code equals vc.vehicle_category_code
join mf in dc.Manufacturers on v.manufacturer_code equals mf.manufacturer_code
where v.vehicle_id == vehicle_id
select new ReviewModel { registration_number = v.registration_number, manufacturer_name = mf.manufacturer_name, model_code = v.model_code, body_style = mdl.body_style,
automatic = mdl.automatic, passenger_capacity = mdl.passenger_capacity, vehicle_category_description = vc.vehicle_category_description, manufacturing_date = v.manufacturing_date,
availability = v.availability, daily_rental_rate = v.daily_hire_rate}).ToList();
return rm[0];
}
