Beispiel #1
0
        private OTATravelItineraryObjectHotel GetCars(TravelItinerary.TravelItineraryReadRSTravelItineraryItineraryInfoItemVehicle car, string commission, string dk,
                                                      string phone, string rfc, string agent, string mail, string sixReceived, string passengerType, int passengerNum, string passengerName, string title,
                                                      string passengerSurname, string lastStatus, List <string> cancelNumberList)
        {
            OTATravelItineraryObjectHotel obj = new OTATravelItineraryObjectHotel();

            obj.Provider_Commission = commission;
            obj.Prov_Direct_Pay     = true;
            obj.DK               = dk;
            obj.Phone            = phone;
            obj.RFC              = rfc;
            obj.User             = agent;
            obj.Mail             = mail;
            obj.Request          = sixReceived;
            obj.CancelNumberList = cancelNumberList;
            obj.StatusSabre      = car.Status;

            string typeCar = string.Empty;

            typeCar = car.VehVendorAvail.VehResCore.VehicleCharges.VehicleCharge.GuaranteeInd == null ? string.Empty : car.VehVendorAvail.VehResCore.VehicleCharges.VehicleCharge.GuaranteeInd.Replace("DPST", string.Empty);

            if (!string.IsNullOrEmpty(typeCar))
            {
                obj.Payment_Form = typeCar.Substring(0, 2).ToUpper();
                obj.Car_Number   = Convert.ToInt32(typeCar.Substring(typeCar.IndexOf("EXP") - 4, 4));
            }
            else
            {
                obj.Payment_Form = string.Empty;
                obj.Car_Number   = 0;
            }

            obj.Sales_Source = car.VehRentalCore.LocationDetails.LocationCode.ToUpper();
            obj.Provider     = "3318"; //OBTENER DE CONSULTA
            obj.Site         = "5475"; //OBTENER DE CONSULTA
            double total   = 0d;
            double semanal = 0d;

            foreach (TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemVehicleVehVendorAvailVehResCoreVehicleChargesVehicleChargeApproximateTotalCharge chargeDetails in car.VehVendorAvail.VehResCore.VehicleCharges.VehicleCharge.ChargeDetails == null ? new TravelItinerary2.TravelItineraryReadRSTravelItineraryItineraryInfoItemVehicleVehVendorAvailVehResCoreVehicleChargesVehicleChargeApproximateTotalCharge[0] : car.VehVendorAvail.VehResCore.VehicleCharges.VehicleCharge.ChargeDetails)
            {
                if (chargeDetails.RateType == "APPROXIMATE TOTAL PRICE")
                {
                    //obj.Number_Nights = Convert.ToInt32(chargeDetails.NumDays);
                    total = Convert.ToDouble(chargeDetails.Amount);
                }

                if (chargeDetails.RateType == "DAILY RATE")
                {
                    obj.Cost = Convert.ToDouble(chargeDetails.Amount);
                }

                if (chargeDetails.RateType == "WEEKLY RATE")
                {
                    semanal = Convert.ToDouble(chargeDetails.Amount);
                }
            }

            obj.Number_Nights = (total / 1.16) / obj.Cost;
            obj.City          = car.VehRentalCore.LocationDetails.LocationCode.ToUpper();
            obj.In_Date       = DateTime.ParseExact(car.VehRentalCore.PickUpDateTime, car.VehRentalCore.PickUpDateTime.Length > 5 ? "MM-ddTHH:mm" : "MM-dd", System.Globalization.CultureInfo.CurrentCulture);
            obj.Out_Date      = DateTime.ParseExact(car.VehRentalCore.ReturnDateTime, car.VehRentalCore.ReturnDateTime.Length > 5 ? "MM-ddTHH:mm" : "MM-dd", System.Globalization.CultureInfo.CurrentCulture);

            if (obj.Cost.Equals(0))
            {
                if (semanal.Equals(0))
                {
                    TimeSpan timespan = obj.Out_Date - obj.In_Date;
                    obj.Number_Nights = timespan.TotalDays;
                    obj.Cost          = (total / 1.16) / obj.Number_Nights;
                }
                else
                {
                    obj.Cost          = semanal / 7;
                    obj.Number_Nights = (total / 1.16) / obj.Cost;
                }
            }
            else
            {
                obj.Number_Nights = (total / 1.16) / obj.Cost;
            }
            string codeCityIti = string.Empty;

            codeCityIti = car.VehRentalCore.LocationDetails.LocationCode;

            List <ListItem> lstCodCity = new List <ListItem>();

            lstCodCity = CatCitiesBL.GetCodeCities(codeCityIti);

            string country    = GetCountryBL.GetCountryByCity(lstCodCity[0].Value);
            string codeCityDB = string.Empty;

            if (country.Equals("MX"))
            {
                codeCityDB = "AU";
            }
            else
            {
                codeCityDB = "AI";
            }

            obj.Service_Type   = codeCityDB.ToUpper();
            obj.Passenger_Type = passengerType.ToUpper();
            obj.Passenger_Num  = passengerNum;
            obj.Passenger_Name = passengerName.ToUpper();
            obj.Title          = title.ToUpper();
            obj.Surname        = passengerSurname;
            obj.Room           = "1";
            status             = car.VehVendorAvail.Vendor.Code.ToUpper();
            if (string.IsNullOrEmpty(car.VehRentalCore.LocationDetails.LocationName))
            {
                obj.Hotel = string.Concat(car.VehRentalCore.LocationDetails.LocationCode.ToUpper(), car.VehVendorAvail.Vendor.Code.ToUpper(), "|",
                                          GetVendorByCodeBL.GetVendorByCode(car.VehVendorAvail.Vendor.Code.ToUpper()).ToUpper());
            }
            else
            {
                string cit = car.VehRentalCore.LocationDetails.LocationName.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries)[0].Substring(0, 3);
                if (car.VehRentalCore.LocationDetails.LocationName.Length > 3)
                {
                    string cod    = car.VehRentalCore.LocationDetails.LocationName.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries)[0].Substring(3, 1);
                    int    numcod = Int32.Parse(Int32.TryParse(car.VehRentalCore.LocationDetails.LocationName.Split(
                                                                   new string[] { " " }, StringSplitOptions.RemoveEmptyEntries
                                                                   )[0].Substring(
                                                                   4, car.VehRentalCore.LocationDetails.LocationName.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries)[0].Length - 4
                                                                   ), out numcod) ? car.VehRentalCore.LocationDetails.LocationName.Split(
                                                    new string[] { " " }, StringSplitOptions.RemoveEmptyEntries
                                                    )[0].Substring(
                                                    4, car.VehRentalCore.LocationDetails.LocationName.Split(new string[] { " " }, StringSplitOptions.RemoveEmptyEntries)[0].Length - 4
                                                    ) : "0");

                    obj.Hotel = string.Concat(cit, car.VehVendorAvail.Vendor.Code.ToUpper(), cod, numcod.ToString("000"), "|",
                                              GetVendorByCodeBL.GetVendorByCode(car.VehVendorAvail.Vendor.Code.ToUpper()).ToUpper());
                }
                else
                {
                    obj.Hotel = string.Concat(cit, car.VehVendorAvail.Vendor.Code.ToUpper(), "|",
                                              GetVendorByCodeBL.GetVendorByCode(car.VehVendorAvail.Vendor.Code.ToUpper()).ToUpper());
                }
            }

            obj.Rate     = "VENTA";
            obj.Currency = car.VehVendorAvail.VehResCore.VehicleCharges.VehicleCharge.Mileage != null?car.VehVendorAvail.VehResCore.VehicleCharges.VehicleCharge.Mileage.CurrencyCode.ToUpper() : string.Empty;

            obj.Price      = obj.Cost * Convert.ToInt32(obj.Number_Nights);
            obj.Status     = lastStatus;
            obj.P_Rate     = "N/A";
            obj.P_Currency = "N/A";
            obj.P_IVA      = "N/A";
            obj.P_ISH      = "N/A";
            obj.P_Total    = "N/A";

            if (car.ConfirmationNumber != null)
            {
                if (!string.IsNullOrEmpty(car.ConfirmationNumber.ToString()))
                {
                    obj.Confirmation_Number = car.ConfirmationNumber.ToString().ToUpper();
                }
            }

            obj.ChainCode = car.VehVendorAvail.Vendor.Code.ToUpper();

            DateTime DateIn = DateTime.ParseExact(car.VehRentalCore.PickUpDateTime, car.VehRentalCore.PickUpDateTime.Length > 5 ? "MM-ddTHH:mm" : "MM-dd", System.Globalization.CultureInfo.CurrentCulture);
            TimeSpan ts     = new TimeSpan();

            if (DateIn == DateTime.Now)
            {
                obj.Time_Limit = DateTime.Now;
            }
            else
            {
                ts = TimeSpan.FromDays(2);
            }

            obj.Time_Limit = DateIn.Subtract(ts);
            obj.In_City    = car.VehVendorAvail.VehResCore.CollectionDeliveryInfo != null?
                             car.VehVendorAvail.VehResCore.CollectionDeliveryInfo.CollectionInfo.Address.CityName.ToUpper() : obj.City;

            obj.Out_City = car.VehVendorAvail.VehResCore.CollectionDeliveryInfo != null?
                           car.VehVendorAvail.VehResCore.CollectionDeliveryInfo.DeliveryInfo.Address.CityName.ToUpper() : obj.City;

            string description  = string.Empty;
            string tipoVehiculo = GetTypesCarByCodeBL.GetTypesCarByCode(car.VehVendorAvail.VehResCore.RentalRate.Vehicle.VehType);
            string equipo       = string.Empty;
            string arrendadora  = obj.Hotel.Split('|')[1];
            string in_City      = GetCityNameBL.GetCityName(obj.In_City);
            string out_City     = GetCityNameBL.GetCityName(obj.Out_City);

            if (car.VehVendorAvail.VehResCore.PricedEquip.Equipment.SpecialEquipConfirmed == "Y")
            {
                equipo = GetEquipmentCarByCodeBL.GetEquipmentCarByCode(car.VehVendorAvail.VehResCore.PricedEquip.Equipment.SpecialEquip).ToUpper();
            }

            description = string.Concat(tipoVehiculo, "|", equipo, "|", arrendadora, "|", in_City, "|",
                                        obj.In_Date.ToString(@"dd \de MMMM yyyy HH:mm \HRS", new System.Globalization.CultureInfo("es-MX")), "|", out_City, "|",
                                        obj.Out_Date.ToString(@"dd \de MMMM yyyy HH:mm \HRS", new System.Globalization.CultureInfo("es-MX")));
            //description = string.Concat("RENTA DE ", !tipoVehiculo.Contains("AUTO") ? "AUTO " : string.Empty, tipoVehiculo, !string.IsNullOrEmpty(equipo) ? " CON " : string.Empty, equipo, " EN ", arrendadora, ");
            //description = string.Concat(description, "RECIBE: \t", obj.In_Date.ToString(@"dd \de MMMM yyyy HH:mm \HRS", new System.Globalization.CultureInfo("es-MX")), " EN ", arrendadora, " ", in_City, "\n");
            //description = string.Concat(description, "ENTREGA:\t", obj.Out_Date.ToString(@"dd \de MMMM yyyy HH:mm \HRS", new System.Globalization.CultureInfo("es-MX")), " EN ", arrendadora, " ", out_City);
            obj.Description = description.ToUpper();

            return(obj);
        }
