public void AddPlaylist(Playlist playlist, int userId) { int ID = userId; using (var context = new CloudMp3SQLContext()) { playlist.P_OwnerId = ID; context.Playlists.Add(playlist); context.SaveChanges(); GetPlaylistsForUser(ID); } }
public int GetUserID(string usrName) { int id; using (var context = new CloudMp3SQLContext()) { var query = (from u in context.Users where u.U_UserName == usrName select u).SingleOrDefault(); id = query.U_Id; } return(id); }
public void UploadSong(string filePath, int userID) { using (var context = new CloudMp3SQLContext()) { using (var tran = context.Database.BeginTransaction()) { try { isCompleted = false; string fileName = Path.GetFileName(filePath); TagLib.File tagFile = TagLib.File.Create(filePath); CloudBlockBlob blockBlob = _container.GetBlockBlobReference(fileName); var user = (from u in context.Users where u.U_Id == userID select u).SingleOrDefault(); string s = ""; if (tagFile.Tag.Title == null) { s = fileName.Replace(".mp3", ""); } else { s = tagFile.Tag.Title; } Song newSong = new Song() { S_Artist = tagFile.Tag.FirstPerformer, S_Length = (int)tagFile.Properties.Duration.TotalMilliseconds, S_Title = s, S_OwnerId = userID, S_Path = blobStorageUri + blockBlob.Uri.AbsolutePath }; Console.WriteLine(newSong.S_Path); user.Songs.Add(newSong); using (var fileStream = System.IO.File.OpenRead(filePath)) { blockBlob.UploadFromStream(fileStream); isCompleted = true; } isCompleted = false; context.SaveChanges(); tran.Commit(); } catch (Exception) { tran.Rollback(); } } } }
public void RenamePlaylist(int playlistId, int userId, string newName) { int ID = userId; using (var context = new CloudMp3SQLContext()) { Playlist playlistQuery = (from p in context.Playlists where p.P_Id == playlistId where p.P_OwnerId == ID select p).First(); playlistQuery.P_Name = newName; context.SaveChanges(); GetPlaylistsForUser(ID); } }
public void RemoveSongFromPlaylist(int songId, int playlistId) { using (var context = new CloudMp3SQLContext()) { Song songQuery = (from s in context.Songs where s.S_Id == songId select s).First(); Playlist playlistQuery = (from p in context.Playlists where p.P_Id == playlistId select p).First(); songQuery.Playlists.Remove(playlistQuery); playlistQuery.Songs.Remove(songQuery); context.SaveChanges(); GetSongsInPlaylist(playlistQuery.P_Id); } }
public ObservableCollection <Playlist> GetPlaylistsForUser(int userId) { ObservableCollection <Playlist> userPlaylists = new ObservableCollection <Playlist>(); using (var context = new CloudMp3SQLContext()) { var query = (from p in context.Playlists where p.P_OwnerId == userId select p).ToList <Playlist>(); foreach (Playlist x in query) { userPlaylists.Add(x); } } return(userPlaylists); }
public ObservableCollection <Song> GetSongsInPlaylist(int playlistId) { ObservableCollection <Song> playlistSongs = new ObservableCollection <Song>(); using (var context = new CloudMp3SQLContext()) { var query = (from p in context.Playlists where p.P_Id == playlistId select p.Songs).SingleOrDefault(); foreach (Song x in query) { playlistSongs.Add(x); } } return(playlistSongs); }
public ObservableCollection <Song> GetSongsForUser(int userId) { ObservableCollection <Song> userSongs = new ObservableCollection <Song>(); using (var context = new CloudMp3SQLContext()) { var query = (from s in context.Songs where s.S_OwnerId == userId select s).ToList <Song>(); foreach (Song x in query) { userSongs.Add(x); } } userSongs = new ObservableCollection <Song>(userSongs.OrderBy(s => s.S_Artist)); return(userSongs); }
public void AddSongToPlaylist(int songId, int playlistId) { using (var context = new CloudMp3SQLContext()) { Song song = (from s in context.Songs where s.S_Id == songId select s).SingleOrDefault(); Playlist playlist = (from p in context.Playlists where p.P_Id == playlistId select p).SingleOrDefault(); //songQuery.Playlists.Add(playlistQuery); playlist.Songs.Add(song); context.SaveChanges(); } }
public void ValidateUserName(string usrName, string pass) { using (var context = new CloudMp3SQLContext()) { var query = (from u in context.Users where u.U_UserName == usrName select u).SingleOrDefault(); if (query == null) { User u = new User(); u.U_UserName = usrName; u.U_Password = pass; context.Users.Add(u); context.SaveChanges(); } } this.Close(); }
public void RemovePlaylist(int playlistId, int userId) { int ID = userId; using (var context = new CloudMp3SQLContext()) { Playlist playlistQuery = (from p in context.Playlists where p.P_Id == playlistId select p).First(); foreach (Song s in playlistQuery.Songs) { s.Playlists.Remove(playlistQuery); } context.Playlists.Remove(playlistQuery); context.SaveChanges(); GetPlaylistsForUser(ID); } }
public bool ValidateUserName(string usrName, string pass) { bool valid = false; using (var context = new CloudMp3SQLContext()) { var query = (from u in context.Users where u.U_UserName == usrName select u).SingleOrDefault(); if (query != null) { if (pass == query.U_Password) { valid = true; } } } return(valid); }