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); }