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