public static async Task <Library> FetchAllAsync()
{
Library library = new Library();
try
{
using (var _context = new MusicLibraryDbContext())
{
library.Musics = new ObservableCollection <MLMusicModel>(_context.Musics.Select(m => new MLMusicModel(m)).ToList());
library.MInP = new ObservableCollection <MLMusicInPlaylistModel>(_context.MusicInPlaylists.Select(m => new MLMusicInPlaylistModel(m)).ToList());
library.Playlists = new ObservableCollection <MLPlayListModel>(_context.Playlists.Select(p => new MLPlayListModel(p)).ToList());
library.Thumbnails = new ObservableCollection <MLThumbnailModel>(_context.Thumbnails.Select(t => new MLThumbnailModel(t)).ToList());
}
foreach (var item in library.Musics)
{
await item.GetFileAsync();
}
foreach (var item in library.Thumbnails)
{
item.GetBitmapImage();
}
return(library);
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
return(library);
}
public static IList <Playlist> FetchPlaylist()
{
using (var _context = new MusicLibraryDbContext())
{
return(_context.Playlists.Select(m => m).ToList());
}
}
public static bool PlaylistNameAvailable(string playlistName)
{
using (var _context = new MusicLibraryDbContext())
{
return(_context.Playlists.Where(p => p.Name == playlistName).FirstOrDefault() == null);
}
}
public static IList <MusicInPlaylist> FetchSongPlaylistRelationship()
{
using (var _context = new MusicLibraryDbContext())
{
return(_context.MusicInPlaylists.Select(m => m).ToList());
}
}
public static void DeletePlaylist(string playlistName)
{
using (var _context = new MusicLibraryDbContext())
{
var playlist = _context.Playlists.Where(p => p.Name == playlistName).First();
_context.Playlists.Remove(playlist);
_context.SaveChanges();
}
}
public static async Task Add(StorageFile File)
{
try
{
Debug.WriteLine(File.Name + " Music meta data start retreiving");
var thumbnail = await File.GetThumbnailAsync(ThumbnailMode.MusicView, 100, ThumbnailOptions.UseCurrentScale);
var properties = await File.Properties.GetMusicPropertiesAsync();
var path = File.Path;
var bytearray = await ConvertThumbnailToBytesAsync(thumbnail);
var artistName = properties.Artist != "" ? properties.Artist : UNKNOWN_ARTIST;
var albumArtistName = properties.AlbumArtist != "" ? properties.AlbumArtist : UNKNOWN_ARTIST;
var albumTitle = properties.Album != "" ? properties.Album : UNKNOWN_ALBUM;
var duration = properties.Duration.ToString(@"mm\:ss");
var albumYear = properties.Year != 0 ? properties.Year.ToString() : UNKNOWN_YEAR;
var songTitle = properties.Title != "" ? properties.Title : Path.GetFileNameWithoutExtension(File.Path);
using (var _context = new MusicLibraryDbContext())
{
var thumb = new Thumbnail
{
ImageBytes = bytearray,
Id = Guid.NewGuid().ToString()
};
_context.Thumbnails.Add(thumb);
_context.SaveChanges();
Debug.WriteLine("Thumbnail Done");
Music Music = new Music
{
Path = path,
Title = songTitle,
AlbumTitle = albumTitle,
Artist = artistName,
AlbumArtist = albumArtistName,
Year = albumYear,
ThumbnailId = thumb.Id,
Duration = duration,
Id = Guid.NewGuid().ToString()
};
_context.Musics.Add(Music);
_context.SaveChanges();
Debug.WriteLine("Music Done");
}
Debug.WriteLine("DataBase Succeed");
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
public static void EditPlaylistName(string oldPlaylistName, string newPlaylistName)
{
using (var _context = new MusicLibraryDbContext())
{
var playlist = _context.Playlists.Where(p => p.Name == oldPlaylistName).First();
playlist.Name = newPlaylistName;
_context.Playlists.Update(playlist);
_context.SaveChanges();
}
}
public static void RemoveSongsFromPlaylist(string playlistName, List <MLMusicModel> musics)
{
using (var _context = new MusicLibraryDbContext())
{
var playlist = _context.Playlists.Where(p => p.Name == playlistName).First();
foreach (var item in musics)
{
var mInP = _context.MusicInPlaylists.Where(m => m.PlaylistId == playlist.Id && m.MusicId == item.Id).First();
_context.MusicInPlaylists.Remove(mInP);
}
_context.SaveChanges();
}
}
public static void Initialize()
{
try
{
using (var db = new MusicLibraryDbContext())
{
db.Database.Migrate();
}
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
public static void Reset()
{
try
{
using (var _context = new MusicLibraryDbContext())
{
_context.Database.EnsureDeleted();
}
}
catch (Exception e)
{
Debug.WriteLine(e.Message);
}
}
public static Playlist CreatePlaylist(string playlistName)
{
Playlist playlist = new Playlist
{
Name = playlistName,
Id = Guid.NewGuid().ToString()
};
using (var _context = new MusicLibraryDbContext())
{
_context.Playlists.Add(playlist);
_context.SaveChanges();
}
return(playlist);
}
public static void Delete(string path)
{
try
{
using (var _context = new MusicLibraryDbContext())
{
var music = _context.Musics.Where(m => m.Path == path).First();
_context.Musics.Remove(music);
_context.SaveChanges();
}
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
public static void AddSongsToPlaylist(string playlistName, List <MLMusicModel> musics)
{
using (var _context = new MusicLibraryDbContext())
{
var playlist = _context.Playlists.Where(p => p.Name == playlistName).First();
foreach (var item in musics)
{
var mInP = new MusicInPlaylist
{
MusicId = item.Id,
PlaylistId = playlist.Id
};
_context.MusicInPlaylists.Add(mInP);
_context.SaveChanges();
}
}
}
public static void Update(KeyValuePair <string, string> pathChange)
{
try
{
Debug.WriteLine("Access into database");
using (var _context = new MusicLibraryDbContext())
{
Music music = _context.Musics.Where(m => m.Path == pathChange.Key).First();
music.Path = pathChange.Value;
_context.Musics.Update(music);
_context.SaveChanges();
}
Debug.WriteLine("Update Succeed");
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
public PlaylistsController(MusicLibraryDbContext context)
{
_context = context;
}
public SongService(MusicLibraryDbContext context)
{
_context = context;
}
public AlbumService(MusicLibraryDbContext context)
{
_context = context;
}
public static async Task Update(StorageFile File)
{
try
{
Debug.WriteLine(File.Name + " Music meta data start retreiving");
var properties = await File.Properties.GetMusicPropertiesAsync();
var fileStream = await File.OpenStreamForReadAsync();
var tagFile = TagLib.File.Create(new StreamFileAbstraction(File.Name,
fileStream, fileStream));
var types = tagFile.TagTypes;
if ((types & (TagTypes.Id3v1 | TagTypes.Id3v2)) == (TagTypes.Id3v1 | TagTypes.Id3v2))
{
types = TagTypes.Id3v2;
}
var tags = tagFile.GetTag(types);
var path = File.Path;
var bytearray = tags.Pictures.Length == 0 ? new byte[] { } : tags.Pictures[0].Data.Data;
var artistName = properties.Artist != "" ? properties.AlbumArtist : UNKNOWN_ARTIST;
var albumArtistName = properties.AlbumArtist != null ? properties.AlbumArtist : UNKNOWN_ARTIST;
var albumTitle = properties.Album != "" ? properties.Album : UNKNOWN_ALBUM;
var duration = properties.Duration.ToString(@"mm\:ss");
var albumYear = properties.Year != 0 ? properties.Year.ToString() : UNKNOWN_YEAR;
var songTitle = properties.Title != "" ? properties.Title : Path.GetFileNameWithoutExtension(File.Path);
Debug.WriteLine("Access into database");
using (var _context = new MusicLibraryDbContext())
{
Music music = _context.Musics.Where(m => m.Path == path).First();
Thumbnail thumbnail = _context.Thumbnails.Where(t => t.Id == music.ThumbnailId).First();
music.Artist = artistName;
music.AlbumArtist = albumArtistName;
music.AlbumTitle = albumTitle;
music.Title = songTitle;
music.Year = albumYear;
music.Duration = duration;
_context.Musics.Update(music);
if (thumbnail.ImageBytes != bytearray)
{
thumbnail.ImageBytes = bytearray;
_context.Thumbnails.Update(thumbnail);
}
_context.SaveChanges();
}
Debug.WriteLine("Update Succeed");
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
public SongsController(MusicLibraryDbContext context)
{
_context = context;
}
public ArtistService(MusicLibraryDbContext context)
{
_context = context;
}
