public void UpdateMessageItem(Models.MessageItem OriginMessage, Models.MessageItem UpdateInfo)
{
int index = this.allItems.IndexOf(OriginMessage);
if (index >= 0 && index < this.allItems.Count)
{
this.allItems[index] = UpdateInfo;
}
}
public void DeleteFavorite(Models.MessageItem msg)
{
string sql = "DELETE FROM Favorite WHERE guid = ?";
using (var statement = conn.Prepare(sql))
{
statement.Bind(1, msg.guid);
statement.Step();
}
}
/// <summary>
/// 查询该用户的该收藏是否存在
/// </summary>
public bool IsFavoriteExist(Models.MessageItem msg)
{
string sql = "SELECT * FROM Favorite WHERE guid = ? AND Username = ?";
using (var statement = conn.Prepare(sql))
{
statement.Bind(1, msg.guid);
statement.Bind(2, Username);
if (statement.Step() == SQLiteResult.ROW)
{
return(true);
}
return(false);
}
}
public bool AddFavorite(Models.MessageItem msg)
{
if (IsFavoriteExist(msg))
{
return(false);
}
else
{
string sql = "INSERT INTO Favorite (Username, Title, FeedType, Author, Guid, PublishDate) "
+ "VALUES (?, ?, ?, ?, ?, ?)";
using (var statement = conn.Prepare(sql))
{
statement.Bind(1, GetUsername());
statement.Bind(2, msg.title);
statement.Bind(3, msg.feedType);
statement.Bind(4, msg.author);
statement.Bind(5, msg.guid);
statement.Bind(6, msg.publishDate.ToString());
statement.Step();
}
return(true);
}
}
public void AddTodoItem(Models.MessageItem message)
{
this.allItems.Add(message);
}
