public List <UnpaidRental> GetUnpaid() { List <UnpaidRental> unpaidRentals = new List <UnpaidRental>(); Microsoft.EntityFrameworkCore.DbSet <Rental> rentals = context.Rentals; foreach (Rental rental in rentals.ToList()) { if (rental.TotalAmount > 0 && rental.RentalEnd != null && rental.Paid == false) { Customer customerFromDb = context.Customers.ToList().Find(c => c.CustomerId == rental.CustomerId); if (customerFromDb == null) { throw new CustomerNotExistingException(); } UnpaidRental ur = new UnpaidRental { CustomerId = customerFromDb.CustomerId, Firstname = customerFromDb.Firstname, Lastname = customerFromDb.Lastname, RentalId = rental.RentalId, RentalBegin = rental.RentalBegin, RentalEnd = rental.RentalEnd }; unpaidRentals.Add(ur); } } return(unpaidRentals); }
public async Task <List <UnpaidRental> > GetUnpaidRental() { List <UnpaidRental> unpaidRentals = new List <UnpaidRental>(); var rentals = _context.Rentals.Where(r => r.Paid == false); foreach (var rental in rentals) { if (rental.TotalCosts > 0) { UnpaidRental u = new UnpaidRental(); u.RentaldId = rental.RentalID; u.Firstname = rental.Customer.FirstName; u.Lastname = rental.Customer.LastName; u.Start = rental.RentBegin; u.End = rental.RentEnd.Value; u.CustomerId = rental.CustomerID; u.TotalPrice = rental.TotalCosts.Value; unpaidRentals.Add(u); } } return(unpaidRentals); }