public async Task <IActionResult> AddSite(ResearchSite site) { var address = site.SiteStreetAddress + ", " + site.SiteCity + ", " + site.SiteState; GeoCode geocode = await _apiCalls.GoogleGeocoding(address); site.Latitude = geocode.results[0].geometry.location.lat; site.Longitude = geocode.results[0].geometry.location.lng; _context.ResearchSite.Add(site); _context.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <IActionResult> EditSite(ResearchSite site) { var researchSite = _context.ResearchSite.Where(r => r.SiteId == site.SiteId).SingleOrDefault(); var address = site.SiteStreetAddress + ", " + site.SiteCity + ", " + site.SiteState; GeoCode geocode = await _apiCalls.GoogleGeocoding(address); researchSite.Latitude = geocode.results[0].geometry.location.lat; researchSite.Longitude = geocode.results[0].geometry.location.lng; researchSite.SiteCity = site.SiteCity; researchSite.SiteName = site.SiteName; researchSite.SiteState = site.SiteState; researchSite.SiteZip = site.SiteZip; researchSite.SiteStreetAddress = site.SiteStreetAddress; _context.SaveChanges(); return(RedirectToAction("AllSites")); }
public ActionResult ExportEnvironment(ResearchSite research) { var sites = _context.Environmental.Where(e => e.SiteName == research.SiteName).ToList(); using (var workbook = new XLWorkbook()) { var worksheet = workbook.Worksheets.Add("SiteInformation"); var currentRow = 1; worksheet.Cell(currentRow, 1).Value = "Research Date"; worksheet.Cell(currentRow, 2).Value = "Opening Temperature"; worksheet.Cell(currentRow, 3).Value = "Closing Temperature"; worksheet.Cell(currentRow, 4).Value = "Cloud Cover"; worksheet.Cell(currentRow, 5).Value = "Precipitation"; worksheet.Cell(currentRow, 6).Value = "Open Time"; worksheet.Cell(currentRow, 7).Value = "Close Time"; worksheet.Cell(currentRow, 8).Value = "Site Name"; foreach (var site in sites) { currentRow++; worksheet.Cell(currentRow, 1).Value = site.ResearchDate; worksheet.Cell(currentRow, 2).Value = site.OpenTemp; worksheet.Cell(currentRow, 3).Value = site.CloseTemp; worksheet.Cell(currentRow, 4).Value = site.CloudCover; worksheet.Cell(currentRow, 5).Value = site.Precipitation; worksheet.Cell(currentRow, 6).Value = site.OpenTime; worksheet.Cell(currentRow, 7).Value = site.CloseTime; worksheet.Cell(currentRow, 8).Value = site.SiteName; } using (var stream = new MemoryStream()) { workbook.SaveAs(stream); var content = stream.ToArray(); return(File( content, "application/vnd.openxmlformats-officedocument.spreadsheet.sheet", "SiteInformation.xlsx")); } } }
public ActionResult ViewDailySiteData(ResearchSite research) { var siteData = _context.Environmental.Where(e => e.SiteName == research.SiteName).ToList(); return(View("DisplayData", siteData)); }