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();
}
}
}
