public int Insert(Dictionary <RowHash, List <object> > rowData)
{
var dtosWithHashes = ReadWithHashes(rowData);
var entities = _mapper.Map(dtosWithHashes).ToList();
entities = AttachRelatedEntities(entities);
DbSet.AddRange(entities);
DbContext.SaveChanges();
DeleteOrphans();
entities.ForEach(e => Reporter.ReportAdded(Entity, e.IdHash, e.Id));
return(entities.Count);
}
public int Insert(Dictionary <RowHash, List <object> > rowData)
{
var availabilities = _dbContext.PokemonAvailabilities.ToList();
var varieties = _dbContext.PokemonVarieties
.IncludeOptimized(v => v.PokemonSpecies)
.IncludeOptimized(v => v.Forms)
.IncludeOptimized(v => v.DefaultForm)
.IncludeOptimized(v => v.PrimaryType)
.IncludeOptimized(v => v.SecondaryType)
.IncludeOptimized(v => v.PrimaryAbility)
.IncludeOptimized(v => v.SecondaryAbility)
.IncludeOptimized(v => v.HiddenAbility)
.IncludeOptimized(v => v.PvpTier)
.IncludeOptimized(v => v.Urls)
.ToList();
var dtosWithHashes = ReadWithHashes(rowData);
var entities = _mapper.Map(dtosWithHashes).ToList();
for (var i = 0; i < entities.Count; i++)
{
var entity = entities[i];
var availability = availabilities.SingleOrDefault(a => a.Name.EqualsExact(entity.Availability.Name));
if (availability is null)
{
_reporter.ReportError(Entity.PokemonForm, entity.IdHash,
$"Could not find availability {entity.Availability.Name} for PokemonForm {entity.Name}, skipping.");
entities.Remove(entity);
i--;
continue;
}
entity.AvailabilityId = availability.Id;
entity.Availability = availability;
var pokemonVariety = varieties.SingleOrDefault(s => s.Name.EqualsExact(entity.PokemonVariety.Name));
// If PokemonVariety already exists, update it (else add the new one)
var variety = UpdatePokemonVariety(pokemonVariety, entity.PokemonVariety, entity.IdHash);
if (variety is null)
{
entities.Remove(entity);
i--;
continue;
}
entity.PokemonVariety = variety;
entity.PokemonVarietyId = variety.Id;
}
// Save default forms and default varieties, then remove them temporarily for initial insert.
var defaultForms = entities
.Select(f => f.PokemonVariety)
.Distinct()
.ToDictionary(v => v.Name, v => v.DefaultForm.Name);
var defaultVarieties = entities
.Select(f => f.PokemonVariety.PokemonSpecies)
.Distinct()
.ToDictionary(s => s.Name, s => s.DefaultVariety.Name);
entities.Select(f => f.PokemonVariety).ToList().ForEach(v => v.DefaultForm = null);
entities.Select(f => f.PokemonVariety.PokemonSpecies).ToList().ForEach(s => s.DefaultVariety = null);
_dbContext.PokemonForms.AddRange(entities);
_dbContext.SaveChanges();
// Attach Default form and default variety
varieties = _dbContext.PokemonVarieties.ToList();
var forms = _dbContext.PokemonForms.ToList();
for (var i = 0; i < entities.Count; i++)
{
var entity = entities[i];
var defaultForm = forms.SingleOrDefault(f => f.Name.EqualsExact(defaultForms[entity.PokemonVariety.Name]));
if (defaultForm is null)
{
_reporter.ReportError(Entity.PokemonForm, entity.IdHash,
$"Could not find default form {entity.PokemonVariety.DefaultForm.Name} " +
$"for PokemonForm {entity.Name}, skipping.");
entities.Remove(entity);
i--;
continue;
}
entity.PokemonVariety.DefaultFormId = defaultForm.Id;
entity.PokemonVariety.DefaultForm = defaultForm;
var defaultVariety = varieties
.SingleOrDefault(v => v.Name.EqualsExact(defaultVarieties[entity.PokemonVariety.PokemonSpecies.Name]));
if (defaultVariety is null)
{
_reporter.ReportError(Entity.PokemonForm, entity.IdHash,
$"Could not find default variety {entity.PokemonVariety.PokemonSpecies.DefaultVariety.Name} " +
$"for PokemonForm {entity.Name}, skipping.");
entities.Remove(entity);
i--;
continue;
}
entity.PokemonVariety.PokemonSpecies.DefaultVarietyId = defaultVariety.Id;
entity.PokemonVariety.PokemonSpecies.DefaultVariety = defaultVariety;
}
_dbContext.SaveChanges();
DeleteOrphans();
entities.ForEach(e =>
_reporter.ReportAdded(Entity.PokemonForm, e.IdHash, e.Id));
return(entities.Count);
}