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");
}
}
}
