void Save()
{
SuccessfulUtil util = new SuccessfulUtil();
var hrefs = SqliteHelper.Select <Hrefs>();
foreach (var entity in hrefs)
{
var art = util.GetArticleByUrl(entity.ArticleHref);
SqliteHelper.Insert(art);
}
}
private void SaveToDB(string relativePath, string resourceName)
{
string sql = string.Format("select * from Subscription where ResourceName='{0}'", resourceName);
if (SqliteHelper.Exists(sql))
{
return;
}
var entity = new Subscription
{
ColumnName = relativePath.Split('/')[3],
RelativePath = relativePath,
Category = "Get",
ResourceName = resourceName
};
SqliteHelper.Insert(entity);
}