Beispiel #2
0
        private OTATravelItineraryObjectHotel GetHotel(TravelItinerary.TravelItineraryReadRSTravelItineraryItineraryInfoItemHotel hotel, string commission, string dk,
                                                       string phone, string rfc, string agent, string mail, string sixReceived, string passengerType, int passengerNum, string passengerName, string title,
                                                       string passengerSurname, string lastStatus, List <string> cancelNumberList)
        {
            OTATravelItineraryObjectHotel itineraryObject = new OTATravelItineraryObjectHotel();

            itineraryObject.Provider_Commission = commission;
            itineraryObject.Prov_Direct_Pay     = true;
            itineraryObject.DK               = dk;
            itineraryObject.Phone            = phone.ToUpper();
            itineraryObject.RFC              = rfc;
            itineraryObject.User             = agent;
            itineraryObject.Mail             = mail;
            itineraryObject.Request          = sixReceived;
            itineraryObject.Passenger_Type   = passengerType;
            itineraryObject.Passenger_Num    = passengerNum;
            itineraryObject.Passenger_Name   = passengerName;
            itineraryObject.Title            = title;
            itineraryObject.Surname          = passengerSurname;
            itineraryObject.CancelNumberList = cancelNumberList;
            itineraryObject.StatusSabre      = hotel.Status;

            string typeCar = string.Empty;

            typeCar = hotel.Guarantee.Replace("DPST", string.Empty);
            itineraryObject.Payment_Form = typeCar.Length > 2 ? typeCar.Substring(0, 2) : string.Empty;
            itineraryObject.Car_Number   = Convert.ToInt32(typeCar.Length > 2 ? typeCar.Substring(typeCar.IndexOf("EXP") - 4, 4) : "0");
            itineraryObject.Sales_Source = hotel.BasicPropertyInfo.HotelCityCode;
            itineraryObject.Provider     = "3318"; //OBTENER DE CONSULTA
            itineraryObject.Site         = "5475"; //OBTENER DE CONSULTA
            itineraryObject.Room         = hotel.NumberOfUnits;
            itineraryObject.City         = hotel.BasicPropertyInfo.HotelCityCode;
            itineraryObject.In_Date      = DateTime.ParseExact(hotel.TimeSpan.Start, "MM-dd", System.Globalization.CultureInfo.CurrentCulture);
            itineraryObject.Out_Date     = DateTime.ParseExact(hotel.TimeSpan.End, "MM-dd", System.Globalization.CultureInfo.CurrentCulture);

            if (itineraryObject.Passenger_Num > 1)
            {
                itineraryObject.Room_Type = "Double";
            }
            else
            {
                itineraryObject.Room_Type = "Single";
            }

            string codeCityIti = string.Empty;

            codeCityIti = hotel.BasicPropertyInfo.HotelCityCode;

            List <ListItem> lstCodCity = new List <ListItem>();

            lstCodCity = CatCitiesBL.GetCodeCities(codeCityIti);

            string country    = GetCountryBL.GetCountryByCity(lstCodCity.Count > 0 ? lstCodCity[0].Value : string.Empty);
            string codeCityDB = string.Empty;

            if (country.Equals("MX") || string.IsNullOrEmpty(country))
            {
                codeCityDB = "H1";
            }
            else
            {
                codeCityDB = "H2";
            }

            itineraryObject.Service_Type  = codeCityDB;
            itineraryObject.Number_Nights = Convert.ToInt32(hotel.TimeSpan.Duration ?? 1.ToString());
            status = hotel.BasicPropertyInfo.HotelCode;
            itineraryObject.Hotel = hotel.BasicPropertyInfo.HotelCode + "|" +
                                    hotel.BasicPropertyInfo.HotelName;
            itineraryObject.Rate       = "VENTA";
            itineraryObject.Currency   = hotel.RoomRates.Rate.CurrencyCode;
            itineraryObject.Cost       = Convert.ToDouble(hotel.RoomRates.Rate.Amount.Substring(0, hotel.RoomRates.Rate.Amount.IndexOf('.') + 3));
            itineraryObject.Price      = itineraryObject.Cost * Convert.ToInt32(itineraryObject.Number_Nights);
            itineraryObject.Status     = lastStatus;
            itineraryObject.P_Rate     = "N/A";
            itineraryObject.P_Currency = "N/A";
            itineraryObject.P_IVA      = "N/A";
            itineraryObject.P_ISH      = "N/A";
            itineraryObject.P_Total    = "N/A";

            if (hotel.BasicPropertyInfo.ConfirmationNumber != null)
            {
                if (!string.IsNullOrEmpty(hotel.BasicPropertyInfo.ConfirmationNumber[0].ToString()))
                {
                    itineraryObject.Confirmation_Number = hotel.BasicPropertyInfo.ConfirmationNumber[0].ToString();
                }
            }

            itineraryObject.ChainCode = hotel.BasicPropertyInfo.ChainCode;

            DateTime DateIn = DateTime.ParseExact(hotel.TimeSpan.Start, "MM-dd", System.Globalization.CultureInfo.CurrentCulture);
            TimeSpan ts     = new TimeSpan();

            if (DateIn == DateTime.Now)
            {
                itineraryObject.Time_Limit = DateTime.Now;
            }
            else
            {
                ts = TimeSpan.FromDays(2);
            }
            itineraryObject.Time_Limit = DateIn.Subtract(ts);
            itineraryObject            = (itineraryObject != null) ? itineraryObject : new OTATravelItineraryObjectHotel();

            return(itineraryObject);
        }