public string InsertSCDCBoleto(SCDCBoleto boleto, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.InsertSCDCBoletoResources.SP_generaboleto);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_RECLOC, DbType.String, boleto.RecLoc);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_FECHACREA, DbType.DateTime, boleto.FechaCreacion);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_SEGMENTO, DbType.String, boleto.Segmento);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_NUMBOLETO, DbType.String, boleto.NumeroBoleto);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_NOMBRE, DbType.String, boleto.Nombre);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_FECHAEMISION, DbType.DateTime, boleto.FechaEmision);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_FECHA, DbType.DateTime, boleto.Fecha);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_BOLETOELECTRONICO, DbType.String, boleto.BoletoElectronico);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_INDICADOR, DbType.String, boleto.Indicador);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_PAIS, DbType.String, boleto.Pais);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_INDICADOR2, DbType.String, boleto.Indicador2);
db.AddInParameter(dbCommand, Resources.InsertSCDCBoletoResources.PARAM_PCC, DbType.String, boleto.Pcc);
string registros = string.Empty;
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _registros = dr.GetOrdinal(Resources.InsertSCDCBoletoResources.PARAM_REGISTROS);
while (dr.Read())
{
registros = (dr[_registros] == DBNull.Value) ? Types.StringNullValue : dr.GetInt32(_registros).ToString();
}
}
return(registros);
}
public List <SCDCBoleto> getBoleto(string convid, string ipcc, string securitytoken, string RecLoc, string pcc)
{
List <SCDCBoleto> boletos = new List <SCDCBoleto>();
try
{
TravelItinerary2.TravelItineraryReadRS resp = getResponseService(convid, ipcc, securitytoken, RecLoc);
foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoTicketing ticketing in resp.TravelItinerary.ItineraryInfo.Ticketing)
{
if (!string.IsNullOrEmpty(ticketing.eTicketNumber))
{
foreach (TravelItinerary2.TravelItineraryReadRSTravelItinerarySpecialServiceInfo specialServiceInfo in resp.TravelItinerary.SpecialServiceInfo)
{
if (specialServiceInfo.Service.SSR_Type == "TKNE")
{
if (specialServiceInfo.Service.Text[0].Contains(ticketing.eTicketNumber.Split(' ')[1].Split('-')[0].Split('/')[0]))
{
foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItem reservationItem in resp.TravelItinerary.ItineraryInfo.ReservationItems)
{
foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemFlightSegment flightSegment in reservationItem.FlightSegment != null ? reservationItem.FlightSegment : new TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemFlightSegment[0])
{
if (Int32.Parse(flightSegment.FlightNumber) == Int32.Parse(specialServiceInfo.Service.Text[0].Split(' ')[1].Substring(6, 4)))
{
SCDCBoleto boleto = new SCDCBoleto();
boleto.RecLoc = resp.TravelItinerary.ItineraryRef.ID;
boleto.FechaCreacion = DateTime.ParseExact(resp.TravelItinerary.ItineraryRef.Source.CreateDateTime, "yyyy-MM-ddTHH:mm", System.Globalization.CultureInfo.CurrentCulture);
boleto.Segmento = Int32.Parse(flightSegment.SegmentNumber).ToString();
boleto.NumeroBoleto = ticketing.eTicketNumber.Split(' ')[1].Split('-')[0].Split('/')[0];
boleto.Nombre = ticketing.eTicketNumber.Split(' ')[2];
boleto.Fecha = DateTime.ParseExact(ticketing.eTicketNumber.Split(' ')[4].Substring(0, 10), "HHmm/ddMMM", new System.Globalization.CultureInfo("en-US"));
boleto.FechaEmision = boleto.Fecha;
boleto.BoletoElectronico = ticketing.eTicketNumber.Split(' ')[0] == "TE" ? "y" : "n";
boleto.Indicador = ticketing.eTicketNumber.Split(' ')[0];
boleto.Pais = ticketing.eTicketNumber.Split(' ')[1].Split('-')[1];
boleto.Indicador2 = ticketing.eTicketNumber.Split(' ').Length == 5 ? ticketing.eTicketNumber.Split(' ')[4].Split('*')[1] : ticketing.eTicketNumber.Split(' ')[5];
boleto.Pcc = ticketing.eTicketNumber.Split(' ')[3].Split('*')[0];
boletos.Add(boleto);
}
}
}
}
}
}
}
}
}
catch { }
return(boletos);
}
public string InsertSCDCBoleto(SCDCBoleto boleto)
{
string result = string.Empty;
try
{
InsertSCDCBoletoDAL objBoleto = new InsertSCDCBoletoDAL();
try
{
result = objBoleto.InsertSCDCBoleto(boleto, CommonENT.MYCTSDB_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
result = objBoleto.InsertSCDCBoleto(boleto, CommonENT.MYCTSDBBACKUP_CONNECTION);
}
}
catch { }
return(result);
}
