public async Task AddTo(OrganismDbContext _context)
{
string uniqueFileName = UploadFile();
ImgDb newImg = new ImgDb()
{
ImgPath = uniqueFileName,
ImgName = ImgName,
ImgDescription = ImgDescription,
ImgType = string.Join(", ", ImgType.Select(a => a.ToString()))
};
_context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes).ThenInclude(i => i.Orders)
.ThenInclude(i => i.Families).ThenInclude(i => i.Genusses).ThenInclude(i => i.Species)
.ThenInclude(i => i.Imgs)
.Single(i => i.KingdomTID == KingdomID).Phylums
.Single(i => i.PhylumTID == PhylumID).Classes
.Single(i => i.ClassTID == ClassID).Orders
.Single(i => i.OrderTID == OrderID).Families
.Single(i => i.FamilyTID == FamilyID).Genusses
.Single(i => i.GenusTID == GenusID).Species
.Single(i => i.SpeciesTID == SpeciesID).Imgs
.Add(newImg);
await _context.SaveChangesAsync();
}
public override async Task Execute(OrganismClassification model, OrganismDbContext _context)
{
_context.Remove(_context.Kingdoms.Include(i => i.Phylums)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID));
await _context.SaveChangesAsync();
}
public override async Task Execute(OrganismData model, OrganismDbContext _context)
{
SpeciesT oldSpecies = _context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes).ThenInclude(i => i.Orders)
.ThenInclude(i => i.Families).ThenInclude(i => i.Genusses).ThenInclude(i => i.Species)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID).Classes
.Single(i => i.ClassTID == model.ClassID).Orders
.Single(i => i.OrderTID == model.OrderID).Families
.Single(i => i.FamilyTID == model.FamilyID).Genusses
.Single(i => i.GenusTID == model.GenusID).Species
.Single(i => i.SpeciesTID == model.SpeciesID);
oldSpecies.Name = model.Name;
oldSpecies.Description = model.Description;
oldSpecies.Class = model.Class;
oldSpecies.Size = model.Size;
oldSpecies.Use = model.Use;
oldSpecies.OccurenceCR = model.OccurenceCR;
oldSpecies.Protection = model.Protection;
oldSpecies.EcoFunction = model.EcoFunction;
oldSpecies.Ecosystems = string.Join(", ", model.Ecosystems.Select(a => a.ToString()));
oldSpecies.OccurencesWorld = string.Join(", ", model.OccurencesWorld.Select(a => a.ToString()));
await _context.SaveChangesAsync();
}
public override async Task <int> Execute(OrganismData model, OrganismDbContext _context)
{
SpeciesT newSpecies = new SpeciesT()
{
Name = model.Name,
Description = model.Description,
Class = model.Class,
Classification = GetClassification(model, _context).Result,
Size = model.Size,
Use = model.Use,
OccurenceCR = model.OccurenceCR,
Protection = model.Protection,
EcoFunction = model.EcoFunction,
Ecosystems = string.Join(", ", model.Ecosystems.Select(a => a.ToString())),
OccurencesWorld = string.Join(", ", model.OccurencesWorld.Select(a => a.ToString()))
};
_context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes).ThenInclude(i => i.Orders)
.ThenInclude(i => i.Families).ThenInclude(i => i.Genusses).ThenInclude(i => i.Species)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID).Classes
.Single(i => i.ClassTID == model.ClassID).Orders
.Single(i => i.OrderTID == model.OrderID).Families
.Single(i => i.FamilyTID == model.FamilyID).Genusses
.Single(i => i.GenusTID == model.GenusID).Species
.Add(newSpecies);
await _context.SaveChangesAsync();
return(newSpecies.SpeciesTID);
}
public async Task <IActionResult> CreatePost()
{
LearningSet newSet = new LearningSet();
if (await TryUpdateModelAsync(newSet))
{
_context.LearningSets.Add(newSet);
await _context.SaveChangesAsync();
return(RedirectToAction("Edit",
routeValues: new
{
newSet.LearningSetID
}));
}
return(RedirectToAction(nameof(Index)));
}
public override async Task Execute(OrganismData model, OrganismDbContext _context)
{
KingdomT oldKingdom = _context.Kingdoms
.Single(i => i.KingdomTID == model.KingdomID);
oldKingdom.Name = model.Name;
await _context.SaveChangesAsync();
}
public override async Task Execute(OrganismData model, OrganismDbContext _context)
{
PhylumT oldPhylum = _context.Kingdoms.Include(i => i.Phylums)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID);
oldPhylum.Name = model.Name;
await _context.SaveChangesAsync();
}
public override async Task Execute(OrganismClassification model, OrganismDbContext _context)
{
_context.Remove(_context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes).ThenInclude(i => i.Orders)
.ThenInclude(i => i.Families)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID).Classes
.Single(i => i.ClassTID == model.ClassID).Orders
.Single(i => i.OrderTID == model.OrderID).Families
.Single(i => i.FamilyTID == model.FamilyID));
await _context.SaveChangesAsync();
}
public override async Task Execute(OrganismData model, OrganismDbContext _context)
{
OrderT oldOrder = _context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes).ThenInclude(i => i.Orders)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID).Classes
.Single(i => i.ClassTID == model.ClassID).Orders
.Single(i => i.OrderTID == model.OrderID);
oldOrder.Name = model.Name;
await _context.SaveChangesAsync();
}
public override async Task <int> Execute(OrganismData model, OrganismDbContext _context)
{
KingdomT newKingdom = new KingdomT
{
Name = model.Name
};
_context.Kingdoms.Add(newKingdom);
await _context.SaveChangesAsync();
return(newKingdom.KingdomTID);
}
public override async Task <int> Execute(OrganismData model, OrganismDbContext _context)
{
PhylumT newPhylum = new PhylumT()
{
Name = model.Name
};
_context.Kingdoms.Include(i => i.Phylums)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Add(newPhylum);
await _context.SaveChangesAsync();
return(newPhylum.PhylumTID);
}
public async Task Delete(OrganismDbContext _context)
{
_context.Remove(_context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes).ThenInclude(i => i.Orders)
.ThenInclude(i => i.Families).ThenInclude(i => i.Genusses).ThenInclude(i => i.Species)
.ThenInclude(i => i.Imgs)
.Single(i => i.KingdomTID == KingdomID).Phylums
.Single(i => i.PhylumTID == PhylumID).Classes
.Single(i => i.ClassTID == ClassID).Orders
.Single(i => i.OrderTID == OrderID).Families
.Single(i => i.FamilyTID == FamilyID).Genusses
.Single(i => i.GenusTID == GenusID).Species
.Single(i => i.SpeciesTID == SpeciesID).Imgs
.Single(i => i.ImgID == ImgID));
await _context.SaveChangesAsync();
}
public override async Task <int> Execute(OrganismData model, OrganismDbContext _context)
{
ClassT newClass = new ClassT()
{
Name = model.Name
};
_context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID).Classes
.Add(newClass);
await _context.SaveChangesAsync();
return(newClass.ClassTID);
}
public override async Task <int> Execute(OrganismData model, OrganismDbContext _context)
{
FamilyT newFamily = new FamilyT()
{
Name = model.Name
};
_context.Kingdoms
.Include(i => i.Phylums).ThenInclude(i => i.Classes).ThenInclude(i => i.Orders)
.ThenInclude(i => i.Families)
.Single(i => i.KingdomTID == model.KingdomID).Phylums
.Single(i => i.PhylumTID == model.PhylumID).Classes
.Single(i => i.ClassTID == model.ClassID).Orders
.Single(i => i.OrderTID == model.OrderID).Families
.Add(newFamily);
await _context.SaveChangesAsync();
return(newFamily.FamilyTID);
}
// GET: Learning/AddSource/5
public async Task <IActionResult> AddSource()
{
SourceModel source = new SourceModel();
if (await TryUpdateModelAsync(source))
{
await source.GetItems(_context);
LearningSet set = _context.LearningSets.Single(x => x.LearningSetID == source.LearningSetID);
set.NumberOfItems = set.Items.Count();
await _context.SaveChangesAsync();
}
return(RedirectToAction("Edit", "LearningSets",
routeValues: new
{
source.LearningSetID
}));
}
public async Task GetItems(OrganismDbContext _context)
{
List <LearningSetItem> setItems = await new ItemsLoader().LoadItems(this, _context);
LearningSet set = _context.LearningSets.Include(x => x.Items)
.Single(x => x.LearningSetID == LearningSetID);
foreach (LearningSetItem item in setItems)
{
if (set.Items.Where(x => x.ImgPath == item.ImgPath).Count() != 0)
{
continue;
}
if (ItemValidator.Validate(set, item))
{
set.Items.Add(item);
}
}
await _context.SaveChangesAsync();
}