private int UpdateReservation(string volarisPnr, string sabrePnr, VolarisReservationStatus status, string connectionString)
{
Database dataBase = DatabaseFactory.CreateDatabase(connectionString);
DbCommand dbComand = dataBase.GetStoredProcCommand("UpdateVolarisLog");
dataBase.AddInParameter(dbComand, "Invoiced", DbType.Boolean,
VolarisSession.ReservationStatus == VolarisReservationStatus.Invoiced);
dataBase.AddInParameter(dbComand, "SabrePNR", DbType.String, VolarisSession.PNRSabre);
dataBase.AddInParameter(dbComand, "VolarisPNR", DbType.String, VolarisSession.PNR);
int result = dataBase.ExecuteNonQuery(dbComand);
return(result);
}
public int UpdateReservation(string volarisPnr, string sabrePnr, VolarisReservationStatus status)
{
try
{
return(UpdateReservation(volarisPnr, sabrePnr, status, CommonENT.MYCTSDB_CONNECTION));
}
catch
{
try
{
return(UpdateReservation(volarisPnr, sabrePnr, status, CommonENT.MYCTSDBBACKUP_CONNECTION));
}
catch (Exception)
{
}
}
return(0);
}
public static void Clean()
{
Extra = 0;
StatusPaymnet = new VolarisPaymentStatus();
Mensaje = string.Empty;
IsClientCard = false;
IsCTSCard = false;
IsVolarisProcess = false;
Profile = false;
IsValidPNR = false;
StoredUserFeeCommand = string.Empty;
ItineraryCommand = string.Empty;
ReservationStatus = new VolarisReservationStatus();
DepartureRoute = string.Empty;
ArrivalRoute = string.Empty;
PNR = string.Empty;
PNRSabre = string.Empty;
Status = false;
BackServicesExtras = false;
PagoTotal = 0;
BasePriceTotal = 0;
TaxesTotal = 0;
PagoVolaris = new MetodoPagoVolaris();
ItinerarioVolaris = new List <ItineraryFlowVolaris>();
VueloDisponible = new VueloDisponibleMyCTS();
VuelosDisponibles = new List <VueloDisponibleMyCTS>();
VueloIda = new VueloDisponibleMyCTS();
VueloIdaConexion = new VueloDisponibleMyCTS();
VueloRegreso = new VueloDisponibleMyCTS();
VueloRegresoConexion = new VueloDisponibleMyCTS();
Signature = string.Empty;
ListaTipoPassenger = new List <TiposVolaris.PassengerType>();
ListaSegmentos = new List <SegmentoDeVuelo>();
ContAdult = 0;
ContChild = 0;
ContInfant = 0;
ContPax = 0;
AddPassengerComplete = new List <DatosPasajerosVolaris>();
ExtrasServices = new List <VolarisServicesExtras>();
VolarisExtras = new List <ExtrasViajeVolaris>();
DK = string.Empty;
Remarks = new VolarisRemarks();
Infant = false;
CantidadExtras = 0;
PrimerNivel = string.Empty;
SegundoNivel = string.Empty;
Nacionalidad = string.Empty;
TipoTarjeta = string.Empty;
TarjetaCredito = string.Empty;
NumeroTarjeta = 0;
NumeroSeguridad = 0;
FechaVencimiento = string.Empty;
NombreTajetaViente = string.Empty;
ReturnShowInformation = false;
Venta = 0;
BaseTotalPayAdult = 0;
IVATotalPayAdult = 0;
TUATotalPayAdult = 0;
OtrosTotalPayAdult = 0;
BaseTotalPayChild = 0;
IVATotalPayChild = 0;
TUATotalPayChild = 0;
OtrosTotalPayChild = 0;
DiscountTotalPayAdult = 0;
DiscountTotalPayChild = 0;
baseTotalPayAdult = 0;
ivaTotalPayAdult = 0;
tuaTotalPayAdult = 0;
otrosTotalPayAdult = 0;
baseTotalPayChild = 0;
ivaTotalPayChild = 0;
tuaTotalPayChild = 0;
otrosTotalPayChild = 0;
discountTotalPayAdult = 0;
discountTotalPayChild = 0;
TypeFly = string.Empty;
Contacto = new ContactVolaris();
AdditionalAdult = new List <AdditionalAccountingLine>();
AdditionalChild = new List <AdditionalAccountingLine>();
additionalAdult = new List <AdditionalAccountingLine>();
additionalChild = new List <AdditionalAccountingLine>();
IsInternational = false;
ErrorPay = false;
IsValidCard = false;
}
public static int UpdateReservation(string volarisPnr, string sabrePnr, VolarisReservationStatus status)
{
return(DataAccess.UpdateReservation(volarisPnr, sabrePnr, status));
}
