public Supplier(ISqlExecutor executor, IMapper mapper, SupplierPoco supplierPoco, SupplierDto dto)
{
_supplierValue = supplierPoco;
_supplierDto = dto;
_sqlExecutor = executor;
_supplierMapper = mapper;
}
public Supplier(ISqlExecutor executor, string id)
{
_sqlExecutor = executor;
_supplierValue = new SupplierPoco();
_supplierDto = new SupplierDto();
_supplierValue.NUM_PROVEE = id;
_supplierDto.NUM_PROVEE = id;
InitializeMapping();
}
public async Task <bool> LoadAuxValue(SupplierPoco supplier)
{
var queryStoreFactory = new QueryStoreFactory();
var queryStore = queryStoreFactory.GetQueryStore();
/// queryStore.AddParam(QueryType.QuerySupplierType, supplier.TIPO.ToString());
/// queryStore.AddParam(QueryType.AccountById, supplier.CUGASTO);
return(true);
}
private void FillCities(ref SupplierPoco poco)
{
var city = from c in _cityDtos
where c.Code == _supplierValue.CP
select c;
var singleCity = city.FirstOrDefault();
if (singleCity != null)
{
poco.POBLACION = singleCity.Poblacion;
}
}
public async Task <bool> LoadValue(IDictionary <string, string> fields, string code)
{
var currentQuery = string.Format(SupplierQuery, code);
Valid = false;
using (IDbConnection connection = _sqlExecutor.OpenNewDbConnection())
{
try
{
var queryResult = await connection.QueryAsync <SupplierPoco>(currentQuery);
_supplierValue = queryResult.FirstOrDefault(c => c.NUM_PROVEE == code);
if (_supplierValue == null)
{
return(false);
}
Value = _supplierMapper.Map <SupplierPoco, SupplierDto>(_supplierValue);
// now we look for aux tables.
if (_supplierValue.TIPO.HasValue)
{
short value = _supplierValue.TIPO.Value;
Type =
await BuildAndExecute <SupplierTypeDataObject, short>(connection, TipoProveSelect,
value);
}
IEnumerable <CU1> accounts = await connection.QueryAsync <CU1>(AccountSelect);
AccountDtos = _supplierMapper.Map <IEnumerable <CU1>, IEnumerable <AccountDto> >(accounts);
var provincia = await connection.QueryAsync <PROVINCIA>(ProvinciaSelectAll);
// await BuildAndExecute<PROVINCIA>(connection, ProvinciaSelect, _supplierValue.PROV);
if (provincia != null)
{
ProvinciaDtos =
_supplierMapper.Map <IEnumerable <PROVINCIA>, IEnumerable <ProvinciaDto> >(provincia);
}
var pais = await connection.QueryAsync <Country>(PaisSelectAll);
if (pais != null)
{
CountryDtos = _supplierMapper.Map <IEnumerable <Country>, IEnumerable <CountryDto> >(pais);
}
var banks = await BuildAndExecute <BANCO>(connection, BankSelect, _supplierValue.BANCO);
if (banks != null)
{
BanksDtos = _supplierMapper.Map <IEnumerable <BANCO>, IEnumerable <BanksDto> >(banks);
if (_supplierValue.VIA.HasValue)
{
var vias = await BuildAndExecute <VIAS, byte>(connection, ViaSelect,
_supplierValue.VIA.Value);
ViasDtos = _supplierMapper.Map <IEnumerable <VIAS>, IEnumerable <ViaDto> >(vias);
}
}
var branches = await BuildAndExecute <ProDelega>(connection, GenericSql.DelegationQuery,
_supplierValue.NUM_PROVEE);
var tmp = _supplierMapper.Map <IEnumerable <ProDelega>, IEnumerable <BranchesDto> >(branches);
AdjustBranchWithProvince(ref tmp, ProvinciaDtos);
BranchesDtos = tmp;
var contacts =
await BuildAndExecute <ProContactos>(connection, GenericSql.ContactsQuery,
_supplierValue.NUM_PROVEE);
ContactsDtos = _supplierMapper.Map <IEnumerable <ProContactos>, IEnumerable <ContactsDto> >(contacts);
var months = await connection.QueryAsync <MESES>(MonthsSelect);
MonthsDtos = _supplierMapper.Map <IEnumerable <MESES>, IEnumerable <MonthsDto> >(months);
var languages = await connection.QueryAsync <IDIOMAS>(LanguageSelect);
LanguageDtos = _supplierMapper.Map <IEnumerable <IDIOMAS>, IEnumerable <LanguageDto> >(languages);
var paymentForms = await connection.QueryAsync <FORMAS>(PaymentFormSelect);
PaymentDtos = _supplierMapper.Map <IEnumerable <FORMAS>, IEnumerable <PaymentFormDto> >(paymentForms);
var currency = await connection.QueryAsync <DIVISAS>(CurrencySelect);
CurrencyDtos = _supplierMapper.Map <IEnumerable <DIVISAS>, IEnumerable <CurrencyDto> >(currency);
// poblacion mapping
var globalMapper = MapperField.GetMapper();
if (_supplierValue.FORMA_ENVIO.HasValue)
{
var deliveringForm = await BuildAndExecute <FORMAS_PEDENT>(connection,
GenericSql.DeliveringFromQuery,
_supplierValue?.FORMA_ENVIO.ToString());
var mapper = MapperField.GetMapper();
DeliveringFormDto = globalMapper.Map <IEnumerable <FORMAS_PEDENT>, IEnumerable <DeliveringFormDto> >(deliveringForm);
}
if (_supplierValue.VIA.HasValue)
{
// var viaForm = await BuildAndExecute<VIAS>(connection, GenericSql.Via, _supplierValue?.VIA.Value)
}
var cityMapper = globalMapper;
var cityQuery = string.Format(_queryCity);
var cities = await connection.QueryAsync <POBLACIONES>(cityQuery);
var mappedCityDtos = cityMapper.Map <IEnumerable <POBLACIONES>, IEnumerable <CityDto> >(cities);
CityDtos = new ObservableCollection <CityDto>(mappedCityDtos);
// office mapping
string query = string.Format(OfficeSelect, _supplierValue.OFICINA, _supplierValue.SUBLICEN);
var office = await connection.QueryAsync <OFICINAS>(query);
var mappedOffices = MapperField.GetMapper().Map <IEnumerable <OFICINAS>, IEnumerable <OfficeDtos> >(office);
OfficeDtos = new ObservableCollection <OfficeDtos>(mappedOffices);
query = string.Format(CompanySelect, _supplierValue.SUBLICEN);
var company = await connection.QueryAsync <SUBLICEN>(query);
CompanyDtos = MapperField.GetMapper().Map <IEnumerable <SUBLICEN>, IEnumerable <CompanyDto> >(company);
Value = _supplierMapper.Map <SupplierPoco, SupplierDto>(_supplierValue);
Valid = true;
}
catch (System.Exception e)
{
throw new DataLayerExecutionException("Cannot load supplier " + e.Message);
}
}
return(Valid);
}