public void StoreGridLayerTest() { var gridLayer = new GridLayer("Kalklag test", RutenettType.SSB010KM) { Description = "Test av kalklag", Code = new Code { Value = "KA", Registry = "NiN", Version = "2.0" }, Owner = new Contact { Company = "Artsdatabanken" }, Established = DateTime.Now, MinValue = "0.0", MaxValue = "3.0" }; gridLayer.Cells.Add(new GridLayerCell { CellId = "22600007060000", Value = "0.0" }); gridLayer.Cells.Add(new GridLayerCell { CellId = "22700007060000", Value = "1.0" }); gridLayer.Cells.Add(new GridLayerCell { CellId = "22600007070000", Value = "2.0" }); gridLayer.Cells.Add(new GridLayerCell { CellId = "22700007070000", Value = "3.0" }); SqlServer.BulkStoreGridLayer(gridLayer); }
public void StoreGridLayerTest2() { var gl = new GridLayer("Kalklag test 2", RutenettType.SSB010KM) { Description = "Test av kalklag nummer 2", Code = new Code { Value = "KA", Registry = "NiN", Version = "2.0" }, Owner = new Contact { Company = "Artsdatabanken" }, Established = DateTime.Now, MinValue = "1", MaxValue = "9" }; var cells = gl.Cells; cells.Add(new GridLayerCell { CellId = "20600006440000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "20200006450000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20300006450000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "20400006450000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20500006450000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "20600006450000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20700006450000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "20800006450000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "20900006450000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "20000006460000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "20100006460000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20200006460000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "20300006460000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20400006460000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "20500006460000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20600006460000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "20700006460000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "20800006460000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "20900006460000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "21000006460000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20000006470000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "20100006470000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20200006470000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "20300006470000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20400006470000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "20500006470000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "20600006470000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "20700006470000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "20800006470000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20900006470000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "21000006470000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "21100006470000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "21200006470000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20000006480000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "20100006480000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "20200006480000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "20300006480000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "20400006480000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20500006480000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "20600006480000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20700006480000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "20800006480000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20900006480000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "21000006480000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "21100006480000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "21200006480000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "21300006480000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "19800006490000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "19900006490000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20000006490000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "20100006490000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20200006490000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "20300006490000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "20400006490000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "20500006490000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "20600006490000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20700006490000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "20800006490000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20900006490000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "21000006490000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "21100006490000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "21200006490000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "21300006490000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "21400006490000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "19700006500000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "19800006500000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "19900006500000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20000006500000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "20100006500000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20200006500000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "20300006500000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "20400006500000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "20500006500000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "20600006500000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20700006500000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "20800006500000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20900006500000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "21000006500000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "21100006500000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "21200006500000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "21300006500000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "21400006500000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "21500006500000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "19600006510000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "19700006510000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "19800006510000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "19900006510000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20000006510000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "20100006510000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "20200006510000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "20300006510000", Value = "1" }); cells.Add(new GridLayerCell { CellId = "20400006510000", Value = "2" }); cells.Add(new GridLayerCell { CellId = "20500006510000", Value = "3" }); cells.Add(new GridLayerCell { CellId = "20600006510000", Value = "4" }); cells.Add(new GridLayerCell { CellId = "20700006510000", Value = "5" }); cells.Add(new GridLayerCell { CellId = "20800006510000", Value = "6" }); cells.Add(new GridLayerCell { CellId = "20900006510000", Value = "7" }); cells.Add(new GridLayerCell { CellId = "21000006510000", Value = "8" }); cells.Add(new GridLayerCell { CellId = "21100006510000", Value = "9" }); cells.Add(new GridLayerCell { CellId = "21200006510000", Value = "1" }); SqlServer.BulkStoreGridLayer(gl); }
public async Task <string> UploadGrid() { Authorize("Dataleverandør"); IFormFile grid2 = Request.Form.Files.GetFile("grid"); HttpFormFile grid = new HttpFormFile(grid2); DataFiles files = HttpFormFile.GetFormFiles(Request.Form.Files); var gridXml = grid.ReadXml(); dataleveranseXmlGreier.ValidateGrid(gridXml); try { var gridFileDocId = Guid.NewGuid(); var gridFile = new File { Id = gridFileDocId.ToString(), FileName = grid.Filename, ContentType = grid.ContentType, Content = grid.OpenReadStream() }; await arkiv.LagreFil(gridFile); Collection <Nin.Types.MsSql.Document> documents; if (gridXml.Root.Name.LocalName.Equals("AdministrativtOmraadeKart")) { AreaLayer areaLayer = AreaLayerImpl.FromXml(gridXml); files.CheckDocuments(areaLayer.Documents); areaLayer.DocGuid = gridFileDocId; documents = areaLayer.Documents; SqlServer.BulkStoreAreaLayer(areaLayer); } else { var gridLayer = GridLayerImpl.FromXml(gridXml); files.CheckDocuments(gridLayer.Documents); gridLayer.DocGuid = gridFileDocId; documents = gridLayer.Documents; SqlServer.BulkStoreGridLayer(gridLayer); } foreach (var file in files.Values) { var fileName = file.Filename; var document = FindDocument(documents, fileName); var docFile = new File { Id = document.Guid.ToString(), FileName = fileName, ContentType = file.ContentType, Content = file.OpenReadStream() }; await arkiv.LagreFil(docFile); } } catch { arkiv.DiscardChanges(); throw; } return("OK"); }