/// <summary>
        ///  Get a list of a booking incident data
        /// </summary>
        /// <param name="primaryKeys">A list of primary keys.</param>
        /// <returns>A list of primary keys</returns>
        public async Task <IEnumerable <IBookingIncidentData> > GetListAsync(IList <string> primaryKeys)
        {
            var           auxQueryStore = QueryStoreFactory.GetQueryStore();
            StringBuilder builder       = new StringBuilder();

            IList <IBookingIncidentData> bookingIncidentData = new List <IBookingIncidentData>();

            foreach (var key in primaryKeys)
            {
                auxQueryStore.AddParam(QueryType.QueryBookingIncident, key);
                var query = auxQueryStore.BuildQuery();
                builder.Append(query);
            }
            var definitiveQuery = builder.ToString();

            using (var connection = SqlExecutor.OpenNewDbConnection())
            {
                if (connection == null)
                {
                    throw new DataLayerException("Error during loading incidents");
                }
                var reader = await connection.QueryMultipleAsync(definitiveQuery).ConfigureAwait(false);

                foreach (var key in primaryKeys)
                {
                    var incident        = SelectionHelpers.WrappedSelectedDto <INCIRE, BookingIncidentViewObject>(key, _mapper, reader);
                    var currentIncident = incident.FirstOrDefault();
                    bookingIncidentData.Add(new BookingIncident(currentIncident));
                }
            }
            return(bookingIncidentData);
        }
Esempio n. 2
0
 private bool ParseResult(IVehicleData vehicle, SqlMapper.GridReader reader, SqlMapper.GridReader secondResult)
 {
     try
     {
         vehicle.ModelDtos          = SelectionHelpers.WrappedSelectedDto <MODELO, ModelVehicleDto>(vehicle.Value.MODELO, _mapper, reader);
         vehicle.BrandDtos          = SelectionHelpers.WrappedSelectedDto <MARCAS, BrandVehicleDto>(vehicle.Value.MAR, _mapper, reader);
         vehicle.PicturesDtos       = SelectionHelpers.WrappedSelectedDto <PICTURES, PictureDto>(vehicle, _mapper, reader);
         vehicle.ActivityDtos       = SelectionHelpers.WrappedSelectedDto <ACTIVEHI, VehicleActivitiesDto>(vehicle.Value.ACTIVIDAD, _mapper, reader);
         vehicle.OwnerDtos          = SelectionHelpers.WrappedSelectedDto <OwnerDto, OwnerDto>(vehicle.Value.PROPIE, _mapper, reader);
         vehicle.AgentsDto          = SelectionHelpers.WrappedSelectedDto <AGENTES, AgentDto>(vehicle.Value.AGENTE_VEHI, _mapper, reader);
         vehicle.MaintenanceHistory = SelectionHelpers.WrappedSelectedDto <MaintainanceDto, MaintainanceDto>(vehicle.Value, _mapper, reader);
         vehicle.ColorDtos          = SelectionHelpers.WrappedSelectedDto <COLORFL, ColorDto>(vehicle.Value.COLOR, _mapper, reader);
         vehicle.VehicleGroupDtos   = SelectionHelpers.WrappedSelectedDto <GRUPOS, VehicleGroupDto>(vehicle.Value.GRUPO, _mapper, reader);
         if (vehicle.Value.FORPAGOCO.HasValue)
         {
             vehicle.PaymentForm = SelectionHelpers.WrappedSelectedDto <FORMAS, PaymentFormDto>(vehicle.Value.FORPAGOCO, _mapper, reader);
         }
         vehicle.Supplier1              = SelectionHelpers.WrappedSelectedDto <SupplierSummaryDto, SupplierSummaryDto>(vehicle.Value.PROVEEDOR, _mapper, reader);
         vehicle.ClientDto              = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(vehicle.Value.COMPRADOR, _mapper, reader);
         vehicle.ResellerDto            = SelectionHelpers.WrappedSelectedDto <VENDEDOR, ResellerDto>(vehicle.Value.VENDEDOR_VTA, _mapper, reader);
         vehicle.RoadTaxesCityDto       = SelectionHelpers.WrappedSelectedDto <POBLACIONES, CityDto>(vehicle.Value.POBLA_IMP, _mapper, reader);
         vehicle.RoadOfficeZoneDto      = SelectionHelpers.WrappedSelectedDto <ZONAOFI, ZonaOfiDto>(vehicle.Value.ZONA_IMP, _mapper, reader);
         vehicle.AssuranceDto           = SelectionHelpers.WrappedSelectedDto <SupplierSummaryDto, SupplierSummaryDto>(vehicle.Value.CIASEGU, _mapper, secondResult);
         vehicle.AssistencePolicyDto    = SelectionHelpers.WrappedSelectedDto <SupplierSummaryDto, SupplierSummaryDto>(vehicle.Value.CIAADA2, _mapper, secondResult);
         vehicle.AssistenceAssuranceDto = SelectionHelpers.WrappedSelectedDto <SupplierSummaryDto, SupplierSummaryDto>(vehicle.Value.CIAADA, _mapper, secondResult);
         vehicle.AdditionalAssuranceDto = SelectionHelpers.WrappedSelectedDto <SupplierSummaryDto, SupplierSummaryDto>(vehicle.Value.CIAADA3, _mapper, secondResult);
         vehicle.Supplier2              = SelectionHelpers.WrappedSelectedDto <SupplierSummaryDto, SupplierSummaryDto>(vehicle.Value.CIALEAS, _mapper, secondResult);
         //  vehicle.AssuranceAgentDto = SelectionHelpers.WrappedSelectedDto<AGENTES, AgentDto>(vehicle.Value.AGENTE, _mapper, reader);
     }
     catch (System.Exception ex)
     {
         return(false);
     }
     return(true);
 }
        private bool ParseResult(IBookingIncidentData request, SqlMapper.GridReader reader)
        {
            if ((request == null) || (reader == null))
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                request.IncidentOfficeDto = SelectionHelpers.WrappedSelectedDto <OFICINAS, OfficeViewObject>(request.Value.OFICINA, _mapper, reader);

                request.IncidentSupplierDto = SelectionHelpers.WrappedSelectedDto <PROVEE1, SupplierSummaryViewObject>(request.Value.PROVEE, _mapper, reader);

                request.IncidentVehicleDto = SelectionHelpers.WrappedSelectedDto <VehicleSummaryViewObject, VehicleSummaryViewObject>(request.Value.NOM_VEHI, _mapper, reader);

                request.IncidentClientDto = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.CLIENTE, _mapper, reader);

                request.IncidentTypeDto = SelectionHelpers.WrappedSelectedDto <COINRE, IncidentTypeViewObject>(request.Value.TIPO, _mapper, reader);


