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