public static async Task <T> GetOneById <T>(this IDbConnection connection, int id) where T : class
{
var key = SelectMethodExtension.GetSingleKey <T>(nameof(GetOneById));
var tableName = SelectMethodExtension.GetTableName(typeof(T));
var sql = $"select * from {tableName} where {key.Name} = @id";
var parameters = new DynamicParameters();
parameters.Add("@id", id);
var result = new List <object[]>();
var entity = await connection.QueryFirstOrDefaultAsync <T>(sql, parameters);
if (entity == null)
{
return(null);
}
var entityResult = new List <object> {
entity
};
await SetReferences(connection, entity, entityResult);
result.Add(entityResult.ToArray());
return(SelectMethodExtension.MapAllEntities <T>(result).FirstOrDefault());
}
private static async Task SetReferences(IDbConnection connection, object entity, List <object> entityResult)
{
var properties = entity.GetType().GetProperties();
var referenceTypes = new List <Type>();
SelectMethodExtension.GetReferenceProperties(entity.GetType(), ref referenceTypes);
var references = properties.Where(x => referenceTypes.Any(t => t == x.PropertyType));
foreach (var reference in references)
{
var tableReferenceName = SelectMethodExtension.GetTableName(reference.PropertyType);
var referenceKey = properties.FirstOrDefault(x => x.Name.Equals($"Id{reference.Name}"));
var idReference = referenceKey.GetValue(entity) ?? 0;
if (entityResult.Any(x =>
{
var valor = (int)x.GetType().GetProperty("Id").GetValue(x);
return(x.GetType() == reference.PropertyType &&
valor.Equals((int)idReference));
}))
{
continue;
}
var sqlReferenceTable = $"select * from {tableReferenceName} where id = {idReference}";
var referenceValue = await connection.QueryAsync(sqlReferenceTable, new[] { reference.PropertyType }, obj => obj);
if (referenceValue == null || !referenceValue.Any())
{
continue;
}
var restult = referenceValue.Select(x => x.FirstOrDefault()).FirstOrDefault();
await SetReferences(connection, restult, entityResult);
entityResult.Add(restult);
}
}