private void Add_Click(object sender, EventArgs e) { AddOrderForm aoForm = new AddOrderForm(); using (var context = new MyDbContext()) { List <Client> clients = context.Clients.ToList(); aoForm.OrderClient.DataSource = clients; aoForm.OrderClient.ValueMember = "Id"; aoForm.OrderClient.DisplayMember = "FullName"; List <Tour> tours = context.Tours.ToList(); aoForm.OrderTour.DataSource = tours; aoForm.OrderTour.ValueMember = "Id"; aoForm.OrderTour.DisplayMember = "Country"; DialogResult result = aoForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } var order = new Order { Client = (Client)aoForm.OrderClient.SelectedItem, Tour = (Tour)aoForm.OrderTour.SelectedItem, Date = aoForm.OrderDate.Value.ToString(), Time = (int)aoForm.OrderTime.Value }; context.Orders.Add(order); context.SaveChanges(); context.Clients.Load(); context.Tours.Load(); context.Orders.Load(); dataGridView1.DataSource = context.Orders.Local.ToBindingList(); } }
private void Edit_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 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; } using (var context = new MyDbContext()) { Order order = context.Orders.Find(id); AddOrderForm aoForm = new AddOrderForm(); List <Client> clients = context.Clients.ToList(); aoForm.OrderClient.DataSource = clients; aoForm.OrderClient.ValueMember = "Id"; aoForm.OrderClient.DisplayMember = "FullName"; List <Tour> tours = context.Tours.ToList(); aoForm.OrderTour.DataSource = tours; aoForm.OrderTour.ValueMember = "Id"; aoForm.OrderTour.DisplayMember = "Country"; if (order.Client != null) { aoForm.OrderClient.SelectedValue = order.Client.Id; } if (order.Tour != null) { aoForm.OrderTour.SelectedValue = order.Tour.Id; } aoForm.OrderTime.Value = order.Time; aoForm.OrderDate.Value = Convert.ToDateTime(order.Date); DialogResult result = aoForm.ShowDialog(this); if (result == DialogResult.Cancel) { return; } order.Client = (Client)aoForm.OrderClient.SelectedItem; order.Tour = (Tour)aoForm.OrderTour.SelectedItem; order.Date = aoForm.OrderDate.Value.ToString(); order.Time = (int)aoForm.OrderTime.Value; context.Entry(order).State = EntityState.Modified; context.SaveChanges(); context.Orders.Load(); context.Clients.Load(); context.Tours.Load(); dataGridView1.DataSource = context.Orders.Local.ToBindingList(); } } }