private void buttonDeleceProduct_Click(object sender, EventArgs e)
{
{
try
{
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden emin misiniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
var db = new electronicShopDbContext();
//db.Categories.Remove();
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
}
}
private void buttonAddProduct_Click(object sender, EventArgs e)
{
var db = new electronicShopDbContext();
Product newProduct = new Product();
newProduct.Name = textBoxProductName.Text;
newProduct.Description = textBoxProductDescription.Text;
Category selectedCategory = new Category();
selectedCategory = db.Categories.ToList().Where <Category>(x => x.Name == comboBoxProductCategory.Text.Trim()).FirstOrDefault <Category>();
//newProduct.CategoryId = selectedCategory.Id;
newProduct.Category = selectedCategory;
db.Products.Add(newProduct);
int affectedRow = db.SaveChanges();
if (affectedRow > 0)
{
MessageBox.Show("Ürün eklendi.");
getProducts();
}
else
{
MessageBox.Show("Ürün ekleme başarısız.");
}
}
private void buttonDeleteCategory_Click(object sender, EventArgs e)
{
{
try
{
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
var db = new electronicShopDbContext();
Category newCategory = new Category();
newCategory = db.Categories.ToList().Where <Category>(x => x.Name == comboCategory.Text.Trim()).FirstOrDefault <Category>();
db.Categories.Remove(newCategory);
db.SaveChanges();
comboCategory.Text = "";
getCategories();
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
}
}
void getCategories()
{
var db = new electronicShopDbContext();
comboBoxProductCategory.Items.Clear();
foreach (var item in db.Categories.ToList())
{
comboBoxProductCategory.Items.Add(item.Name);
}
}
void getCategories()
{
var db = new electronicShopDbContext();
dataGridViewCategories.DataSource = db.Categories.ToList();
comboCategory.Items.Clear();
foreach (var item in db.Categories.ToList())
{
comboCategory.Items.Add(item.Name);
}
}
private void buttonAddCategory_Click(object sender, EventArgs e)
{
var db = new electronicShopDbContext();
Category newCategory = new Category();
newCategory.Name = textBoxCategoryName.Text;
newCategory.Desription = textBoxCategoryDescription.Text;
db.Categories.Add(newCategory);
int affectedRow = db.SaveChanges();
if (affectedRow > 0)
{
MessageBox.Show("Kategori eklendi.");
getCategories();
}
else
{
MessageBox.Show("Kategori ekleme başarısız.");
}
}
void getProducts()
{
var db = new electronicShopDbContext();
dataGridViewProducts.DataSource = db.Products.ToList();
}
void getCategories()
{
var db = new electronicShopDbContext();
dataGridViewCategories.DataSource = db.Categories.ToList();
}