private static List <OrderTable> GetOrderListForTable() { List <OrderTable> list = new List <OrderTable>(); var orders = ConnectToDB.GetOrderList(); foreach (var v in orders) { OrderTable o = new OrderTable(); Employee employee = ConnectToDB.GetEmployee(v.AuthorId); o.ClientName = v.Name; o.Number = v.Id; o.OrderDate = v.Date; o.OrderNumber = v.Number; o.SellerSurname = employee.Surname; list.Add(o); } return(list); }
private void addOrderButton_Click(object sender, RoutedEventArgs e) { if (this.clientTextBox.Text == "") { MessageBox.Show("Укажите заказчика."); return; } Order order = new Order(); Employee employee = ConnectToDB.GetEmployee(this.sellerComboBox.Text); order.AuthorId = employee.Id; order.Name = this.clientTextBox.Text; order.Number = (new Random()).Next(1, 10000); order.Date = DateTime.Now; if (!ConnectToDB.AddOrder(order)) { MessageBox.Show("Ошибка. Заказ не добавлен."); return; } MessageBox.Show("Заказ добавлен."); this.clientTextBox.Text = ""; this.ordersGrid.ItemsSource = ConnectToDB.GetOrderList(); }