async void chimneyMpdServer_OnPlaylistInfo(object sender, ResponseEventArgs e)
{
var currentPlaylist = await Dbconnection.QueryAsync<CurrentPlaylist>("SELECT * FROM CurrentPlaylist ORDER BY PositionId");
string response = string.Empty;
foreach(CurrentPlaylist cp in currentPlaylist)
{
if (cp.IsUri)
{
response += "file: " + cp.Uri + "\n";
response += "Pos: " + cp.PositionId + "\n";
}
else
{
var file = await Dbconnection.FindAsync<File>(o => o.FileId == cp.FileId);
if (file != null)
{
file.Pos = cp.PositionId;
await Dbconnection.UpdateAsync(file);
response += file.ToResponseString();
}
}
}
chimneyMpdServer.AppendResponse(response, e.id, e.position);
}