private void add_data() { if (db.Avtos.Any()) { return; } else { Engine engine = new Engine(); engine.EngineID = 1; engine.Type_Engine = "Дизель"; Engine engine1 = new Engine(); engine1.EngineID = 2; engine1.Type_Engine = "Бензин"; Engine engine2 = new Engine(); engine2.EngineID = 3; engine2.Type_Engine = "Газ"; Type_Body body = new Type_Body(); body.Type_BodyID = 1; body.NameBody = "Пикап"; Type_Body body1 = new Type_Body(); body1.Type_BodyID = 2; body1.NameBody = "Универсал"; Type_Body body2 = new Type_Body(); body2.Type_BodyID = 3; body2.NameBody = "Седан"; Avto avto = new Avto(); avto.Model = "Opel"; avto.Marka = "Turbo"; avto.Color = "Gold"; avto.Count_Doors = 2; avto.Type_BodyID = 3; avto.EngineID = 1; db.Engines.Add(engine); db.Engines.Add(engine1); db.Engines.Add(engine2); db.Type_Bodies.Add(body); db.Type_Bodies.Add(body1); db.Type_Bodies.Add(body2); db.Avtos.Add(avto); db.SaveChanges(); } }
private void button1_Add_Click(object sender, EventArgs e) { Avto avto = new Avto { Model = textBoxModel.Text, Marka = textBoxMarka.Text, EngineID = getEngine, Type_BodyID = getBody, Count_Doors = Convert.ToInt32(CountDoors.Text), Color = textBoxColor.Text }; db.Avtos.Add(avto); db.SaveChanges(); this.Close(); }
private void buttonDelete_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows[0].Index > 0) { int index = dataGridView1.SelectedRows[0].Index; int id = 0; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) { return; } Avto avto = db.Avtos.Find(id); db.Avtos.Remove(avto); db.SaveChanges(); Refresh(); } }
private void buttonEdit_Click(object sender, EventArgs e) { int index; try { index = dataGridView1.SelectedRows[0].Index; } catch { index = 0; } int id; bool converted = Int32.TryParse(dataGridView1[0, index].Value.ToString(), out id); if (converted == false) { return; } Avto avto = db.Avtos.Find(id); Form_Add edit = new Form_Add(); edit.getModel = avto.Model; edit.getMarka = avto.Marka; edit.getColor = avto.Color; edit.getCountDoors = avto.Count_Doors; edit.getEngine = avto.EngineID; edit.getBody = avto.Type_BodyID; edit.buttonUpdate.Visible = true; edit.button1_Add.Visible = false; edit.ShowDialog(); avto.Model = edit.getModel; avto.Marka = edit.getMarka; avto.Color = edit.getColor; avto.Count_Doors = edit.getCountDoors; avto.EngineID = edit.getEngine; avto.Type_BodyID = edit.getBody; db.SaveChanges(); Refresh(); }