// GET: Sites/Details/5
public async Task <IActionResult> Details(int?id)
{
if (id == null)
{
return(NotFound());
}
var site = await _repostory.DbContext().Sites
.Include(s => s.Client)
.FirstOrDefaultAsync(m => m.Id == id);
if (site == null)
{
return(NotFound());
}
return(View(site));
}
// GET: CSVData
public async Task <IActionResult> Index()
{
var myDbContext = _repostory.DbContext().CSVData.Include(c => c.Client).Include(c => c.Site);
return(View(await myDbContext.ToListAsync()));
}
public void GetSites()
{
var siteNames = DataInFile.Select(d => d.Site);
Sites = _repostory.DbContext().Sites.AsQueryable().Where(s => siteNames.Contains(s.Name));
}
