public async Task <int> GetSP500CountAsync()
{
var count = await Dbset.CountAsync(c => c.SP500 && c.Filtered);
return(count);
}
public async Task <int> GetCountAsync(int sectorId)
{
var count = await Dbset.CountAsync(c => c.Filtered && (c.SectorId == sectorId || sectorId == 0));
return(count);
}
public async Task <int> GetCountAsync(int jobId)
{
var count = await Dbset.CountAsync(r => r.JobId == jobId);
return(count);
}