public List <NotRentableCarDto> GetNotRentableCarDetails()
        {
            InMemoryCarDal      inMemoryCarDal      = new InMemoryCarDal();
            InMemoryBrandDal    inMemoryBrandDal    = new InMemoryBrandDal();
            InMemoryCustomerDal inMemoryCustomerDal = new InMemoryCustomerDal();
            InMemoryUserDal     inMemoryUserDal     = new InMemoryUserDal();

            List <Car>      _cars      = inMemoryCarDal.GetAll();
            List <Brand>    _brands    = inMemoryBrandDal.GetAll();
            List <Customer> _customers = inMemoryCustomerDal.GetAll();
            List <User>     _users     = inMemoryUserDal.GetAll();

            var result = from c in _cars
                         join r in _rentals on c.Id equals r.CarId  where r.ReturnDate == null
                         join cu in _customers on r.CustomerId equals cu.Id
                         join u in _users on cu.UserId equals u.Id
                         join b in _brands on c.BrandId equals b.Id

                         select new NotRentableCarDto
            {
                CarId       = c.Id,
                BrandName   = b.BrandName,
                CarName     = c.CarName,
                Description = c.Description,
                CompanyName = cu.CompanyName,
                FirstName   = u.FirstName,
                LastName    = u.LastName,
                ReturnDate  = r.ReturnDate
            };

            return(result.ToList());
        }
        public List <CarDetailDto> GetCarDetails()
        {
            InMemoryBrandDal brandDal = new InMemoryBrandDal();
            InMemoryColorDal colorDal = new InMemoryColorDal();

            var resault = from c in GetAll()
                          join b in brandDal.GetAll() on c.BrandId equals b.Id
                          join o in colorDal.GetAll() on c.ColorId equals o.Id

                          select new CarDetailDto
            {
                CarName     = c.CarName,
                BrandName   = b.BrandName,
                ColorName   = o.ColorName,
                DailyPrice  = c.DailyPrice,
                Description = c.Description
            };

            return(resault.ToList());
        }