public List <FilmSpecies> GetMostAppearedSpecies()
{
List <FilmSpecies> _filmSpecies = new List <FilmSpecies>();
FilmSpecies filmSpecies;
try
{
using (SqlConnection connection = new SqlConnection(_SqlConnectionString))
{
SqlCommand command = new SqlCommand(usp_MostAppearedSpecies, connection);
DataSet resultSet = ExecuteDataSet(command);
if (resultSet != null && resultSet.Tables.Count > 0)
{
foreach (DataRow row in resultSet.Tables[0].Rows)
{
filmSpecies = new FilmSpecies();
filmSpecies.Species = row["Name"].ToString();
filmSpecies.Films = row["Films"].ToString();
filmSpecies.PeopleCount = row["People"].ToString();
_filmSpecies.Add(filmSpecies);
}
}
}
}
catch (Exception ex)
{
}
return(_filmSpecies);
}
public Film ToModel(star_wars_apiContext context)
{
Film film = context.Film.Find(this.id);
bool newObject = false;
if (film == null)
{
newObject = true;
film = new Film();
film.characterIds = new List <FilmCharacter>();
film.planetIds = new List <FilmPlanet>();
film.speciesIds = new List <FilmSpecies>();
film.starshipIds = new List <FilmStarship>();
film.vehicleIds = new List <FilmVehicle>();
}
film.id = this.id;
film.created = this.created;
film.edited = this.edited;
film.director = this.director;
film.episodeId = this.episodeId;
film.openingCrawl = this.openingCrawl;
film.producer = this.producer;
film.releaseDate = this.releaseDate;
film.title = this.title;
if (newObject == false)
{
// many-many mapping classes have the IDs as foreign keys - if the object does not yet exist it cannot be linked to other objects.
foreach (int characterId in this.characterIds)
{
if (context.Character.Find(characterId) != null)
{
FilmCharacter filmCharacter = context.FilmCharacter.Find(this.id, characterId);
if (filmCharacter == null)
{
filmCharacter = new FilmCharacter(this.id, characterId);
}
if (film.characterIds.Contains(filmCharacter) == false)
{
film.characterIds.Add(filmCharacter);
}
}
}
foreach (int planetId in this.planetIds)
{
if (context.Planet.Find(planetId) != null)
{
FilmPlanet filmPlanet = context.FilmPlanet.Find(this.id, planetId);
if (filmPlanet == null)
{
filmPlanet = new FilmPlanet(this.id, planetId);
}
if (film.planetIds.Contains(filmPlanet) == false)
{
film.planetIds.Add(filmPlanet);
}
}
}
foreach (int speciesId in this.speciesIds)
{
if (context.Species.Find(speciesId) != null)
{
FilmSpecies filmSpecies = context.FilmSpecies.Find(this.id, speciesId);
if (filmSpecies == null)
{
filmSpecies = new FilmSpecies(this.id, speciesId);
}
if (film.speciesIds.Contains(filmSpecies) == false)
{
film.speciesIds.Add(filmSpecies);
}
}
}
foreach (int starshipId in this.starshipIds)
{
if (context.Starship.Find(starshipId) != null)
{
FilmStarship filmStarship = context.FilmStarship.Find(this.id, starshipId);
if (filmStarship == null)
{
filmStarship = new FilmStarship(this.id, starshipId);
}
if (film.starshipIds.Contains(filmStarship) == false)
{
film.starshipIds.Add(filmStarship);
}
}
}
foreach (int vehicleId in this.vehicleIds)
{
if (context.Vehicle.Find(vehicleId) != null)
{
FilmVehicle filmVehicle = context.FilmVehicle.Find(this.id, vehicleId);
if (filmVehicle == null)
{
filmVehicle = new FilmVehicle(this.id, vehicleId);
}
if (film.vehicleIds.Contains(filmVehicle) == false)
{
film.vehicleIds.Add(filmVehicle);
}
}
}
}
return(film);
}
public Species ToModel(star_wars_apiContext context)
{
Species species = context.Species.Find(this.id);
bool newObject = false;
if (species == null)
{
newObject = true;
species = new Species();
}
species.id = this.id;
species.created = this.created;
species.edited = this.edited;
species.averageHeight = this.averageHeight;
species.averageLifespan = this.averageLifespan;
species.classification = this.classification;
species.designation = this.designation;
species.homeworldId = this.homeworldId;
species.language = this.language;
species.name = this.name;
species.filmIds = new List <FilmSpecies>();
species.peopleIds = new List <SpeciesCharacter>();
species.eyeColors = new List <SpeciesEyeColor>();
species.hairColors = new List <SpeciesHairColor>();
species.skinColors = new List <SpeciesSkinColor>();
if (newObject == false)
{
// many-many mapping classes have the IDs as foreign keys - if the object does not yet exist it cannot be linked to other objects.
foreach (int filmId in this.filmIds)
{
if (context.Film.Find(filmId) != null)
{
FilmSpecies filmSpecies = context.FilmSpecies.Find(filmId, this.id);
if (filmSpecies == null)
{
species.filmIds.Add(new FilmSpecies(filmId, this.id));
}
else
{
species.filmIds.Add(filmSpecies);
}
}
}
foreach (int characterId in this.peopleIds)
{
if (context.Character.Find(characterId) != null)
{
SpeciesCharacter speciesCharacter = context.SpeciesCharacter.Find(this.id, characterId);
if (speciesCharacter == null)
{
species.peopleIds.Add(new SpeciesCharacter(this.id, characterId));
}
else
{
species.peopleIds.Add(speciesCharacter);
}
}
}
foreach (string eyeColor in this.eyeColors)
{
SpeciesEyeColor speciesEyeColor = context.SpeciesEyeColor.Find(this.id, eyeColor);
if (speciesEyeColor == null)
{
species.eyeColors.Add(new SpeciesEyeColor(this.id, eyeColor));
}
else
{
species.eyeColors.Add(speciesEyeColor);
}
}
foreach (string hairColor in this.hairColors)
{
SpeciesHairColor speciesHairColor = context.SpeciesHairColor.Find(this.id, hairColor);
if (speciesHairColor == null)
{
species.hairColors.Add(new SpeciesHairColor(this.id, hairColor));
}
else
{
species.hairColors.Add(speciesHairColor);
}
}
foreach (string skinColor in this.skinColors)
{
SpeciesSkinColor speciesSkinColor = context.SpeciesSkinColor.Find(this.id, skinColor);
if (speciesSkinColor == null)
{
species.skinColors.Add(new SpeciesSkinColor(this.id, skinColor));
}
else
{
species.skinColors.Add(speciesSkinColor);
}
}
}
return(species);
}
