// public string DevolveNumTerminal(Guid value) { var resultado = "Sem Numero"; try { using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { try { tmp.Configuration.AutoDetectChangesEnabled = false; var tmpd = (from t in tmp.Terminais where t.FkIDOT == value select t.NumPda).SingleOrDefault(); if (tmpd != null) { resultado = tmpd; } } finally { tmp.Configuration.AutoDetectChangesEnabled = true; } return(resultado); } } catch (Exception e) { EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, e.Message)); } return(resultado); }
public void DeleteTerminal(Guid value) { try { using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { var e = tmp.Terminais.Find(value); if (e == null) { return; } var tmpTerminals = tmp.OpcoesTerminais.Find(e.FkIDOT); tmp.OpcoesTerminais.Remove(tmpTerminals); tmp.Terminais.Remove(e); tmp.SaveChanges(); } } catch (Exception e) { EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, e.Message)); } //using (var tmp=new DbTerminalContext(_utilities.GetSqlConfigData("DbTerminalContext").ProviderConnectionString)) }
public bool CreateTerminal(TbTerminal valuet, TbOpcoesTerminal valueOp) { try { //using (var tmp = new DbTerminalContext(_utilities.GetSqlConfigData("DbTerminalContext").ProviderConnectionString)) using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { if (valueOp != null) { valuet.FkIDOT = valueOp.Id; tmp.OpcoesTerminais.Add(valueOp); } tmp.Terminais.Add(valuet); tmp.SaveChanges(); } } //catch(DbEntityValidationException dbex) //{ // foreach (var validationErrors in dbex.EntityValidationErrors) // { // foreach (var Errovalidacao in validationErrors.ValidationErrors) // { // Debug.WriteLine("Property:{0} Error{1}",Errovalidacao.PropertyName,Errovalidacao.ErrorMessage); // } // } //} catch (Exception e) { EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, e.Message)); } return(true); }
public bool VerificaTerminalNum(string value) { var resultado = false; try { using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { try { tmp.Configuration.AutoDetectChangesEnabled = false; var tmpd = (from t in tmp.Terminais where t.NumPda == value select t.NumPda).SingleOrDefault(); resultado = tmpd != null; } finally { tmp.Configuration.AutoDetectChangesEnabled = true; } } } catch (Exception e) { EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, e.Message)); } return(resultado); }
public TbOpcoesTerminal GetEntityOpcoes(Guid opcoesTerminalId) { using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { var tmpData = (from t in tmp.OpcoesTerminais where t.Id == opcoesTerminalId select t).SingleOrDefault(); return(tmpData); } }
public BindableCollection <TbTerminal> LoadTerminais() { BindableCollection <TbTerminal> resultado = null; try { //using (var tmp= new DbTerminalContext(_utilities.GetSqlConfigData("DbTerminalContext").ProviderConnectionString)) using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { var x = (from t in tmp.Terminais select t).ToList(); resultado = x.Any() ? new BindableCollection <TbTerminal>(x) : new BindableCollection <TbTerminal>(); } } catch (Exception e) { EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, e.Message)); } return(resultado); }
public BindableCollection <string> GetDataBasesFromInstance(string valueInstance) { var resultado = new BindableCollection <string>(); try { //var t = _utilities.GetSqlConfigData("DbTerminalContext"); //var t = _utilities.GetIfConnection(); //var t = GetSqlConfigData("DbTerminalContext"); using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { tmp.Database.Initialize(true); StoredProc ldbStoredProc = new StoredProc().HasName("sp_databases").ReturnsTypes(typeof(ListDataBaseResultSet)); ResultsList results = tmp.CallStoredProc(ldbStoredProc); List <ListDataBaseResultSet> tmplst = results.ToList <ListDataBaseResultSet>(); List <string> x = (from b in tmplst where b.DbName != "master" && b.DbName != "msdb" && b.DbName != "model" && b.DbName != "IFDB" && b.DbName != "tempdb" && b.DbName != "ReportServer$" + valueInstance && b.DbName != "ReportServer$" + valueInstance + "TempDB" orderby b.DbName ascending select b.DbName).ToList(); if (x.Count > 0) { resultado = new BindableCollection <string>(x); } } } catch (Exception ex) { EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, ex.Message)); } return(resultado); }
public void UpdateTerminal(TbTerminal value, TbOpcoesTerminal valueop) { try { //using (var tmp = new DbTerminalContext(_utilities.GetSqlConfigData("DbTerminalContext").ProviderConnectionString)) using (var tmp = new DbTerminalContext(_utilities.GetIfConnection())) { if (valueop != null) { var tmpOp = (from t in tmp.OpcoesTerminais where t.Id == valueop.Id select t).SingleOrDefault(); if (tmpOp != null) { tmpOp.PhcNomeFiltroClientes = valueop.PhcNomeFiltroClientes; tmpOp.PhcNomeFiltroArtigos = valueop.PhcNomeFiltroArtigos; tmpOp.ArmazemEnvio = valueop.ArmazemEnvio; tmpOp.ArmazemRegisto = valueop.ArmazemRegisto; tmpOp.TipoRetencaoEncomendas = valueop.TipoRetencaoEncomendas; tmpOp.NumeroEncomendasRetidas = valueop.NumeroEncomendasRetidas; tmpOp.NumeroInicioEncomendas = valueop.NumeroInicioEncomendas; tmpOp.NumeroFimEncomendas = valueop.NumeroFimEncomendas; tmpOp.EliminarEncomendas = valueop.EliminarEncomendas; tmpOp.AlterarPrecoVenda = valueop.AlterarPrecoVenda; tmpOp.IntroduzComponentes = valueop.IntroduzComponentes; tmpOp.MostrarDataLinhas = valueop.MostrarDataLinhas; tmpOp.CriaLinhaEncomenda = valueop.CriaLinhaEncomenda; tmpOp.NomeVendedor = valueop.NomeVendedor; tmpOp.NumVendedor = valueop.NumVendedor; tmpOp.NumeroInicioClientes = valueop.NumeroInicioClientes; tmpOp.NumeroFimClientes = valueop.NumeroFimClientes; tmpOp.SincronizaCcNaoRegula = valueop.SincronizaCcNaoRegula; tmpOp.PhcNomeDossierInterno = valueop.PhcNomeDossierInterno; tmpOp.PhcNumDossierInterno = valueop.PhcNumDossierInterno; tmpOp.NumeroInicioClientes = valueop.NumeroInicioClientes; tmpOp.NumeroFimClientes = valueop.NumeroFimClientes; tmpOp.NumMaxDescontos = valueop.NumMaxDescontos; tmpOp.UsaPreco1 = valueop.UsaPreco1; tmpOp.UsaPreco2 = valueop.UsaPreco2; tmpOp.UsaPreco3 = valueop.UsaPreco3; tmpOp.UsaPreco4 = valueop.UsaPreco4; tmpOp.UsaPreco5 = valueop.UsaPreco5; tmpOp.NumMaxDescontos = valueop.NumMaxDescontos; tmpOp.IniciaisUs = valueop.IniciaisUs; //tmp.SaveChanges(); } } var tmpterminal = (from t in tmp.Terminais where t.IDTerminal == value.IDTerminal select t).SingleOrDefault(); if (tmpterminal != null) { tmpterminal.NumPda = value.NumPda; tmpterminal.MacAddress3G = value.MacAddress3G; tmpterminal.MacAddressWireless = value.MacAddressWireless; tmpterminal.TerminalAccessKey = value.TerminalAccessKey; } tmp.SaveChanges(); } } catch (Exception e) { EventAggregationProvider.Aggregator.Publish(new EventoBackend(EventoTipo.Erro, e.Message)); } }