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