public void onDeleteBtnClicked(object sender, RoutedEventArgs e)
{
Button deleteBtn = (Button)sender;
AccountTitle accountTitle = (AccountTitle)deleteBtn.DataContext;
this.sqLiteDbHelper.delete(accountTitle.id, this.userId);
this.showAllAccounts();
}
public void onEditBtnClicked(object sender, RoutedEventArgs e)
{
Button editBtn = (Button)sender;
AccountTitle accountTitle = (AccountTitle)editBtn.DataContext;
AccountDetailsWindow accountDetailsWindow = new AccountDetailsWindow(AccountDetailsWindow.State.Edit, accountTitle.id, this.userId);
accountDetailsWindow.Closed += this.onAccountDetailsWindowClosed;
accountDetailsWindow.Show();
}
public List <AccountTitle> selectTitles(long userId)
{
this.dbConnection.Open();
SQLiteCommand command = new SQLiteCommand(this.select_titles, dbConnection);
command.Parameters.Add(new SQLiteParameter("@user_id", userId));
SQLiteDataReader reader = command.ExecuteReader();
List <AccountTitle> accountTitles = new List <AccountTitle>();
while (reader.Read())
{
AccountTitle accountTitle = new AccountTitle((long)reader["id"], (String)reader["title"]);
accountTitles.Add(accountTitle);
}
this.dbConnection.Close();
return(accountTitles);
}
