public ObservableCollection<DisplayResults> getPowerballRows()
{
powerballResults = new ObservableCollection<DisplayResults>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var query = db.Query<PowerBallSaved>("select * from PowerBallSaved");
foreach (var _res in query)
{
var res = new DisplayResults()
{
Id = _res.Id,
Num1 = _res.num1,
Num2 = _res.num2,
Num3 = _res.num3,
Num4 = _res.num4,
Num5 = _res.num5
};
powerballResults.Add(res);
}
}
return powerballResults;
}
public ObservableCollection<DisplayResults> getRows()
{
results = new ObservableCollection<DisplayResults>();
using (var db = new SQLite.SQLiteConnection(app.dbPath))
{
var query = db.Query<LottoSaved>("select * from LottoSaved");
foreach (var _results in query)
{
var res = new DisplayResults()
{
Id = _results.Id,
Num1 = _results.num1,
Num2 = _results.num2,
Num3 = _results.num3,
Num4 = _results.num4,
Num5 = _results.num5,
Num6 = _results.num6
};
results.Add(res);
}
}
return results;
}
