public void UpdateDiaryitem(string id, string DiaryContent, string food, DateTime date, BitmapImage image, int emojiindex) { foreach (Models.Diaryitem cache in allItems) { if (cache.Id == id) { seletedItem = cache; break; } } seletedItem.DiaryContent = DiaryContent; seletedItem.food = food; seletedItem.date = date; seletedItem.image = image; seletedItem.emojiindex = emojiindex; using (var statement = _connection.Prepare(SQL_UPDATE)) { statement.Bind(1, DiaryContent); statement.Bind(2, food); statement.Bind(3, date.ToString()); statement.Bind(4, image.UriSource.ToString()); statement.Bind(5, emojiindex.ToString()); statement.Bind(6, id); statement.Step(); } seletedItem = null; }
public void SeleteDiaryitem(string id) { foreach (Models.Diaryitem cache in allItems) { if (cache.Id == id) { seletedItem = cache; break; } } }
public void AddDiaryitem(string DiaryContent, string food, DateTime date, BitmapImage image, int emojiindex) { this.allItems.Add(new Diaryitem(DiaryContent, food, date, image, emojiindex)); Diaryitem temp = this.allItems.Last(); using (var statement = _connection.Prepare(SQL_INSERT)) { statement.Bind(1, temp.Id); statement.Bind(2, temp.DiaryContent); statement.Bind(3, temp.food); statement.Bind(4, temp.date.ToString()); statement.Bind(5, temp.image.UriSource.ToString()); statement.Bind(6, temp.emojiindex.ToString()); statement.Step(); } }
public void RemoveDiaryitem(string id) { foreach (Diaryitem cache in allItems) { if (cache.Id == id) { seletedItem = cache; break; } } allItems.Remove(seletedItem); using (var statement = _connection.Prepare(SQL_DELETE)) { statement.Bind(1, id); statement.Step(); } seletedItem = null; }