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