public List <NewspaperViewModel> GetNewspapers()
{
var a = _newspaperRepository.GetAll().ToList();
var res = a.Select(b =>
new NewspaperViewModel
{
Id = b.Id,
Name = b.Name,
Date = b.Date,
Authors = (from at in _authorRepository.GetAll().ToList()
from na in _newspaperAuthorRepository.GetAll().ToList()
where na.NewspaperId == b.Id
where na.AuthorId == at.Id
select new AuthorViewModel {
Id = at.Id, FullName = at.Name + " " + at.Surname
}).ToList(),
PublishingHouses = (from ph in _publishingHouseRepository.GetAll().ToList()
from bph in _newspaperPublishingHouseRepository.GetAll().ToList()
where bph.NewspaperId == b.Id
where bph.PublishingHouseId == ph.Id
select new PublishingHouseViewModel {
Id = ph.Id, Name = ph.Name
}).ToList()
}).ToList();
return(res);
}
public List <JournalViewModel> GetJournals()
{
var a = _journalRepository.GetAll().ToList();
var res = a.Select(b =>
new JournalViewModel
{
Id = b.Id,
Name = b.Name,
Date = b.Date,
Authors = (from at in _authorRepository.GetAll().ToList()
from ba in _journalAuthorRepository.GetAll().ToList()
where ba.JournalId == b.Id
where ba.AuthorId == at.Id
select new AuthorViewModel {
Id = at.Id, FullName = at.Name + " " + at.Surname
}).ToList(),
PublishingHouses = (from ph in _publishingHouseRepository.GetAll().ToList()
from bph in _journalPublishingHouseRepository.GetAll().ToList()
where bph.JournalId == b.Id
where bph.PublishingHouseId == ph.Id
select new PublishingHouseViewModel {
Id = ph.Id, Name = ph.Name
}).ToList()
}).ToList();
return(res);
}
public List <PublishingHouseViewModel> GetPublishingHouses()
{
var publishingHouses = _publishingHouseRepository.GetAll().ToList();
var res = publishingHouses.Select(b =>
new PublishingHouseViewModel
{
Id = b.Id,
Name = b.Name,
}).ToList();
return(res);
}
public IEnumerable <PublishingHouse> GetAll()
{
return(_publishingHouseRepository.GetAll());
}
public IEnumerable <PublishingHouseViewModel> GetAllPublisingHouse()
{
return(_publishingHouseRepository.GetAll().Select(p => new PublishingHouseViewModel(p)));
}