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); }