public static void Import(string RootDir) { DirectoryInfo DI = new DirectoryInfo(RootDir); FileInfo[] D = DI.GetFiles("*.mp3"); foreach(FileInfo X in D){ try{ id3.MP3 Dw = new id3.MP3(X.DirectoryName,X.Name); id3.FileCommands.readMP3Tag(ref Dw); SQLiteConnection CP = MainForm.MakeConnection(); CP.Open(); String P = "INSERT INTO song(name,artist,album,path) VALUES (\""+Dw.id3Title.Replace("\0","")+"\" ,'"+Dw.id3Artist.Replace("\0","")+"','"+Dw.id3Album.Replace("\0","")+"','mp3:"+X.FullName+"')"; SQLiteCommand C = new SQLiteCommand(P,CP); C.ExecuteNonQuery(); CP.Close(); }catch(Exception e){ } } DirectoryInfo[] Directories = DI.GetDirectories(); foreach(DirectoryInfo R in Directories){ Import(R.FullName); } }
public void ImportData(SQLiteConnection Conn,string RootDir) { DirectoryInfo DI = new DirectoryInfo(RootDir); FileInfo[] D = DI.GetFiles("*.mp3"); foreach(FileInfo X in D){ try{ id3.MP3 Dw = new id3.MP3(X.DirectoryName,X.Name); id3.FileCommands.readMP3Tag(ref Dw); SQLiteConnection CP = Conn; CP.Open(); String P = "INSERT INTO song(name,artist,album,path,no,composer,store,engine) VALUES (\""+Dw.id3Title.Replace("\0","").Replace("\"","'")+"\" ,\""+Dw.id3Artist.Replace("\0","").Replace("\"","'")+"\",\""+Dw.id3Album.Replace("\0","").Replace("\"","'")+"\",\"mp3:"+X.FullName+"\","+Dw.id3TrackNumber+",\"Other\",\"Local Files\",\"mp3\")"; SQLiteCommand C = new SQLiteCommand(P,CP); C.ExecuteNonQuery(); FilesCompleted++; CP.Close(); }catch(Exception e){ System.Windows.Forms.MessageBox.Show(e.Message); } } DirectoryInfo[] Directories = DI.GetDirectories(); foreach(DirectoryInfo R in Directories){ ImportData(Conn,R.FullName); } }
void FX_DownloadFileCompleted(object sender, AsyncCompletedEventArgs e) { try { id3.MP3 D; try { D = new id3.MP3(Folder,FileName); id3.FileCommands.readMP3Tag(ref D); File.Move(Folder+"\\"+FileName,Folder+"\\"+FileName+".mp3"); FileName=FileName+"mp3"; SQLiteConnection CP = MainForm.MakeConnection(); CP.Open(); String P = "INSERT INTO song(name,artist,album,path) VALUES (\""+D.id3Title.Replace("\0","")+"\" ,'"+D.id3Artist.Replace("\0","")+"','"+D.id3Album.Replace("\0","")+"','"+PartFile+"')"; SQLiteCommand C = new SQLiteCommand(P,CP); C.ExecuteNonQuery(); String Ps = "INSERT INTO purchase(song_id,store) VALUES(last_insert_rowid(),'"+Store+"')"; C = new SQLiteCommand(Ps,CP); C.ExecuteNonQuery(); CP.Close(); } catch { id3.FileCommands.oFileStream.Close(); String FileFolder=FileName.Replace(".zip",""); if(!Directory.Exists(Folder+"\\"+FileFolder.Replace("%20"," "))) { Directory.CreateDirectory(Folder+"\\"+FileFolder.Replace("%20"," ")); } String DS = MainForm.GetAppPath()+"unzip"; Process sD = new Process(); sD.Exited+= new EventHandler(D_Exited); ProcessStartInfo XP = new ProcessStartInfo(); sD.StartInfo= XP; XP.CreateNoWindow=false; XP.UseShellExecute=false; sD.EnableRaisingEvents=true; XP.FileName=(DS); XP.Arguments =(" \""+Folder+"\\"+FileName+"\" -d \""+Folder+"\\"+FileName.Replace(".zip","")+"\""); sD.Start(); } } catch(Exception ex) { MessageBox.Show(ex.Message); } }