private void btAlbumsSave_Click(object sender, EventArgs e)
{
if (cbAlbums.Text != "")
{
using (MusicAppContext ctx = new MusicAppContext())
{
Album AlbumToSave = new Album();
bool newSong = false;
string msg = " updated";
if ((cbAlbums.Text != "") && ((cbAlbums.SelectedItem as ComboboxItem) != null))
{
ComboboxItem AlbumSelected = (cbSongs.SelectedItem as ComboboxItem);
AlbumToSave = ctx.Albums.FirstOrDefault(s => s.AlbumId == AlbumSelected.Key);
}
else
{
newSong = true;
msg = " created";
}
AlbumToSave.Name = cbAlbums.Text;
if (newSong)
{
ctx.Albums.Add(AlbumToSave);
}
ctx.SaveChanges();
MessageBox.Show(cbAlbums.Text + msg);
}
LoadRefresh();
}
}
private void btPlayListDelete_Click(object sender, EventArgs e)
{
if ((cbPlaylists.Text != null) && (cbPlaylists.SelectedItem as ComboboxItem) != null)
{
ComboboxItem playlistSelected = cbPlaylists.SelectedItem as ComboboxItem;
using (MusicAppContext ctx = new MusicAppContext())
{
Playlist playlistToDelete = ctx.Playlists.FirstOrDefault(s => s.PlaylistId == playlistSelected.Key);
ctx.Playlists.Remove(playlistToDelete);
ctx.SaveChanges();
}
LoadRefresh();
}
}
private void btAlbumsDelete_Click(object sender, EventArgs e)
{
if ((cbAlbums.Text != null) && (cbAlbums.SelectedItem as ComboboxItem) != null)
{
ComboboxItem albumSelected = cbAlbums.SelectedItem as ComboboxItem;
using (MusicAppContext ctx = new MusicAppContext())
{
Album albumToDelete = ctx.Albums.FirstOrDefault(s => s.AlbumId == albumSelected.Key);
ctx.Albums.Remove(albumToDelete);
ctx.SaveChanges();
}
LoadRefresh();
}
}
private void btSongsDelete_Click(object sender, EventArgs e)
{
if ((cbSongs.Text != null) && (cbSongs.SelectedItem as ComboboxItem) != null)
{
ComboboxItem songSelected = cbSongs.SelectedItem as ComboboxItem;
using (MusicAppContext ctx = new MusicAppContext())
{
Song songToDelete = ctx.Songs.FirstOrDefault(s => s.SongId == songSelected.Key);
ctx.Songs.Remove(songToDelete);
ctx.SaveChanges();
}
LoadRefresh();
}
}
private void btSongsSave_Click(object sender, EventArgs e)
{
if (cbSongs.Text != "")
{
bool newSong = false;
string msg = " updated";
using (MusicAppContext ctx = new MusicAppContext())
{
Song SongToSave = new Song();
if ((cbSongs.Text != "") && ((cbSongs.SelectedItem as ComboboxItem) != null))
{
ComboboxItem SongSelected = (cbSongs.SelectedItem as ComboboxItem);
SongToSave = ctx.Songs.FirstOrDefault(s => s.SongId == SongSelected.Key);
}
else
{
newSong = true;
}
SongToSave.Title = cbSongs.Text;
if ((cbAlbums.Text != "") && ((cbAlbums.SelectedItem as ComboboxItem) != null))
{
ComboboxItem AlbumSelected = cbAlbums.SelectedItem as ComboboxItem;
Album attachAlbum = ctx.Albums.FirstOrDefault(a => a.AlbumId == AlbumSelected.Key);
if (SongToSave.Albums == null)
{
SongToSave.Albums = new List <Album>();
}
SongToSave.Albums.Add(attachAlbum);
}
if ((cbArtists.Text != "") && ((cbArtists.SelectedItem as ComboboxItem) != null))
{
ComboboxItem artistSelected = cbArtists.SelectedItem as ComboboxItem;
Artist artistToAdd = ctx.Artists.FirstOrDefault(a => a.ArtistId == artistSelected.Key);
if (SongToSave.Artists == null)
{
SongToSave.Artists = new List <Artist>();
}
SongToSave.Artists.Add(artistToAdd);
}
if (newSong)
{
ctx.Songs.Add(SongToSave);
msg = " created";
}
ctx.SaveChanges();
MessageBox.Show(cbSongs.Text + msg);
}
LoadRefresh();
}
}
private void btAddToPlaylist_Click(object sender, EventArgs e)
{
if ((cbPlaylists.Text != null) && ((cbPlaylists.SelectedItem as ComboboxItem) != null))
{
if ((cbSongs.Text != null) && (cbSongs.SelectedItem as ComboboxItem) != null)
{
ComboboxItem songToAdd = cbSongs.SelectedItem as ComboboxItem;
ComboboxItem toPlaylist = cbPlaylists.SelectedItem as ComboboxItem;
using (MusicAppContext ctx = new MusicAppContext())
{
Playlist playlist = ctx.Playlists.FirstOrDefault(p => p.PlaylistId == toPlaylist.Key);
Song song = ctx.Songs.FirstOrDefault(s => s.SongId == songToAdd.Key);
playlist.Songs.Add(song);
ctx.SaveChanges();
}
RefreshPlaylistGrid();
}
}
}
private void btPlayListSave_Click(object sender, EventArgs e)
{
if (cbPlaylists.Text != "")
{
if (cbPlaylists.ValueMember == "")
{
using (MusicAppContext ctx = new MusicAppContext())
{
Playlist newPlaylist = new Playlist();
newPlaylist.Name = cbPlaylists.Text;
newPlaylist.UserId = CurrentUserId;
ctx.Playlists.Add(newPlaylist);
ctx.SaveChanges();
MessageBox.Show(cbPlaylists.Text + " created");
}
LoadRefresh();
}
}
}
private void btRegister_Click(object sender, EventArgs e)
{
if (ValidUser())
{
using (MusicAppContext ctx = new MusicAppContext())
{
User nieuwUser = new User()
{
Firstname = regFirstName,
Lastname = regLastName,
Email = regEmail,
Password = regPassword
};
ctx.Users.Add(nieuwUser);
ctx.SaveChanges();
}
UserLoggedIn = LoginSuccess(regEmail, regPassword);
}
else
{
MessageBox.Show("Invalid user");
}
}
private void btArtistsSave_Click(object sender, EventArgs e)
{
if (cbArtists.Text != "")
{
using (MusicAppContext ctx = new MusicAppContext())
{
Artist ArtistToSave = new Artist();
bool newArtist = false;
string msg = " updated";
if ((cbArtists.Text != "") && ((cbArtists.SelectedItem as ComboboxItem) != null))
{
ComboboxItem ArtistSelected = (cbArtists.SelectedItem as ComboboxItem);
ArtistToSave = ctx.Artists.FirstOrDefault(s => s.ArtistId == ArtistSelected.Key);
}
else
{
newArtist = true;
msg = " created";
}
ArtistToSave.Name = cbArtists.Text;
if ((cbSongs.Text != "") && ((cbSongs.SelectedItem as ComboboxItem) != null))
{
ComboboxItem songSelected = cbSongs.SelectedItem as ComboboxItem;
Song SongToArtist = ctx.Songs.FirstOrDefault(s => s.SongId == songSelected.Key);
ArtistToSave.Songs.Add(SongToArtist);
}
if (newArtist)
{
ctx.Artists.Add(ArtistToSave);
}
ctx.SaveChanges();
MessageBox.Show(cbArtists.Text + msg);
}
LoadRefresh();
}
}