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