public void updateReservation(eReservation e) { tbl_Reservation temp = db.tbl_Reservations.Where(x => x.ReservationID == e.ReservationID).FirstOrDefault(); temp.ReservationDate = e.ReservationDate; temp.CustomerID = e.CustomerID; db.SubmitChanges(); }
public void insertReservation(eReservation e) { tbl_Reservation temp = new tbl_Reservation(); temp.ReservationDate = e.ReservationDate; temp.CustomerID = e.CustomerID; db.tbl_Reservations.InsertOnSubmit(temp); db.SubmitChanges(); }
public bool deleteReservation(int rid) { tbl_Reservation temp = db.tbl_Reservations.Where(x => x.ReservationID == rid).FirstOrDefault(); if (temp != null) { db.tbl_Reservations.DeleteOnSubmit(temp); db.SubmitChanges(); return(true); } return(false); }