//JOIN AND GROUPED TABLES FOR PRESENTING BETWEEN 2 DATES RECEIVABLE ORDERS
private void BtnShowReceiv_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrWhiteSpace(DpStart.ToString()) || string.IsNullOrWhiteSpace(DpEnd.ToString()))
{
MessageBox.Show("Tarixlər seçilməmişdir !");
return;
}
var query = from ef in _context.BookOrders
join p in _context.Books
on ef.BookId equals p.Id
join s in _context.Orders
on ef.OrderId equals s.Id
join t in _context.Customers
on s.CustomerId equals t.Id
where s.CreatedAt.Date >= DpStart.SelectedDate
where s.DeadLine.Date <= DpEnd.SelectedDate
where s.PaymentStatus == false
group s by new
{
s.Customer.Name,
s.Customer.Surname,
s.Customer.Phone,
s.Customer.Email,
s.CreatedAt,
s.DeadLine,
s.Fine,
s.Quantity,
s.TotalPrice,
p.BookName
}
into g
select new
{
g.Key.Name,
g.Key.Surname,
g.Key.Phone,
g.Key.Email,
g.Key.CreatedAt,
g.Key.DeadLine,
g.Key.Fine,
Quantity = g.Sum(x => x.Quantity),
g.Key.TotalPrice,
g.Key.BookName,
};
DgtReport.ItemsSource = query.ToList();
BtnSaveAs.Visibility = Visibility.Visible;
}
public WorkTimeRangeAddView()
{
InitializeComponent();
DpStart.Focus();
}
