Chimney.Shared.UserControls.ChimneyServerUserControl.chimneyMpdServer_OnListPlaylist C# (CSharp) Method

        async void chimneyMpdServer_OnListPlaylist(object sender, ResponseEventArgs e)
        {
            bool suc = false;

            string playlistName = string.Empty;

            string response = string.Empty;

            if (e.arguments.Count > 0)
            {
                playlistName = e.arguments[0];
            }

            var playlistToList = await Dbconnection.FindAsync<Playlist>(o => o.Name == playlistName);

            if (playlistToList != null)
            {
                var playlistsItems = await Dbconnection.QueryAsync<PlaylistFile>("SELECT * FROM PlaylistFiles WHERE PlaylistId = " + playlistToList.PlaylistId + " ORDER BY Position");

                foreach (PlaylistFile playlistItem in playlistsItems)
                {
                    if (playlistItem.IsUri)
                    {
                        response += "file: " + playlistItem.Uri + "\n";
                        response += "Pos: " + playlistItem.Position + "\n";
                    }
                    else
                    {
                        var file = await Dbconnection.FindAsync<File>(o => o.FileId == playlistItem.FileId);

                        if (file != null)
                        {
                            response += file.ToSmallResponseString();
                        }
                    }

                }
            }

            chimneyMpdServer.AppendResponse(response, e.id, e.position);

        }