public bool addToTempPlaylist(Playlist playlist,ISession session) { try { // Prepare and bind statement passing in the relevant fields String todo = ("insert into playlist (track_id,playlist_id,track_pos)\n" + "values (:tid, :pid,:tpos) if not exists using ttl 3600;"); PreparedStatement ps = session.Prepare(todo); // Getting Appropriate ID's for query Guid pid = playlist.getID(); List<Song> songs = playlist.getSongs(); for (int i = 0; i < songs.Count(); i++) { Guid tid = songs[i].getSongID(); int pos = getListPos(session, tid, pid); BoundStatement bs = ps.Bind(tid, pid, pos); // Execute Query session.Execute(bs); } return false; // Catch exceptions } catch (Exception ex) { Console.WriteLine("SOMETHING WENT WRONG add to temp playlist: " + ex.Message); return false; } }
//Method to open single playlist view public void showViewPlaylist(Playlist playlist) { hideForms(); viewPlaylist = new ViewPlaylist(playlist, this.musicPlayer, this.currentUser, this); viewPlaylist.TopLevel = false; viewPlaylist.Parent = this; viewPlaylist.setupAlbumCovers(playlist.getSongs()); viewPlaylist.setupLabels(); viewPlaylist.FormBorderStyle = FormBorderStyle.None; viewPlaylist.Size = new Size(1092, 392); picBoxBackground.Hide(); viewPlaylist.Show(); }
public void savePlaylist(Playlist playlist, User newUser) { // Get details of current playlist // Create new playlist, same name different owner String newOwner = newUser.getUsername(); Guid newID = Guid.NewGuid(); playlist.setOwner(newOwner); playlist.setGuid(newID); List<Song> tracks = playlist.getSongs(); createPlaylist(playlist); populatePlaylist(playlist, tracks); }
public ViewPlaylist(Playlist playlist, frmMusicPlayer music, User currentUser, HomePage parent) { InitializeComponent(); picSave.Visible = true; //Set player, playlist, user this.musicPlayer = music; this.currentUser = currentUser; this.thePlaylist = playlist; lblPlaylistName.Text = thePlaylist.getPlaylistName(); lblOwner.Text = thePlaylist.getOwner(); this.parent = parent; //Initially hide edit box txtPlaylistNameEdit.Hide(); List<Song> songs = thePlaylist.getSongs(); int numSongs = thePlaylist.getSongs().Count; lblNumSongs.Text = numSongs.ToString(); if (numSongs == 1) { lblNumSongs.Text += " song"; } else { lblNumSongs.Text += " songs"; } //Get total playlist length int totalLength = 0; for (int i = 0; i < songs.Count; i++) { totalLength += songs[i].getLength(); } int hours = totalLength / 3600; int minutes = (totalLength - hours * 3600) / 60; int seconds = totalLength - (hours * 3600) - (minutes * 60); //Set up string saying how long the playlist is String output = ""; if(hours > 0) { output += hours.ToString() + " hours, \n"; } if (minutes > 0) { output += minutes.ToString() + " minutes, \n"; } if (seconds > 0) { output += seconds.ToString() + " seconds, \n"; } if (output.Equals("")) { output = "O seconds"; } else { output = output.Substring(0, output.Length - 3); } //Set length to label lblTime.Text = output; String currUser = this.currentUser.getUsername(); String owner = thePlaylist.getOwner(); String first6 = ""; if (!(thePlaylist.getPlaylistName().Length < 6)) { first6 = thePlaylist.getPlaylistName().Substring(0, 6); } if (currUser.Equals(owner) && first6 != "" ) { if (first6.Equals("$temp$")) { lblPlaylistName.Text = thePlaylist.getPlaylistName().Substring(6); thePlaylist.setName(thePlaylist.getPlaylistName().Substring(6)); } else { picSave.Visible = false; } picRecommend.Visible = true; picPlay.Left = lblPlaylistName.Left + lblPlaylistName.Width + 10; } else { picSave.Left = lblPlaylistName.Left + lblPlaylistName.Width + 10; picPlay.Left = lblPlaylistName.Left + lblPlaylistName.Width + 15 + picSave.Width; picRecommend.Visible = false; } }