public IEnumerable <ImportModel> Upload() { var file = File.ReadAllText(_options.Value.JsonPath); var points = JsonConvert.DeserializeObject <List <ImportModel> >(file); var dboWasteTakePoints = points.Select(x => new WasteTakePointDbo { Id = Guid.NewGuid(), Location = new LocationDbo { Coordinates = new Point(x.Longitude, x.Latitude) }, Name = x.Type }).ToList(); _dbContext.WasteTakePoints.AddRange(dboWasteTakePoints); _dbContext.SaveChanges(); return(points); }
public async Task <IActionResult> PrepareDb() { garbageCollectorContext.AppUsers.RemoveRange(garbageCollectorContext.AppUsers); garbageCollectorContext.WasteTakePoints.RemoveRange(garbageCollectorContext.WasteTakePoints); garbageCollectorContext.WasteCategories.RemoveRange(garbageCollectorContext.WasteCategories); garbageCollectorContext.SaveChanges(); var points = _dataUploader.Upload(); _dataUploader.ImportCategories(); await _dataUploader.MapPointsToCategoriesAsync().ConfigureAwait(true); await _dataUploader.CreateDefaultUser().ConfigureAwait(true); return(Ok()); }