#pragma warning disable CS0168 // Variable is declared but never used
            }
            catch (System.Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
            {
                return(false);
            }
            return(true);
        }
        private bool ParseClientResult(IBookingData request, SqlMapper.GridReader reader)
        {
            if ((request == null) || (reader == null))
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                // client queries. Multiple Query are stacked when created so we need to fetch in the reverse order.
                request.DriverDto5 = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.OTRO3COND_RES2, _mapper, reader);

                request.DriverDto4 = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.OTRO2COND_RES2, _mapper, reader);

                request.DriverDto3 = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.OTROCOND_RES2, _mapper, reader);

                request.DriverDto2 = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.CONDUCTOR_RES1, _mapper, reader);

                request.Clients = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.CLIENTE_RES1, _mapper, reader);
            } catch (System.Exception ex)
            {
                throw new DataAccessLayerException("Parsing multiple query result error", ex);
            }
            return(true);
        }
        private async Task <bool> ExecuteSecondDriverResult(IBookingData request)
        {
            if (request == null)
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                using (var connection = SqlExecutor.OpenNewDbConnection())
                {
                    BookingViewObject dto = request.Value;
                    var secondDriverStore = _queryStoreFactory.GetQueryStore();
                    secondDriverStore.AddParamCount(QueryType.QueryCity, dto.DRV2_CITY);
                    secondDriverStore.AddParamCount(QueryType.QueryCountry, dto.DRV2_ID_CARD_COU_CODE);
                    secondDriverStore.AddParamCount(QueryType.QueryProvince, dto.DRV2_ZIP_CODE);
                    var secondDriverQuery = secondDriverStore.BuildQuery();
                    var driverResult      = await connection.QueryMultipleAsync(secondDriverQuery).ConfigureAwait(false);

                    request.SecondDriverCityDto     = SelectionHelpers.WrappedSelectedDto <POBLACIONES, CityViewObject>(request.Value.DRV2_CITY, _mapper, driverResult);
                    request.SecondDriverCountryDto  = SelectionHelpers.WrappedSelectedDto <Country, CountryViewObject>(request.Value.DRV2_ID_CARD_COU_CODE, _mapper, driverResult);
                    request.SecondDriverProvinceDto = SelectionHelpers.WrappedSelectedDto <PROVINCIA, ProvinceViewObject>(request.Value.DRV2_ZIP_CODE, _mapper, driverResult);
                }
            }
            catch (System.Exception ex)
            {
                throw new DataAccessLayerException("Parsing multiple query result error", ex);
            }
            return(true);
        }
