public IEnumerable <planet> GetPilots()
{
using (StarwarsDBContext dbcontext = new StarwarsDBContext())
{
return(dbcontext.planets.ToList());
}
}
public opening_crawl GetLongestCrawl()
{
opening_crawl openingCrawlLongest = new opening_crawl();
string longest = "";
using (StarwarsDBContext dbContext = new StarwarsDBContext())
{
var Films = dbContext.films;
foreach (film f in Films)
{
if (f.opening_crawl.Length > longest.Length)
{
longest = f.opening_crawl;
openingCrawlLongest.openingCrawl = f.title.ToString();
}
}
}
return(openingCrawlLongest);
}
public Species GetSpecies()
{
Species species = new Species();
using (StarwarsDBContext dbContext = new StarwarsDBContext())
{
List <string> listSpecies = new List <string>();
List <film> filmList = dbContext.films.ToList();
foreach (film f in filmList)
{
foreach (species s in f.species)
{
foreach (person p in s.people)
{
listSpecies.Add(s.name);
}
}
}
species.speciesName = listSpecies.GroupBy(i => i).OrderByDescending(g => g.Count()).Take(2).Select(g => string.Format(g.Key + "({0})", g.Count()));
return(species);
}
}
public CharName GetChars()
{
List <string> charactersList = new List <string>();
CharName character = new CharName();
using (StarwarsDBContext dbContext = new StarwarsDBContext())
{
List <person> Characters = dbContext.people.ToList();
foreach (person p in Characters)
{
foreach (film f in p.films)
{
charactersList.Add(p.name);
}
}
var characters = charactersList.GroupBy(i => i).OrderByDescending(g => g.Count()).Take(1).Select(g => g.Key);
foreach (string charName in characters)
{
character.charName = charName;
}
return(character);
}
}
