Exemplo n.º 1
0
        public static void ImportSingleMP3IntoDB(string path)
        {
            TagLib.File f = TagLib.File.Create(path);

            //checken of artist al in db zit, zoja artist ophalen; zo nee, nieuwe aanmaken
            Artist ar = null;
            if (!string.IsNullOrEmpty(f.Tag.FirstAlbumArtist))
                ar = ArtistDA.GetArtistByName(f.Tag.FirstAlbumArtist);
            else
            {
                ar = (f.Tag.Artists.Length > 0) ? (ArtistDA.GetArtistByName(f.Tag.Artists[0])):(null);
            }

            if (ar == null)
            {
                if (!string.IsNullOrEmpty(f.Tag.FirstAlbumArtist))
                    ar = new Artist(f.Tag.FirstAlbumArtist);
                else if (f.Tag.Artists.Length > 0)
                    ar = new Artist(f.Tag.Artists[0]);
                else
                    ar = new Artist("Andere");

                ar.ID = ArtistDA.InsertArtist(ar);
                Console.WriteLine("DB: created new Artist - " + ar.ArtistName);
            }

            //checken of de album al in db zit aan de hand van albumnaam en artist id, zoja, album ophalen. Zo nee, nieuwe aanmaken
            Album al =null;
            if (!string.IsNullOrEmpty(f.Tag.Album))
                al = AlbumDA.GetAlbumByArtistIDAndAlbumName(ar.ID, f.Tag.Album);
            if(al == null)
            {
                string albumname = (!String.IsNullOrEmpty(f.Tag.Album)) ? (f.Tag.Album) : ("Andere");
                al = new Album(albumname, ar.ID);
                al.ID = AlbumDA.InsertAlbum(al);
                Console.WriteLine("DB: created new Album - " + al.Name);
            }

            //checken of da et liedje al in de database zit adhb artist / album id en songname, anders in db steken
            Song s = SongDA.GetSongByArtistAlbumSong(ar.ID, al.ID, f.Tag.Title);
            if (s==null)
            {
                s = new Song();
                s.AlbumID = al.ID;
                s.ArtistID = ar.ID;
                s.SongName = f.Tag.Title;
                s.Track = (int)f.Tag.Track;

                ShellFile so = ShellFile.FromFilePath(path);
                double nanoseconds;
                double.TryParse(so.Properties.System.Media.Duration.Value.ToString(),
                out nanoseconds);
                s.SongLength = (int)Math.Round((nanoseconds / 10000000), 0);
                s.PlayedAmmount = 0;
                s.FilePath = path;
                int songID = SongDA.InsertSong(s);
                s.ID = songID;
                Console.WriteLine("DB: created new Song - " + s.SongName);
            }
        }
Exemplo n.º 2
0
 public static int DeleteSongByID(Song a)
 {
     //ook albums and songs implementeren
     string sql = "DELETE FROM song WHERE ID=@ID";
     DbParameter parID = Database.AddParameter(Database.DBNAME, "@ID", a.ID);
     return Database.ModifyData(Database.GetConnection(Database.DBNAME), sql, parID);
 }
Exemplo n.º 3
0
 public MP3Tag(Artist ar, Album al, Song s)
 {
     this.Artist = ar;
     this.Album = al;
     this.Song = s;
 }
Exemplo n.º 4
0
 public static int UpdateSong(Song s)
 {
     string sql = "UPDATE song SET AlbumID=@AlbumID, ArtistID=@ArtistID, Song=@Name, Track=@Track, Length=@Length, Played=@Played, Path=@Path where ID=@ID;";
     DbParameter parID = Database.AddParameter(Database.DBNAME, "@ID", s.ID);
     DbParameter parAlbum = Database.AddParameter(Database.DBNAME, "@AlbumID", s.AlbumID);
     DbParameter parArtist = Database.AddParameter(Database.DBNAME, "@ArtistID", s.ArtistID);
     DbParameter parName = Database.AddParameter(Database.DBNAME, "@Name", s.SongName);
     DbParameter parTrack = Database.AddParameter(Database.DBNAME, "@Track", s.Track);
     DbParameter parLength = Database.AddParameter(Database.DBNAME, "@Length", s.SongLength);
     DbParameter parPlayed = Database.AddParameter(Database.DBNAME, "@Played", s.PlayedAmmount);
     DbParameter parFile = Database.AddParameter(Database.DBNAME, "@Path", s.FilePath);
     return Database.ModifyData(Database.GetConnection(Database.DBNAME), sql, parID, parAlbum, parArtist, parName, parTrack, parLength, parPlayed, parFile);
 }
Exemplo n.º 5
0
 public static int InsertSong(Song s)
 {
     string sql = "INSERT INTO song(AlbumID,ArtistID,Song,Track,Length,Played,Path) VALUES(@AlbumID,@ArtistID,@Name,@Track,@Length,@Played,@Path);";
     DbParameter parAlbum = Database.AddParameter(Database.DBNAME, "@AlbumID", s.AlbumID);
     DbParameter parArtist = Database.AddParameter(Database.DBNAME, "@ArtistID", s.ArtistID);
     DbParameter parName = Database.AddParameter(Database.DBNAME, "@Name", s.SongName);
     DbParameter parTrack = Database.AddParameter(Database.DBNAME, "@Track", s.Track);
     DbParameter parLength = Database.AddParameter(Database.DBNAME, "@Length", s.SongLength);
     DbParameter parPlayed = Database.AddParameter(Database.DBNAME, "@Played", s.PlayedAmmount);
     DbParameter parFile = Database.AddParameter(Database.DBNAME, "@Path", s.FilePath);
     return Database.InsertData(Database.GetConnection(Database.DBNAME), sql, parAlbum, parArtist, parName, parTrack, parLength, parPlayed, parFile);
 }