public IEnumerable <AdoptionDto> GetReponsablesAndTheirAdoptions()
{
IEnumerable <AdoptionDto> adoptions;
using (var connection = ConnectionFactory.GetConnection())
{
adoptions = connection.Query(
AdoptionProcedure.GetReponsablesAndTheirAdoptions,
AdoptionMap.AdoptionDto(),
splitOn: "split, splitCpf, splitEmail",
commandType: CommandType.StoredProcedure
).AsQueryable();
}
return(adoptions);
}
public AdoptionDto FindReponsableAndTheirAdoptionsBy(Guid id)
{
var parameters = new DynamicParameters();
parameters.Add("@cd_responsavel", id);
AdoptionDto adoptionDto;
using (var connection = ConnectionFactory.GetConnection())
{
adoptionDto = connection.Query(
AdoptionProcedure.FindReponsableAndTheirAdoptionsById,
AdoptionMap.AdoptionDto(),
parameters,
splitOn: "split, splitCpf, splitEmail",
commandType: CommandType.StoredProcedure
).SingleOrDefault();
}
return(adoptionDto);
}
