private static void SeedSpecies(dynamic json, StarwarsContext _context)
{
dynamic _species = json["results"];
foreach (var _specie in _species)
{
_context.Add(new Species
{
Url = _specie["url"],
Name = _specie["name"],
Classification = _specie["classification"],
Designation = _specie["designation"],
AverageHeight = _specie["average_height"],
SkinColors = _specie["skin_colors"],
HairColors = _specie["hair_colors"],
EyeColors = _specie["hair_colors"],
AverageLifespan = _specie["average_lifespan"],
Homeworld = _specie["homeworld"],
Language = _specie["language"],
Created = _specie["created"]
});
// object already done
}
}
// public static async void GetDataMode (string path)
// {
// string url = $"https://swapi.dev/api/{path}/";
// }
private static void SeedFilms(dynamic json, StarwarsContext _context)
{
dynamic _films = json["results"];
// parse though the films and add to the context.
foreach (var _film in _films)
{
_context.Add(new Films
{
Url = _film["url"],
Title = _film["title"],
EpisodeId = _film["episode_id"],
OpeningCrawl = _film["opening_crawl"],
Director = _film["director"],
Producer = _film["producer"],
ReleaseDate = _film["release_date"],
Created = _film["created"]
});
// get the array objects
var characters = _film["characters"];
foreach (var ch in characters)
{
_context.Add(new FilmToPeople {
FilmUrl = _film["url"], PeopleUrl = ch
});
}
var planets = _film["planets"];
foreach (var pl in planets)
{
_context.Add(new PlanetsToFilms {
FilmsUrl = _film["url"], PlanetUrl = pl
});
}
var starships = _film["starships"];
foreach (var st in starships)
{
_context.Add(new FilmToCraft {
FilmUrl = _film["url"], CraftUrl = st
});
}
var vehicles = _film["vehicles"];
foreach (var ch in vehicles)
{
_context.Add(new FilmToCraft {
FilmUrl = _film["url"], CraftUrl = ch
});
}
var species = _film["species"];
foreach (var sp in species)
{
_context.Add(new FilmsToSpecies {
FilmUrl = _film["url"], SpeciesUrl = sp
});
}
_context.SaveChangesAsync();
}
}
public CharacterControllerTests()
{
optionsBuilder.UseSqlServer(connectionString);
starwarsContext = new StarwarsContext(optionsBuilder.Options);
core = new CoreCharacterRepository(starwarsContext);
mock = new Mock <IRepository <CoreCharacterRepository> >();
characterController = new CharactersController(core);
}
public static async Task SeedDataBase(StarwarsContext context)
{
if (await context.Films.AnyAsync())
{
return;
}
// var result = await GetDataModel<Films>("films");
// if (result != null)
// {
// }
}
private static void SeedPeople(dynamic json, StarwarsContext _context)
{
dynamic _people = json["results"];
foreach (var _person in _people)
{
_context.Add(new Peoples
{
Url = _people["url"],
Name = _people["name"],
Height = _people["height"],
Mass = _people["mass"],
HairColor = _people["hair_color"],
SkinColor = _people["skin_color"],
EyeColor = _people["eye_color"],
BirthYear = _people["birth_year"],
Gender = _people[""],
Homeworld = _people[""],
Created = _people["created"]
});
// get the array objects
var peoplesp = _people["species"];
foreach (var ps in peoplesp)
{
_context.Add(new SpeciesToPeople {
PeopleUrl = _people["url"], SpeciesUrl = ps
});
}
var vehicles = _people["Vehicles"];
foreach (var vh in vehicles)
{
_context.Add(new PersonToCraft {
PersonUrl = _people["url"], CraftUrl = vh
});
}
var starships = _people["starships"];
foreach (var ss in starships)
{
_context.Add(new PersonToCraft {
PersonUrl = _people["url"], CraftUrl = ss
});
}
}
}
public PeopleRepository(StarwarsContext ctxt, ILogger <PeopleRepository> logger)
{
_context = ctxt;
_logger = logger;
}
public FilmRepository(StarwarsContext context, ILogger <FilmRepository> log)
{
_context = context; logger = log;
}
public VehicleRepository(StarwarsContext ctxt, ILogger <VehicleRepository> log)
{
_logger = log;
_context = ctxt;
}
public PlanetRepository(StarwarsContext ctx, ILogger <StarwarsContext> logger)
{
_context = ctx; _logger = logger;
}
public StarshipsRepository(StarwarsContext ctxt) => _context = ctxt;
public SpeciesRepository(ILogger <SpeciesRepository> logger, StarwarsContext ctx)
{
_logger = logger; _context = ctx;
}
public SpeciesController(ISpeciesRepository speciesRepository, StarwarsContext ctx)
{
_speciesRepository = speciesRepository;
_context = ctx;
}
