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