/// <summary> /// Create a local query store. /// </summary> /// <param name="company">Company data transfer object used to be inserted in the query store.</param> /// <returns>Return an interface of the query store.</returns> private IQueryStore CreateQueryStore(CompanyViewObject company) { IQueryStore store = _queryStoreFactory.GetQueryStore(); store.Clear(); store.AddParamCount(QueryType.QueryCity, company.CP); store.AddParamCount(QueryType.QueryProvince, company.PROVINCIA); store.AddParamCount(QueryType.QueryCompanyOffices, company.Code); return(store); }
private IQueryStore AddParams(IQueryStore auxQueryStore, VehicleDto resultQuery) { auxQueryStore.AddParam(QueryType.QueryVehicleModelWithCount, resultQuery.MAR, resultQuery.MO1, resultQuery.MO2); auxQueryStore.AddParamCount(QueryType.QueryBrandByVehicle, resultQuery.MAR, resultQuery.CODIINT); auxQueryStore.AddParam(QueryType.QueryVehiclePhoto, resultQuery.CODIINT); auxQueryStore.AddParamCount(QueryType.QueryVehicleActivity, resultQuery.ACTIVIDAD); auxQueryStore.AddParamCount(QueryType.QueryVehicleOwner, resultQuery.PROPIE); auxQueryStore.AddParamCount(QueryType.QueryAgentByVehicle, resultQuery.AGENTE_VEHI); auxQueryStore.AddParam(QueryType.QueryVehicleMaintenance, resultQuery.CODIINT); auxQueryStore.AddParamCount(QueryType.QueryVehicleColor, resultQuery.COLOR); auxQueryStore.AddParamCount(QueryType.QueryVehicleGroup, resultQuery.GRUPO); auxQueryStore.AddParamCount(QueryType.QueryPaymentForm, resultQuery.FORPAGOCO); auxQueryStore.AddParamCount(QueryType.QuerySupplierSummaryById, resultQuery.PROVEEDOR); auxQueryStore.AddParamCount(QueryType.QueryClientSummaryExtById, resultQuery.COMPRADOR); auxQueryStore.AddParamCount(QueryType.QueryReseller, resultQuery.VENDEDOR_VTA); auxQueryStore.AddParamCount(QueryType.QueryCity, resultQuery.POBLA_IMP); auxQueryStore.AddParamCount(QueryType.QueryOfficeZone, resultQuery.ZONA_IMP); return(auxQueryStore); }
private IQueryStore CreateQueryStore(SupplierPoco queryResult) { // QueryType.QuerySuppliersBranches, code IQueryStore store = _queryStoreFactory.GetQueryStore(); store.AddParamCount(QueryType.QuerySuppliersBranches, "ProDelega", "ccoIdCliente", queryResult.NUM_PROVEE); store.AddParamCount(QueryType.QuerySuppliersContacts, "ProContactos", "ccoIdCliente", queryResult.NUM_PROVEE); store.AddParamCount(QueryType.QueryProvince, queryResult.PROV); store.AddParamCount(QueryType.QueryCity, queryResult.POBLACION); store.AddParamCount(QueryType.QueryAccount, queryResult.CUGASTO); store.AddParamCount(QueryType.QueryAccount, queryResult.CONTABLE); store.AddParamCount(QueryType.QueryAccount, queryResult.RETENCION); store.AddParamCount(QueryType.QueryAccount, queryResult.CTAPAGO); store.AddParamCount(QueryType.QueryAccount, queryResult.CTALP); store.AddParamCount(QueryType.QueryAccount, queryResult.CTACP); store.AddParamCount(QueryType.QueryAccount, queryResult.CTAINTRACOP); store.AddParamCount(QueryType.QueryAccount, queryResult.ctaintracoPRep); store.AddParamCount(QueryType.QueryLanguage, "IDIOMAS", "CODIGO", queryResult.IDIOMA); store.AddParamCount(QueryType.QueryCountry, "PAIS", "SIGLAS", queryResult.PAIS_DEVO); store.AddParamCount(QueryType.QueryCountry, "PAIS", "SIGLAS", queryResult.PAIS_PAGO); store.AddParamCount(QueryType.QueryCountry, "PAIS", "SIGLAS", queryResult.PAIS_RECLAMA); store.AddParamCount(QueryType.QueryOffice, queryResult.OFICINA); store.AddParamCount(QueryType.QueryCompany, queryResult.SUBLICEN); store.AddParamCount(QueryType.QueryCurrency, queryResult.DIVISA); store.AddParamCount(QueryType.QueryDeliveringFrom, ValueToString(queryResult.FORMA_ENVIO)); return(store); }
private IQueryStore CreateQueryStore(ClientDto clientPoco) { IQueryStore store = _queryStoreFactory.GetQueryStore(); store.AddParamCount(QueryType.QueryCity, "POBLACIONES", "CP", clientPoco.CP); store.AddParamCount(QueryType.QueryProvince, "PROVINCIA", "SIGLAS", clientPoco.PROVINCIA); store.AddParamCount(QueryType.QueryCountry, "PAIS", "SIGLAS", clientPoco.NACIODOMI); store.AddParamCount(QueryType.QueryClientType, "TIPOCLI", "NUM_TICLI", clientPoco.TIPOCLI); store.AddParamCount(QueryType.QueryMarket, "MERCADO", "CODIGO", clientPoco.MERCADO); store.AddParamCount(QueryType.QueryZone, "ZONAS", "NUM_ZONA", clientPoco.ZONA); store.AddParamCount(QueryType.QueryLanguage, "IDIOMAS", "CODIGO", ValueToString(clientPoco.IDIOMA)); store.AddParamCount(QueryType.QueryCreditCard, "TARCREDI", "CODIGO", clientPoco.TARTI); store.AddParamCount(QueryType.QueryChannel, "CANAL", "CODIGO", clientPoco.CANAL); store.AddParamCount(QueryType.QueryCompany, "SUBLICEN", "CODIGO", clientPoco.SUBLICEN); store.AddParamCount(QueryType.QueryOffice, "OFICINAS", "CODIGO", clientPoco.OFICINA); store.AddParamCount(QueryType.QueryPaymentForm, "FORMAS", "CODIGO", ValueToString(clientPoco.FPAGO)); store.AddParamCount(QueryType.QuerySeller, "VENDEDOR", "NUM_VENDE", clientPoco.VENDEDOR); store.AddParamCount(QueryType.QueryActivity, "ACTIVI", "NUM_ACTIVI", clientPoco.SECTOR); store.AddParamCount(QueryType.QueryOrigin, "ORIGEN", "NUM_ORIGEN", ValueToString(clientPoco.ORIGEN)); store.AddParamCount(QueryType.QueryBusiness, "NEGOCIO", "CODIGO", clientPoco.NEGOCIO); store.AddParamCount(QueryType.QueryInvoiceBlocks, "BLOQUEFAC", "CODIGO", clientPoco.BLOQUEFAC); store.AddParamCount(QueryType.QueryBudgetKey, "CLAVEPTO", "COD_CLAVE", clientPoco.CLAVEPTO); store.AddParamCount(QueryType.QueryClientSummary, "CLIENTES1", "NUMERO_CLI", clientPoco.CLIENTEFAC); store.AddParamCount(QueryType.QueryCommissionAgentSummaryById, "COMISIO", "NUM_COMI", clientPoco.COMISIO); store.AddParamCount(QueryType.QueryClientDelegations, "CliDelega", "cldIdCliente", clientPoco.NUMERO_CLI); store.AddParamCount(QueryType.QueryClientContacts, "CliContactos", "ccoIdCliente", clientPoco.NUMERO_CLI); store.AddParamCount(QueryType.QueryRentingUse, "USO_ALQUILER", "CODIGO", ValueToString(clientPoco.USO_ALQUILER)); return(store); }