public static List <CurrencyRow> Get_currencies(string file_path)
{
SQLiteConnection connection = new SQLiteConnection(string.Format("DataSource={0}", file_path));
connection.Open();
SQLiteCommand command = new SQLiteCommand(connection)
{
CommandText = "SELECT * FROM currencies"
};
SQLiteDataReader results_reader = command.ExecuteReader();
List <CurrencyRow> rows = new List <CurrencyRow>();
while (results_reader.Read())
{
CurrencyRow row = new CurrencyRow
{
Id = Convert.ToInt32(results_reader["id"]),
Currency_name = Convert.ToString(results_reader["currency"]),
Vs_usd_rate = Convert.ToDouble(results_reader["vs_usd_rate"])
};
rows.Add(row);
}
results_reader.Close();
connection.Close();
return(rows);
}
private void Currency_selected(object sender, RoutedEventArgs e)
{
int selected_row_index = SelectCurrencyDataGrid.SelectedIndex;
if (selected_row_index != -1)
{
this.selected_row = this.datagrid_rows[selected_row_index];
this.selected = true;
this.Close();
}
}