private async void Load()
{
var html = await GetPage(@"http://nnmclub.to/forum/portal.php?c=1&start=" + 20 *currentPage);
var refs = html.DocumentNode.SelectNodes("//table[contains(@class, \"pline\")]//td[contains(@class, \"pcatHead\")]//a[contains(concat(\" \", normalize-space(@class), \" \"), \" pgenmed \")]");
items.Clear();
using (var db = new LiteDatabase(@"C:\Users\User\YandexDisk\anime-list.litedb"))
{
var col = db.GetCollection <AnimeInfo>("anime");
foreach (var rf in refs)
{
if (!rf.InnerText.Equals("Популярные раздачи"))
{
var dbref = col.FindOne(x => x.Topic == rf.InnerText);
if (dbref != null)
{
items.Add(dbref);
}
else
{
var item = new AnimeInfo {
Topic = rf.InnerText
};
col.Insert(item);
items.Add(item);
}
}
}
}
return;
}
private void TopicGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
AnimeInfo anime = (AnimeInfo)e.Row.Item;
Console.WriteLine(anime.Episodes);
Console.WriteLine(e.Column.Header);
TextBox text = (TextBox)e.EditingElement;
Console.WriteLine(text.Text);
if (String.Equals(e.Column.Header, "EngTitle"))
{
anime.EngTitle = text.Text;
}
if (String.Equals(e.Column.Header, "RusTitle"))
{
anime.RusTitle = text.Text;
}
if (String.Equals(e.Column.Header, "Year"))
{
anime.Year = int.Parse(text.Text);
}
if (String.Equals(e.Column.Header, "Episodes"))
{
anime.Episodes = int.Parse(text.Text);
}
if (String.Equals(e.Column.Header, "Topic"))
{
return;
}
if (String.Equals(e.Column.Header, "ID"))
{
return;
}
using (var db = new LiteDatabase(@"C:\Users\User\YandexDisk\anime-list.litedb"))
{
var col = db.GetCollection <AnimeInfo>("anime");
col.Update(anime);
}
}