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