private static void RunSynchAnime()
{
var dbControl = new DatabaseControl();
var animeElements = GetElements("http://myanimelist.net/malappinfo.php?u=CWarlord87&status=all&type=anime");
foreach (var anime in animeElements)
{
var myanimeObject = new MyAnime();
var status = anime.Element("my_status").Value;
var episodes = Convert.ToInt32(anime.Element("my_watched_episodes").Value);
var score = Convert.ToInt32(anime.Element("my_score").Value);
var animeId = Convert.ToInt32(anime.Element("series_animedb_id").Value);
AnimeFunction(animeId, dbControl);
if (dbControl.AnimeExists(animeId, true))
{
myanimeObject.AnimeID = animeId;
myanimeObject.WatchedEpisodes = episodes;
myanimeObject.Score = score;
myanimeObject.Status = status;
dbControl.InsertAnime(myanimeObject);
}
else
{
var myanime = dbControl.GetMyAnimeById(animeId);
var myStatus = myanime.GetStatus(status);
//change to just update specific items
if (Convert.ToInt32(myanime.Status) != myanime.GetStatus(status) ||
score != Convert.ToInt32(myanime.Score) || episodes != Convert.ToInt32(myanime.WatchedEpisodes))
{
dbControl.UpdateAnime(animeId, score, episodes, myStatus);
}
}
}
}
public void InsertAnime(MyAnime myAnime)
{
_connection.Execute("InsertMyAnime", myAnime, commandType: CommandType.StoredProcedure);
}
