public String GetIpAddrByHotelNumId(int hotelNumId)
        {
            ChannelManagerDataSet.HotelRoomsRow           hotelRoomRow = _dataSet.HotelRooms.FindByid(hotelNumId);
            ChannelManagerDataSet.HotelRoomsCategoriesRow catRow       = hotelRoomRow.HotelRoomsCategoriesRow;
            ChannelManagerDataSet.HotelsRow      hotelRow = catRow.HotelsRow;
            ChannelManagerDataSet.ARIIpAddrRow[] ipRows   = hotelRow.GetARIIpAddrRows();
            String resultString = "";

            foreach (ChannelManagerDataSet.ARIIpAddrRow ip in ipRows)
            {
                resultString += ip.ipAddr + ';';
            }
            return(resultString);
        }
        public String GetIpAddrByNewBooking(int bookingId)
        {
            ChannelManagerDataSet.DateBookingRow          bookingRow    = _dataSet.DateBooking.FindByid(bookingId);
            ChannelManagerDataSet.DateAvaliableRow        dateAvaliable = bookingRow.DateAvaliableRow;
            ChannelManagerDataSet.HotelRoomsRow           hotelRoomRow  = dateAvaliable.HotelRoomsRow;
            ChannelManagerDataSet.HotelRoomsCategoriesRow catRow        = hotelRoomRow.HotelRoomsCategoriesRow;
            ChannelManagerDataSet.HotelsRow      hotelRow = catRow.HotelsRow;
            ChannelManagerDataSet.ARIIpAddrRow[] ipRows   = hotelRow.GetARIIpAddrRows();
            String resultString = "";

            foreach (ChannelManagerDataSet.ARIIpAddrRow ip in ipRows)
            {
                resultString += ip.ipAddr + ';';
            }
            return(resultString);
        }
 public int AddDateAvaliable(int hotelNumId, DateTime startDate, DateTime endDate)
 {
     ChannelManagerDataSet.HotelRoomsRow    numRow = _dataSet.HotelRooms.FindByid(hotelNumId);
     ChannelManagerDataSet.DateAvaliableRow newDateAvaliableRow = _dataSet.DateAvaliable.AddDateAvaliableRow(numRow, startDate, endDate);
     return(_dateAvaliableTableAdapter.Update(newDateAvaliableRow));
 }
 public int AddHotelNum(int hotelClassId, String hotelNum)
 {
     ChannelManagerDataSet.HotelRoomsCategoriesRow catRow    = _dataSet.HotelRoomsCategories.FindByid(hotelClassId);
     ChannelManagerDataSet.HotelRoomsRow           newNumRow = _dataSet.HotelRooms.AddHotelRoomsRow(catRow, hotelNum);
     return(_hotelRoomTableAdapter.Update(newNumRow));
 }