private void PersistirDados(SiteComPosicaoResponse lista)
{
StringBuilder sb = new StringBuilder();
foreach (var p in lista.posicoes)
{
sb.AppendLine($@"insert into posicoes_sitacom values (
{p.pktId},
{p.cveiId},
{p.teveId},
'{p.cveiPlaca}',
'{p.teveDescricao}',
getdate(),
'{p.llpoDataGps}',
'{p.llpoDataStatus}',
'{p.llpoLatitude.ToString()}',
'{p.llpoLongitude.ToString()}',
{p.llpoVelocidade},
'{p.truaNome}',
'{p.tmunNome}',
'{p.testNome}');");
}
_conexao.Executa(sb.ToString());
}
private SiteComPosicaoResponse ObterPosicoes()
{
var lista = new SiteComPosicaoResponse();
var body = new SitaComCredenciais()
{
login = login,
cgruChave = cgruChave,
cusuChave = cusuChave
};
var json = JsonConvert.SerializeObject(body);
var data = new StringContent(json, Encoding.UTF8, "application/json");
var url = $"{urlBase}/{endpointUltimaPosicao}";
var client = new HttpClient();
var task = client.PostAsync(url, data);
task.Wait();
var response = task.Result;
string result = response.Content.ReadAsStringAsync().Result;
lista = JsonConvert.DeserializeObject <SiteComPosicaoResponse>(result);
if (lista.posicoes != null && lista.posicoes.Count > 0)
{
lista.posicoes.ForEach(e =>
{
var dataGps = e.llpoDataGps.Split(' ');
e.llpoDataGps = $"{Convert.ToDateTime(dataGps[0]).ToString("yyyy-MM-dd")} {dataGps[1]}";
var dataStatus = e.llpoDataStatus.Split(' ');
e.llpoDataStatus = $"{Convert.ToDateTime(dataStatus[0]).ToString("yyyy-MM-dd")} {dataStatus[1]}";
e.cveiPlaca = memoriaVeiculos.veiculos.Where(v => v.cveiId == e.cveiId).SingleOrDefault().cveiPlaca;
});
}
return(lista);
}
