Exemple #1
0
        private void buttonSaveArtist_Click(object sender, EventArgs e)
        {
            using (var db = new PlayListContext())
            {
                if (db.Database.CanConnect())
                {
                    var  artists      = db.Artists.ToList().OrderBy(artist => artist.ArtistId);
                    int  newId        = artists.LastOrDefault().ArtistId + 1;
                    bool artistExists = db.Artists.Any(a => a.Name == tbNewArtist.Text);

                    if (tbNewArtist.Text != null || tbNewArtist.Text != "")
                    {
                        if (artistExists)
                        {
                            MessageBox.Show("Artist already exists in Database!");
                        }
                        else
                        {
                            var result = MessageBox.Show($"Do you want to save the artist {tbNewArtist.Text} to the Database?",
                                                         "Save artist",
                                                         MessageBoxButtons.OKCancel);

                            if (result == DialogResult.OK)
                            {
                                Artist newArtist = new Artist()
                                {
                                    Name     = tbNewArtist.Text,
                                    ArtistId = newId
                                };
                                db.Artists.Add(newArtist);
                                db.SaveChanges();

                                MessageBox.Show("Artist successfully saved!");
                            }
                        }
                    }
                    else
                    {
                        MessageBox.Show("Artist name can't be blank!");
                    }
                }
            }
        }
Exemple #2
0
        private void buttonSavePL_Click(object sender, EventArgs e)
        {
            using (var db = new PlayListContext())
            {
                if (db.Database.CanConnect())
                {
                    var playlists = db.Playlists.ToList().OrderBy(pl => pl.PlaylistId);
                    int newId     = playlists.LastOrDefault().PlaylistId + 1;

                    if (!string.IsNullOrEmpty(tbPLName.Text))
                    {
                        Playlist playlist = new Playlist()
                        {
                            Name       = tbPLName.Text,
                            PlaylistId = newId
                        };

                        db.Playlists.Add(playlist);
                        DialogResult result = MessageBox.Show($"Do you want to save the playlist as '{playlist.Name}'?"
                                                              , "Save playlist",
                                                              MessageBoxButtons.OKCancel);

                        if (result == DialogResult.OK)
                        {
                            db.SaveChanges();
                        }
                        tbPLName.Clear();
                    }
                    else
                    {
                        MessageBox.Show("Please enter a title for your playlist!");
                    }
                }
                else
                {
                    MessageBox.Show("Connection Failed!");
                }
            }
        }