public void KategoriesAdd(Kategories kategories) { Context db = new Context(); db.kategories.Add(kategories); db.SaveChanges(); }
private void button1_Click(object sender, EventArgs e) { if (comboBox1.SelectedIndex == 0) { Kategories kategories = new Kategories { name = textBox1.Text }; kategories.KategoriesAdd(kategories); kategoriesDataGridFill(); } else if (comboBox1.SelectedIndex == 1) { Manufacturer manufacturer = new Manufacturer { companyName = textBox1.Text, county = textBox2.Text, yearsOfCooperation = Convert.ToInt32(textBox3.Text) }; manufacturer.ManufacturerAdd(manufacturer); manufactureDataGridFill(); } else if (comboBox1.SelectedIndex == 2) { Furniture furniture = new Furniture(); furniture.FurnitureAdd(Convert.ToInt32(textBox1.Text), Convert.ToInt32(textBox2.Text), Convert.ToInt32(textBox3.Text)); furnitureDataGridFill(); } else if (comboBox1.SelectedIndex == 3) { Delivery delivery = new Delivery(); delivery.DeliveryAdd(textBox1.Text, textBox2.Text, Convert.ToInt32(textBox3.Text)); deliveryDataGridFill(); } }
public void FurnitureAdd(int price, int IdK, int IdM) { Context db = new Context(); Kategories a = db.kategories.Find(IdK); Manufacturer b = db.manufacturers.Find(IdM); Furniture furniture = new Furniture { kategories = a, manufacturer = b, Price = price }; db.furnitures.Add(furniture); db.SaveChanges(); }
private void Grid_CellContentClick(object sender, DataGridViewCellEventArgs e) { Context db = new Context(); if (e.ColumnIndex == 0) { if (comboBox1.SelectedIndex == 0) { int i = 0; Kategories kategories = new Kategories(); foreach (var a in db.kategories) { if (i == e.RowIndex - 1) { kategories = a; } i++; } db.kategories.Remove(kategories); db.SaveChanges(); kategoriesDataGridFill(); } else if (comboBox1.SelectedIndex == 1) { int i = 0; Manufacturer manufacturer = new Manufacturer(); foreach (var a in db.manufacturers) { if (i == e.RowIndex - 1) { manufacturer = a; } i++; } db.manufacturers.Remove(manufacturer); db.SaveChanges(); manufactureDataGridFill(); } else if (comboBox1.SelectedIndex == 2) { int i = 0; Furniture furniture = new Furniture(); foreach (var a in db.furnitures) { if (i == e.RowIndex - 1) { furniture = a; } i++; } db.furnitures.Remove(furniture); db.SaveChanges(); furnitureDataGridFill(); } else if (comboBox1.SelectedIndex == 3) { int i = 0; Delivery delivery = new Delivery(); foreach (var a in db.deliveries) { if (i == e.RowIndex - 1) { delivery = a; } i++; } db.deliveries.Remove(delivery); db.SaveChanges(); deliveryDataGridFill(); } } }