public string bookRoom(Booking model) { try { if (model != null) { var bookingRecord = _dbContext.Bookings.Where(m => m.ID == model.ID && m.Booking_Date == model.Booking_Date).FirstOrDefault(); if (bookingRecord == null) { EntityDB.Booking booking = new EntityDB.Booking(); booking.Room_ID = model.Room_ID; booking.Status = BookingsStatus.Optional.ToString(); booking.Booking_Date = model.Booking_Date; _dbContext.Bookings.Add(booking); _dbContext.SaveChanges(); return("Booking sucessfull for " + model.Booking_Date + " with Room ID:" + booking.Room_ID + " having " + booking.Status + " status"); } else { return("Sorry , it is already booked by someone else on " + model.Booking_Date); } } throw new NullReferenceException(); } catch (Exception ex) { return(ex.Message); } }
public string deleteBooking(Booking model) { try { if (model.ID != null) { EntityDB.Booking booking = _dbContext.Bookings.Find(model.ID); if (booking != null) { booking.Status = BookingsStatus.Deleted.ToString(); _dbContext.SaveChanges(); return(" Changed Status of Booking ID" + model.ID + " to " + booking.Status); } else { return(" Oops we cannot find any booking with ID:" + model.ID); } } throw new NullReferenceException(); } catch (Exception ex) { return(ex.Message); } }