public async static void RemoveData(HistoryClass id)
{
await Task.Run(() =>
{
string dbpath = Path.Combine(ApplicationData.Current.LocalFolder.Path, "sqliteHistory.db");
using (SqliteConnection db =
new SqliteConnection($"Filename={dbpath}"))
{
db.Open();
SqliteCommand DeleteCommand = new SqliteCommand();
DeleteCommand.Connection = db;
// Use parameterized query to prevent SQL injection attacks
DeleteCommand.CommandText = "DELETE FROM MyTable WHERE ID = '" + id.IdSQL + "'";
DeleteCommand.ExecuteNonQuery();
// = "INSERT INTO MyTable(Col1, Col2) VALUES('Test Text ', 1); ";
// DeleteCommand.Parameters.Remove(id.HeaderSQL);
// DeleteCommand.ExecuteReader();
db.Close();
}
});
}
private List <HistoryClass> thelist()
{
List <HistoryClass> ret = new List <HistoryClass>();
FileStream fs = new FileStream("HistoryFile.txt", FileMode.OpenOrCreate);
StreamReader sr = new StreamReader(fs);
string[] args = new string[6];
while (sr.Peek() != -1)
{
for (int i = 0; i < 6; i++)
{
args[i] = sr.ReadLine();
}
HistoryClass temp = new HistoryClass()
{
Algorithm_Name = args[0],
NumberOfAudios = args[1],
SecondsPerFolder = args[2],
NumberOfFolders = args[3],
ExecutionTime = args[4],
Date = args[5]
};
ret.Add(temp);
}
ret.Reverse();
return(ret);
}
private async void RemoveDataButton_Click(object sender, RoutedEventArgs e)
{
var ide = (FrameworkElement)sender;
var dataCxtx = ide.DataContext;
HistoryClass dataSauce = (HistoryClass)dataCxtx;
DataAccess.RemoveData(dataSauce);
await Task.Delay(500);
Output.ItemsSource = await GetData();
}
private void Output_ItemClick(object sender, ItemClickEventArgs e)
{
HistoryClass Historyitemclicked = e.ClickedItem as HistoryClass;
WebViewPage.WebviewControl.Navigate(new Uri(Historyitemclicked.UrlSQL));
}
