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 virtual List <T> GetAll()
 {
     return(DbSet.ToList());
 }
Example #3
0
 public virtual IEnumerable <TEntity> GetAll()
 {
     // return DbSet.Take(t).Skip(s).ToList();
     return(DbSet.ToList());
 }
Example #4
0
 public virtual System.Collections.Generic.List <TEntity> GetAll()
 {
     return(DbSet.ToList());
 }