public async Task <IActionResult> GetPublisher([FromRoute] int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var publisher = await _context.Publisher.Include(pb => pb.VideoGames).FirstAsync(pb => pb.PubId == id);
if (publisher == null)
{
return(NotFound());
}
PublisherDTO dto = new PublisherDTO()
{
PubID = publisher.PubId,
Name = publisher.Name,
VideoGames = new List <VideoGamesDTO>()
};
foreach (VideoGames vg in publisher.VideoGames)
{
VideoGamesDTO vgdto = new VideoGamesDTO()
{
VideoGamesID = vg.Id,
Title = vg.Title,
System = vg.System,
ReleaseDate = vg.ReleaseDate,
ESRB = vg.Esrb,
Publisher = vg.Publisher,
Developer = vg.Developer
};
dto.VideoGames.Add(vgdto);
}
return(Ok(dto));
}
public async Task <IActionResult> GetEsrb([FromRoute] int id)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var esrb = await _context.Esrb.Include(es => es.VideoGames).FirstAsync(es => es.Esrbid == id);
if (esrb == null)
{
return(NotFound());
}
ESRBDTO esdto = new ESRBDTO()
{
ESRBID = esrb.Esrbid,
Rating = esrb.Rating,
VideoGames = new List <VideoGamesDTO>()
};
foreach (VideoGames vg in esrb.VideoGames)
{
VideoGamesDTO vgdto = new VideoGamesDTO()
{
VideoGamesID = vg.Id,
Title = vg.Title,
System = vg.System,
ReleaseDate = vg.ReleaseDate,
ESRB = vg.Esrb,
Publisher = vg.Publisher,
Developer = vg.Developer
};
esdto.VideoGames.Add(vgdto);
}
return(Ok(esdto));
}
public IEnumerable <PublisherDTO> GetPublisher()
{
List <Publisher> publishers = _context.Publisher.Include(pb => pb.VideoGames).ToList();
List <PublisherDTO> publisherDTOList = new List <PublisherDTO>();
foreach (Publisher pb in publishers)
{
List <VideoGamesDTO> videogamesDTOList = new List <VideoGamesDTO>();
foreach (VideoGames vg in pb.VideoGames)
{
VideoGamesDTO vgDTO = new VideoGamesDTO()
{
VideoGamesID = vg.Id,
Title = vg.Title,
System = vg.System,
ReleaseDate = vg.ReleaseDate,
ESRB = vg.Esrb,
Publisher = vg.Publisher,
Developer = vg.Developer
};
videogamesDTOList.Add(vgDTO);
}
PublisherDTO dto = new PublisherDTO()
{
PubID = pb.PubId,
Name = pb.Name
};
publisherDTOList.Add(dto);
}
return(publisherDTOList);
}
public IEnumerable <ESRBDTO> GetEsrb()
{
List <Esrb> esrb = _context.Esrb.Include(es => es.VideoGames).ToList();
List <ESRBDTO> esrbDTOList = new List <ESRBDTO>();
foreach (Esrb es in esrb)
{
List <VideoGamesDTO> videogamesDTOList = new List <VideoGamesDTO>();
foreach (VideoGames vg in es.VideoGames)
{
VideoGamesDTO vgDTO = new VideoGamesDTO()
{
VideoGamesID = vg.Id,
Title = vg.Title,
System = vg.System,
ReleaseDate = vg.ReleaseDate,
ESRB = vg.Esrb,
Publisher = vg.Publisher,
Developer = vg.Developer
};
videogamesDTOList.Add(vgDTO);
}
ESRBDTO esdto = new ESRBDTO()
{
ESRBID = es.Esrbid,
Rating = es.Rating
};
esrbDTOList.Add(esdto);
}
return(esrbDTOList);
}
public IEnumerable <DeveloperDTO> GetDeveloper()
{
List <Developer> developers = _context.Developer.Include(dv => dv.VideoGames).ToList();
List <DeveloperDTO> developerDTOList = new List <DeveloperDTO>();
foreach (Developer dv in developers)
{
List <VideoGamesDTO> videogamesDTOList = new List <VideoGamesDTO>();
foreach (VideoGames vg in dv.VideoGames)
{
VideoGamesDTO vgDTO = new VideoGamesDTO()
{
VideoGamesID = vg.Id,
Title = vg.Title,
System = vg.System,
ReleaseDate = vg.ReleaseDate,
ESRB = vg.Esrb,
Publisher = vg.Publisher,
Developer = vg.Developer
};
videogamesDTOList.Add(vgDTO);
}
DeveloperDTO dvdto = new DeveloperDTO()
{
DevID = dv.DevId,
Name = dv.Name
};
developerDTOList.Add(dvdto);
}
return(developerDTOList);
}
