async Task<int> GetAlbumId(string name)
{
int id = -1;
while (id < 0)
{
if (string.IsNullOrEmpty(name)) name = string.Empty;
var album = await Dbconnection.QueryAsync<Album>("SELECT * FROM Albums WHERE Name = \"" + name + "\"");
if (album.Count > 0)
{
id = album.First<Album>().AlbumId;
}
else
{
Album newAlbum = new Album()
{
Name = name
};
await Dbconnection.InsertAsync(newAlbum);
}
}
return id;
}