public void DownloadStringCompleted(object sender, HtmlDocumentLoadCompleted e)
{
if (e.Document != null)
{
HtmlNodeCollection table = e.Document.DocumentNode.SelectNodes("//*[@class='consulta ']");
var appBar = table[2].InnerHtml.Replace(" colspan=\"3\"", "").Replace(" align=\"center\"", "").Replace(" class=\"rowTable\"", "").Replace(" style=\"width:50px\"", "").Replace(" style=\"width:400px\"", "").Replace(" class=\"corUm\" align=\"right\"", "").Replace(" ", "");
appBar = appBar.Insert(0, "<xml>").Insert(appBar.Length - 1, "</xml>");
var tableSaldo = table[3].InnerHtml.Replace(" class=\"rowTable\"", "")
.Replace(" class=\"corUm fontWeightDois\"", "")
.Replace(" align=\"right\"", "")
.Replace(" class=\"corUm fontWeightDois\"", "")
.Replace(" style=\"width:80px\"", "")
.Replace("disponível:", "");
if (appBar.Contains("Não há movimentações para o período selecionado."))
{
if (appBar.Contains("Não há movimentações para o período selecionado."))
{
foreach (var item in table.Descendants("td"))
{
var text = item.InnerHtml;
if (item.XPath == "/html[1]/body[1]/table[1]/tr[1]/td[2]")
{
info.DataConsulta = item.InnerHtml;
}
else if (item.XPath == "/html[1]/body[1]/table[1]/tr[3]/td[2]")
{
info.DataUltimoBeneficioDataBeneficio = item.InnerHtml;
}
else if (item.XPath == "/html[1]/body[1]/table[1]/tr[3]/td[3]")
{
info.ValorUltimoBeneficio = item.InnerHtml;
}
}
xDoc = XDocument.Parse(tableSaldo);
tbtMessage.Visibility = Visibility.Visible;
}
}
else
{
// disponível:
xDoc = XDocument.Parse(appBar);
XDocument xDocSaldo = XDocument.Parse(tableSaldo);
foreach (var item in xDocSaldo.Root.Nodes())
{
if (((System.Xml.Linq.XElement)(item)).Value.ToString().Contains("$"))
{
info.getSaldo = ((System.Xml.Linq.XElement)(item)).Value.ToString();
//MessageBox.Show(((System.Xml.Linq.XElement)(item)).Value.ToString());
}
}
foreach (var item in table.Descendants("td"))
{
var teste = item.InnerHtml;
//data ultima disponibilizacao
if (item.XPath == "/html[1]/body[1]/table[1]/tr[3]/td[2]")
{
info.DataUltimoBeneficioDataBeneficio = item.InnerHtml;
//MessageBox.Show(item.InnerHtml);
}//valor disponibilizado
else if (item.XPath == "/html[1]/body[1]/table[1]/tr[3]/td[3]")
{
info.ValorUltimoBeneficio = item.InnerHtml;
//MessageBox.Show(item.InnerHtml);
}///data proximo
else if (item.XPath == "/html[1]/body[1]/table[1]/tr[4]/td[2]")
{
// MessageBox.Show(item.InnerHtml);
info.DataProximoBeneficio = item.InnerHtml;
// MessageBox.Show(item.InnerHtml);
}
/// valor proximo
else if (item.XPath == "/html[1]/body[1]/table[1]/tr[4]/td[3]")
{
info.ValorProximoBeneficio = item.InnerHtml;
// MessageBox.Show(item.InnerHtml);
}
else if (item.XPath == "/html[1]/body[1]/table[1]/tr[1]/td[2]")
{
info.DataConsulta = item.InnerHtml.Substring(0, 10);
}
else if (item.XPath == "/html[1]/body[1]/table[1]/tr[2]/td[2]")
{
info.NumeroCartao = item.InnerHtml;
}
}
List<VisaValeGastos> c = new List<VisaValeGastos>();
foreach (var item in xDoc.Root.Nodes())
{
c.Add(new VisaValeGastos() { Local = ((System.Xml.Linq.XElement)(item)).Value.ToString().Remove(0, 5).Remove(((System.Xml.Linq.XElement)(item)).Value.IndexOf("$") - 6), Data = ((System.Xml.Linq.XElement)(item)).Value.ToString().Substring(0, 5), Valor = ((System.Xml.Linq.XElement)(item)).Value.Substring(((System.Xml.Linq.XElement)(item)).Value.IndexOf("R$")) });
}
c.Reverse();
listaGastos.ItemsSource = c;
listaGastos.Foreground = new SolidColorBrush(Colors.Black);
var coldata = listaGastos.Columns["Data"];
coldata.Width = new GridLength(80);
var colLocal = listaGastos.Columns["Local"];
colLocal.Width = new GridLength(260);
var colValor = listaGastos.Columns["Valor"];
colValor.Width = new GridLength(140);
Dispatcher.BeginInvoke(() =>
{
Save();
});
}
tblDate.DataContext = info.DataUltimoBeneficioDataBeneficio;
tblText.DataContext = "Último benefício";
tblLast.DataContext = info.ValorUltimoBeneficio.Substring(6);
tblDateNext.DataContext = info.DataProximoBeneficio != null ? info.DataProximoBeneficio : "N/D";
tblTextNext.DataContext = "Próximo benefício";
tblLastNext.DataContext = info.ValorProximoBeneficio != null ? info.ValorProximoBeneficio.Substring(6) : "N/D";
tblTextSaldo.DataContext = "Saldo atual";
tblSaldo.DataContext = info.getSaldo != null ? info.getSaldo : xDoc.Root.Value.Replace("Saldo ", "");
tblDataPesquisa.DataContext = "Data da pesquisa: " + info.DataConsulta;
title.DataContext = "Extrato";
title.FontSize = 30;
ApplicationBar.Buttons.RemoveAt(0);
this.ApplicationBar = new ApplicationBar();
var newButton = new ApplicationBarIconButton();
newButton.IconUri = new Uri("/Resourses/appbar.refresh.png", UriKind.Relative);
newButton.Text = "update";
newButton.Click += UpdateServer;
this.ApplicationBar.Buttons.Add(newButton);
stackPanel.Visibility = Visibility.Collapsed;
this.progressBar.IsIndeterminate = false;
}
else
{
if (this.progressBar.IsIndeterminate)
{
using (var ctx = new visaValeDataContext(conn))
{
if (ctx.DatabaseExists())
{
var confirm = MessageBox.Show("Não foi possível obter conexão de dados! \n Deseja continuar com as informações da sua última pesquisa ?", "", MessageBoxButton.OKCancel);
if (confirm.ToString() == "OK")
{
foreach (var item in ctx.VisaVales)
{
if (item.Id == 1)
{
tblDate.DataContext = item.DataUltimoBeneficioDataBeneficio;
tblLast.DataContext = item.ValorUltimoBeneficio.Substring(6);
tblDateNext.DataContext = item.DataProximoBeneficio != null ? item.DataProximoBeneficio : "N/D";
tblTextNext.DataContext = "Próximo benefício";
tblLastNext.DataContext = item.ValorProximoBeneficio != null ? item.ValorProximoBeneficio.Substring(6) : "N/D";
tblTextSaldo.DataContext = "Saldo atual";
tblSaldo.DataContext = item.GetSaldo;
tblDataPesquisa.DataContext = "Data da pesquisa: " + item.DataConsulta;
title.DataContext = "Extrato";
title.FontSize = 30;
ApplicationBar.Buttons.RemoveAt(0);
this.ApplicationBar = new ApplicationBar();
var newButton = new ApplicationBarIconButton();
newButton.IconUri = new Uri("/Resourses/appbar.refresh.png", UriKind.Relative);
newButton.Text = "update";
newButton.Click += UpdateServer;
this.ApplicationBar.Buttons.Add(newButton);
stackPanel.Visibility = Visibility.Collapsed;
this.progressBar.IsIndeterminate = false;
List<VisaValeGastos> listaGastosVisa = new List<VisaValeGastos>();
foreach (var item2 in item.VisaValeGastos)
{
listaGastosVisa.Add(new VisaValeGastos { Data = item2.Data, Local = item2.Local, Valor = item2.Valor });
}
listaGastosVisa.Reverse();
listaGastos.ItemsSource = listaGastosVisa;
listaGastos.Foreground = new SolidColorBrush(Colors.Black);
var coldata = listaGastos.Columns["Data"];
coldata.Width = new GridLength(80);
var colLocal = listaGastos.Columns["Local"];
colLocal.Width = new GridLength(260);
var colValor = listaGastos.Columns["Valor"];
colValor.Width = new GridLength(140);
break;
}
}
}
}
else if (!ctx.DatabaseExists())
{
MessageBox.Show("Não foi possível estabelecer conexão com o servidor de dados!");
NavigationService.GoBack();
}
}
}
}
this.progressBar.IsIndeterminate = false;
stackPanel.Visibility = Visibility.Collapsed;
}
public void Save()
{
using (var ctx = new visaValeDataContext(conn))
{
//if (ctx.DatabaseExists())
//{
ctx.DeleteDatabase();
ctx.CreateDatabase();
var infoVisa = new VisaVale1
{
DataConsulta = info.DataConsulta,
DataProximoBeneficio = info.DataProximoBeneficio,
DataUltimoBeneficioDataBeneficio = info.DataUltimoBeneficioDataBeneficio,
GetSaldo = info.getSaldo,
ValorProximoBeneficio = info.ValorProximoBeneficio,
ValorUltimoBeneficio = info.ValorUltimoBeneficio,
NumeroCartao = info.NumeroCartao
};
foreach (var item2 in xDoc.Root.Nodes())
{
infoVisa.VisaValeGastos.Add(new VisaValeGasto { Local = ((System.Xml.Linq.XElement)(item2)).Value.ToString().Remove(0, 5).Remove(((System.Xml.Linq.XElement)(item2)).Value.IndexOf("$") - 6), Data = ((System.Xml.Linq.XElement)(item2)).Value.ToString().Substring(0, 5), Valor = ((System.Xml.Linq.XElement)(item2)).Value.Substring(((System.Xml.Linq.XElement)(item2)).Value.IndexOf("R$")) });
}
ctx.VisaVales.InsertOnSubmit(infoVisa);
ctx.SubmitChanges();
}
}