public int SaveBooking(Booking b)
{
try
{
int j = -1;
dc = new LSQLDataContext();
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 bool deleteBooking(int booking_id)
{
try
{
dc = new LSQLDataContext();
var bk = (from b in dc.Bookings
where b.booking_id == booking_id
select b);
dc.Bookings.DeleteAllOnSubmit(bk);
dc.SubmitChanges();
}
catch (Exception)
{
return false;
}
return true;
}
public int SaveCustomer(Customer c)
{
try
{
dc = new LSQLDataContext();
dc.Customers.InsertOnSubmit(c);
dc.SubmitChanges();
}
catch (Exception)
{
return -1;
}
return 0;
}