Esempio n. 6
0
        private bool ParseResult(IReservationRequest request, SqlMapper.GridReader reader)
        {
            if ((request == null) || (reader == null))
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                request.ResquestReasonDto = SelectionHelpers.WrappedSelectedDto <MOPETI, RequestReasonDto>(request.Value.MOPETI, _mapper, reader);
                request.OfficeDto         = SelectionHelpers.WrappedSelectedDto <OFICINAS, OfficeDtos>(request.Value.OFICINA, _mapper, reader);
                request.ClientDto         = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(request.Value.CLIENTE, _mapper, reader);
                request.ResellerDto       = SelectionHelpers.WrappedSelectedDto <VENDEDOR, ResellerDto>(request.Value.VENDEDOR, _mapper, reader);
                request.FareDto           = SelectionHelpers.WrappedSelectedDto <NTARI, FareDto>(request.Value.TARIFA, _mapper, reader);
                request.CompanyDto        = SelectionHelpers.WrappedSelectedDto <SUBLICEN, CompanyDto>(request.Value.SUBLICEN, _mapper, reader);
                request.GroupDto          = SelectionHelpers.WrappedSelectedDto <GRUPOS, VehicleGroupDto>(request.Value.CATEGO, _mapper, reader);
                request.OriginDto         = SelectionHelpers.WrappedSelectedDto <ORIGEN, OrigenDto>(request.Value.ORIGEN, _mapper, reader);
                request.VehicleDto        = SelectionHelpers.WrappedSelectedDto <VehicleSummaryDto, VehicleSummaryDto>(request.Value.OTRO_VEHI, _mapper, reader);


#pragma warning disable CS0168 // Variable is declared but never used
            }
            catch (System.Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
            {
                return(false);
            }
            return(true);
        }
Esempio n. 7
0
        /// <summary>
        ///  Parse the result of an office multiple query
        /// </summary>
        /// <param name="request"></param>
        /// <param name="reader"></param>
        /// <returns></returns>

        private bool ParseResult(OfficeViewObject request, OFICINAS value, SqlMapper.GridReader reader)
        {
            if ((request == null) || (reader == null))
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                request.City           = SelectionHelpers.WrappedSelectedDto <POBLACIONES, CityViewObject>(value.CP, _mapper, reader);
                request.Province       = SelectionHelpers.WrappedSelectedDto <PROVINCIA, ProvinceViewObject>(value.PROVINCIA, _mapper, reader);
                request.Currencies     = SelectionHelpers.WrappedSelectedDto <CURRENCIES, CurrenciesViewObject>(value.CURRENCY_OFI, _mapper, reader);
                request.HolidayDates   = SelectionHelpers.WrappedSelectedDto <FESTIVOS_OFICINA, HolidayViewObject>(value.CODIGO, _mapper, reader);
                request.DelegaContable = SelectionHelpers.WrappedSelectedDto <DELEGA, DelegaContableViewObject>(value.DEPARTA, _mapper, reader);
                request.Country        = SelectionHelpers.WrappedSelectedDto <Country, CountryViewObject>(value.PAIS, _mapper, reader);
                request.OfficeZone     = SelectionHelpers.WrappedSelectedDto <ZONAOFI, ZonaOfiViewObject>(value.ZONAOFI, _mapper, reader);
#pragma warning disable CS0168 // Variable is declared but never used
            }
            catch (System.Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
            {
                return(false);
            }
            return(true);
        }
