private void cmbKategori_SelectedIndexChanged(object sender, EventArgs e) { if (cmbKategori.SelectedItem == null) { return; } CategoryViewModel cat = cmbKategori.SelectedItem as CategoryViewModel; var db = new NorthEntities(); var sorgu = db.Categories .First(x => x.CategoryID == cat.CategoryID) .Products .Select(x => new ProductViewModel { ProductID = x.ProductID, ProductName = x.ProductName, UnitPrice = x.UnitPrice }) .OrderBy(x => x.ProductName) .ToList(); // lstUrunler.DataSource = db.Products.Where(x => x.CategoryID == cat.CategoryID).OrderBy(x => x.ProductName).ToList(); // lstUrunler.DisplayMember = "ProductName"; lstUrunler.DataSource = sorgu; gbUrun.Visible = sorgu.Count > 0; }
private void btnKatKaydet_Click(object sender, EventArgs e) { try { var db = new NorthEntities(); db.Categories.Add(new Category() { CategoryName = string.IsNullOrEmpty(txtKategoriAdi.Text) ? null: txtKategoriAdi.Text, Description = txtAciklama.Text, }); var sonuc = db.SaveChanges(); MessageBox.Show($@"{sonuc} kayit eklendi."); KategorileriGetir(); } catch (DbEntityValidationException dbEx) { foreach (var validationError in dbEx.EntityValidationErrors) { foreach (var error in validationError.ValidationErrors) { if (error.PropertyName == "CategoryName") { ep1.SetError(txtKategoriAdi, error.ErrorMessage); } } } MessageBox.Show(EntityHelper.ValidationMessage(dbEx), @"Bir Hata Olustu", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void KategorileriGetir() { NorthEntities db = new NorthEntities(); var kategoriler1 = db.Categories .OrderBy(category => category.CategoryName) .Select(x => new CategoryViewModel { CategoryID = x.CategoryID, CategoryName = x.CategoryName, ProductCount = x.Products.Count }) .ToList(); var kategoriler2 = db.Categories .OrderBy(category => category.CategoryName) .Select(x => new CategoryViewModel { CategoryID = x.CategoryID, CategoryName = x.CategoryName, ProductCount = x.Products.Count }) .ToList(); cmbUrunKategori.DataSource = kategoriler2; cmbKategori.DataSource = kategoriler1; }
private void silToolStripMenuItem_Click(object sender, EventArgs e) { if (lstUrunler.SelectedItem == null) { return; } var urunId = (lstUrunler.SelectedItem as ProductViewModel).ProductID; var cevap = MessageBox.Show("Secili urunu silmek istiyor musunuz?", "Uyarı!", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (cevap != DialogResult.Yes) { return; } try { var db = new NorthEntities(); var urun = db.Products.Find(urunId); db.Products.Remove(urun); MessageBox.Show($"{db.SaveChanges()} kayıt silindi."); KategorileriGetir(); } catch (DbUpdateException) { MessageBox.Show("Silmek istediginiz kayıt baska bir tabloda bulundugu icin silemezsiniz.", "Hata", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnUrunGuncelle_Click(object sender, EventArgs e) { try { ep1.Clear(); var db = new NorthEntities(); var seciliUrun = lstUrunler.SelectedItem as ProductViewModel; var urun = db.Products.Find(seciliUrun.ProductID); urun.ProductName = txtUrunAdi.Text; urun.UnitPrice = nuFiyat.Value; urun.CategoryID = (cmbUrunKategori.SelectedItem as CategoryViewModel).CategoryID; int sonuc = db.SaveChanges(); KategorileriGetir(); MessageBox.Show($"{sonuc} urun guncellendi."); } catch (DbEntityValidationException dbEx) { foreach (var validationError in dbEx.EntityValidationErrors) { foreach (var error in validationError.ValidationErrors) { if (error.PropertyName == "ProductName") { ep1.SetError(txtUrunAdi, error.ErrorMessage); } } } MessageBox.Show(EntityHelper.ValidationMessage(dbEx), @"Bir Hata Olustu", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void lstUrunler_SelectedIndexChanged(object sender, EventArgs e) { if (lstUrunler.SelectedItem == null) { return; } var seciliUrun = lstUrunler.SelectedItem as ProductViewModel; var db = new NorthEntities(); var urun = db.Products.Find(seciliUrun.ProductID); txtUrunAdi.Text = urun.ProductName; nuFiyat.Value = urun.UnitPrice ?? 0; var katId = urun.CategoryID; cmbUrunKategori.SelectedItem = katId; var uruncatList = cmbUrunKategori.DataSource as List <CategoryViewModel>; foreach (var item in uruncatList) { if (item.CategoryID == urun.CategoryID) { cmbUrunKategori.SelectedItem = item; break; } } }