/// <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);
}