Esempio n. 8
0
        /// <summary>
        ///  Load just a company with a code primary key value
        /// </summary>
        /// <param name="code">Identifier of the company</param>
        /// <returns>The company data transfer object.</returns>
        public async Task <CompanyViewObject> LoadValueAsync(string code)
        {
            var companyDto = new CompanyViewObject();

            using (var connection = _sqlExecutor.OpenNewDbConnection())
            {
                var value = await connection.GetAsync <SUBLICEN>(code);

                if (value == null)
                {
                    companyDto.IsValid = false;
                    return(companyDto);
                }
                companyDto = _mapper.Map <SUBLICEN, CompanyViewObject>(value);

                var store         = CreateQueryStore(companyDto);
                var multipleQuery = store.BuildQuery();
                var reader        = await connection.QueryMultipleAsync(multipleQuery);

                var city = SelectionHelpers.WrappedSelectedDto <POBLACIONES, CityViewObject>(value.POBLACION, _mapper, reader);

                var province = SelectionHelpers.WrappedSelectedDto <PROVINCIA, ProvinceViewObject>(value.PROVINCIA, _mapper, reader);
                companyDto.Offices  = SelectionHelpers.WrappedSelectedDto <OFICINAS, OfficeViewObject>(value.CODIGO, _mapper, reader);
                companyDto.City     = city.FirstOrDefault();
                companyDto.Province = province.FirstOrDefault();
            }
            return(companyDto);
        }
 private bool ParseOfficeResult(IBookingData request, SqlMapper.GridReader reader)
 {
     if ((request == null) || (reader == null))
     {
         return(false);
     }
     if (request.Value == null)
     {
         return(false);
     }
     try
     {
         // office queries. Requests are stacked so, retrieval shall be reversed.
         request.ReservationOfficeArrival   = SelectionHelpers.WrappedSelectedDto <OFICINAS, OfficeViewObject>(request.Value.OFIRETORNO_RES1, _mapper, reader);
         request.ReservationOfficeDeparture = SelectionHelpers.WrappedSelectedDto <OFICINAS, OfficeViewObject>(request.Value.OFISALIDA_RES1, _mapper, reader);
         request.OfficeDto = SelectionHelpers.WrappedSelectedDto <OFICINAS, OfficeViewObject>(request.Value.OFICINA_RES1, _mapper, reader);
     }
     catch (System.Exception ex)
     {
         throw new DataAccessLayerException("Parsing multiple query result error", ex);
     }
     return(true);
 }
 private bool ParseCountryResult(IBookingData request, SqlMapper.GridReader reader)
 {
     // null checking as usual.
     if ((request == null) || (reader == null))
     {
         return(false);
     }
     if (request.Value == null)
     {
         return(false);
     }
     try
     {
         // client queries. Multiple Query are stacked when created so we need to fetch in the reverse order.
         request.CountryDto3       = SelectionHelpers.WrappedSelectedDto <Country, CountryViewObject>(request.Value.PAISCOND_RES2, _mapper, reader);
         request.DriverCountryList = SelectionHelpers.WrappedSelectedDto <Country, CountryViewObject>(request.Value.PAISNIFCOND_RES2, _mapper, reader);
     }
     catch (System.Exception ex)
     {
         throw new DataAccessLayerException("Parsing multiple query result error", ex);
     }
     return(true);
 }
Esempio n. 11
0
        private bool ParseResult(IUsersData request, SqlMapper.GridReader reader)
        {
            if ((request == null) || (reader == null))
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                request.UserOfficeDto = SelectionHelpers.WrappedSelectedDto <OFICINA, OfficeViewObject>(request.Value.OFI_COD, _mapper, reader);


#pragma warning disable CS0168 // Variable is declared but never used
            }
            catch (System.Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
            {
                return(false);
            }
            return(true);
        }
