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