public string GetGeom(int id)
{
var geom = new GradParceliDa().GetGeom(id);
geom = geom.Substring(9, geom.Length - 2 - 9);
return(geom);
}
public string GetByParcelaExcel(List <int> ids)
{
var parceli = new GradParceliDa().Get(ids);
if (parceli == null)
{
return(null);
}
var downloadDirectory = HttpRuntime.AppDomainAppPath + "Excel\\";
if (!Directory.Exists(downloadDirectory))
{
Directory.CreateDirectory(downloadDirectory);
}
var myGuid = Guid.NewGuid();
var outFileName = string.Format("Excel_{0}_{1}.xlsx", parceli[0].Id, myGuid);
var fs = downloadDirectory + outFileName;
using (var workbook = new XLWorkbook(XLEventTracking.Disabled))
{
foreach (var parcela in parceli)
{
var ws = workbook.AddWorksheet(parcela.Broj);
ws.Cell(1, 1).Value = "Број";
ws.Cell(1, 2).Value = parcela.Broj;
ws.Cell(2, 1).Value = "Катност";
ws.Cell(2, 2).Value = parcela.Katnost;
ws.Cell(3, 1).Value = "Класа на намена";
ws.Cell(3, 2).Value = parcela.KlasaNamena;
ws.Cell(4, 1).Value = "Коефициент на искористенст";
ws.Cell(4, 2).Value = parcela.KoeficientIskoristenost;
ws.Cell(5, 1).Value = "Компатибилна класа на намена";
ws.Cell(5, 2).Value = parcela.KompKlasaNamena;
ws.Cell(6, 1).Value = "Максимална висина";
ws.Cell(6, 2).Value = parcela.MaxVisina;
ws.Cell(7, 1).Value = "Процент на изграденост";
ws.Cell(7, 2).Value = parcela.ProcentIzgradenost;
ws.Cell(8, 1).Value = "Површина";
ws.Cell(8, 2).Value = parcela.Povrshina;
ws.Cell(9, 1).Value = "Површина за градење";
ws.Cell(9, 2).Value = parcela.PovrshinaGradenje;
ws.Cell(10, 1).Value = "Бруто развиена површина";
ws.Cell(10, 2).Value = parcela.BrutoPovrshina;
ws.Cell(11, 1).Value = "Име на планска документација";
ws.Cell(11, 2).Value = parcela.OpfatIme;
}
workbook.SaveAs(fs);
return(outFileName);
}
}
public string GetImage(int id)
{
var centroid = new GradParceliDa().GetCentroidById(id);
var resolution = GetResolutionForScale(1000);
var bbox = CalculateBounds(centroid.X, centroid.Y, resolution, 300, 300);
var address =
string.Format(
"http://{0}/cgi-bin/mapserv.exe?map=../../apps/{9}/htdocs/{8}.map&request=GetMap&service=WMS&version=1.1.1&layers={8}&styles=&srs=EPSG%3A6316&bbox={1},{2},{3},{4}&width={5}&height={6}&GID={7}&format=image%2Fpng",
ConfigurationManager.AppSettings["server"] + ":" + ConfigurationManager.AppSettings["port"],
bbox.Left.ToString(new CultureInfo("en-US")), bbox.Bottom.ToString(new CultureInfo("en-US")),
bbox.Right.ToString(new CultureInfo("en-US")), bbox.Top.ToString(new CultureInfo("en-US")), 900,
900, id, "sintezen2", ConfigurationManager.AppSettings["ms4w_app"]);
return(address);
}
