public static void SaveFirstRead()
{
if (!NewsReadExist)
return;
NewsFeeds.FindAll (f => f.FirstRead).ForEach(delegate(NewsFeed feed) {
QSMain.CheckConnectionAlive();
logger.Info ("Сохраняем новый feed({0})...", feed.Title);
string sql = "INSERT INTO read_news (user_id, feed_id, items) " +
"VALUES (@user_id, @feed_id, @items)";
DbCommand cmd = QSMain.ConnectionDB.CreateCommand();
cmd.CommandText = sql;
DbParameter param = cmd.CreateParameter();
param.ParameterName = "@user_id";
param.Value = QSMain.User.Id;
cmd.Parameters.Add(param);
param = cmd.CreateParameter();
param.ParameterName = "@feed_id";
param.Value = feed.Id;
cmd.Parameters.Add(param);
param = cmd.CreateParameter();
param.ParameterName = "@items";
param.Value = String.Join (",", feed.ReadItems);
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery ();
feed.FirstRead = false;
});
}