public void update(customer cust, String type) { customer custme = hrs.customers.Where(x => (x.cust_id == cust.cust_id)).FirstOrDefault(); booking bkg = hrs.bookings.Where(x => (x.Booking_id == cust.booking.Booking_id)).FirstOrDefault(); ; if (type == custme.booking.room.room_type) { hrs.Entry(custme).CurrentValues.SetValues(cust); hrs.Entry(bkg).CurrentValues.SetValues(cust.booking); hrs.SaveChanges(); } else { room roo = hrs.rooms.Where(y => (y.room_ == cust.booking.Room_)).FirstOrDefault(); // for changing room ststus room rm = hrs.rooms.Where(y => (y.room_type == type && y.status == "unreserved")).FirstOrDefault(); cust.booking.Room_ = rm.room_; rm.status = "reserved"; cust.booking.room.status = rm.status; hrs.Entry(custme).CurrentValues.SetValues(cust); hrs.Entry(bkg).CurrentValues.SetValues(cust.booking); roo.status = "unreserved"; hrs.SaveChanges(); } }
public void addpayment(customer cus, booking bk, payment pay) { customer cust = hrs.customers.Where(x => (x.fname == cus.fname && x.lastname == cus.lastname && x.cell_no == cus.cell_no && x.cnic == cus.cnic)).FirstOrDefault(); pay.cust_id = cust.cust_id; pay.Booking_id = cust.booking.Booking_id; hrs.payments.Add(pay); hrs.SaveChanges(); }
public void paid(record rcd) { hrs.records.Add(rcd); hrs.SaveChanges(); customer custm = hrs.customers.Where(x => (x.cnic == rcd.CNIC_)).FirstOrDefault(); payment pay = hrs.payments.Where(x => (x.cust_id == custm.cust_id)).FirstOrDefault(); booking bk = hrs.bookings.Where(x => (x.Booking_id == pay.Booking_id)).FirstOrDefault(); bk.room.status = "unreserved"; hrs.SaveChanges(); hrs.bookings.Remove(bk); hrs.payments.Remove(pay); hrs.customers.Remove(custm); hrs.SaveChanges(); }
public void deletebooking(customer cust) { customer custme = hrs.customers.Where(x => (x.cust_id == cust.cust_id)).FirstOrDefault(); booking bok = hrs.bookings.Where(x => (x.Booking_id == cust.booking_id)).FirstOrDefault(); System.Console.WriteLine(bok.booking_date); System.Console.WriteLine(bok.Booking_id); System.Console.WriteLine(bok.cust_id); System.Console.WriteLine(bok.Room_); System.Console.WriteLine(bok.leave_date); payment py = hrs.payments.Where(x => (x.cust_id == cust.cust_id)).FirstOrDefault(); hrs.customers.Remove(custme); hrs.SaveChanges(); hrs.bookings.Remove(bok); hrs.payments.Remove(py); hrs.SaveChanges(); }
public void addbooking(booking bk, customer cus, String rm_type) { customer cust = hrs.customers.Where(x => (x.fname == cus.fname && x.lastname == cus.lastname && x.cell_no == cus.cell_no && x.cnic == cus.cnic)).FirstOrDefault(); bk.cust_id = cust.cust_id; room roo = hrs.rooms.Where(x => (x.room_type == rm_type && x.status == "unreserved")).FirstOrDefault(); bk.Room_ = roo.room_; hrs.bookings.Add(bk); hrs.SaveChanges(); roo.status = "reserved"; hrs.SaveChanges(); booking bok = hrs.bookings.Where(x => (x.cust_id == cust.cust_id)).FirstOrDefault(); int cbok = bok.Booking_id; cust.booking_id = cbok; hrs.SaveChanges(); }
public void addbooking(booking bk, customer cus, String type) { hrsda.addbooking(bk, cus, type); }
public void addpayment(customer cus, booking bk, payment pay) { hrsda.addpayment(cus, bk, pay); }