private void PaymentScreen_Load(object sender, EventArgs e)
{
SardirimRest_DBEntities db = new SardirimRest_DBEntities();
IQueryable <Order> orders = db.Orders.Where(x => x.PaymentStatusID == 1 && x.PaymentStatusID != 3);
foreach (var order in orders)
{
ListViewItem lst = new ListViewItem();
lst.Text = order.OrderID.ToString();
lst.SubItems.Add(order.Table.TableName);
lst.SubItems.Add(order.Customer.CustomerName);
if (order.PaymentStatusID == 1)
{
lst.SubItems.Add("Ödenmedi");
}
lst.SubItems.Add(order.Bills.Sum(x => x.BillAmount).ToString());
lstPaymenStatus.Items.Add(lst);
}
}