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);
}
