public string InsertSCDCVuelo(SCDCResumen resumen, int vueloid, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbCommand = db.GetStoredProcCommand(Resources.InsertSCDCVueloResources.SP_insertvuelos); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_RECLOC, DbType.String, resumen.RecLoc); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_FECHACREACION, DbType.DateTime, resumen.FechaCreacion); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_SEGMENTO, DbType.Int32, resumen.Vuelos[vueloid].Segmento); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_AEROLINEA, DbType.String, resumen.Vuelos[vueloid].Aerolinea); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_NUMVUELO, DbType.String, resumen.Vuelos[vueloid].NumVuelo); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_FECHA, DbType.DateTime, resumen.Vuelos[vueloid].FechaSalida); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_FECHAREG, DbType.DateTime, resumen.Vuelos[vueloid].FechaRegreso); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_ORIGEN, DbType.String, resumen.Vuelos[vueloid].Origen); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_DESTINO, DbType.String, resumen.Vuelos[vueloid].Destino); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_CLASE, DbType.String, resumen.Vuelos[vueloid].Clase); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_ASIENTOS, DbType.String, resumen.Vuelos[vueloid].Asientos); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_CONEXION, DbType.String, resumen.Vuelos[vueloid].Conexion); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_ESTATUS, DbType.String, resumen.Vuelos[vueloid].Estatus); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_ESPACIOS, DbType.Int32, resumen.Vuelos[vueloid].Espacios); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_INDICADORCON1, DbType.String, resumen.Vuelos[vueloid].IndicadorCon1); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_INDICADORCON2, DbType.String, resumen.Vuelos[vueloid].IndicadorCon2); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_MILLAS, DbType.Int32, resumen.Vuelos[vueloid].Millas); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_TIEMPOVUELO, DbType.String, resumen.Vuelos[vueloid].TiempoVuelo); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_AVION, DbType.String, resumen.Vuelos[vueloid].Avion); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_CLAVELA, DbType.String, resumen.Vuelos[vueloid].ClaveLa); db.AddInParameter(dbCommand, Resources.InsertSCDCVueloResources.PARAM_ESCALAS, DbType.Int32, resumen.Vuelos[vueloid].Escalas); string registros = string.Empty; using (IDataReader dr = db.ExecuteReader(dbCommand)) { int _registros = dr.GetOrdinal(Resources.InsertSCDCResumenResources.PARAM_REGISTROS); while (dr.Read()) { registros = (dr[_registros] == DBNull.Value) ? Types.StringNullValue : dr.GetInt32(_registros).ToString(); } } return(registros); }
public string InsertSCDCResumen(SCDCResumen resumen, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbCommand = db.GetStoredProcCommand(Resources.InsertSCDCResumenResources.SP_insertaresumen); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_RECLOC, DbType.String, resumen.RecLoc); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_FECHACREACION, DbType.DateTime, resumen.FechaCreacion); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_FECHATRANS, DbType.DateTime, resumen.FechaTrans); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_CANTPAX, DbType.String, resumen.CantPax); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_APELLIDO, DbType.String, resumen.Apellido); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_NOMBRE, DbType.String, resumen.Nombre); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_DK, DbType.String, resumen.Dk); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_FECHAINICIO, DbType.DateTime, resumen.FechaInicio); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_FECHAFIN, DbType.String, resumen.FechaFin); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_RUTA, DbType.String, resumen.Ruta); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_TARIFABASE, DbType.String, resumen.TarifaBase); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_IMPUESTOS, DbType.String, resumen.Impuestos); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_TARIFATOTAL, DbType.String, resumen.TarifaTotal); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_BOLETO, DbType.String, resumen.Boleto); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_HOTEL, DbType.String, resumen.Hotel); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_AUTO, DbType.String, resumen.Auto); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_FECHAMOD, DbType.DateTime, resumen.FechaMod); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_INTERNACIONAL, DbType.String, resumen.Internacional); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_LCTARIFABASE, DbType.String, resumen.LcTarifaBase); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_LCIMPUESTO1, DbType.String, resumen.LcImpuesto1); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_LCIMPUESTO2, DbType.String, resumen.LcImpuesto2); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_LCIMPUESTO3, DbType.String, resumen.LcImpuesto3); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_LCCOMISION, DbType.String, resumen.LcComision); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_RECIBIDO, DbType.String, resumen.Recibido); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_PCCCREA, DbType.String, resumen.PccCrea); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_PCCFIRMA, DbType.String, resumen.PccFirma); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_LASTDAY, DbType.DateTime, resumen.LastDay); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_AGENTE, DbType.String, resumen.Agente); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_LINCONTAEREA, DbType.String, resumen.LinContAerea); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_VUELOSHIST, DbType.String, resumen.VuelosHist); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_REVISION, DbType.String, resumen.Revision); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_PCCLECTURA, DbType.String, resumen.PccLectura); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_QUEUELECTURA, DbType.String, resumen.QueueLectura); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_BSGGRUPO, DbType.String, resumen.BsgGrupo); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_BSGNOMBRE, DbType.String, resumen.BsgNombre); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_BSGESPACIOSRESERVADOS, DbType.Int32, resumen.BsgEspaciosReservados); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_BSGESPACIOSLIBRES, DbType.Int32, resumen.BsgEspaciosLibres); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_MILLAS, DbType.Int32, resumen.Millas); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_TARIFAMONEDA, DbType.String, resumen.TarifaMoneda); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_TXCASILLA1, DbType.String, resumen.TxCasilla1); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_TXCASILLA2, DbType.String, resumen.TxCasilla2); db.AddInParameter(dbCommand, Resources.InsertSCDCResumenResources.PARAM_TXCASILLA3, DbType.String, resumen.TxCasilla3); string registros = string.Empty; using (IDataReader dr = db.ExecuteReader(dbCommand)) { int _registros = dr.GetOrdinal(Resources.InsertSCDCResumenResources.PARAM_REGISTROS); while (dr.Read()) { registros = (dr[_registros] == DBNull.Value) ? Types.StringNullValue : dr.GetInt32(_registros).ToString(); } } return(registros); }
public SCDCResumen getResumen(string convid, string ipcc, string securitytoken, string RecLoc, string pcc) { SCDCResumen resumen = null; string errorMessage = string.Empty; try { TravelItinerary2.TravelItineraryReadRS resp = getResponseService(convid, ipcc, securitytoken, RecLoc); if (resp.ApplicationResults.Error == null) { resumen = new SCDCResumen(); resumen.RecLoc = RecLoc; resumen.FechaCreacion = DateTime.ParseExact(resp.TravelItinerary.ItineraryRef.Source.CreateDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); resumen.FechaTrans = DateTime.Now; resumen.Apellido = resp.TravelItinerary.CustomerInfo.PersonName[0].Surname; resumen.Nombre = resp.TravelItinerary.CustomerInfo.PersonName[0].GivenName; resumen.BsgEspaciosLibres = Int32.Parse(resp.TravelItinerary.CustomerInfo.PersonName[0].GroupInfo != null ? resp.TravelItinerary.CustomerInfo.PersonName[0].GroupInfo.NumSeatsRemaining : "0"); resumen.BsgGrupo = resp.TravelItinerary.CustomerInfo.PersonName[0].GroupInfo != null ? "y" : "n"; resumen.BsgNombre = resp.TravelItinerary.CustomerInfo.PersonName[0].GroupInfo != null ? resp.TravelItinerary.CustomerInfo.PersonName[0].GroupInfo.Name : string.Empty; resumen.Dk = resp.TravelItinerary.ItineraryRef.CustomerIdentifier ?? string.Empty; resumen.FechaInicio = DateTime.Now.AddYears(3); DateTime fechaFin = DateTime.Now.AddYears(-3); List <string> departure = new List <string>(); List <string> arrival = new List <string>(); #region Busqueda de fechafin y fechainicio foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItem item in resp.TravelItinerary.ItineraryInfo.ReservationItems) { foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemFlightSegment flightSegment in item.FlightSegment == null ? new TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemFlightSegment[0] : item.FlightSegment) { departure.Add(flightSegment.OriginLocation.LocationCode); arrival.Add(flightSegment.DestinationLocation.LocationCode); if (resumen.FechaInicio >= DateTime.ParseExact(flightSegment.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) { resumen.FechaInicio = DateTime.ParseExact(flightSegment.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); } if (fechaFin <= DateTime.ParseExact(flightSegment.ArrivalDateTime, "MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) { fechaFin = DateTime.ParseExact(flightSegment.ArrivalDateTime, "MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); } } //if (item.AirTaxi != null) //{ // if (resumen.FechaInicio >= DateTime.ParseExact(item.AirTaxi.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) // { // resumen.FechaInicio = DateTime.ParseExact(item.AirTaxi.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); // } // if (fechaFin <= DateTime.ParseExact(item.AirTaxi.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) // { // fechaFin = DateTime.ParseExact(item.AirTaxi.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); // resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); // } //} if (item.Hotel != null) { departure.Add(item.Hotel.BasicPropertyInfo.ChainCode); arrival.Add(item.Hotel.BasicPropertyInfo.ChainCode); if (resumen.FechaInicio >= DateTime.ParseExact(item.Hotel.TimeSpan.Start, "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) { resumen.FechaInicio = DateTime.ParseExact(item.Hotel.TimeSpan.Start, "MM-dd", System.Globalization.CultureInfo.CurrentCulture); } if (fechaFin <= DateTime.ParseExact(item.Hotel.TimeSpan.End, "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) { fechaFin = DateTime.ParseExact(item.Hotel.TimeSpan.End, "MM-dd", System.Globalization.CultureInfo.CurrentCulture); resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); } } //if (item.Insurance != null) //{ // if (resumen.FechaInicio >= DateTime.ParseExact(item.Insurance.InsuranceDetails.Start, "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) // { // resumen.FechaInicio = DateTime.ParseExact(item.Insurance.InsuranceDetails.Start, "MM-dd", System.Globalization.CultureInfo.CurrentCulture); // } // if (fechaFin <= DateTime.ParseExact(item.Insurance.InsuranceDetails.End, "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) // { // fechaFin = DateTime.ParseExact(item.Insurance.InsuranceDetails.End, "MM-dd", System.Globalization.CultureInfo.CurrentCulture); // resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); // } //} //if (item.MiscSegment != null) //{ // if (resumen.FechaInicio >= DateTime.ParseExact(item.MiscSegment.DepartureDateTime, "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) // { // resumen.FechaInicio = DateTime.ParseExact(item.MiscSegment.DepartureDateTime, "MM-dd", System.Globalization.CultureInfo.CurrentCulture); // } // if (fechaFin <= DateTime.ParseExact(item.MiscSegment.DepartureDateTime, "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) // { // fechaFin = DateTime.ParseExact(item.MiscSegment.DepartureDateTime, "MM-dd", System.Globalization.CultureInfo.CurrentCulture); // resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); // } //} //if (item.Surface != null) //{ // if (resumen.FechaInicio >= DateTime.ParseExact(item.Surface.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) // { // resumen.FechaInicio = DateTime.ParseExact(item.Surface.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); // } // if (fechaFin <= DateTime.ParseExact(item.Surface.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) // { // fechaFin = DateTime.ParseExact(item.Surface.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); // resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); // } //} //if (item.Tour != null) //{ // if (resumen.FechaInicio >= DateTime.ParseExact(item.Tour.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) // { // resumen.FechaInicio = DateTime.ParseExact(item.Tour.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); // } // if (fechaFin <= DateTime.ParseExact(item.Tour.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture)) // { // fechaFin = DateTime.ParseExact(item.Tour.DepartureDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture); // resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); // } //} if (item.Vehicle != null) { departure.Add(item.Vehicle.VehVendorAvail.Vendor.Code); arrival.Add(item.Vehicle.VehVendorAvail.Vendor.Code); if (resumen.FechaInicio >= DateTime.ParseExact(item.Vehicle.VehRentalCore.PickUpDateTime, item.Vehicle.VehRentalCore.PickUpDateTime.Length > 5 ? "MM-ddTHH:mm" : "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) { resumen.FechaInicio = DateTime.ParseExact(item.Vehicle.VehRentalCore.PickUpDateTime, item.Vehicle.VehRentalCore.PickUpDateTime.Length > 5 ? "MM-ddTHH:mm" : "MM-dd", System.Globalization.CultureInfo.CurrentCulture); } if (fechaFin <= DateTime.ParseExact(item.Vehicle.VehRentalCore.ReturnDateTime, item.Vehicle.VehRentalCore.ReturnDateTime.Length > 5 ? "MM-ddTHH:mm" : "MM-dd", System.Globalization.CultureInfo.CurrentCulture)) { fechaFin = DateTime.ParseExact(item.Vehicle.VehRentalCore.ReturnDateTime, item.Vehicle.VehRentalCore.ReturnDateTime.Length > 5 ? "MM-ddTHH:mm" : "MM-dd", System.Globalization.CultureInfo.CurrentCulture); resumen.FechaFin = fechaFin.ToString("MMM dd yyyy HH:mm tt", new System.Globalization.CultureInfo("es-MX")); } } } #endregion for (int i = 0; i < departure.Count; i++) { if (string.IsNullOrEmpty(resumen.Ruta)) { resumen.Ruta = string.Concat(departure[i], '-', arrival[i]); } else if ((departure[i] != arrival[i - 1]) && departure[i].Length <= 3) { resumen.Ruta = string.Concat(resumen.Ruta, '-', departure[i], '-', arrival[i]); } else { resumen.Ruta = string.Concat(resumen.Ruta, '-', arrival[i]); } } if (string.IsNullOrEmpty(resumen.Ruta)) { resumen.Ruta = "NA"; } int cantPax = 0; resumen.TarifaBase = 0.ToString(); resumen.Impuestos = 0.ToString(); resumen.TarifaTotal = 0.ToString(); resumen.LcTarifaBase = 0.ToString(); resumen.LcImpuesto1 = 0.ToString(); resumen.LcImpuesto2 = "0"; resumen.LcImpuesto3 = "0"; resumen.LcComision = 0.ToString(); resumen.TarifaMoneda = "MXN"; if (resp.TravelItinerary.ItineraryInfo.ItineraryPricing != null) { TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricing itineraryPricing = resp.TravelItinerary.ItineraryInfo.ItineraryPricing; foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricingPriceQuote priceQuote in itineraryPricing.PriceQuote) { foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricingPriceQuotePricedItinerary pricedItinerary in priceQuote.PricedItinerary) { foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricingPriceQuotePricedItineraryAirItineraryPricingInfoPassengerTypeQuantity passengerTypeQuantity in pricedItinerary.AirItineraryPricingInfo.PassengerTypeQuantity) { cantPax += Int32.Parse(passengerTypeQuantity.Quantity); } foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricingPriceQuotePricedItineraryAirItineraryPricingInfoItinTotalFare itinTotalFare in pricedItinerary.AirItineraryPricingInfo.ItinTotalFare ?? new TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricingPriceQuotePricedItineraryAirItineraryPricingInfoItinTotalFare[0]) { resumen.TarifaBase = (float.Parse(string.IsNullOrEmpty(resumen.TarifaBase) ? "0" : resumen.TarifaBase) + float.Parse(itinTotalFare.BaseFare.Amount)).ToString(); resumen.Impuestos = (float.Parse(string.IsNullOrEmpty(resumen.Impuestos) ? "0" : resumen.Impuestos) + float.Parse(itinTotalFare.Taxes.Tax.Amount)).ToString(); resumen.TarifaTotal = (float.Parse(string.IsNullOrEmpty(resumen.TarifaTotal) ? "0" : resumen.TarifaTotal) + float.Parse(itinTotalFare.TotalFare.Amount)).ToString(); resumen.LcTarifaBase = (float.Parse(string.IsNullOrEmpty(resumen.LcTarifaBase) ? "0" : resumen.LcTarifaBase) + float.Parse(itinTotalFare.Totals != null ? itinTotalFare.Totals.TotalFare.Amount : itinTotalFare.TotalFare.Amount)).ToString(); resumen.LcImpuesto1 = (float.Parse(string.IsNullOrEmpty(resumen.LcImpuesto1) ? "0" : resumen.LcImpuesto1) + float.Parse(itinTotalFare.Totals != null ? itinTotalFare.Totals.Taxes.Tax.Amount : itinTotalFare.Taxes.Tax.Amount)).ToString(); resumen.LcImpuesto2 = "0"; resumen.LcImpuesto3 = "0"; resumen.TarifaMoneda = itinTotalFare.TotalFare.CurrencyCode; } } } foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricingPhaseIVInfo phaseIVInfo in itineraryPricing.PhaseIVInfo != null ? itineraryPricing.PhaseIVInfo : new TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItineraryPricingPhaseIVInfo[0]) { resumen.LcComision = (float.Parse(string.IsNullOrEmpty(resumen.LcComision) ? "0" : resumen.LcComision) + float.Parse(phaseIVInfo.Record.ItinTotalFare.Commission.Amount)).ToString(); } } resumen.Boleto = "n"; resumen.CantPax = cantPax.ToString("00"); foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryAccountingInfo accountInfo in resp.TravelItinerary.AccountingInfo != null ? resp.TravelItinerary.AccountingInfo : new TravelItinerary2.TravelItineraryReadRSTravelItineraryAccountingInfo[0]) { resumen.Boleto = string.IsNullOrEmpty(accountInfo.TicketingInfo.OriginalTicketNumber != null ? accountInfo.TicketingInfo.OriginalTicketNumber[0] : string.Empty) ? "n" : "y"; break; } resumen.FechaMod = DateTime.Now; resumen.Hotel = "n"; resumen.Auto = "n"; resumen.Millas = 0; foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItem reservationItem in resp.TravelItinerary.ItineraryInfo.ReservationItems) { if (reservationItem.Hotel != null) { resumen.Hotel = "y"; continue; } else if (reservationItem.Vehicle != null) { resumen.Auto = "y"; continue; } else if (reservationItem.FlightSegment != null) { foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemFlightSegment flightSegment in reservationItem.FlightSegment) { if (resumen.Vuelos == null) { resumen.Vuelos = new List <SCDCVuelo>(); } resumen.Vuelos.Add(MappingVuelo(flightSegment)); resumen.Millas += string.IsNullOrEmpty(flightSegment.AirMilesFlown) ? 0 : Int32.Parse(flightSegment.AirMilesFlown); } } else if (reservationItem.Seats != null) { foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemSeat seat in reservationItem.Seats) { for (int i = 0; i < resumen.Vuelos.Count; i++) { if (resumen.Vuelos[i].Segmento == Int32.Parse(seat.SegmentNumber)) { resumen.Vuelos[i].Asientos = "Y"; break; } } } continue; } else { continue; } } resumen.Internacional = "."; foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoTicketing ticketing in resp.TravelItinerary.ItineraryInfo.Ticketing ?? new TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoTicketing[0]) { if (string.IsNullOrEmpty(ticketing.eTicketNumber)) { resumen.Internacional = "."; } else if (!ticketing.eTicketNumber.Contains("-MX")) { resumen.Internacional = "I"; } else { resumen.Internacional = "N"; break; } } resumen.LinContAerea = "n"; if (resumen.Internacional != ".") { resumen.LinContAerea = "y"; } resumen.Recibido = resp.TravelItinerary.ItineraryRef.Source.ReceivedFrom; resumen.PccCrea = resp.TravelItinerary.ItineraryRef.Source.HomePseudoCityCode; resumen.PccFirma = resp.TravelItinerary.ItineraryRef.Source.PseudoCityCode; resumen.PccLectura = resp.TravelItinerary.ItineraryRef.Source.AAA_PseudoCityCode; //resumen.LastDay = null; resumen.Agente = resp.TravelItinerary.ItineraryRef.Source.CreationAgent.Substring(1); resumen.VuelosHist = string.Empty; resumen.Revision = "CTS"; resumen.QueueLectura = string.Empty; foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryPlacement queueInfo in resp.TravelItinerary.QueueInfo != null ? resp.TravelItinerary.QueueInfo : new TravelItinerary2.TravelItineraryReadRSTravelItineraryPlacement[0]) { resumen.QueueLectura = queueInfo.Value.Split('/')[1].Split('-')[1]; resumen.LastDay = DateTime.ParseExact(queueInfo.Value.Split('/')[0].Substring(3), "ddMMM", new System.Globalization.CultureInfo("en-US")); break; } if (resumen.LastDay == new DateTime(1, 1, 1)) { resumen.LastDay = resumen.FechaInicio.AddDays(-1); } resumen.TxCasilla1 = "0.00"; resumen.TxCasilla2 = "0.00"; resumen.TxCasilla3 = resumen.Impuestos; } } catch { } return(resumen); }
public string InsertSDCResumen(SCDCResumen resumen) { string result = string.Empty; try { InsertSCDCResumenDAL objResumen = new InsertSCDCResumenDAL(); try { result = objResumen.InsertSCDCResumen(resumen, CommonENT.MYCTSDB_CONNECTION); if (result == "1") { DeleteSCDCVuelosDAL objdelete = new DeleteSCDCVuelosDAL(); result = objdelete.DeleteSCDCVuelo(resumen.RecLoc, CommonENT.MYCTSDB_CONNECTION); if (result == "1") { InsertSCDCVueloDAL objVuelo = new InsertSCDCVueloDAL(); for (int i = 0; i < (resumen.Vuelos != null ? resumen.Vuelos.Count : 0); i++) { result = objVuelo.InsertSCDCVuelo(resumen, i, CommonENT.MYCTSDB_CONNECTION); } } else { throw (new ArgumentException("Fallo el ingreso de datos a la tabla Resumen de SCDC. Revise el PA deleteResumen")); } } else { throw (new ArgumentException("Fallo el ingreso de datos a la tabla Resumen de SCDC. Revise el PA insertResumen")); } } catch (Exception ex) { new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos); result = objResumen.InsertSCDCResumen(resumen, CommonENT.MYCTSDBBACKUP_CONNECTION); if (result == "1") { DeleteSCDCVuelosDAL objdelete = new DeleteSCDCVuelosDAL(); result = objdelete.DeleteSCDCVuelo(resumen.RecLoc, CommonENT.MYCTSDBBACKUP_CONNECTION); if (result == "1") { InsertSCDCVueloDAL objVuelo = new InsertSCDCVueloDAL(); for (int i = 0; i < (resumen.Vuelos != null ? resumen.Vuelos.Count : 0); i++) { result = objVuelo.InsertSCDCVuelo(resumen, i, CommonENT.MYCTSDBBACKUP_CONNECTION); } } else { throw (new ArgumentException("Fallo el ingreso de datos a la tabla Resumen de SCDC. Revise el PA deleteResumen")); } } else { throw (new ArgumentException("Fallo el ingreso de datos a la tabla Resumen de SCDC. Revise el PA insertResumen")); } } } catch { } return(result); }