private void btnAdd_Click(object sender, RoutedEventArgs e)
{
using (var ctx = new MusicStoreContext())
{
Order order = new Order();
order.Music = ctx.Musics.Where(m => m.id == musicId).FirstOrDefault();
order.User = ctx.Users.Where(u => u.Id == loginUserId).FirstOrDefault();
ctx.Orders.Add(order);
ctx.SaveChanges();
MessageBox.Show("One Music Added to Cart");
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
dynamic row = dataGrid.SelectedItem;
int selectedOrderId = row.Id;
using (var ctx = new MusicStoreContext())
{
Order order = ctx.Orders.Where(o => o.Id == selectedOrderId).FirstOrDefault();
ctx.Orders.Remove(order);
ctx.SaveChanges();
bindData();
}
}
private void btSave_Click(object sender, RoutedEventArgs e)
{
using (var ctx = new MusicStoreContext())
{
Music m1 = ctx.Musics.Where(m => m.id == id).FirstOrDefault();
m1.id = id;
m1.musicName = tbName.Text;
m1.album = tbAlbum.Text;
m1.artist = tbArtist.Text;
m1.available = bool.Parse(tbAvailable.Text);
ctx.SaveChanges();
MessageBox.Show("Edited Successful");
ManageMusic manageMusic = new ManageMusic();
manageMusic.Show();
this.Close();
}
}
private void btSave_Click(object sender, RoutedEventArgs e)
{
using (var ctx = new MusicStoreContext())
{
Music m1 = new Music()
{
musicName = tbName.Text,
album = tbAlbum.Text,
artist = tbArtist.Text,
available = bool.Parse(tbAvailable.Text)
};
ctx.Musics.Add(m1);
ctx.SaveChanges();
MessageBox.Show("Add to Database Successful");
tbName.Clear();
tbAlbum.Clear();
tbArtist.Clear();
tbAvailable.Clear();
}
}