public IList <SimpleSelectDto> All(AdancedSearchFilter filter)
{
using (Connection)
{
var query = new StringBuilder();
query.Append(@"
select
e.Id as 'Id',
e.SubspeciesName as 'Name'
from
Subspecies e
where
(@SpecieId is null or e.SpeciesId = @SpecieId)
ORDER BY
e.SubspeciesName asc;
");
return(Connection.Query <SimpleSelectDto>(query.ToString(), filter).ToList());
}
}
public IList <SimpleSelectDto> All(AdancedSearchFilter filter)
{
using (Connection)
{
var query = new StringBuilder();
query.Append(@"
select
e.Id as 'Id',
e.TribeName as 'Name'
from
Tribe e
inner join Subfamily sf on sf.Id = e.SubfamilyId
inner join Family f on f.Id = sf.FamilyId
where
@FamilyId = f.Id
and (@SubfamilyId is null or sf.Id = @SubfamilyId)
ORDER BY
e.TribeName asc;
");
return(Connection.Query <SimpleSelectDto>(query.ToString()
, filter).ToList());
}
}
public IList <SimpleSelectDto> GetSubspecies(AdancedSearchFilter filter)
{
return(_subspeciesRepository.All(filter));
}
public IList <SimpleSelectDto> GetGenus(AdancedSearchFilter filter)
{
return(_genusRepository.All(filter));
}
public IList <SimpleSelectDto> GetTribes(AdancedSearchFilter filter)
{
return(_tribeRepository.All(filter));
}
public JsonResultHelper GetSubgenus(AdancedSearchFilter filter)
{
var result = _appService.GetSubgenus(filter);
return new JsonResultHelper(result, JsonRequestBehavior.AllowGet);
}
