public object Get(LocationCount request)
{
var resp = new Dto <long>();
resp.Result = Handler.Count();
return(resp);
}
public IHttpActionResult GetCountOnLocation()
{
var locationCount = new LocationCount();
var species = new List <Specie>();
using (
var conn =
new SqlConnection(
@"Data Source=localhost\SQLEXPRESS;Initial Catalog=RedList;Integrated Security=SSPI;"))
{
conn.Open();
species = conn.Query <Specie>("select * from Species where category not like 'LC'").ToList();
foreach (var specie in species)
{
if (!string.IsNullOrWhiteSpace(specie.Hordaland) || !string.IsNullOrWhiteSpace(specie.Hordaland))
{
locationCount.Hordaland++;
}
if (!string.IsNullOrWhiteSpace(specie.Akershus) || !string.IsNullOrWhiteSpace(specie.Akershus))
{
locationCount.Akershus++;
}
if (!string.IsNullOrWhiteSpace(specie.AustAgder) || !string.IsNullOrWhiteSpace(specie.AustAgder))
{
locationCount.Aust_Agder++;
}
if (!string.IsNullOrWhiteSpace(specie.Buskerud) || !string.IsNullOrWhiteSpace(specie.Buskerud))
{
locationCount.Buskerud++;
}
if (!string.IsNullOrWhiteSpace(specie.Finnmark) || !string.IsNullOrWhiteSpace(specie.Finnmark))
{
locationCount.Finnmark++;
}
if (!string.IsNullOrWhiteSpace(specie.Hedmark) || !string.IsNullOrWhiteSpace(specie.Hedmark))
{
locationCount.Hedmark++;
}
if (!string.IsNullOrWhiteSpace(specie.MoreogRomsdal) ||
!string.IsNullOrWhiteSpace(specie.MoreogRomsdal))
{
locationCount.Møre_og_Romsdal++;
}
if (!string.IsNullOrWhiteSpace(specie.NordTrondelag) ||
!string.IsNullOrWhiteSpace(specie.NordTrondelag))
{
locationCount.Nord_Trøndelag++;
}
if (!string.IsNullOrWhiteSpace(specie.Nordland) || !string.IsNullOrWhiteSpace(specie.Nordland))
{
locationCount.Nordland++;
}
if (!string.IsNullOrWhiteSpace(specie.Oppland) || !string.IsNullOrWhiteSpace(specie.Oppland))
{
locationCount.Oppland++;
}
if (!string.IsNullOrWhiteSpace(specie.Oslo) || !string.IsNullOrWhiteSpace(specie.Oslo))
{
locationCount.Oslo++;
}
if (!string.IsNullOrWhiteSpace(specie.Ostfold) || !string.IsNullOrWhiteSpace(specie.Ostfold))
{
locationCount.Østfold++;
}
if (!string.IsNullOrWhiteSpace(specie.Rogaland) || !string.IsNullOrWhiteSpace(specie.Rogaland))
{
locationCount.Rogaland++;
}
if (!string.IsNullOrWhiteSpace(specie.SognogFjordane) ||
!string.IsNullOrWhiteSpace(specie.SognogFjordane))
{
locationCount.Sogn_og_Fjordane++;
}
if (!string.IsNullOrWhiteSpace(specie.SorTrondelag) ||
!string.IsNullOrWhiteSpace(specie.SorTrondelag))
{
locationCount.Sør_Trøndelag++;
}
if (!string.IsNullOrWhiteSpace(specie.Telemark) || !string.IsNullOrWhiteSpace(specie.Telemark))
{
locationCount.Telemark++;
}
if (!string.IsNullOrWhiteSpace(specie.Troms) || !string.IsNullOrWhiteSpace(specie.Troms))
{
locationCount.Troms++;
}
if (!string.IsNullOrWhiteSpace(specie.VestAgder) || !string.IsNullOrWhiteSpace(specie.VestAgder))
{
locationCount.Vest_Agder++;
}
if (!string.IsNullOrWhiteSpace(specie.Vestfold) || !string.IsNullOrWhiteSpace(specie.Vestfold))
{
locationCount.Vestfold++;
}
}
}
return(Ok(locationCount));
}
