//добавляем новый платеж(здесь только условия его добавления и привязка данных, остальная логика в триггере как и было в тз) private bool AddPayment() { using (var idk = new idkEntities()) { var order = idk.Orders.FirstOrDefault((p) => p.id == selectedOrder); var arrival = idk.Arrival.FirstOrDefault((p) => p.id == selecetedArrival); if (order.Total_Order_Amount > order.Amount_Paid || arrival.Remains > 0) { int lastID = idk.Payments.Count() > 0 ? idk.Payments.Max((p) => p.id) + 1 : 0; Payments payment = new Payments() { id = lastID, Arrival_id = selecetedArrival, Order_id = selectedOrder }; idk.Payments.Add(payment); idk.SaveChanges(); return(true); } return(false); } }
//Обновляем данные из бд private void UpdateDataGrids() { using (var idk = new idkEntities()) { OrdersDataGrid.ItemsSource = idk.Orders.ToList(); ArrivalsDataGrid.ItemsSource = idk.Arrival.ToList(); } }
private void FindOrderButton_Click(object sender, RoutedEventArgs e) { int.TryParse(OrderID_TB.Text, out int result); int SearchableID = result; using (var idk = new idkEntities()) { var order = idk.Orders.Where((p) => p.id == SearchableID); OrdersDataGrid.ItemsSource = order.ToList(); } }
private void FindArrivalButton_Click(object sender, RoutedEventArgs e) { int.TryParse(ArrivalID_TB.Text, out int result); int SearchableID = result; using (var idk = new idkEntities()) { var arrival = idk.Arrival.Where((p) => p.id == SearchableID); ArrivalsDataGrid.ItemsSource = arrival.ToList(); } }