public double getCostPrice(string Type)
        {
            DataSetHotelTableAdapters.roomsTableAdapter cost = new HotelWebService.DataSetHotelTableAdapters.roomsTableAdapter();
            double costPrice1 = (double)cost.costPrice(Type);

            return costPrice1;
        }
        public double getMaxPrice(string Type)
        {
            DataSetHotelTableAdapters.roomsTableAdapter max = new HotelWebService.DataSetHotelTableAdapters.roomsTableAdapter();
            double MaxPrice1 = (double)max.maxPrice(Type);

            return MaxPrice1;
        }
        public int GetAvailableRooms(string Type)
        {
            DataSetHotelTableAdapters.roomsTableAdapter rooms = new HotelWebService.DataSetHotelTableAdapters.roomsTableAdapter();
            int Available = (int)rooms.getAvailableRooms(Type);

            return Available;
        }
        public bool IsAvailable(string Type, int NumberOfRooms,DateTime Arrival,DateTime Departure)
        {
            DataSetHotelTableAdapters.bookingTableAdapter booking = new HotelWebService.DataSetHotelTableAdapters.bookingTableAdapter();
            int UnavailableRooms = (int)booking.getUnavailable(Arrival, Departure, Type);

            DataSetHotelTableAdapters.roomsTableAdapter rooms = new HotelWebService.DataSetHotelTableAdapters.roomsTableAdapter();
            int TotalRooms = (int)rooms.getAvailableRooms(Type);
            int Available = TotalRooms - UnavailableRooms;

            if (Available >= NumberOfRooms)
            {
                return true;

            }
            else
            {
                return false;
            }
        }