Esempio n. 12
0
 /// <summary>
 ///  Parse the data from the helper.
 /// </summary>
 /// <param name="data">Booking object to be used.</param>
 /// <param name="reader">Reader to be used.</param>
 private void ParseAuxData(ref BookingViewObject data, SqlMapper.GridReader reader)
 {
     data.Drivers = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(data.CONDUCTOR_RES1, _mapper, reader);
     data.Clients = SelectionHelpers.WrappedSelectedDto <ClientSummaryExtended, ClientSummaryExtended>(data.CLIENTE_RES1, _mapper, reader);
 }
        private bool ParseResult(IBookingData request, SqlMapper.GridReader reader)
        {
            if ((request == null) || (reader == null))
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                request.AgencyEmployeeDto = SelectionHelpers.WrappedSelectedDto <EAGE, AgencyEmployeeViewObject>(request.Value.EMPLEAGE_RES2, _mapper, reader);

                request.BookingMediaDto = SelectionHelpers.WrappedSelectedDto <MEDIO_RES, BookingMediaViewObject>(request.Value.MEDIO_RES1, _mapper, reader);

                request.BookingTypeDto = SelectionHelpers.WrappedSelectedDto <TIPOS_RESERVAS, BookingTypeViewObject>(request.Value.TIPORES_res1, _mapper, reader);



                request.BookingBudget = SelectionHelpers.WrappedSelectedDto <BudgetSummaryViewObject, BudgetSummaryViewObject>(request.Value.PRESUPUESTO_RES1, _mapper, reader);

                request.BrokerDto = SelectionHelpers.WrappedSelectedDto <CommissionAgentSummaryViewObject, CommissionAgentSummaryViewObject>(request.Value.COMISIO_RES2, _mapper, reader);


                request.CityDto3 = SelectionHelpers.WrappedSelectedDto <POBLACIONES, CityViewObject>(SanitizeCity(request.Value.POCOND_RES2), _mapper, reader);

                request.ContactsDto1 = SelectionHelpers.WrappedSelectedDto <CliContactos, ContactsViewObject>(request.Value.CONTACTO_RES2, _mapper, reader);

                request.CompanyDto = SelectionHelpers.WrappedSelectedDto <SUBLICEN, CompanyViewObject>(request.Value.SUBLICEN_RES1, _mapper, reader);


                request.FareDto = SelectionHelpers.WrappedSelectedDto <NTARI, FareViewObject>(request.Value.TARIFA_RES1, _mapper, reader);

                request.PaymentFormDto = SelectionHelpers.WrappedSelectedDto <FORMAS, PaymentFormViewObject>(request.Value.FCOBRO_RES1, _mapper, reader);

                request.ProvinceDto3 = SelectionHelpers.WrappedSelectedDto <PROVINCIA, ProvinceViewObject>(request.Value.PROVCOND_RES2, _mapper, reader);

                request.PrintingTypeDto = SelectionHelpers.WrappedSelectedDto <CONTRATIPIMPR, PrintingTypeViewObject>(request.Value.CONTRATIPIMPR_RES, _mapper, reader);

                request.OriginDto = SelectionHelpers.WrappedSelectedDto <ORIGEN, OrigenViewObject>(request.Value.ORIGEN_RES2, _mapper, reader);

                request.VehicleActivitiesDto = SelectionHelpers.WrappedSelectedDto <ACTIVEHI, VehicleActivitiesViewObject>(request.Value.ACTIVEHI_RES1, _mapper, reader);

                request.VehicleGroupDto = SelectionHelpers.WrappedSelectedDto <GRUPOS, VehicleGroupViewObject>(request.Value.GRUPO_RES1, _mapper, reader);

                request.VehicleDto = SelectionHelpers.WrappedSelectedDto <VehicleSummaryViewObject, VehicleSummaryViewObject>(request.Value.VCACT_RES1, _mapper, reader);

                request.BookingRefusedDto = SelectionHelpers.WrappedSelectedDto <MOTANU, BookingRefusedViewObject>(request.Value.RECHAZAMOTI, _mapper, reader);


#pragma warning disable CS0168 // Variable is declared but never used
            }
            catch (System.Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
            {
                var msg = "Parsing multiple query result error " + ex.Message;
                throw new DataAccessLayerException(msg, ex);
            }
            return(true);
        }
