public ConsultaSocioFincaPorIdBE ConsultarSocioFincaPorId(ConsultaSocioFincaPorIdRequestDTO request)
{
ConsultaSocioFincaPorIdBE consultaSocioFincaPorIdBE = _ISocioFincaRepository.ConsultarSocioFincaPorId(request.SocioFincaId);
consultaSocioFincaPorIdBE.FincaEstimado = _ISocioFincaRepository.ConsultarSocioFincaEstimadoPorSocioFincaId(request.SocioFincaId).ToList();
return(consultaSocioFincaPorIdBE);
}
public ConsultaSocioFincaPorIdBE ConsultarSocioFincaPorId(int socioFincaId)
{
ConsultaSocioFincaPorIdBE itemBE = null;
var parameters = new DynamicParameters();
parameters.Add("@SocioFincaId", socioFincaId);
using (IDbConnection db = new SqlConnection(_connectionString.Value.CoffeeConnectDB))
{
var list = db.Query <ConsultaSocioFincaPorIdBE>("uspSocioFincaConsultaPorId", parameters, commandType: CommandType.StoredProcedure);
if (list.Any())
{
itemBE = list.First();
}
}
return(itemBE);
}
