public string bookRoom(Booking model) { try { if (model != null) { var bookingRecord = _dbContext.Booking_Detail.Where(m => m.RoomId == model.RoomId && DbFunctions.TruncateTime(m.BookingDate) == model.BookingDate).FirstOrDefault(); if (bookingRecord == null) { Database.Booking_Detail booking = new Database.Booking_Detail(); booking.RoomId = model.RoomId; booking.BookingsStatus = BookingsStatus.Optional.ToString(); booking.BookingDate = model.BookingDate; _dbContext.Booking_Detail.Add(booking); _dbContext.SaveChanges(); return("Booking of room no " + model.RoomId + " has been confirmed on " + model.BookingDate + " with optional status"); } else { return("Room is already booked on " + model.BookingDate); } } return("ID and date can are required"); } catch (Exception ex) { return(ex.Message); } }
public string deleteBooking(Booking model) { try { if (model.BookingId != null) { Database.Booking_Detail booking = _dbContext.Booking_Detail.Find(model.BookingId); if (booking != null) { booking.BookingsStatus = BookingsStatus.Deleted.ToString(); _dbContext.SaveChanges(); return("Status of Booking id " + model.BookingId + " has been changed to deleted"); } else { return("Booking No " + model.BookingId + " is not there nothing to delete"); } } return("Booking id is empty"); } catch (Exception ex) { return(ex.Message); } }