private void Button_Click(object sender, RoutedEventArgs e)
{
if (TextContent.Text == "")
{
return;
}
else
{
var newEnter = new JournalEntryViewModel() { Content = TextContent.Text, Date = DateTime.Now };
newEnter.Id = newEnter.GetNewJournalEntryId();
newEnter.SaveJournalEntry(newEnter);
journalEntrys.Add(newEnter);
TextContent.Text = "";
}
}
public ObservableCollection<JournalEntryViewModel> GetJournalEntrys()
{
_journalEntrys = new ObservableCollection<JournalEntryViewModel>();
using (var db = new SQLite.SQLiteConnection(app.DBPath))
{
var jes = db.Table<JournalEntry>().Select(x => x);
foreach(var item in jes)
{
var something = new JournalEntryViewModel();
something.Id = item.Id;
something.Title = item.Title;
something.Content = item.Content;
something.Date = item.date;
_journalEntrys.Add(something);
}
}
return _journalEntrys;
}
public JournalEntryViewModel GetJournalEntry(int journalEntryId)
{
var journalEntry = new JournalEntryViewModel();
using (var db = new SQLite.SQLiteConnection(app.DBPath))
{
var je = db.Table<JournalEntry>().FirstOrDefault(x => x.Id == journalEntryId);
journalEntry.Id = je.Id;
journalEntry.Content = je.Content;
journalEntry.Date = je.date;
journalEntry.Title = je.Title;
}
return journalEntry;
}
public string SaveJournalEntry(JournalEntryViewModel journalEntry)
{
string result = string.Empty;
using (var db = new SQLite.SQLiteConnection(app.DBPath))
{
string change = string.Empty;
try
{
var existingJournalEntry = (db.Table<JournalEntry>().Where(
c => c.Id == journalEntry.Id)).SingleOrDefault();
if (existingJournalEntry != null)
{
existingJournalEntry.Title = journalEntry.Title;
existingJournalEntry.Content = journalEntry.Content;
int success = db.Update(existingJournalEntry);
}
else
{
int success = db.Insert(new JournalEntry()
{
Id = journalEntry.Id,
Title = journalEntry.Title,
Content = journalEntry.Content,
});
}
result = "Success";
}
catch (Exception ex)
{
result = "This customer was not saved.";
}
}
return result;
}
