public void Configure(IServerRoutingTable serverRoutingTable)
{
// Once on start
using (var db = new PdbContext())
{
db.Database.EnsureCreated();
}
}
public PackageServices(PdbContext db, IReceiptsServices receiptsServices)
{
this.db = db;
this.receiptsServices = receiptsServices;
}
/// <summary>
/// Carrega os dados da phc
/// </summary>
public void LoadBulkData()
{
try
{
using (var tmp = new PdbContext(_utilities.GetPhcConnection()))
{
try
{
tmp.Configuration.AutoDetectChangesEnabled = false;
//var tmpFiltrosClientes = (from x in tmp.FiltrosClientes
// select x.Ftitulo
// ).ToList();
var tmpFiltrosClientes = (from t in tmp.FiltrosClientes
select new
{
_tStamp = t.Fltclstamp,
_tFiltroTitulo = t.Ftitulo
}).AsEnumerable().Select(tmpf => new Fltcl
{
Fltclstamp = tmpf._tStamp,
Ftitulo = tmpf._tFiltroTitulo
}).ToList();
_dadosFiltrosClientes = tmpFiltrosClientes.Any()
? new BindableCollection <Fltcl>(tmpFiltrosClientes)
: new BindableCollection <Fltcl>();
var tmpFiltrosStocks = (from t in tmp.FiltrosStocks
select new
{
_tStamp = t.Fltststamp,
_tFiltroTitulo = t.Ftitulo
}).AsEnumerable().Select(tmpf => new Fltst
{
Fltststamp = tmpf._tStamp,
Ftitulo = tmpf._tFiltroTitulo
}).ToList();
_dadosFiltrosStocks = tmpFiltrosStocks.Any()
? new BindableCollection <Fltst>(tmpFiltrosStocks)
: new BindableCollection <Fltst>();
var tmpDataUs = (from t in tmp.DadosUs
where t.Vendedor != 0 && t.Inactivo == false
select new
{
_tVendedor = t.Vendedor,
_tUsIniciais = t.Iniciais,
_tNomeVendedor = t.Vendnm
}).Distinct().AsEnumerable().Select(tmpUs => new Us
{
Vendedor = tmpUs._tVendedor,
Iniciais = tmpUs._tUsIniciais,
Vendnm = tmpUs._tNomeVendedor
}).ToList();
_listaIniciais = tmpDataUs.Any()
? new BindableCollection <Us>(tmpDataUs)
: new BindableCollection <Us>();
var tmpBosConfig = (from t in tmp.DadosTs
select new
{
_tNdos = t.Ndos,
_tNdos2 = t.Ndos2,
_tNomeDossier = t.Nmdos,
_tNdescs = t.Ndescs,
_tArmazem = t.Armazem
}).AsEnumerable().Select(tmpConfigBo => new Ts
{
Ndos = tmpConfigBo._tNdos,
Ndos2 = tmpConfigBo._tNdos2,
Nmdos = tmpConfigBo._tNomeDossier,
Ndescs = tmpConfigBo._tNdescs,
Armazem = tmpConfigBo._tArmazem
}).ToList();
//var tmpBos = (from t in tmp.DossiersInternos
// where t.Boclose == false && t.Fechada == false
// select new
// {
// _tBostamp = t.Bostamp,
// _tNo = t.No,
// _tNmdos = t.Nmdos
// }).Distinct().AsEnumerable().Select(tmpBo => new Bo
// {
// Bostamp = tmpBo._tBostamp,
// No = tmpBo._tNo,
// Nmdos = tmpBo._tNmdos
// }).ToList();
_listaNumerosDescontos = tmpBosConfig.Any()
? new BindableCollection <Ts>(tmpBosConfig)
: new BindableCollection <Ts>();
//var tmpUsr = (from t in tmp.DadosClientes
// where t.Inactivo == false
// select new
// {
// _Vendedor = t.Vendedor,
// _VendNm = t.Vendnm
// }).Distinct().AsEnumerable().Select(tmpCl => new Cl
// {
// Vendnm = tmpCl._VendNm,
// Vendedor = tmpCl._Vendedor
// }).ToList();
//_dadosUtilizadores = tmpUsr.Any()
// ? new BindableCollection<Cl>(tmpUsr)
// : new BindableCollection<Cl>();
}
finally
{
tmp.Configuration.AutoDetectChangesEnabled = true;
}
}
}
catch (Exception e)
{
EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, e.Message));
}
}
public ReceiptsServices(PdbContext db)
{
this.db = db;
}
public UserService(PdbContext db)
{
this.db = db;
}