static void Main(string[] args) { AlbumMusic a = new AlbumMusic() { NameAlmum = "ss" }; Music m = new Music() { MusicAddress = "dd", MusicName = "aa", }; Singer s = new Singer() { SignerName = "bb" }; uowPleerMusic pm = new uowPleerMusic(); pm.pMusic.Insert(m); pm.pAlbumMusic.Insert(a); pm.pSinger.Insert(s); pm.Save(); }
public async static Task DeleteAddressesFromDb() { await Task.Run(() => { using (uowPleerMusic db = new uowPleerMusic()) { foreach (var item in db.pMusic.GetAll()) { if (!File.Exists(item.MusicAddress)) { db.pMusic.Delete(item); } } db.Save(); } }); }
private async static Task <List <vmMusic> > GetDateFromDb(string where = null) { return(await Task <List <vmMusic> > .Run(() => { using (uowPleerMusic db = new uowPleerMusic()) { List <vmMusic> musics = db.pMusic.GetAll().ToList() .Select( m => new vmMusic { AlbumThisMusic = ((AlbumMusic)(db.pMusic.GetAll(m1 => m1.MusicID == m.MusicID, "AlbumThisMusic"))?.FirstOrDefault().AlbumThisMusic).NameAlmum, MusicAddress = m.MusicAddress, MusicName = m.MusicName, SingerThisMusic = (mergeNameSinger((List <Singer>)(db.pMusic.GetAll(m1 => m.MusicID == m1.MusicID, "SingerThisMusic")).FirstOrDefault().SingerThisMusic)).ToString(), MusicID = m.MusicID }).ToList(); return musics; } })); }
public static async Task <List <(Music music, AlbumMusic album, Singer singer)> > ToClass(List <string> listAddress) { using (uowPleerMusic db = new uowPleerMusic()) { foreach (var item in db.pMusic.GetAll().ToList()) { listAddress.Remove(item.MusicAddress.ToString()); if (listAddress.Count == 0) { return(null); } } } List <(Music music, AlbumMusic album, Singer singer)> lsitClass = new List <(Music music, AlbumMusic album, Singer singer)>(); await Task.Run(() => { foreach (string addres in listAddress) { try { using (TagLib.File file = TagLib.File.Create(addres)) { string name = ""; using (OpenFileDialog openFile = new OpenFileDialog()) { openFile.FileName = addres; int extensionLength = System.IO.Path.GetExtension(addres).Length; name = openFile.SafeFileName.Remove(openFile.SafeFileName.Length - extensionLength); } Music music = new Music(); music.MusicAddress = addres; music.MusicName = (file.Tag.Title == null) ? name : file.Tag.Title; AlbumMusic albumMusic = new AlbumMusic(); albumMusic.NameAlmum = (file.Tag.Album == null) ? "Singel" : file.Tag.Album; Singer singer = new Singer(); List <Singer> singers = new List <Singer>(); music.AlbumThisMusic = albumMusic; albumMusic.SingersThisAlbum = music.SingerThisMusic = singers; singer.MusicsThisMusic = albumMusic.MusicOfThisAlbum = new List <Music>(); singer.AlbumsThisSinger = new List <AlbumMusic>(); albumMusic.MusicOfThisAlbum.Add(music); foreach (var item in file.Tag.Artists.ToList()) { singer.SignerName = item; singer.AlbumsThisSinger.Add(albumMusic); singer.MusicsThisMusic.Add(music); singers.Add(singer); } (Music music, AlbumMusic album, Singer singer)tupl = (music, albumMusic, singer); lsitClass.Add(tupl); } } catch { } } }); return(lsitClass); }