public async void update()
{
SQLiteAsyncConnection connection = new SQLiteAsyncConnection("Test.db");
await connection.ExecuteAsync("UPDATE Employee SET Skill=\"" + Skill + "\" WHERE BadgeId=\"" + BadgeId+"\"");
var addmsg = new MessageDialog("Your SkillSet has been updated!");
await addmsg.ShowAsync();
}
/// <summary>
/// Initialise the Database connection and creates tables/default values if not existant.
/// </summary>
private async void ConnectionInit()
{
//Connection init
var dbPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
Database = new SQLite.SQLiteAsyncConnection(dbPath);
//Create tables if not exists
await Database.CreateTablesAsync(new Account().GetType(), new DatabaseRoute().GetType(), new DatabasePOI().GetType());
await Database.ExecuteAsync("create table if not exists \"RouteBinds\"(\"RouteID\" integer,\"WaypointID\" integer);", new object[] { });
//Set default Admin Admin password
var result = await Database.ExecuteScalarAsync<String>("Select Gebruikersnaam From Account WHERE Gebruikersnaam = ? AND Password = ?", new object[] { "Admin", "Admin" });
if(result == null)
await Database.InsertAsync(new Account("Admin", "Admin"));
}
public async Task Clear()
{
var connection = new SQLiteAsyncConnection(DbPath);
await connection.ExecuteAsync("DELETE FROM TracklistItem");
}
public Task Remove(int trackId, int trackCollectionId)
{
var connection = new SQLiteAsyncConnection(DbPath);
return connection.ExecuteAsync("DELETE FROM TracklistItem WHERE TrackCollectionId=? AND TrackId=?;", trackCollectionId, trackId);
}
/// <summary>
/// Method to create tables into database.
/// </summary>
/// <param name="db">Database connection for async calls.</param>
/// <returns><see cref="Task"/></returns>
protected async Task CreateTables(SQLiteAsyncConnection db)
{
await Task.Run(async () =>
{
///Tables:
await db.CreateTableAsync<Zip>();
await db.ExecuteAsync(string.Format("PRAGMA user_version = {0};", CURRENT_DB_VERSION));
});
}
public Task RemoveLocation(MapLocationModel mapLocation)
{
SQLiteAsyncConnection connection = new SQLiteAsyncConnection(SQLiteConfiguration.ConnectionString);
_locations.Remove(mapLocation);
connection.ExecuteAsync("DELETE FROM MapLocationFolders WHERE MapLocationId = ?", mapLocation.ID);
return connection.DeleteAsync(mapLocation);
}
public Task RemoveLocationFolders(List<MapLocationFolderModel> locationFolders)
{
string query = "DELETE FROM MapLocationFolders WHERE ID IN (" +
locationFolders.Aggregate(string.Empty, (current, next) =>
{
_locationFolders.Remove(next);
return current + "'" + next.ID + "',";
}).TrimEnd(',') + ")";
SQLiteAsyncConnection connection = new SQLiteAsyncConnection(SQLiteConfiguration.ConnectionString);
return connection.ExecuteAsync(query);
}
