//Faz o select do Horoscopo e carrega na lista
void CarregarHoroscopo()
{
using (var db = new HoroscopoContext())
{
var resultado = (from Horoscopo in db.signos
select Horoscopo).ToList();
listaHoroscopo.ItemsSource = resultado;
}
}
private void WebClient_OpenReadCompleted(object sender, OpenReadCompletedEventArgs e)
{
try{
XDocument doc = XDocument.Load(e.Result);
using (var db = new HoroscopoContext())
{
if (db.signos.Count() == 0)
{
foreach (var item in doc.Descendants("signo"))
{
Horoscopo horoscopo = new Horoscopo();
horoscopo.Nome = (string)item.Element("nome");
horoscopo.Data = (string)item.Element("periodo");
horoscopo.Mensagem = (string)item.Element("msg");
horoscopo.Icone = (string)item.Element("icone");
db.signos.InsertOnSubmit(horoscopo);
db.SubmitChanges();
}
}
else
{
db.SubmitChanges();
}
}
CarregarHoroscopo();
}
catch{
MessageBox.Show("Para utilizar a aplicação pela primeira vez você precisa esta conectado a internet!");
}
}
// Code to execute when the application is launching (eg, from Start)
// This code will not execute when the application is reactivated
private void Application_Launching(object sender, LaunchingEventArgs e)
{
using (var bd = new HoroscopoContext())
{
if (!bd.DatabaseExists())
{
bd.CreateDatabase();
}
}
}
