public async Task <IReadOnlyList <Developer> > Run(FilterDeveloperStatus filtrer)
{
using var connection = new SQLiteConnection
(_geekLemonContext.ConnectionString);
IEnumerable <DevloperTemp> r;
var q = @$ "SELECT
Id,UniqueId,Name,Status FROM Developers";
if (filtrer == FilterDeveloperStatus.All)
{
r = await connection.QueryAsync <DevloperTemp>(q);
}
else
{
r = await connection.QueryAsync <DevloperTemp>
(q + " WHERE Status = @st;"
, new { st = (int)filtrer });
}
var rmaped = _mapper.Map <IEnumerable <Developer> >(r);
return(rmaped.ToList().AsReadOnly());
}
public Task<IReadOnlyList<Developer>> GetCollectionAsync(FilterDeveloperStatus filtrer)
{
return _developerGetAllDoer.Run(filtrer);
}
