public int AddDateBooking(int dateAvaliableId, int userId, DateTime startDateBooking, DateTime endDateBooking, decimal paid, decimal totalCostByRoom) { ChannelManagerDataSet.DateAvaliableRow dateAvaliableRow = _dataSet.DateAvaliable.FindByid(dateAvaliableId); ChannelManagerDataSet.UsersRow usersRow = _dataSet.Users.FindByid(userId); ChannelManagerDataSet.DateBookingRow newDateBookingRow = _dataSet.DateBooking.AddDateBookingRow(dateAvaliableRow, usersRow, startDateBooking, endDateBooking, paid, totalCostByRoom); return(_dateBookingTableAdapter.Update(newDateBookingRow)); }
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 AddBooking(int dateAvaliableId, String firstName, String surName, String patronymic, int passportSeries, int passportNum, DateTime startDateRate, DateTime endDateRate, decimal paid, decimal totalCostByRoom) { ChannelManagerDataSet.DateAvaliableRow dateAvaliableRow = _dataSet.DateAvaliable.FindByid(dateAvaliableId); int newUserId = AddUser(firstName, surName, patronymic, passportSeries, passportNum); if (newUserId >= 0) { ChannelManagerDataSet.UsersRow userRow = _dataSet.Users.FindByid(newUserId); ChannelManagerDataSet.DateBookingRow newDateBookingRow = _dataSet.DateBooking.AddDateBookingRow(dateAvaliableRow, userRow, startDateRate, endDateRate, paid, totalCostByRoom); _usersTableAdapter.Update(newDateBookingRow); return(newDateBookingRow.id); } else { return(-1); //Ошибка добавления пользователя в БД. } }
public int AddPrice(int dateAvaliableId, decimal price) { ChannelManagerDataSet.DateAvaliableRow dateAvailableRow = _dataSet.DateAvaliable.FindByid(dateAvaliableId); ChannelManagerDataSet.PriceRow newPriceRow = _dataSet.Price.AddPriceRow(dateAvailableRow, price); return(_priceTableAdapter.Update(newPriceRow)); }
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)); }