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 bool EmailFound(string email) { using (MusicAppContext ctx = new MusicAppContext()) { if (ctx.Users.Any(u => u.Email.Trim() == regEmail)) { return(true); } else { MessageBox.Show(email + " already exists"); } } MessageBox.Show("connection to database failed"); return(false); }
private bool LoginSuccess(string email, string password) { using (MusicAppContext ctx = new MusicAppContext()) { var currentUser = ctx.Users.FirstOrDefault(u => (u.Email.Trim() == email) && (u.Password.Trim() == password)); if (currentUser != null) { this.Hide(); PlaylistForm newPlaylistForm = new PlaylistForm(currentUser.UserId); MessageBox.Show("logged in successfull"); newPlaylistForm.Show(); return(true); } } MessageBox.Show("connection to database failed or user not found"); return(false); }
private void RefreshPlaylistGrid() { if ((cbPlaylists.Text != "") && ((cbPlaylists.SelectedItem as ComboboxItem) != null)) { DataTable dtSongsOfPlaylist = new DataTable(); ComboboxItem selectedPlaylist = (cbPlaylists.SelectedItem as ComboboxItem); dtSongsOfPlaylist.Columns.Add(new DataColumn("Song Title", typeof(string))); dtSongsOfPlaylist.Columns.Add(new DataColumn("Albums", typeof(string))); dtSongsOfPlaylist.Columns.Add(new DataColumn("Artists", typeof(string))); using (MusicAppContext ctx = new MusicAppContext()) { var PlaylistWithSongs = ctx.Playlists.FirstOrDefault(p => p.PlaylistId == selectedPlaylist.Key); foreach (var Song in PlaylistWithSongs.Songs.ToList()) { List <string> newRow = new List <string>(); string albums = ""; string artists = ""; int iCount = 0; newRow.Add(Song.Title); foreach (var album in Song.Albums.ToList()) { if (iCount++ > 0) { albums += ", "; } albums += album.Name; } newRow.Add(albums); iCount = 0; foreach (var artist in Song.Artists.ToList()) { if (iCount++ > 0) { artists += ", "; } artists += artist.Name; } newRow.Add(artists); dtSongsOfPlaylist.Rows.Add(newRow.ToArray()); } } dgPlaylist.DataSource = dtSongsOfPlaylist; } }
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(); } }
private void LoadRefresh() { using (MusicAppContext ctx = new MusicAppContext()) { DataTable dtSongs = new DataTable(); DataTable dtPlaylists = new DataTable(); cbPlaylists.Items.Clear(); cbPlaylists.Text = ""; cbAlbums.Items.Clear(); cbAlbums.Text = ""; cbSongs.Items.Clear(); cbSongs.Text = ""; cbArtists.Items.Clear(); cbArtists.Text = ""; var userPlaylists = ctx.Playlists.Where(p => p.UserId == CurrentUserId); foreach (Playlist playlist in userPlaylists) { ComboboxItem newItem = new ComboboxItem(playlist.PlaylistId, playlist.Name); cbPlaylists.Items.Add(newItem); } cbAlbums.Items.Clear(); foreach (Album album in ctx.Albums) { ComboboxItem newItem = new ComboboxItem(album.AlbumId, album.Name); cbAlbums.Items.Add(newItem); } foreach (Song song in ctx.Songs) { ComboboxItem newItem = new ComboboxItem(song.SongId, song.Title); cbSongs.Items.Add(newItem); } foreach (Artist artist in ctx.Artists) { ComboboxItem newItem = new ComboboxItem(artist.ArtistId, artist.Name); cbArtists.Items.Add(newItem); } dtSongs.Columns.Add(new DataColumn("Song Title", typeof(string))); dtSongs.Columns.Add(new DataColumn("Albums", typeof(string))); dtSongs.Columns.Add(new DataColumn("Artists", typeof(string))); var SongsWithAlbums = ctx.Songs; foreach (var Song in SongsWithAlbums.ToList()) { List <string> newRow = new List <string>(); string albums = ""; string artists = ""; int iCount = 0; newRow.Add(Song.Title); foreach (var album in Song.Albums.ToList()) { if (iCount++ > 0) { albums += ", "; } albums += album.Name; } newRow.Add(albums); iCount = 0; foreach (var artist in Song.Artists.ToList()) { if (iCount++ > 0) { artists += ", "; } artists += artist.Name; } newRow.Add(artists); dtSongs.Rows.Add(newRow.ToArray()); } dgSongs.DataSource = dtSongs; } }