public void updateReservationTitle(eReservationTitle e)
{
tbl_ReservationTitle temp = db.tbl_ReservationTitles.Where(x => x.ReservationID == e.ReservationID).FirstOrDefault();
temp.ReservationID = e.ReservationID;
temp.TitleID = e.TitleID;
db.SubmitChanges();
}
public void insertReservationTitle(eReservationTitle e)
{
tbl_ReservationTitle temp = new tbl_ReservationTitle();
temp.ReservationID = e.ReservationID;
temp.TitleID = e.TitleID;
db.tbl_ReservationTitles.InsertOnSubmit(temp);
db.SubmitChanges();
}
public bool deleteReservationTitle(int rid, int tid)
{
//var qr = from d in db.tbl_DiskRentals
// where (d.RentalID==rid) && (d.DiskID==did)
// select d;
tbl_ReservationTitle temp = db.tbl_ReservationTitles.Where(x => x.ReservationID == rid && x.TitleID == tid).FirstOrDefault();
if (temp != null)
{
db.tbl_ReservationTitles.DeleteOnSubmit(temp);
db.SubmitChanges();
return(true);
}
return(false);
}
