public string bookRoom(Booking model)
        {
            try
            {
                if (model != null)
                {
                    var entity = dbContext.tbl_room.Find(model.roomid);


                    DAL.Database.tbl_room room = new DAL.Database.tbl_room();

                    DAL.Database.tbl_booking book = new DAL.Database.tbl_booking();

                    book.bookingDate     = model.bookingDate;
                    book.roomid          = model.roomid;
                    book.statusOfBooking = "Definitive";
                    book.hotelid         = model.hotelid;
                    book.isActive        = 0;

                    entity.isActive = 1;


                    dbContext.tbl_booking.Add(book);
                    dbContext.SaveChanges();
                    return("Booked Successfully.");
                }
                return("Model is Null.");
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
        public string createRoom(Room model)
        {
            try
            {
                if (model != null)
                {
                    DAL.Database.tbl_room entities = new DAL.Database.tbl_room();


                    entities.hotelid     = model.hotelid;
                    entities.category    = model.category;
                    entities.price       = model.price;
                    entities.createdBy   = model.createdBy;
                    entities.createdDate = DateTime.Now;
                    entities.updatedBy   = model.updatedBy;
                    entities.updateDate  = DateTime.Now;
                    entities.roomName    = model.roomName;
                    entities.isActive    = 0;



                    dbContext.tbl_room.Add(entities);

                    dbContext.SaveChanges();
                    return("Room Booked Successfully.");
                }
                return("Model is Null.");
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }