async public Task <ObservableCollection <ViewItemDb> > Get(string IN_TimeStamp)
{
_Open();
var tmpResult = new ObservableCollection <ViewItemDb>();
var tmpMainTable = new SqliteCommand();
tmpMainTable.Connection = _connection;
var tmpTimeStamp = new SqliteParameter("@TimeStamp", IN_TimeStamp);
tmpMainTable.CommandText = "SELECT * FROM MainTable WHERE TimeStamp LIKE '%'||@TimeStamp||'%';";
SqliteParameter[] tmpRateCardTableColumns = { tmpTimeStamp };
tmpMainTable.Parameters.AddRange(tmpRateCardTableColumns);
var tmpDataReader = await tmpMainTable.ExecuteReaderAsync();
while (tmpDataReader.Read())
{
var tmpCurrentViewItemDb = new ViewItemDb();
tmpCurrentViewItemDb.Id = tmpDataReader.GetInt32(0);
tmpCurrentViewItemDb.Name = tmpDataReader.GetString(1);
tmpCurrentViewItemDb.TimeStamp = tmpDataReader.GetString(2);
tmpResult.Add(tmpCurrentViewItemDb);
}
_Close();
return(tmpResult);
}
private void GridView_ItemClick(object sender, ItemClickEventArgs e)
{
var tmpSelectedSeries = (ViewItem)e.ClickedItem;
var tmpViewItemDb = new ViewItemDb();
tmpViewItemDb.TimeStamp = tmpSelectedSeries.Name;
Frame.Navigate(typeof(SeriesView), tmpViewItemDb);
}
async public Task <ObservableCollection <ViewItemDb> > Get()
{
_Open();
var tmpResult = new ObservableCollection <ViewItemDb>();
var tmpMainTable = new SqliteCommand();
tmpMainTable.Connection = _connection;
tmpMainTable.CommandText = "SELECT * FROM MainTable WHERE";
var tmpDataReader = await tmpMainTable.ExecuteReaderAsync();
while (tmpDataReader.Read())
{
var tmpCurrentViewItemDb = new ViewItemDb();
tmpCurrentViewItemDb.Id = tmpDataReader.GetInt32(0);
tmpCurrentViewItemDb.Name = tmpDataReader.GetString(1);
tmpCurrentViewItemDb.TimeStamp = tmpDataReader.GetString(2);
tmpResult.Add(tmpCurrentViewItemDb);
}
_Close();
return(tmpResult);
}
