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(); }