//iegūst tikai novadus
public async Task <JArray> GetNovadiOnly()
{
CreateJson createJson = new CreateJson(_clientFactory);
string url = "https://localhost:44303/api/adreses/getNovadi";
return(await createJson.GetJsonArray(url));
}
public async Task <JsonDocument> NLietuSaraksts()
{
CreateJson createJson = new CreateJson(_clientFactory);
string url = "";
JsonDocument jsonDocument = await createJson.GetJsonDocument(url);
return(jsonDocument);
}
public async Task <JsonDocument> Dokumenti()
{
CreateJson createJson = new CreateJson(_clientFactory);
string url = "https://localhost:44303/api/Art_Dokuments";
JsonDocument jsonDocument = await createJson.GetJsonDocument(url);
return(jsonDocument);
}
public async Task <JsonDocument> GetPagasti(decimal NovadsID)
{
CreateJson createJson = new CreateJson(_clientFactory);
string url = "https://localhost:44303/api/adreses/getPagasti/NovadsID=" + NovadsID + "";
JsonDocument testJson = await createJson.GetJsonDocument(url);
return(testJson);
}
public ActionResult StartMyApp(ExecViewCSVtoJS.Models.FilePathParam model)
{
CreateJson cj = new CreateJson();
if (!ModelState.IsValid)
{
return(View());
}
cj.Executecsv(model.uploadinput, model.uploadoutput);
return(RedirectToAction("JsonFileSuccess", "CSVtojson"));
}
public async Task <IActionResult> Index()
{
CreateJson createJson = new CreateJson(_clientFactory);
string urlStatusi = "https://localhost:44303/api/Art_Konst/AdresesStatusi";
string urlAdrVeidi = "https://localhost:44303/api/Art_Konst/KODIF100";
ViewBag.novadi = await GetNovadi();
ViewBag.statusi = await createJson.GetJsonArray(urlStatusi);
ViewBag.adrVeidi = await createJson.GetJsonArray(urlAdrVeidi);
return(View());
}
public Bookmark CreateBookmark(CreateJson content)
{
return(_bookmarkRepository.CreateBookmark(content.Bookmark, content.Username));
}
public async Task <IActionResult> Excel(int novadsID, int?pagastsID = null)
{
CreateJson createJson = new CreateJson(_clientFactory);
//izveidojam excel workbook
XLWorkbook wb = new XLWorkbook();
var ws = wb.Worksheets.Add("Sheet");
string fileName;
//ciemi
if (pagastsID == null)
{
fileName = "ciemuSaraksts.xlsx";
//web requests uz backendu
string url = "https://localhost:44303/api/Adreses/PagastiCiemi/NovadsID=" + novadsID;
JArray ciemiJArray = await createJson.GetJsonArray(url);
ws.Cell(1, 1).Value = "Ciemu saraksts novadā " + novadsID;
ws.Cell(3, 1).Value = "Pagasts";
ws.Cell(3, 2).Value = "Pagasta kods";
ws.Cell(3, 3).Value = "Ciems";
ws.Cell(3, 4).Value = "Ciema kods";
ws.Cell(3, 5).Value = "Statuss";
ws.Cell(3, 6).Value = "AR pēdējās veiktās izmaiņas";
int totalCiemiCount = 0;
for (int i = 0; i < ciemiJArray.Count(); i++)
{
for (int j = 0; j < ciemiJArray[i]["arg_AdreseCiemi"].Count(); j++)
{
totalCiemiCount++;
int row = totalCiemiCount + 3;
ws.Cell(row, 1).Value = (string)ciemiJArray[i]["std"]; //pagasts
ws.Cell(row, 2).Value = (string)ciemiJArray[i]["adR_CD"]; //pagasta kods
ws.Cell(row, 3).Value = (string)ciemiJArray[i]["arg_AdreseCiemi"][j]["std"]; //ciems
ws.Cell(row, 4).Value = (string)ciemiJArray[i]["arg_AdreseCiemi"][j]["adR_CD"]; //ciema id
ws.Cell(row, 5).Value = (string)ciemiJArray[i]["arg_AdreseCiemi"][j]["statuss"]; //statuss
JToken datMod = ciemiJArray[i]["arg_AdreseCiemi"][j]["daT_MOD"];
ws.Cell(row, 6).Value = datMod.HasValues ? (string)datMod : "Nav datu"; //pēd. veiktās izmaiņas
}
}
//ciemi specific formatting
IXLRange dataRange = ws.Range(ws.Cell(4, 1).Address, ws.Cell(totalCiemiCount + 3, 6).Address);
dataRange.Style.Border.BottomBorder = XLBorderStyleValues.Thin;
dataRange.Style.Border.RightBorder = XLBorderStyleValues.Thin;
dataRange.Style.Border.TopBorder = XLBorderStyleValues.Thin;
}
//nekustamas lietas
else
{
fileName = "nLietuSaraksts.xlsx";
string url = "https://localhost:44303/api/ArtNlietas/NLbyPagastsID/" + pagastsID;
JArray jArray = await createJson.GetJsonArray(url);
ws.Cell(1, 1).Value = "NL novads " + novadsID + " ; pagasts " + pagastsID;
ws.Cell(3, 1).Value = "Adrese";
ws.Cell(3, 2).Value = "Kods";
ws.Cell(3, 3).Value = "Nekustama lieta";
ws.Cell(3, 4).Value = "N/L kods";
ws.Cell(3, 5).Value = "Statuss";
ws.Cell(3, 6).Value = "AR pēdējās veiktās izmaiņas";
int counter = 0;
for (int i = 0; i < jArray.Count(); i++)
{
counter++;
int row = counter + 3;
ws.Cell(row, 1).Value = "";
ws.Cell(row, 2).Value = "";
ws.Cell(row, 3).Value = (string)jArray[i]["nosaukums"];
ws.Cell(row, 4).Value = (string)jArray[i]["kods"];
ws.Cell(row, 5).Value = (string)jArray[i]["statuss"];
ws.Cell(row, 6).Value = (string)jArray[i]["daT_MOD"];
}
}
//formatting
ws.Cell(1, 1).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
ws.Range("A1:F1").Merge();
ws.Cell(1, 1).Style.Font.FontSize = 16;
ws.Cell(1, 1).Style.Font.SetBold();
ws.Range("A3:F3").Style.Border.BottomBorder = XLBorderStyleValues.Thick;
ws.Range("A3:F3").Style.Border.TopBorder = XLBorderStyleValues.Thick;
ws.Range("A3:F3").Style.Border.RightBorder = XLBorderStyleValues.Thick;
ws.Range("A3:F3").Style.Fill.BackgroundColor = XLColor.FromHtml("E1E1E1");
ws.Range("A3:F3").Style.Font.Bold = true;
ws.Columns("1,2,3,4,5,6").AdjustToContents();
//download stream
using var stream = new MemoryStream();
wb.SaveAs(stream);
var content = stream.ToArray();
return(File(
content,
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
fileName));
}