protected override void ViewMoreLogic(int id)
{
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsDirectory);
List <PlaylistsSongs> playlistsSongs = playlistsSongsRepo.GetAll(playlistsong => playlistsong.PlaylistId == id);
if (playlistsSongs.Count == 0)
{
Console.WriteLine("This playlist doesn't have any songs in it!");
return;
}
List <int> songsIds = new List <int>();
foreach (PlaylistsSongs playlistSong in playlistsSongs) //gets the song ids for the chosen playlist
{
songsIds.Add(playlistSong.SongId);
}
SongsRepository songsRepo = new SongsRepository(Constants.SongsDirectory);
List <Song> songs = new List <Song>();
foreach (int songId in songsIds) //gets the actual songs from the playlist
{
songs.Add(songsRepo.GetById(songId));
}
Console.WriteLine("Songs");
foreach (Song song in songs)
{
Console.WriteLine("Song ID: " + song.Id);
Console.WriteLine("Song Title: " + song.Title);
Console.WriteLine("Song Artist Name: " + song.ArtistName);
Console.WriteLine("Song Year: " + song.Year);
Console.WriteLine("============================================");
}
}
public void DeleteArtist()
{
ViewArtists();
Console.WriteLine();
InputId:
Console.Write("Enter artist id to delete: ");
int deleteId;
bool isInt = int.TryParse(Console.ReadLine(), out deleteId);
while (isInt == false)
{
Console.WriteLine("IDs can only be integer numbers. Try again!!");
Console.ReadKey(true);
goto InputId;
}
ArtistsRepository artistsRepo = new ArtistsRepository(Constants.ArtistsPath);
Artist artist = artistsRepo.GetAll(a => a.Id == deleteId).FirstOrDefault();
if (artist == null)
{
Console.WriteLine("No artist with that Id exists in the system yet!");
Console.ReadKey(true);
return;
}
SongsArtistsRepository songsArtistsRepo = new SongsArtistsRepository(Constants.SongsArtistsPath);
List <SongsArtists> songsArtistsEntities = songsArtistsRepo.GetAll(sae => sae.ArtistId == deleteId);
SongsRepository songsRepo = new SongsRepository(Constants.SongsPath);
List <Song> songs = new List <Song>();
foreach (SongsArtists songsArtistsEntity in songsArtistsEntities)
{
Song song = songsRepo.GetAll(s => s.Id == songsArtistsEntity.SongId).FirstOrDefault();
songs.Add(song);
}
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsPath);
List <PlaylistsSongs> playlistsSongsEntities = new List <PlaylistsSongs>();
foreach (SongsArtists songsArtistsEntity in songsArtistsEntities)
{
PlaylistsSongs playlistSongEntity = playlistsSongsRepo.GetAll(pse => pse.SongId == songsArtistsEntity.SongId).FirstOrDefault();
playlistsSongsEntities.Add(playlistSongEntity);
}
foreach (PlaylistsSongs playlistsSongsEntity in playlistsSongsEntities)
{
playlistsSongsRepo.Delete(playlistsSongsEntity);
}
foreach (Song song in songs)
{
songsRepo.Delete(song);
}
artistsRepo.Delete(artist);
Console.WriteLine("Artist deleted successfully!");
Console.ReadKey(true);
}
protected override void DeleteMoreLogic(int id)
{
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsDirectory);
playlistsSongsRepo.Delete(playlistSong => playlistSong.PlaylistId == id);
UsersPlaylistsRepository usersPlaylistsRepo = new UsersPlaylistsRepository(Constants.UsersPlaylistsDirectory);
usersPlaylistsRepo.Delete(usersPlaylist => usersPlaylist.PlaylistId == id);
}
private void AddSongToPlaylist()
{
Console.Clear();
SongsRepository songsRepo = new SongsRepository(Constants.SongsDirectory);
List <Song> songsDb = songsRepo.GetAll();
foreach (Song song in songsDb)
{
Console.WriteLine("Song ID: " + song.Id);
Console.WriteLine("Song Title: " + song.Title);
Console.WriteLine("Song ArtistName: " + song.ArtistName);
Console.WriteLine("Song Year: " + song.Year);
Console.WriteLine("==================================================");
}
Console.Write("Song ID: ");
int songIdInput = Int32.Parse(Console.ReadLine());
List <Song> songDb = songsRepo.GetAll((song => song.Id == songIdInput));
if (songDb[0] == null)
{
Console.WriteLine("Cannot find song");
Console.ReadKey(true);
return;
}
Console.Clear();
PlaylistsRepository playlistsRepo = new PlaylistsRepository(Constants.PlaylistsDirectory);
List <Playlist> playlistsDb = playlistsRepo.GetAll(playlist => AuthenticationService.LoggedUser.Id == playlist.ParentUserId);
foreach (Playlist playlist in playlistsDb)// user's playlists
{
Console.WriteLine("Playlist ID: " + playlist.Id);
Console.WriteLine("Playlist Name: " + playlist.Name);
Console.WriteLine("Playlist Description: " + playlist.Description);
Console.WriteLine("Playlist Is public?: " + playlist.IsPublic);
Console.WriteLine("====================================================");
}
Console.Write("Playlist ID: ");
int playlistIdInput = Int32.Parse(Console.ReadLine());
if (playlistsDb.Count == 0)
{
Console.WriteLine("Playlist not found");
Console.ReadKey(true);
return;
}
playlistsDb = playlistsDb.Where(playlist => playlist.Id == playlistIdInput).ToList();
PlaylistsSongs playlistsSongs = new PlaylistsSongs(songDb[0], playlistsDb[0]);
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsDirectory);
playlistsSongsRepo.Save(playlistsSongs);
Console.WriteLine("Song saved successfully to playlist!");
Console.ReadKey(true);
}
public void DeletePlaylist()
{
ViewUserPlaylists();
Console.WriteLine();
Console.Write("Enter id to delete: ");
int deleteId = 0;
int currentUserId = AuthenticationService.LoggedUser.Id;
bool isIntId = int.TryParse(Console.ReadLine(), out deleteId);
while (isIntId == false)
{
Console.WriteLine("Id can only be an integer number. Try again!!");
Console.ReadKey();
Console.Write("Enter id to delete: ");
isIntId = int.TryParse(Console.ReadLine(), out deleteId);
}
UsersPlaylistsRepository usersPlaylistsRepo = new UsersPlaylistsRepository(Constants.UsersPlaylistsPath);
PlaylistsRepository playlistsRepo = new PlaylistsRepository(Constants.PlaylistsPath);
UsersPlaylists usersPlaylistsEntity = usersPlaylistsRepo.GetAll(upe => upe.PlaylistId == deleteId && upe.UserId == currentUserId)
.FirstOrDefault();
if (usersPlaylistsEntity == null)
{
Console.WriteLine("Playlist with id {0} does not exist or you have no rights to delete!", deleteId);
Console.ReadKey();
return;
}
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsPath);
List <PlaylistsSongs> playlistsSongsEntities = playlistsSongsRepo.GetAll(pse => pse.PlaylistId == deleteId);
foreach (PlaylistsSongs playlistsSongsEntity in playlistsSongsEntities)
{
playlistsSongsRepo.Delete(playlistsSongsEntity);
}
Playlist playlistToDelete = playlistsRepo.GetAll(p => p.Id == deleteId).FirstOrDefault();
usersPlaylistsRepo.Delete(usersPlaylistsEntity);
playlistsRepo.Delete(playlistToDelete);
Console.WriteLine("Playlist successfully deleted!");
Console.ReadKey(true);
}
public void DeleteSong()
{
bool hasSongs = ViewSongs(); //TODO: Refactore with do...while loop or simple while loop like in the bookmarked while loop.
if (hasSongs == false)
{
return;
}
Console.WriteLine();
Console.Write("Enter id to delete: ");
int deleteId = Convert.ToInt32(Console.ReadLine());
SongsArtistsRepository songsArtistsRepo = new SongsArtistsRepository(Constants.SongsArtistsPath);
List <SongsArtists> songsArtistsEntities = songsArtistsRepo.GetAll(sa => sa.SongId == deleteId);
foreach (SongsArtists songArtistEntity in songsArtistsEntities)
{
songsArtistsRepo.Delete(songArtistEntity);
}
SongsRepository songsRepo = new SongsRepository(Constants.SongsPath);
Song songToDelete = songsRepo.GetAll(s => s.Id == deleteId).FirstOrDefault();
if (songToDelete == null)
{
Console.WriteLine("There is no song with that Id.");
Console.ReadKey(true);
return;
}
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsPath);
List <PlaylistsSongs> playlistsSongsEntities = playlistsSongsRepo.GetAll(pse => pse.SongId == deleteId);
foreach (PlaylistsSongs playlistSongsEntity in playlistsSongsEntities)
{
playlistsSongsRepo.Delete(playlistSongsEntity);
}
songsRepo.Delete(songToDelete);
Console.WriteLine("Song deleted successfully!");
Console.ReadKey(true);
}
protected override void DeleteMoreLogic(int id)
{
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsDirectory);
playlistsSongsRepo.Delete(item => item.SongId == id);
}
private void DeleteSongFromPlaylist()
{
Console.Clear();
PlaylistsRepository playlistRepo = new PlaylistsRepository(Constants.PlaylistsDirectory);
List <Playlist> playlists = playlistRepo.GetAll(playlist => playlist.ParentUserId == AuthenticationService.LoggedUser.Id);
if (playlists.Count == 0)
{
Console.WriteLine("You don't have any playlists");
Console.ReadKey(true);
return;
}
foreach (Playlist playlist in playlists)
{
Console.WriteLine("Playlist ID: " + playlist.Id);
Console.WriteLine("Playlist Name: " + playlist.Name);
Console.WriteLine("Playlist Description: " + playlist.Description);
Console.WriteLine("==============================================================");
}
Console.Write("Playlist ID: ");
int playlistInputId = Int32.Parse(Console.ReadLine());
if (!playlists.Any(playlist => playlist.Id == playlistInputId))
{
Console.WriteLine("Playlist not found!");
Console.ReadKey(true);
return;
}
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsDirectory);
List <PlaylistsSongs> playlistsSongs = playlistsSongsRepo.GetAll(playlistSong => playlistSong.PlaylistId == playlistInputId);
Console.Clear();
if (playlistsSongs.Count == 0)
{
Console.WriteLine("This playlist doesn't have any songs!");
Console.ReadKey(true);
return;
}
SongsRepository songsRepo = new SongsRepository(Constants.SongsDirectory);
List <Song> songs = new List <Song>();
foreach (PlaylistsSongs playlistSong in playlistsSongs)
{
songs.Add(songsRepo.GetById(playlistSong.SongId));
}
foreach (Song song in songs)
{
Console.WriteLine("Song ID: " + song.Id);
Console.WriteLine("Song Title: " + song.Title);
Console.WriteLine("Song Artist Name: " + song.ArtistName);
Console.WriteLine("Song Year: " + song.Year);
Console.WriteLine("==========================================================");
}
Console.Write("Song ID: ");
int songInputId = Int32.Parse(Console.ReadLine());
bool IsSongExist = playlistsSongsRepo.GetAll(playlistSong => playlistSong.PlaylistId == playlistInputId && playlistSong.SongId == songInputId).Count > 0;
if (!IsSongExist)
{
Console.WriteLine("Song not found");
Console.ReadKey(true);
return;
}
playlistsSongsRepo.Delete(playlistSong => playlistSong.PlaylistId == playlistInputId && playlistSong.SongId == songInputId);
Console.WriteLine("Song deleted successfully from the playlist");
Console.ReadKey(true);
}
public void ViewPublicPlaylists()
{
PlaylistsRepository playlistsRepo = new PlaylistsRepository(Constants.PlaylistsPath);
List <Playlist> playlists = playlistsRepo.GetAll();
IEnumerable <Playlist> filteredPlaylists = playlists.Where(p => p.IsPublic == true);
Console.Clear();
foreach (Playlist playlist in filteredPlaylists)
{
Console.WriteLine("*************************************");
Console.WriteLine("Id: {0}", playlist.Id);
Console.WriteLine("Playlist name: {0}", playlist.Name);
if (string.IsNullOrWhiteSpace(playlist.Description) == false)
{
Console.WriteLine("Description: {0}", playlist.Description);
}
Console.WriteLine("*************************************");
}
Console.WriteLine();
Console.Write("Enter playlist id to see: ");
int playlistId;
bool isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
while (isIntPlaylistId == false)
{
Console.WriteLine("Playlist id can only be an integer number!");
Console.ReadKey();
Console.Write("Enter playlist id to see: ");
isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
}
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsPath);
SongsArtistsRepository songsArtistsRepo = new SongsArtistsRepository(Constants.SongsArtistsPath);
ArtistsRepository artistsRepo = new ArtistsRepository(Constants.ArtistsPath);
SongsRepository songsRepo = new SongsRepository(Constants.SongsPath);
List <PlaylistsSongs> playlistsSongsEntities = playlistsSongsRepo.GetAll(pse => pse.PlaylistId == playlistId);
List <Song> songs = new List <Song>();
foreach (PlaylistsSongs playlistsSongsEntity in playlistsSongsEntities)
{
Song song = songsRepo.GetAll(s => s.Id == playlistsSongsEntity.SongId).FirstOrDefault();
songs.Add(song);
}
Console.Clear();
foreach (Song song in songs)
{
Console.WriteLine("********************************");
Console.WriteLine("Id: {0}", song.Id);
Console.WriteLine("Song title: {0}", song.Title);
Console.WriteLine("Song release year: {0}", song.Year);
List <SongsArtists> songsArtists = songsArtistsRepo.GetAll(sa => sa.SongId == song.Id);
List <Artist> artists = new List <Artist>();
foreach (SongsArtists songArtistItem in songsArtists)
{
int artistId = songArtistItem.ArtistId;
Artist artist = artistsRepo.GetAll(a => a.Id == songArtistItem.ArtistId).FirstOrDefault();
artists.Add(artist);
}
if (artists.Count == 1)
{
Console.WriteLine("Artist: {0}", artists[0].Name);
}
else
{
Console.Write("Artists: ");
int end = artists.Count - 1;
for (int i = 0; i < end; i++)
{
Console.WriteLine("{0}, ", artists[i].Name);
}
Console.WriteLine(artists[end]);
}
Console.WriteLine("********************************");
}
Console.ReadKey(true);
}
public void ViewSpecificPlaylist()
{
ViewUserPlaylists();
Console.WriteLine();
Console.Write("Enter playlist id to view: ");
int currentUserId = AuthenticationService.LoggedUser.Id;
int playlistId;
bool isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
while (isIntPlaylistId == false)
{
Console.WriteLine("Id can only be an integer number");
Console.Write("Enter playlist id to view: ");
isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
}
UsersPlaylistsRepository usersPlaylistsRepo = new UsersPlaylistsRepository(Constants.UsersPlaylistsPath);
bool hasRightsToShare = usersPlaylistsRepo.EntityExists(upe => upe.PlaylistId == playlistId && upe.UserId == currentUserId);
if (hasRightsToShare == false)
{
Console.WriteLine("Playlist does not exist or you have no rights to view!");
Console.ReadKey(true);
return;
}
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsPath);
List <PlaylistsSongs> playlistsSongsEntities = playlistsSongsRepo.GetAll(pse => pse.PlaylistId == playlistId);
SongsRepository songsRepo = new SongsRepository(Constants.SongsPath);
SongsArtistsRepository songsArtistsRepo = new SongsArtistsRepository(Constants.SongsArtistsPath);
ArtistsRepository artistsRepo = new ArtistsRepository(Constants.ArtistsPath);
List <Song> songs = new List <Song>();
foreach (PlaylistsSongs playlistsSongsEntity in playlistsSongsEntities)
{
Song song = songsRepo.GetAll(s => s.Id == playlistsSongsEntity.SongId).FirstOrDefault();
songs.Add(song);
}
if (songs.Count == 0)
{
Console.WriteLine("Playlist empty!");
Console.ReadKey(true);
return;
}
Console.Clear();
foreach (Song song in songs)
{
Console.WriteLine("********************************");
Console.WriteLine("Id: {0}", song.Id);
Console.WriteLine("Song title: {0}", song.Title);
Console.WriteLine("Song release year: {0}", song.Year);
List <SongsArtists> songsArtists = songsArtistsRepo.GetAll(sa => sa.SongId == song.Id);
List <Artist> artists = new List <Artist>();
foreach (SongsArtists songArtistItem in songsArtists)
{
int artistId = songArtistItem.ArtistId;
Artist artist = artistsRepo.GetAll(a => a.Id == songArtistItem.ArtistId).FirstOrDefault();
artists.Add(artist);
}
if (artists.Count == 1)
{
Console.WriteLine("Artist: {0}", artists[0].Name);
}
else
{
Console.Write("Artists: ");
int end = artists.Count - 1;
for (int i = 0; i < end; i++)
{
Console.WriteLine("{0}, ", artists[i].Name);
}
Console.WriteLine(artists[end]);
}
Console.WriteLine("********************************");
}
Console.ReadKey(true);
}
public void RemoveSongFromPlaylist()
{
ViewUserPlaylists();
Console.WriteLine();
Console.Write("Enter id of playlist: ");
int playlistId;
bool isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
while (isIntPlaylistId == false)
{
Console.WriteLine("Id can only be an integer number. Try again!!");
Console.ReadKey();
Console.Write("Enter id of playlist: ");
isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
}
UsersPlaylistsRepository usersPlaylistsRepo = new UsersPlaylistsRepository(Constants.UsersPlaylistsPath);
int currentUserId = AuthenticationService.LoggedUser.Id;
if (usersPlaylistsRepo.EntityExists(upe => upe.PlaylistId == playlistId && upe.UserId == currentUserId) == false)
{
Console.WriteLine("Playlist does not exist exist or you have no rights to add songs to it!");
Console.ReadKey(true);
return;
}
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsPath);
List <PlaylistsSongs> playlistsSongsEntities = playlistsSongsRepo.GetAll(pse => pse.PlaylistId == playlistId);
SongsRepository songsRepo = new SongsRepository(Constants.SongsPath);
SongsArtistsRepository songsArtistsRepo = new SongsArtistsRepository(Constants.SongsArtistsPath);
ArtistsRepository artistsRepo = new ArtistsRepository(Constants.ArtistsPath);
List <Song> songs = new List <Song>();
foreach (PlaylistsSongs playlistSongsEntity in playlistsSongsEntities)
{
Song song = songsRepo.GetAll(s => s.Id == playlistSongsEntity.SongId).FirstOrDefault();
songs.Add(song);
}
Console.Clear();
foreach (Song song in songs)
{
Console.WriteLine("********************************");
Console.WriteLine("Id: {0}", song.Id);
Console.WriteLine("Song title: {0}", song.Title);
Console.WriteLine("Song release year: {0}", song.Year);
List <SongsArtists> songsArtists = songsArtistsRepo.GetAll(sa => sa.SongId == song.Id);
List <Artist> artists = new List <Artist>();
foreach (SongsArtists songArtistItem in songsArtists)
{
int artistId = songArtistItem.ArtistId;
Artist artist = artistsRepo.GetAll(a => a.Id == songArtistItem.ArtistId).FirstOrDefault();
artists.Add(artist);
}
if (artists.Count == 1)
{
Console.WriteLine("Artist: {0}", artists[0].Name);
}
else
{
Console.Write("Artists: ");
int end = artists.Count - 1;
for (int i = 0; i < end; i++)
{
Console.WriteLine("{0}, ", artists[i].Name);
}
Console.WriteLine(artists[end]);
}
Console.WriteLine("********************************");
}
Console.WriteLine();
Console.Write("Select song id to remove from the playlist: ");
int songId;
bool isIntSongId = int.TryParse(Console.ReadLine(), out songId);
while (isIntSongId == false)
{
Console.WriteLine("Id can only be an integer number. Try again!!");
Console.ReadKey();
Console.Write("Select song id to remove from the playlist: ");
isIntSongId = int.TryParse(Console.ReadLine(), out songId);
}
PlaylistsSongs playlistsSongsEntity = playlistsSongsRepo.GetAll(pse => pse.PlaylistId == playlistId && pse.SongId == songId).FirstOrDefault();
if (playlistsSongsEntity == null)
{
Console.WriteLine("Song does not exist in that playlist or you have no rights to remove!");
Console.ReadKey(true);
return;
}
playlistsSongsRepo.Delete(playlistsSongsEntity);
Console.WriteLine("Song successfully removed from playlist!");
Console.ReadKey(true);
}
public void AddSongToPlaylist()
{
SongsView.ViewSongs();
Console.WriteLine();
Console.Write("Enter id of song to add: ");
int songId = 0;
bool isIntSongId = int.TryParse(Console.ReadLine(), out songId);
while (isIntSongId == false)
{
Console.WriteLine("Song id can only be an integer number. Try again!");
Console.ReadKey(true);
Console.Write("Enter id of song to add: ");
isIntSongId = int.TryParse(Console.ReadLine(), out songId);
}
SongsRepository songsRepo = new SongsRepository(Constants.SongsPath);
if (songsRepo.EntityExists(s => s.Id == songId) == false)
{
Console.WriteLine("Song with id {0} doesn't exist!", songId);
Console.ReadKey(true);
return;
}
ViewUserPlaylists();
Console.Write("Select id of playlist you would add to: ");
int playlistId = 0;
bool isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
while (isIntPlaylistId == false)
{
Console.WriteLine("Song id can only be an integer number. Try again!");
Console.ReadKey(true);
Console.Write("Enter id of song to add: ");
isIntPlaylistId = int.TryParse(Console.ReadLine(), out playlistId);
}
UsersPlaylistsRepository usersPlaylistsRepo = new UsersPlaylistsRepository(Constants.UsersPlaylistsPath);
int currentUserId = AuthenticationService.LoggedUser.Id;
if (usersPlaylistsRepo.EntityExists(upe => upe.PlaylistId == playlistId && upe.UserId == currentUserId) == false)
{
Console.WriteLine("Playlist does not exist exist or you have no rights to add songs to it!");
Console.ReadKey(true);
return;
}
PlaylistsSongs playlistSongsEntity = new PlaylistsSongs();
playlistSongsEntity.SongId = songId;
playlistSongsEntity.PlaylistId = playlistId;
PlaylistsSongsRepository playlistsSongsRepo = new PlaylistsSongsRepository(Constants.PlaylistsSongsPath);
if (playlistsSongsRepo.EntityExists(p => p.PlaylistId == playlistSongsEntity.PlaylistId && p.SongId == playlistSongsEntity.SongId))
{
Console.WriteLine("The selected song is already in that playlist!");
Console.ReadKey(true);
return;
}
playlistsSongsRepo.Save(playlistSongsEntity);
Console.WriteLine("Song successfully added to playlist");
Console.ReadKey(true);
}
