public IEnumerable <PublishedBook> GetPublishedBookByBookId(int bookId) { var bookRepository = new BookRepository(dapperConnectionFactory); var publishingHouseRepository = new PublishingHouseRepository(dapperConnectionFactory); IEnumerable <PublishedBook> publishedBookList = GetList().Where(pb => pb.Book_Id == bookId); publishedBookList.ToList().ForEach(pb => { pb.PublishingHouse = pb.PublishingHouse_Id.HasValue ? publishingHouseRepository.Get(pb.PublishingHouse_Id.Value) : null; pb.Book = pb.Book_Id.HasValue ? bookRepository.Get(pb.Book_Id.Value) : null; }); return(publishedBookList); }
public IEnumerable <GetPeriodicalResponseModel> GetPeriodicalResponseModelList(int skip, int take) { IEnumerable <Periodical> periodicalList = GetList(skip, take); var periodicalEditionsRepo = new PeriodicalEditionRepository(dapperConnectionFactory); var publishingHouseRepo = new PublishingHouseRepository(dapperConnectionFactory); IEnumerable <GetPeriodicalResponseModel> response = periodicalList.Select(periodical => { return(new GetPeriodicalResponseModel { Id = periodical.Id, Foundation = periodical.Foundation, IsPublished = periodical.IsPublished, ISSN = periodical.ISSN, Name = periodical.Name, PublishingHouse_Id = periodical.PublishingHouse_Id, PeriodicalEditions = periodicalEditionsRepo.GetPeriodicalEditionByPeriodicalId(periodical.Id), PublishingHouse = periodical.PublishingHouse_Id.HasValue ? publishingHouseRepo.Get(periodical.PublishingHouse_Id.Value) : null }); }); return(response); }