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