public override bool create(ViewTransmissionCar obj) { transmission t = db.transmissions.Where(o => o.transmissionId == obj.transmissionId).FirstOrDefault(); if (t != null) { // obj is alredy existed return(false); } else { manualTransmission m = new manualTransmission(); m.manualTrans = obj.manualTrans; m = db.manualTransmissions.Add(m); db.SaveChanges(); transmission tmp = new transmission(); tmp.transPrice = obj.transPrice; tmp.autoTrans = obj.autoTrans; tmp.manualTrans = m.manualTransId; db.transmissions.Add(tmp); db.SaveChanges(); return(true); } }
public override bool update(ViewTransmissionCar obj) { // Find(id) выполнит запрос и найдет объект по этому ID transmission t = db.transmissions.Find(obj.transmissionId); if (t != null) { manualTransmission m = db.manualTransmissions.Find(obj.manualTransId); m.manualTrans = obj.manualTrans; db.SaveChanges(); t.transPrice = obj.transPrice; t.manualTrans = obj.manualTransId; t.autoTrans = obj.autoTrans; db.SaveChanges(); return(true); } else { return(false); } }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { int id = Convert.ToInt32(dataGridView1.CurrentRow.Cells["manualTransIdDataGridViewTextBoxColumn"].Value); manualTransmission m = db.manualTransmissions.Find(id); ViewTransmissionCar t = new ViewTransmissionCar(); t.manualTrans = m.manualTrans; t.manualTransId = m.manualTransId; caller.pickedTransmission = t; caller.picked = true; caller.tbTrans.Text = m.manualTrans; this.Close(); }