internal Endereco ObterCache(string CEP) { var sql = "select * from cache where CEP = #cep#"; try { var listaDeCEP = bancoDeDados.Conexao if (tabela.Rows.Count != 0) { var strJSON = tabela.Rows[0]["Retorno"].ToString(); enderecoBase = ManipulacaoJSON.ObterEndereco(strJSON); } } catch (System.Exception ex) { throw new Exception($"Erro no banco: {ex.Message}"); } }
internal static Endereco ObterCache(string CEP) { var enderecoBase = new Endereco(); SpartacusMin.Database.Generic database; var cmd = new SpartacusMin.Database.Command(); var tabela = new DataTable(); cmd.v_text = "select * from cache where CEP = #cep#"; cmd.AddParameter("cep", SpartacusMin.Database.Type.STRING); cmd.SetValue("cep", CEP); try { database = new SpartacusMin.Database.Sqlite(BancosDeDados.ObterCaminhoBancoCache()); database.SetExecuteSecurity(false); tabela = database.Query(cmd.GetUpdatedText(), "Saida"); if (tabela.Rows.Count != 0) { var strJSON = tabela.Rows[0]["Retorno"].ToString(); enderecoBase = ManipulacaoJSON.ObterEndereco(strJSON); } } catch (SpartacusMin.Database.Exception ex) { throw new Exception($"Erro no banco: {ex.v_message}"); } return(enderecoBase); }