private void chdnge_button_Click(object sender, EventArgs e) { using (CarSalonContext db = new CarSalonContext()) { List <Car> li = new List <Car>(); Car ca = new Car(); ca.update(li); int index = AllCarsTable.CurrentCell.RowIndex; li[index].Mark = Mark_t.Text; List <Car> l = new List <Car>(); ca.update(l); int val = li[index].IdCar; ca = db.Car .Where(j => j.IdCar == val) .FirstOrDefault(); ca.Mark = li[index].Mark; db.SaveChanges(); ca.update(li); } }
private void delete_button_Click(object sender, EventArgs e) { using (CarSalonContext db = new CarSalonContext()) { List <Car> l = new List <Car>(); Contract con = new Contract(); Car cc = new Car(); cc.update(l); foreach (DataGridViewRow drv in AllCarsTable.SelectedRows) { int index = drv.Index; int val = l[index].IdCar; con = db.Contract .Where(j => j.Car == val) .FirstOrDefault(); db.Contract.Remove(con); cc = db.Car .Where(j => j.IdCar == val) .FirstOrDefault(); db.Car.Remove(cc); db.SaveChanges(); cc.update(l); AllCarsTable.DataSource = l; break; } } }
public void addCar(string mark_t, DateTime year_t, int mileage_t, int price_t, string size_t, string desc_t) { using (CarSalonContext db = new CarSalonContext()) { Car car = new Car(); car.Mark = mark_t; car.IssueYear = Convert.ToDateTime(year_t); car.Mileage = mileage_t; car.Price = Convert.ToDecimal(price_t); car.Size = size_t; car.Description = desc_t; db.Car.Add(car); db.SaveChanges(); } }