public int SaveBooking(Booking b) { try { int j = -1; LINQDBDataContext dc = new LINQDBDataContext(); IQueryable<int> d = from r in dc.Bookings orderby r.booking_id ascending select r.booking_id; foreach (int i in d) { j = i; } b.booking_id = j + 1; dc.Bookings.InsertOnSubmit(b); dc.SubmitChanges(); } catch (Exception) { return -1; } return b.booking_id; }
public int SaveCustomer(Customer c) { try { LINQDBDataContext dc = new LINQDBDataContext(); dc.Customers.InsertOnSubmit(c); dc.SubmitChanges(); } catch (Exception) { return -1; } return 0; }
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]; }