private void Window_Loaded(object sender, RoutedEventArgs e) { using (var ctx = new MusicStoreContext()) { musicsNumber = ctx.Musics.Where(m => m.available == true).Count(); Music m1 = ctx.Musics.Where(m => m.available == true).FirstOrDefault(); tbSong.Text = m1.musicName; tbAlbum.Text = m1.album; tbArtist.Text = m1.artist; } }
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 btnPrivious_Click(object sender, RoutedEventArgs e) { if (counter > 0) { counter--; using (var ctx = new MusicStoreContext()) { List <Music> fetchMusicList = ctx.Musics.Where(m => m.available == true).ToList(); tbSong.Text = fetchMusicList[counter].musicName; tbAlbum.Text = fetchMusicList[counter].album; tbArtist.Text = fetchMusicList[counter].artist; musicId = fetchMusicList[counter].id; } } }
private void Button_Click(object sender, RoutedEventArgs e) { using (var ctx = new MusicStoreContext()) { string uName = tbUserName.Text.Trim(); string pwd = tbPassword.Text.Trim(); bool isAdmin = rbAdmin.IsChecked ?? false; List <User> list1 = ctx.Users.Where(u => u.UserName == uName).ToList(); if (list1.Count >= 1) { User loginUser = ctx.Users.Where(u => u.UserName == uName).FirstOrDefault(); loginUserId = loginUser.Id; List <User> list2 = ctx.Users.Where(u => u.UserName == uName && u.PassWord == pwd).ToList(); if (list2.Count >= 1) { if (isAdmin == false) { Window1 BuyMusic = new Window1(); BuyMusic.loginUserId = loginUserId; this.Close(); BuyMusic.Show(); } else { ManageMusic manageMusic = new ManageMusic(); this.Close(); manageMusic.Show(); } } else { MessageBox.Show("Either the user name or password entered is incorrect."); } } else { MessageBox.Show("Either the user name or password entered is incorrect."); } //int howManyUsers = ctx.Users.Count(); //User u1 = new User() { UserName = "******", PassWord = "******", isAdmin = true }; //ctx.Users.Add(u1); //ctx.SaveChanges(); } }
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(); } }
protected void Application_Start() { AreaRegistration.RegisterAllAreas(); RouteConfig.RegisterRoutes(RouteTable.Routes); UnityConfig.RegisterComponents(); Database.SetInitializer(new MigrateDatabaseToLatestVersion <MusicStoreContext, Migrations.Configuration>()); Database.SetInitializer(new MigrateDatabaseToLatestVersion <AppDbContext, Migrations.UserConfiguration>()); using (var context = new MusicStoreContext()) { context.Database.Initialize(true); } using (var context = new AppDbContext()) { context.Database.Initialize(true); } //Database.SetInitializer<MusicStore.Models.MusicStoreContext>(InitialCreate); }
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(); } }
public MySqlHealthContributor(MusicStoreContext dbContext, ILogger <MySqlHealthContributor> logger) { _context = dbContext; _logger = logger; }