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