public MainWindow() { InitializeComponent(); using (MusicContext db = new MusicContext()) { albumList = db.Albums.ToList(); musicListView.ItemsSource = db.Albums.Include("Songs").ToList(); authorComboBox.ItemsSource = db.Authors.ToList(); genreComboBox.ItemsSource = db.Genres.ToList(); } }
private void Button_Click_1(object sender, RoutedEventArgs e) { using (MusicContext db = new MusicContext()) { albumList = db.Albums.ToList(); musicListView.ItemsSource = db.Albums.Include("Songs").ToList(); comboBoxSearch.ItemsSource = db.Genres.ToList(); authorComboBox.ItemsSource = db.Authors.ToList(); genreComboBox.ItemsSource = db.Genres.ToList(); } }
private void BaiButtonClick(object sender, RoutedEventArgs e) { int ID = Convert.ToInt32((sender as Button).Tag); using (MusicContext db = new MusicContext()) { var a = db.Albums.Find(ID); if (a != null) { Process.Start("chrome.exe", a.ShopUrl); } } }
public EditAlbumWindow(int ID) { InitializeComponent(); using (MusicContext db = new MusicContext()) { editableAlbum = db.Albums.Include("Songs").FirstOrDefault(x => x.Id == ID); AuthorsComboBox.ItemsSource = db.Authors.ToList(); GenreComboBox.ItemsSource = db.Genres.ToList(); } AuthorsComboBox.SelectedItem = editableAlbum.Author; TitleTextBox.Text = editableAlbum.Title; LengthtextBox.Text = SecondsToString(editableAlbum.Length); AlbumImage.Source = new BitmapImage(new Uri(editableAlbum.Image)); GenreComboBox.SelectedItem = editableAlbum.Genre; PriceTextBox.Text = Math.Round(editableAlbum.Price, 2).ToString(); DatePublishedCalendar.DisplayDate = editableAlbum.DatePublished; oldDatePublished.Content = "Previous date: " + editableAlbum.DatePublished.Date.ToString().Split(' ')[0]; URLTextBox.Text = editableAlbum.ShopUrl; }
private void RadioButton_Click(object sender, RoutedEventArgs e) { using (MusicContext db = new MusicContext()) { if ((sender as System.Windows.Controls.RadioButton).Tag.ToString() == "Author") { comboBoxSearch.ItemsSource = db.Authors.ToList(); comboBoxSearch.DisplayMemberPath = "Name"; } else if ((sender as System.Windows.Controls.RadioButton).Tag.ToString() == "Genre") { comboBoxSearch.ItemsSource = db.Genres.ToList(); comboBoxSearch.DisplayMemberPath = "Name"; } else if ((sender as System.Windows.Controls.RadioButton).Tag.ToString() == "Title") { comboBoxSearch.ItemsSource = db.Albums.ToList(); comboBoxSearch.DisplayMemberPath = "Title"; } } }
private void ButtonConfirm_Click(object sender, RoutedEventArgs e) { using (MusicContext db = new MusicContext()) { Album album = db.Albums.Find(editableAlbum.Id); if (album != null) { if (editableAlbum.Songs.Count == 0) { album.Songs.Clear(); } else { album.Songs.Clear(); album.Songs = editableAlbum.Songs; } } db.SaveChanges(); } this.Close(); }
private void ConfirmButton_Click(object sender, RoutedEventArgs e) { if (titleTextBox.Text != "" && urlTextBox.Text != "" && genreComboBox.SelectedIndex != -1 && authorComboBox.SelectedIndex != -1 && lengthTextBox.Text != "" && datePublishCalendar.SelectedDate != null && newAlbum.Image != null && songsExist == true) { using (MusicContext db = new MusicContext()) { newAlbum.Title = titleTextBox.Text; string authName = (authorComboBox.SelectedItem as Author).Name.ToString(); string authGenre = (genreComboBox.SelectedItem as Genre).Name; newAlbum.Author = db.Authors.FirstOrDefault(x => x.Name == authName); newAlbum.Genre = db.Genres.FirstOrDefault(x => x.Name == authGenre); newAlbum.Length = StringToSeconds(lengthTextBox.Text); newAlbum.Price = decimal.Parse(priceTextBox.Text); newAlbum.ShopUrl = urlTextBox.Text; } using (MusicContext db = new MusicContext()) { db.Albums.Add(newAlbum); db.SaveChanges(); songsExist = false; this.ShowMessageAsync("Alert", "Song successfully added"); } } }