public void Load()
{
_playlists.Clear();
using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0}", TabsterDatabaseHelper.TablePlaylists), _databaseHelper.GetConnection()))
{
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = long.Parse(reader["id"].ToString());
var name = reader["name"].ToString();
var created = reader["created"].ToString();
var playlist = new TablaturePlaylist(name)
{
Id = id, Created = TabsterDatabaseHelper.UnixTimestampToDateTime(int.Parse(created))
};
_playlists.Add(playlist);
}
}
}
foreach (var playlist in _playlists)
{
using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0} WHERE playlist_id=@playlist_id", TabsterDatabaseHelper.TablePlaylistItems), _databaseHelper.GetConnection()))
{
cmd.Parameters.Add(new SQLiteParameter("@playlist_id", playlist.Id));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = long.Parse(reader["id"].ToString());
var filename = reader["filename"].ToString();
var file = _fileProcessor.Load(filename);
if (file != null)
{
var fileInfo = new FileInfo(filename);
var item = new TablaturePlaylistItem(file, fileInfo);
playlist.Add(item);
}
}
}
}
}
}
public void Load(bool useFileSystem)
{
if (useFileSystem)
{
LoadTablatureFiles();
}
else
{
using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0}", TabsterDatabaseHelper.TableLibraryItems), _databaseHelper.GetConnection()))
{
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var id = long.Parse(reader["id"].ToString());
var filename = reader["filename"].ToString();
var favorite = bool.Parse(reader["favorite"].ToString());
var views = int.Parse(reader["views"].ToString());
var rating = TablatureRatingUtilities.FromString(reader["rating"].ToString());
var file = _fileProcessor.Load(filename);
if (file != null)
{
var fileInfo = new FileInfo(filename);
var item = new TablatureLibraryItem <TablatureFile>(file, fileInfo)
{
Id = id,
Favorited = favorite,
Views = views,
Rating = rating
};
base.Add(item);
}
}
}
}
}
}
public void Load()
{
_items.Clear();
using (var cmd = new SQLiteCommand(string.Format("SELECT * FROM {0} ORDER BY id DESC", TabsterDatabaseHelper.TableRecentFiles), _databaseHelper.GetConnection()))
{
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var filename = reader["filename"].ToString();
var file = _fileProcessor.Load(filename);
if (file != null)
{
var r = new RecentFile(file, new FileInfo(filename));
_items.Add(r);
}
}
}
}
}