public void UpdateNews()
{
HtmlNodeCollection newsContent = labsNews.NewsContent();
foreach (var trNode in newsContent)
{
Newsletter letter = null;
var tdNode = trNode.ChildNodes;
if (tdNode[0].Name == "td")
{
letter = new Newsletter();
int id;
if (int.TryParse(tdNode[0].InnerText,out id))
{
letter.Id = id;
}
}
if (letter == null)
{
continue;
}
letter.Description = tdNode[1].InnerText;
letter.Picture = tdNode[2].FirstChild.GetAttributeValue("href", "");
int intState;
if (int.TryParse(tdNode[3].InnerText, out intState))
{
letter.State = intState;
}
var dbLetter = this.newsletterDal.GetById(letter.Id);
if (dbLetter == null)
{
this.newsletterDal.InsertNewsletter(letter);
continue;
}
dbLetter.Description = letter.Description;
dbLetter.Picture = letter.Picture;
dbLetter.State = letter.State;
dbLetter.ModifyTime = DateTime.Now;
this.newsletterDal.UpdateNewsletter(dbLetter);
}
}
