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);
     }
 }