//добавляем новый платеж(здесь только условия его добавления и привязка данных, остальная логика в триггере как и было в тз)
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();
}
}
