public void LoadDisks() { musicListView.Items.Clear(); List <Disk> disks = db.Disks.ToList(); DiskView d = null; double percent = 0; decimal money = 0; foreach (Disk disk in disks) { d = new DiskView(); d.DiskId = disk.Id; d.Name = disk.Name; d.BandName = db.Bands.FirstOrDefault(p => p.Id == disk.BandId).Name; d.BandId = disk.BandId; d.GenreName = db.Genres.FirstOrDefault(p => p.Id == disk.GenreId).Name; d.GenreId = disk.GenreId; d.PublisherName = db.Publishers.FirstOrDefault(p => p.Id == disk.PublisherId).Name; d.PublisherId = disk.PublisherId; d.PublishYear = disk.PublishYear; percent = db.Prices.FirstOrDefault(p => p.DiskId == disk.Id).Percent / 100.0; money = disk.SelfPrice + disk.SelfPrice * Convert.ToDecimal(percent); d.Money = money; d.DiskSelfPrice = disk.SelfPrice; d.Amount = db.Storages.FirstOrDefault(s => s.DiskId == disk.Id).Amount; musicListView.Items.Add(d); } }
private void BtnDiskFind_Click(object sender, RoutedEventArgs e) { musicListView.Items.Clear(); DiskView d = null; double percent = 0; decimal money = 0; foreach (Disk disk in db.Disks.Where(c => c.Name == BoxDiscName.Text)) { d = new DiskView(); d.DiskId = disk.Id; d.Name = disk.Name; d.BandName = db.Bands.FirstOrDefault(p => p.Id == disk.BandId).Name; d.BandId = disk.BandId; d.GenreName = db.Genres.FirstOrDefault(p => p.Id == disk.GenreId).Name; d.GenreId = disk.GenreId; d.PublisherName = db.Publishers.FirstOrDefault(p => p.Id == disk.PublisherId).Name; d.PublisherId = disk.PublisherId; d.PublishYear = disk.PublishYear; percent = db.Prices.FirstOrDefault(p => p.DiskId == disk.Id).Percent / 100.0; money = disk.SelfPrice + disk.SelfPrice * Convert.ToDecimal(percent); d.Money = money; d.DiskSelfPrice = disk.SelfPrice; d.Amount = db.Storages.FirstOrDefault(s => s.DiskId == disk.Id).Amount; musicListView.Items.Add(d); } }
private void ResultShowDiskList(List <DiskSource> diskSources) { DiskView.BeginUpdate(); DiskView.Items.Clear(); foreach (var sourceItem in diskSources) { //1st var lvi = new ListViewItem(sourceItem.Name); lvi.UseItemStyleForSubItems = false; //2nd lvi.SubItems.Add(sourceItem.Format); //3rd lvi.SubItems.Add(sourceItem.AvailableSpace); //4th lvi.SubItems.Add(sourceItem.TotalSize); //5th lvi.SubItems.Add(sourceItem.Usage); lvi.SubItems[4].BackColor = sourceItem.StatusColor; //5th lvi.SubItems.Add(sourceItem.limitPercentage.ToString()); DiskView.Items.Add(lvi); } DiskView.EndUpdate(); DiskView.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); DiskView.GridLines = Enabled; }
private void MusicListView_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (musicListView.SelectedItem != null) { DiskView diskView = musicListView.SelectedItem as DiskView; BoxDiscName.Text = diskView.Name; ComboDiskBand.SelectedItem = db.Bands.FirstOrDefault(b => b.Id == diskView.BandId); ComboDiskGenre.SelectedItem = db.Genres.FirstOrDefault(g => g.Id == diskView.GenreId); ComboDiskPublisher.SelectedItem = db.Publishers.FirstOrDefault(p => p.Id == diskView.PublisherId); BoxDiskYear.Text = diskView.PublishYear.ToString(); BoxDiskMoney.Text = diskView.DiskSelfPrice.ToString();//db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId).SelfPrice.ToString(); BoxPricePercent.Text = db.Prices.FirstOrDefault(p => p.DiskId == diskView.DiskId).Percent.ToString(); BoxStorageAmount.Text = db.Storages.FirstOrDefault(s => s.DiskId == diskView.DiskId).Amount.ToString(); } }
private void BtnDiskEdit_Click(object sender, RoutedEventArgs e) { DiskView diskView = musicListView.SelectedItem as DiskView; int bandId = db.Bands.FirstOrDefault(b => b.Name == ComboDiskBand.Text).Id; int genreId = db.Genres.FirstOrDefault(b => b.Name == ComboDiskGenre.Text).Id; int publisherId = db.Publishers.FirstOrDefault(b => b.Name == ComboDiskPublisher.Text).Id; db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId).Name = BoxDiscName.Text; db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId).BandId = bandId; db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId).GenreId = genreId; db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId).PublisherId = publisherId; db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId).PublishYear = Convert.ToInt32(BoxDiskYear.Text); db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId).SelfPrice = Convert.ToDecimal(BoxDiskMoney.Text); db.Storages.FirstOrDefault(s => s.DiskId == diskView.DiskId).Amount = Convert.ToInt32(BoxStorageAmount.Text); db.Prices.FirstOrDefault(p => p.DiskId == diskView.DiskId).Percent = Convert.ToDouble(BoxPricePercent.Text); db.SaveChanges(); LoadDisks(); }
private void BtnDiskDelete_Click(object sender, RoutedEventArgs e) { DiskView diskView = new DiskView(); diskView = musicListView.SelectedItem as DiskView; Storage storage = db.Storages.FirstOrDefault(s => s.DiskId == diskView.DiskId); db.Storages.Remove(storage); Price price = db.Prices.FirstOrDefault(p => p.DiskId == diskView.DiskId); db.Prices.Remove(price); if (db.DiscountDisks.Where(d => d.DiskId == diskView.DiskId).Count() > 0) { DiscountDisk discount = db.DiscountDisks.FirstOrDefault(d => d.DiskId == diskView.DiskId); db.DiscountDisks.Remove(discount); } Disk disk = db.Disks.FirstOrDefault(d => d.Id == diskView.DiskId); db.Disks.Remove(disk); db.SaveChanges(); LoadDisks(); }