public static void UpdateFeedReads(NewsFeed feed)
{
if (feed.FirstRead)
{
throw new InvalidOperationException("Нельзя обновить новый фид с FirstRead = true");
}
QSMain.CheckConnectionAlive();
logger.Info("Обновляем прочитанные новости...");
string sql = "UPDATE read_news SET items = @items WHERE id = @id";
DbCommand cmd = QSMain.ConnectionDB.CreateCommand();
cmd.CommandText = sql;
DbParameter param = cmd.CreateParameter();
param.ParameterName = "@id";
param.Value = feed.DataBaseId;
cmd.Parameters.Add(param);
param = cmd.CreateParameter();
param.ParameterName = "@items";
param.Value = String.Join(",", feed.ReadItems);
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery();
logger.Info("Ok");
}
public static bool ItemIsRead(SyndicationItem synitem)
{
NewsFeed feed = NewsFeeds.Find(f => f.Id == synitem.SourceFeed.Id);
if (feed.FirstRead)
{
feed.ReadItems.Add(synitem.Id);
return(true);
}
return(feed.ReadItems.Exists(i => i == synitem.Id));
}
public static void LoadReadFeed()
{
logger.Info("Получаем таблицу прочитанных пользователем новостей...");
if (NewsFeeds == null)
{
NewsFeeds = new List <NewsFeed> ();
}
string sql = "SELECT * FROM `read_news` WHERE user_id = @user_id";
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);
using (DbDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
NewsFeed feed = NewsFeeds.Find(f => f.Id == DBWorks.GetString(rdr, "feed_id", ""));
if (feed != null)
{
feed.FirstRead = false;
feed.DataBaseId = DBWorks.GetInt(rdr, "id", -1);
string[] items = DBWorks.GetString(rdr, "items", "").Split(',');
feed.ReadItems = new List <string> (items);
}
else
{
logger.Warn("В базе найден feed_id={0}, но в программе он не настроен.", DBWorks.GetString(rdr, "feed_id", ""));
}
}
}
logger.Info("Ok");
}
public static void UpdateFeedReads(NewsFeed feed)
{
if (!NewsReadExist)
return;
if (feed.FirstRead)
throw new InvalidOperationException ("Нельзя обновить новый фид с FirstRead = true");
QSMain.CheckConnectionAlive();
logger.Info ("Обновляем прочитанные новости...");
string sql = "UPDATE read_news SET items = @items WHERE id = @id";
DbCommand cmd = QSMain.ConnectionDB.CreateCommand();
cmd.CommandText = sql;
DbParameter param = cmd.CreateParameter();
param.ParameterName = "@id";
param.Value = feed.DataBaseId;
cmd.Parameters.Add(param);
param = cmd.CreateParameter();
param.ParameterName = "@items";
param.Value = String.Join (",", feed.ReadItems);
cmd.Parameters.Add(param);
cmd.ExecuteNonQuery ();
logger.Info ("Ok");
}