public bool RemoveAlbum(Album album)
{
SqliteCommand cmd = new SqliteCommand ();
cmd.Connection = conn;
cmd.CommandText = String.Format ("REMOVE FROM albums WHERE id = {0}", album.GetHashCode ());
int res = cmd.ExecuteNonQuery ();
if (res > 0)
return true;
return false;
}
public bool AddAlbum(Album album)
{
string songs = ArrayToSqlString (album.Songs);
string artists = ArrayToSqlString (album.Artists);
string performers = ArrayToSqlString (album.Performers);
SqliteCommand cmd = new SqliteCommand ();
cmd.Connection = conn;
cmd.CommandText = String.Format ("INSERT INTO albums (id, name, songs, artists, performers, year) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}')",
album.GetHashCode (),
album.Name,
songs,
artists,
performers,
album.Year);
int res = cmd.ExecuteNonQuery ();
if (res > 0)
return true;
return false;
}
