public IHttpActionResult PostHotelRoomType(HotelRoomType hotelRoomType) { db.HotelRoomTypes.Add(hotelRoomType); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = hotelRoomType.hotelRoomTypeID }, hotelRoomType)); }
public async Task <IActionResult> Puthotel_room_type([FromRoute] int id, [FromBody] HotelRoomTypeDTO hotel_room_type) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != hotel_room_type.Id) { return(BadRequest()); } HotelRoomType hotel_room_type_map = Mapper.Map <HotelRoomType>(hotel_room_type); _context.Entry(hotel_room_type_map).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!hotel_room_typeExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public IHttpActionResult PutHotelRoomType(int id, HotelRoomType hotelRoomType) { if (id != hotelRoomType.hotelRoomTypeID) { return(BadRequest()); } db.Entry(hotelRoomType).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!HotelRoomTypeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public override async void ReceiveMessageAsync(EventArgs e) { string userInput = (e as CallbackQueryEventArgs).CallbackQuery.Data; Chat chat = (e as CallbackQueryEventArgs).CallbackQuery.Message.Chat; if (!Validator.CheckNumber(userInput)) { await ServicesMessageController.SendMessageAsync(chat, Validator.BadNumber); return; } long roomTypeId = int.Parse(userInput); HotelRoomType roomType = ServicesHotelRoomType.GetHotelRoomTypeById(roomTypeId); List <string> photos = DbServices.GetHotelRoomTypeImagesUrl(roomTypeId); if (roomType == null) { await ServicesMessageController.SendMessageAsync( chat, "Такого типу номеру не існує", Keyboards.ReturnMainMenu); return; } string message = ViewRoomType.GetTextAboutRoomType(roomType); await ServicesMessageController.SendPhotosAsync(chat.Id, photos); await ServicesMessageController.SendMessageAsync(chat, message, Keyboards.ReturnMainMenu); responder.SetState(new HotelRoom_0()); }
public async Task <IActionResult> Posthotel_room_type([FromBody] HotelRoomTypeDTO hotel_room_type) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { HotelRoomType hotel_room_type_map = Mapper.Map <HotelRoomType>(hotel_room_type); _context.HotelRoomType.Add(hotel_room_type_map); await _context.SaveChangesAsync(); } catch (DbUpdateException) { if (hotel_room_typeExists(hotel_room_type.Id)) { return(new StatusCodeResult(StatusCodes.Status409Conflict)); } else { throw; } } return(CreatedAtAction("Gethotel_room_type", new { id = hotel_room_type.Id }, hotel_room_type)); }
internal static string GetTextAboutRoomType(HotelRoomType roomType) { return("" + $"*{roomType.Name}*\n\n" + $"{roomType.Description}\n\n" + $"*Площа:* {roomType.Area} м^2\n" + $"*Послуги:* {roomType.Services}\n\n" + $"*Ціна за ніч:* {roomType.Price} грн"); }
public IEnumerable <HotelRoomTypeDTO> GetHotelRoomType() { HotelRoomType hotel_room_type = new HotelRoomType(); var model = Mapper.Map <HotelRoomType, HotelRoomTypeDTO>(hotel_room_type); var hotel_room_types = _context.HotelRoomType.ToList(); List <HotelRoomTypeDTO> list_obj = Mapper.Map <List <HotelRoomType>, List <HotelRoomTypeDTO> >(hotel_room_types); return(list_obj); }
private void open_one_seat(HotelRoom seat, bool child, BathDBDataContext dc) { if (seat.status == 3) { BathClass.reset_seat(seat); dc.SubmitChanges(); } seat.openEmployee = LogIn.m_User.id.ToString(); seat.openTime = BathClass.Now(LogIn.connectionString); seat.systemId = BathClass.systemId(db, LogIn.connectionString); seat.status = 2; if (!seatlock) { seat.chainId = chainId; } HotelRoomType seatType = dc.HotelRoomType.FirstOrDefault(x => x.id == seat.typeId); var menu = dc.Menu.FirstOrDefault(x => x.id == seatType.menuId); if (menu != null) { Orders order = new Orders(); order.menu = menu.name; order.text = seat.text; order.systemId = seat.systemId; order.number = 1; order.money = menu.price; order.inputTime = BathClass.Now(LogIn.connectionString); order.inputEmployee = LogIn.m_User.id.ToString(); order.paid = false; dc.Orders.InsertOnSubmit(order); } if (child) { var child_menu = dc.Menu.FirstOrDefault(x => x.name == "儿童浴资"); if (child_menu != null) { Orders order = new Orders(); order.menu = child_menu.name; order.text = seat.text; order.systemId = seat.systemId; order.number = 1; order.money = child_menu.price; order.inputTime = BathClass.Now(LogIn.connectionString); order.inputEmployee = LogIn.m_User.id.ToString(); order.paid = false; dc.Orders.InsertOnSubmit(order); } } dc.SubmitChanges(); }
public IHttpActionResult GetHotelRoomType(int id) { HotelRoomType hotelRoomType = db.HotelRoomTypes.Find(id); if (hotelRoomType == null) { return(NotFound()); } return(Ok(hotelRoomType)); }
public IHttpActionResult DeleteHotelRoomType(int id) { HotelRoomType hotelRoomType = db.HotelRoomTypes.Find(id); if (hotelRoomType == null) { return(NotFound()); } db.HotelRoomTypes.Remove(hotelRoomType); db.SaveChanges(); return(Ok(hotelRoomType)); }
internal static IReplyMarkup GetReservationsMenu(List <Reservation> listReservation) { List <List <InlineKeyboardButton> > keyboards = new List <List <InlineKeyboardButton> >(); foreach (Reservation r in listReservation) { HotelRoom room = ServicesHotelRoom.GetHotelRoomById(r.HotelRoomId); HotelRoomType roomType = ServicesHotelRoomType.GetHotelRoomTypeById(room.HotelRoomTypeId); keyboards.Add(new List <InlineKeyboardButton>() { InlineKeyboardButton.WithCallbackData( $"{roomType.Name}: {r.DateOfArrival}-{r.DateOfDeparture}", $"{r.Id}" ) }); } return(new InlineKeyboardMarkup(keyboards)); }
public async Task <IEnumerable <HotelModel> > GetAll(CancellationToken cancellationToken) { Random random = new Random(); List <HotelModel> allHotels = new List <HotelModel>(); HotelRoomType[] hotelTypes = new HotelRoomType[] { HotelRoomType.King, HotelRoomType.TwoQueens, HotelRoomType.Suite, HotelRoomType.Penthouse }; foreach (var airPort in (await _airportDataProvider.GetAll(cancellationToken))) { for (int dayOffset = -1; dayOffset < 7; dayOffset++) { DateTime today = DateTime.Now.Date.AddDays(dayOffset); TimeZoneInfo airPortTimeZone = ContosoTravel.Web.Application.Extensions.TimeZoneHelper.FindSystemTimeZoneById(airPort.TimeZone); DateTimeOffset startDate = DateTimeOffset.Parse($"{today.ToString("MM/dd/yyyy")} 12:00 AM {airPortTimeZone.BaseUtcOffset.Hours.ToString("00")}:{airPortTimeZone.BaseUtcOffset.Minutes.ToString("00")}"); if (airPortTimeZone.IsDaylightSavingTime(today)) { startDate = startDate.AddHours(1); } double baseCost = 200d; foreach (HotelRoomType hotelType in hotelTypes) { allHotels.Add(new HotelModel() { StartingTime = startDate, EndingTime = startDate.AddDays(1), RoomType = hotelType, Location = airPort.AirportCode, LocationAirport = airPort, Cost = random.NextDouble() * baseCost }); baseCost += 50d; } } } return(allHotels); }
internal static string GetTextAboutReservation(Reservation r, HotelRoomType t, HotelRoom room, int countDays) { return("" + $"*{t.Name}\n*" + $"\n" + $"Прізвище: {r.SecondName}\n" + $"Ім’я: {r.FirstName}\n" + $"По батькові: {r.MiddleName}\n" + $"Номер телефону: {r.Number}\n" + $"Email: {r.Email}\n" + $"Період: {r.DateOfArrival}-{r.DateOfDeparture}\n" + $"Дорослих: {r.NumberOfAdults}\n" + $"Дітей: {r.NumberOfChildren}\n" + $"\n" + $"Кімната: {room.Name}\n" + $"Поверх: {room.Floor}\n" + $"\n" + $"До оплати: {countDays * t.Price} грн\n" + $"\n" + $"Ідентифікатор для перевірки: *494ebf5f419ad02a86af25f8db5ed114790399c2aa6b233384b1b4b9ac3458e5*"); }
public override async void OnStateChange(Chat chat) { await ServicesMessageController.SendMessageAsync(chat, "Очікування бронювання"); responder.userTempData.TryGetValue("HotelRoomTypeId", out string hotelRoomTypeId); responder.userTempData.TryGetValue("DateOfArrival", out string arrival); responder.userTempData.TryGetValue("DateOfDeparture", out string departure); responder.userTempData.TryGetValue("SecondName", out string secondName); responder.userTempData.TryGetValue("FirstName", out string firstName); responder.userTempData.TryGetValue("MiddleName", out string middleName); responder.userTempData.TryGetValue("Number", out string number); responder.userTempData.TryGetValue("Email", out string email); responder.userTempData.TryGetValue("NumberOfAdults", out string adults); responder.userTempData.TryGetValue("NumberOfChildren", out string children); Reservation reservation = new Reservation() { IdUserChat = chat.Id, SecondName = secondName, FirstName = firstName, MiddleName = middleName, Number = number, Email = email, DateOfArrival = arrival, DateOfDeparture = departure, NumberOfAdults = int.Parse(adults), NumberOfChildren = int.Parse(children) }; Reservation r = await DbServices.AddReservationAsync(chat.Id, int.Parse(hotelRoomTypeId), reservation); HotelRoom room = ServicesHotelRoom.GetHotelRoomById(r.HotelRoomId); HotelRoomType t = ServicesHotelRoomType.GetHotelRoomTypeById(room.HotelRoomTypeId); int countDays = DbServices.GetIntermediateDates(r.DateOfArrival, r.DateOfArrival).Count; string text = ViewReservation.GetTextAboutReservation(r, t, room, countDays); await ServicesMessageController.SendMessageAsync(chat, text, Keyboards.ReturnMainMenu); }
public IActionResult Search(HotelSerachViewModel model) { DateTime TempchkIn = new DateTime(); DateTime TempchkOut = new DateTime(); var hotelList = new List <HotelListViewModel>(); HotelListViewModel hotelModel = null; List <Hotel> SearchHotels = new List <Hotel>(); HotelRoomType RoomType = new HotelRoomType(); int RoomCount = 0; // filtered Hotel by Hotel City And RoomType if (model.City != null && model.RoomTypeId > 0 && model.checkOut == null && model.checkIn == null) { SearchHotels = _filterHotelByCityAndRoomType. GetHotelByCityAndRoomType(model.City, model.checkIn, model.checkOut); RoomType = RoomTypeById(model.RoomTypeId); } // Filtered Hotel by Price and StarRating else if (model.Price > 0 && model.StarRatingid > 0) { SearchHotels = _filterHotelByPriceAndHotelRatings. GetHotelByPriceAndHotelRatings(model.City, model.Price, model.StarRatingid, model.checkIn, model.checkOut); RoomType = RoomTypeById(model.hotelRoomTypeId); } // Filtered Hotel By HotelPrice else if (model.Price > 0 && model.StarRatingid == 0) { SearchHotels = _filterHotelByPrice. GetHotelByPrice(model.City, model.Price, model.checkIn, model.checkOut); RoomType = RoomTypeById(model.hotelRoomTypeId); } //Filtered Hotel By StarRating else if (model.Price == 0 && model.StarRatingid > 0) { SearchHotels = _filterHotelByHotelRatings. GetHotelByHotelRatings(model.City, model.StarRatingid , model.checkIn, model.checkOut); RoomType = RoomTypeById(model.hotelRoomTypeId); } //Filtered Hotel By Main Search Engine else if (model.City != null && model.checkIn != null && model.checkOut != null && model.RoomTypeId > 0) { SearchHotels = _hotelNetworkMainSearchEngine. GetHotelBySearchEngine(model.City, model.checkIn, model.checkOut); RoomType = RoomTypeById(model.RoomTypeId); TempchkIn = model.checkIn; TempchkOut = model.checkOut; } foreach (var hotel in SearchHotels) { var Rooms = _context.hotelRooms .Where(p => p.Hotel.HotelId == hotel.HotelId) .Where(p => p.HotelRoomType.HotelRoomTypeId == RoomType.HotelRoomTypeId).ToList(); if (Rooms != null) { foreach (var room in Rooms) { if (room.IsBooked == false) { RoomCount++; } else if (room.IsBooked == true) { if (_checkOutCheckInImplmentation. Check(room.HotelRoomId, model.checkIn, model.checkOut) == true) { RoomCount++; } } } } var Averagereview = _context.hotelReviews. Include(p => p.hotel).Where(p => p.hotel.HotelId == hotel.HotelId).ToList(); if (Averagereview != null) { for (int review = 0; review < Averagereview.Count; review++) { TotalStar = TotalStar + Averagereview[review].ReviewStar; } AverageStar = TotalStar / Averagereview.Count; } var RoomPrice = _context.hotelRooms. Include(p => p.Hotel).Where(p => p.Hotel.HotelId == hotel.HotelId).ToList(); if (RoomPrice != null) { for (int price = 0; price < RoomPrice.Count; price++) { TotalPrice = TotalPrice + RoomPrice[price].RsPernight; } Averageprice = TotalPrice / (RoomPrice.Count); } if (RoomCount > 0) { hotelModel = new HotelListViewModel() { HotelName = hotel.HotelName, HotelCity = model.City, NoOfRoomsFree = RoomCount, HotelImage = hotel.HotelImage, HotelId = hotel.HotelId, ReviewStar = AverageStar, AveragePrice = Averageprice, TotalReview = Averagereview.Count, hotelRoomtype = RoomType.RoomType, HotelRoomTypeId = RoomType.HotelRoomTypeId, }; if (TempchkIn != null && TempchkOut != null) { hotelModel.CheckIn = TempchkIn; hotelModel.CheckOut = TempchkOut; } hotelList.Add(hotelModel); AverageStar = 0; Averageprice = 0; TotalPrice = 0; TotalStar = 0; RoomCount = 0; } } return(View(hotelList)); }
//确定 private void btnOk_Click(object sender, EventArgs e) { var dc_new = new BathDBDataContext(LogIn.connectionString); if (m_open) { int i = 0; foreach (var seat in m_Seats) { var seat_tmp = dc_new.HotelRoom.FirstOrDefault(x => x.text == seat.text); var child = Convert.ToBoolean(dgv.Rows[i].Cells[2].Value); if (!seatlock) { open_one_seat(seat_tmp, child, dc_new); } else { var mtype = dc_new.HotelRoomType.FirstOrDefault(x => x.id == seat_tmp.typeId); if (mtype.menuId == null) { if (seat_tmp.status == 3) { BathClass.reset_seat(seat_tmp); dc_new.SubmitChanges(); } seat_tmp.openEmployee = LogIn.m_User.id.ToString(); seat_tmp.openTime = BathClass.Now(LogIn.connectionString); seat_tmp.systemId = BathClass.systemId(db, LogIn.connectionString); seat_tmp.status = 2; } seat_tmp.chainId = chainId; HotelRoomType seatType = dc_new.HotelRoomType.FirstOrDefault(x => x.id == seat_tmp.typeId); var menu = dc_new.Menu.FirstOrDefault(x => x.id == seatType.menuId); var child_menu = dc_new.Menu.FirstOrDefault(x => x.name == "儿童浴资"); if (menu != null) { Orders order = new Orders(); order.menu = menu.name; order.text = seat_tmp.text; order.systemId = seat_tmp.systemId; order.number = 1; order.money = menu.price; order.inputTime = BathClass.Now(LogIn.connectionString); order.inputEmployee = LogIn.m_User.id.ToString(); order.paid = false; order.departmentId = 1; dc_new.Orders.InsertOnSubmit(order); if (child) { Orders child_order = new Orders(); child_order.menu = child_menu.name; child_order.text = seat_tmp.text; child_order.systemId = seat_tmp.systemId; child_order.number = 1; child_order.money = child_menu.price; child_order.inputTime = BathClass.Now(LogIn.connectionString); child_order.inputEmployee = LogIn.m_User.id.ToString(); child_order.paid = false; order.departmentId = 1; dc_new.Orders.InsertOnSubmit(child_order); } } } i++; } dc_new.SubmitChanges(); } else { foreach (var seat in m_Seats) { seat.chainId = chainId; } db.SubmitChanges(); } this.DialogResult = DialogResult.OK; }
public ResponseModel Delete(HotelRoomType hotelRoomType) { return(_hotelRoomTypeRepository.Delete(hotelRoomType)); }
public ResponseModel Update(HotelRoomType hotelRoomType) { return(_hotelRoomTypeRepository.Update(hotelRoomType)); }
public ResponseModel Insert(HotelRoomType hotelRoomType) { return(_hotelRoomTypeRepository.Insert(hotelRoomType)); }
/// <summary> /// Save HotelRoomType manage model /// </summary> /// <param name="model"></param> /// <returns></returns> public ResponseModel SaveHotelRoomTypeManageModel(HotelRoomTypeManageModel model) { ResponseModel response; var hotelRoomType = GetById(model.Id); #region Edit HotelRoomType if (hotelRoomType != null) { hotelRoomType.Name = model.Name; hotelRoomType.Description = model.Description; hotelRoomType.Price = model.Price; hotelRoomType.RecordOrder = model.RecordOrder; var currentServices = hotelRoomType.HotelRoomServices.Select(rs => rs.ServiceId).ToList(); foreach (var id in currentServices) { if (!model.HotelRoomTypeServiceIds.Contains(id)) { _hotelRoomServiceRepository.Delete(id); } } foreach (var serviceId in model.HotelRoomTypeServiceIds) { if (currentServices.All(n => n != serviceId)) { var hotelRoomTypeHotelRoomTypeCategory = new HotelRoomService { RoomTypeId = hotelRoomType.Id, ServiceId = serviceId }; _hotelRoomServiceRepository.Insert(hotelRoomTypeHotelRoomTypeCategory); } } //Get page record order response = Update(hotelRoomType); return(response.SetMessage(response.Success ? _localizedResourceServices.T("AdminModule:::HotelRoomTypes:::Messages:::UpdateSuccessfully:::Update HotelRoomType successfully.") : _localizedResourceServices.T("AdminModule:::HotelRoomTypes:::Messages:::UpdateFailure:::Update HotelRoomType failed. Please try again later."))); } #endregion hotelRoomType = new HotelRoomType { Name = model.Name, Description = model.Description, Price = model.Price, }; response = Insert(hotelRoomType); foreach (var serviceId in model.HotelRoomTypeServiceIds) { var hotelRoomTypeHotelRoomTypeCategory = new HotelRoomService { RoomTypeId = hotelRoomType.Id, ServiceId = serviceId }; _hotelRoomServiceRepository.Insert(hotelRoomTypeHotelRoomTypeCategory); } return(response.SetMessage(response.Success ? _localizedResourceServices.T("AdminModule:::HotelRoomTypes:::Messages:::CreateSuccessfully:::Create HotelRoomType successfully.") : _localizedResourceServices.T("AdminModule:::HotelRoomTypes:::Messages:::CreateFailure:::Create HotelRoomType failed. Please try again later."))); }
public HotelFare getHotelFare(DataSet dsData) { clsParametros cParametros = new clsParametros(); HotelFare oHotelFare = new HotelFare(); StringBuilder consulta = new StringBuilder(); VO_Credentials vo_Credentials = clsCredenciales.Credenciales(Enum_ProveedorWebServices.TotalTrip); bool bSoloTT = false; try { bSoloTT = bool.Parse(clsValidaciones.GetKeyOrAdd("bSoloTT", "False")); } catch { } try { VO_HotelValuedAvailRQ vo_HotelValuedAvailRQ = clsSesiones.getParametrosHotel(); DataTable dtHotelInfo = dsData.Tables[clsEsquema.TABLA_HOTEL_INFO]; DataTable dtHotelRoom = dsData.Tables[clsEsquema.TABLA_HOTEL_ROOM]; DataTable dtPriceDate = dsData.Tables[clsEsquema.TABLA_PRICE]; if (dtHotelInfo.Rows.Count > 0) { string sWhere = string.Empty; int sHotel = int.Parse(dtHotelInfo.Rows[0][clsEsquema.COLUMN_HOTELCODE].ToString()); string sCityCode = dtHotelInfo.Rows[0][clsEsquema.COLUMN_DESTINATION_CODE].ToString(); decimal dAgencyComision = clsValidaciones.getDecimalNotRound(dtHotelInfo.Rows[0][clsEsquema.COLUMN_AGENCY_COMISION].ToString()); decimal dIva = clsValidaciones.getDecimalNotRound(dtHotelInfo.Rows[0][clsEsquema.COLUMN_IVA].ToString()); int iSource = int.Parse(dtHotelInfo.Rows[0][clsEsquema.COLUMN_SOURCE].ToString()); Hotel oHotel = new Hotel(); string sAdulto = clsValidaciones.GetKeyOrAdd("AdultoHB", "AD"); string sInfante = clsValidaciones.GetKeyOrAdd("InfanteHB", "CH"); int iRoom = dtHotelRoom.Rows.Count; HotelRoom[] oRoomArray = new HotelRoom[iRoom]; oHotel.CityCode = sCityCode; oHotel.HotelCode = sHotel; oHotel.Source = iSource; for (int i = 0; i < iRoom; i++) { HotelRoomType[] oHotelRoomTypeArray = new HotelRoomType[1]; sWhere = clsEsquema.COLUMN_HOTEL_ROOM_ID + " = " + dtHotelRoom.Rows[i][clsEsquema.COLUMN_HOTEL_ROOM_ID].ToString(); HotelRoom oRoom = new HotelRoom(); HotelRoomType oHotelRoomType = new HotelRoomType(); int iPax = vo_HotelValuedAvailRQ.lHotelOccupancy[i].Occupancy.lGuestList.Count; HotelRoomPax[] oPaxArray = new HotelRoomPax[iPax]; for (int j = 0; j < iPax; j++) { HotelRoomPax oPax = new HotelRoomPax(); oPax.Age = vo_HotelValuedAvailRQ.lHotelOccupancy[i].Occupancy.lGuestList[j].Age; if (vo_HotelValuedAvailRQ.lHotelOccupancy[i].Occupancy.lGuestList[j].Type.Equals(sAdulto)) { oPax.PaxType = PaxType.Adult; } else { oPax.PaxType = PaxType.Child; } oPax.EmailAddress = "*****@*****.**"; oPax.FirstName = vo_HotelValuedAvailRQ.lHotelOccupancy[i].Occupancy.lGuestList[j].Name; oPax.LastName = vo_HotelValuedAvailRQ.lHotelOccupancy[i].Occupancy.lGuestList[j].LastName; oPax.PhoneNumber = "571"; oPaxArray[j] = oPax; } oRoom.Paxes = oPaxArray; DataRow[] drRoomsPrices = dtPriceDate.Select(sWhere); int iFechas = drRoomsPrices.Length; EffectiveDate[] eFechasArray = new EffectiveDate[iFechas]; int k = 0; foreach (DataRow drRoomPrice in drRoomsPrices) { EffectiveDate eFechas = new EffectiveDate(); eFechas.Date = DateTime.Parse(drRoomPrice[clsEsquema.COLUMN_DATE].ToString());; eFechas.AmountAfterTax = decimal.Parse(drRoomPrice[clsEsquema.COLUMN_PRICE_AMOUN_AFTER_TAX].ToString()); eFechas.AmountBeforeTax = decimal.Parse(drRoomPrice[clsEsquema.COLUMN_PRICE_AMOUN_BEFORE_TAX].ToString()); eFechas.DiscountAfterTax = decimal.Parse(drRoomPrice[clsEsquema.COLUMN_PRICE_DISCOUNT_AFTER_TAX].ToString()); eFechas.DiscountBeforeTax = decimal.Parse(drRoomPrice[clsEsquema.COLUMN_PRICE_DISCOUNT_BEFORE_TAX].ToString()); try { eFechas.Currency = drRoomPrice[clsEsquema.COLUMN_CURRENCY].ToString(); eFechas.ProviderCurrency = drRoomPrice[clsEsquema.COLUMN_PROVIDER_CURRENCY].ToString(); eFechas.ROE = decimal.Parse(drRoomPrice[clsEsquema.COLUMN_ROE].ToString()); } catch { } eFechasArray[k] = eFechas; k++; } oHotelRoomType.EffectiveDates = eFechasArray; oHotelRoomType.InvBlockCode = dtHotelRoom.Rows[i][clsEsquema.COLUMN_CHARASTERISTIC].ToString(); oHotelRoomType.RatePlanType = dtHotelRoom.Rows[i][clsEsquema.COLUMN_CONFIRM_RATEPLANTYPE].ToString(); oHotelRoomType.RoomDesc = dtHotelRoom.Rows[i][clsEsquema.COLUMN_ROOM_TYPE_TEXT].ToString(); oHotelRoomType.RoomRate = dtHotelRoom.Rows[i][clsEsquema.COLUMN_SHRUI].ToString(); oHotelRoomType.RoomType = dtHotelRoom.Rows[i][clsEsquema.COLUMN_TYPE].ToString(); oHotelRoomType.AmountIncludedBoardSurcharge = decimal.Parse(dtHotelRoom.Rows[i][clsEsquema.COLUMN_ROOM_AMOUNT_SURCHARGE].ToString()); try { if (!dtHotelRoom.Rows[i][clsEsquema.COLUMN_ROOM_TTL].ToString().Equals("True")) { oHotelRoomType.TTL = DateTime.Parse(dtHotelRoom.Rows[i][clsEsquema.COLUMN_ROOM_TTL].ToString()); } } catch { } oHotelRoomTypeArray[0] = oHotelRoomType; oRoom.RoomTypes = oHotelRoomTypeArray; oRoomArray[i] = oRoom; } oHotelFare.Hot = oHotel; oHotelFare.Rooms = oRoomArray; oHotelFare.AgencyCommission = dAgencyComision; oHotelFare.Iva = dIva; if (bSoloTT) { oHotelFare.ContentType = ContentType.Exclusive; } else { oHotelFare.ContentType = ContentType.NonExclusive; } } } catch (Exception Ex) { cParametros.Id = 0; cParametros.Message = Ex.Message; cParametros.Severity = clsSeveridad.Alta; cParametros.Tipo = clsTipoError.WebServices; cParametros.Metodo = System.Reflection.MethodBase.GetCurrentMethod().Name; cParametros.Complemento = "Confirmacion de Hoteles"; consulta.AppendLine("Credenciales: "); try { if (vo_Credentials != null) { consulta.AppendLine("User: "******"Password: "******"Url: " + vo_Credentials.UrlWebServices); clsCache cCache = new csCache().cCache(); if (cCache != null) { consulta.AppendLine("Sesion Local: " + cCache.SessionID.ToString()); } } } catch { } cParametros.Info = consulta.ToString(); cParametros.Source = Ex.Source; cParametros.StackTrace = Ex.StackTrace; cParametros.ViewMessage.Add("No se confirmo la reserva"); cParametros.Sugerencia.Add("Por favor intente de nuevo"); ExceptionHandled.Publicar(cParametros); } return(oHotelFare); }