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); } }