public async Task <Person> GetPerson(int id)
{
await using var connection = new SqlConnection(_dbConfig.ConnectionString);
await using var command = new SqlCommand("GetPersonById", connection)
{
CommandType = CommandType.StoredProcedure
};
connection.Open();
command.Parameters.AddWithValue("id", id);
await using var reader = await command.ExecuteReaderAsync();
var person = DbHelper.CreatePerson(reader);
return(person);
}
public async Task <Person> GetPersonAsync(int id)
{
var person = new Person();
using (var connection = new SqlConnection(_dbConfig.ConnectionString))
using (var command = new SqlCommand("GetPersonById", connection)
{
CommandType = CommandType.StoredProcedure
})
{
connection.Open();
command.Parameters.AddWithValue("Id", id);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
await Task.Run(() => person = DbHelper.CreatePerson(reader));
}
}
}
return(person);
}
public async Task <IEnumerable <Person> > GetPersonsAsync(int roleId)
{
var persons = new List <Person>();
using (var connection = new SqlConnection(_dbConfig.ConnectionString))
using (var command = new SqlCommand("GetPersonsByRoleId", connection)
{
CommandType = CommandType.StoredProcedure
})
{
connection.Open();
command.Parameters.AddWithValue("roleId", roleId);
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
await Task.Run(() => persons.Add(DbHelper.CreatePerson(reader)));
}
}
}
return(persons);
}
