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