Esempio n. 14
0
        private bool ParseResult(IBookingData request, SqlMapper.GridReader reader)
        {
            if ((request == null) || (reader == null))
            {
                return(false);
            }
            if (request.Value == null)
            {
                return(false);
            }
            try
            {
                request.OfficeDto = SelectionHelpers.WrappedSelectedDto <OFICINA, OfficeDto>(request.Value.OFICINA_RES1, _mapper, reader);

                request.ReservationOfficeDeparture = SelectionHelpers.WrappedSelectedDto <OFICINA, OfficeDto>(request.Value.OFISALIDA_RES1, _mapper, reader);

                request.ReservationOfficeArrival = SelectionHelpers.WrappedSelectedDto <OFICINA, OfficeDto>(request.Value.OFIRETORNO_RES1, _mapper, reader);

                request.BudgetDto = SelectionHelpers.WrappedSelectedDto <PRESUP1, BudgetDto>(request.Value.PRESUPUESTO_RES1, _mapper, reader);

                request.FareDto = SelectionHelpers.WrappedSelectedDto <NTARI, FareDto>(request.Value.TARIFA_RES1, _mapper, reader);

                request.VehicleGroupDto = SelectionHelpers.WrappedSelectedDto <GRUPOS, VehicleGroupDto>(request.Value.GRUPO_RES1, _mapper, reader);

                request.BrokerDto = SelectionHelpers.WrappedSelectedDto <COMISIO, CommissionAgentSummaryDto>(request.Value.COMISIO_RES2, _mapper, reader);

                request.VehicleDto = SelectionHelpers.WrappedSelectedDto <VEHICULOS1, VehicleSummaryDto>(request.Value.VCACT_RES1, _mapper, reader);

                request.DriverDto3 = SelectionHelpers.WrappedSelectedDto <CLIENTES1, ClientSummaryExtended>(request.Value.OTROCOND_RES2, _mapper, reader);

                request.DriverDto4 = SelectionHelpers.WrappedSelectedDto <CLIENTES1, ClientSummaryExtended>(request.Value.OTRO2COND_RES2, _mapper, reader);

                request.DriverDto5 = SelectionHelpers.WrappedSelectedDto <CLIENTES1, ClientSummaryExtended>(request.Value.OTRO3COND_RES2, _mapper, reader);

                request.DriverDto2 = SelectionHelpers.WrappedSelectedDto <CLIENTES1, ClientSummaryExtended>(request.Value.CONDUCTOR_CON1, _mapper, reader);

                request.CityDto3 = SelectionHelpers.WrappedSelectedDto <POBLACIONES, CityDto>(request.Value.POCOND_RES2, _mapper, reader);

                request.Country2Dto = SelectionHelpers.WrappedSelectedDto <PAIS, CountryDto>(request.Value.PAISNIFCOND_RES2, _mapper, reader);

                request.CountryDto3 = SelectionHelpers.WrappedSelectedDto <PAIS, CountryDto>(request.Value.PAISCOND_RES2, _mapper, reader);

                request.ProvinceDto3 = SelectionHelpers.WrappedSelectedDto <PROVINCIA, ProvinciaDto>(request.Value.PROVCOND_RES2, _mapper, reader);

                request.OriginDto = SelectionHelpers.WrappedSelectedDto <ORIGEN, OriginDto>(request.Value.ORIGEN_RES1, _mapper, reader);

                request.BookingMediaDto = SelectionHelpers.WrappedSelectedDto <MEDIO_RES, BookingMediaDto>(request.Value.MEDIO_RES1, _mapper, reader);

                request.BookingTypeDto = SelectionHelpers.WrappedSelectedDto <TIPORES, BookingTypeDto>(request.Value.TIPORES_RES1, _mapper, reader);

                request.AgencyEmployeeDto = SelectionHelpers.WrappedSelectedDto <EAGE, AgencyEmployeeDto>(request.Value.EMPLEAGE_RES2, _mapper, reader);

                request.ContactsDto1 = SelectionHelpers.WrappedSelectedDto <CliContactos, ContactsDto>(request.Value.CONTACTO_RES2, _mapper, reader);

                request.PaymentFormDto = SelectionHelpers.WrappedSelectedDto <FORMAS, PaymentFormDto>(request.Value.FCOBRO_RES1, _mapper, reader);

                request.PrintingTypeDto = SelectionHelpers.WrappedSelectedDto <CONTRATIPIMPR, PrintingTypeDto>(request.Value.CONTRATIPIMPR_RES, _mapper, reader);

                request.VehicleActivitiesDto = SelectionHelpers.WrappedSelectedDto <ACTIVEHI, VehicleActivitiesDto>(request.Value.ACTIVEHI_RES1, _mapper, reader);


#pragma warning disable CS0168 // Variable is declared but never used
            }
            catch (System.Exception ex)
#pragma warning restore CS0168 // Variable is declared but never used
            {
                return(false);
            }
            return(true);
        }