public async Task<string> TransferCountries() { var countries = (await this.mongoRepository.GetCountries()).ToList(); using (WeaponSystemContext ctx = new WeaponSystemContext()) { foreach (var country in countries) { if (!ctx.Countries.Any(c => c.Name == country.Name)) { ctx.Countries.Add(country); } } ctx.SaveChanges(); } return "Countries" + MessageEnd; }
public async Task<string> TransferTargetCategories() { var targetCategories = (await this.mongoRepository.GetTargetCategories()).ToList(); using (WeaponSystemContext ctx = new WeaponSystemContext()) { foreach (var cat in targetCategories) { if (!ctx.TargetCategories.Any(c => c.Name == cat.Name)) { ctx.TargetCategories.Add(cat); } } ctx.SaveChanges(); } return "Target Categories" + MessageEnd; }
public async Task<string> GetXmlData() { var targets = XmlReader.ReadXmlCollectionFromFile(DataPath); var repo = new MongoDbRepository(); await repo.InsertTargets(targets); using (WeaponSystemContext db = new WeaponSystemContext()) { var targetCats = db.TargetCategories.ToList(); foreach (var targetItem in targets) { if (!targetCats.Any(c => c.Name == targetItem[0])) { var newTargetCat = new Target() { Name = targetItem[0] }; } var target = new Target(); var targetItemName = targetItem[1]; var id = db.TargetCategories. Where(c => c.Name == targetItemName) .FirstOrDefault(); if (id != null && !db.Targets.Any(t => t.Name == target.Name)) { target.Name = targetItem[0]; target.TargetCategoryId = id.Id; db.Targets.Add(target); } } db.SaveChanges(); } return "Targets from xml dispatched"; }
public async Task<string> TransferManufacturers() { var manufacturers = (await this.mongoRepository.GetManufacturers()).ToList(); using (WeaponSystemContext ctx = new WeaponSystemContext()) { foreach (var man in manufacturers) { if (!ctx.Manufacturers.Any(c => c.Name == man.Name)) { ctx.Manufacturers.Add(man); } } ctx.SaveChanges(); } return "Manufacturers" + MessageEnd; }