internal static List <Endereco> ObterCache(UF p_UF, string Localidade, string Logradouro)
{
List <string> listaCaheJSON = new List <string>();
List <Endereco> listaEnderecos = new List <Endereco>();
SpartacusMin.Database.Generic database;
SpartacusMin.Database.Command cmd = new SpartacusMin.Database.Command();
DataTable tabela = new DataTable();
cmd.v_text = @"select c.retorno, x.DataConsulta, c.idconsultaendereco from cache c
inner join ConsultaEndereco x on x.ID = c.idconsultaendereco
where x.Parametros = #parametros#" ;
cmd.AddParameter("parametros", SpartacusMin.Database.Type.STRING);
cmd.SetValue("parametros", Formatacao.FormatarStrParametros(p_UF, Localidade, Logradouro), false);
try
{
database = new SpartacusMin.Database.Sqlite(BancosDeDados.ObterCaminhoBancoCache());
database.SetExecuteSecurity(false);
tabela = database.Query(cmd.GetUpdatedText(), "Resultado");
if (tabela.Rows.Count != 0)
{
if (DateTime.Now.ValidarIntervaloDeTempo(tabela.Rows[0]["DataConsulta"].ToString()))
{
foreach (DataRow item in tabela.Rows)
{
listaCaheJSON.Add(item[0].ToString());
}
listaEnderecos = ManipulacaoJSON.ObterEnderecos(listaCaheJSON);
}
else
{
Cache.Deletar(Convert.ToInt16(tabela.Rows[0][2]));
}
}
}
catch (SpartacusMin.Database.Exception ex)
{
throw new Exception($"Erro no banco: {ex.v_message}");
}
return(listaEnderecos);
}
internal static DataTable ObterTabelaDoBanco(string p_Query)
{
var tabelaSaida = new DataTable();
SpartacusMin.Database.Generic database;
try
{
database = new SpartacusMin.Database.Sqlite(BancosDeDados.ObterCaminhoBancoLugares());
tabelaSaida = database.Query(p_Query, "Resultado");
}
catch (SpartacusMin.Database.Exception ex)
{
throw new Exception(ex.v_message);
}
return(tabelaSaida);
}
private static string ObterIDultimaInsercao()
{
SpartacusMin.Database.Generic database;
DataTable tabela;
try
{
database = new SpartacusMin.Database.Sqlite(BancosDeDados.ObterCaminhoBancoCache());
tabela = database.Query("select MAX(id) from ConsultaEndereco", "UltimoRegistro");
return(tabela.Rows[0][0].ToString());
}
catch (SpartacusMin.Database.Exception ex)
{
throw new Exception($"Erro: {ex.v_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);
}
