public ConsultaAduanaPorIdBE ConsultarAduanaPorId(int aduanaId) { ConsultaAduanaPorIdBE itemBE = null; var parameters = new DynamicParameters(); parameters.Add("@AduanaId", aduanaId); using (IDbConnection db = new SqlConnection(_connectionString.Value.CoffeeConnectDB)) { var list = db.Query <ConsultaAduanaPorIdBE>("uspAduanaConsultarPorId", parameters, commandType: CommandType.StoredProcedure); if (list.Any()) { itemBE = list.First(); } } return(itemBE); }
public ConsultaAduanaPorIdBE ConsultarAduanaPorId(ConsultaAduanaPorIdRequestDTO request) { ConsultaAduanaPorIdBE consultaAduanaPorIdBE = _IAduanaRepository.ConsultarAduanaPorId(request.AduanaId); List <ConsultaDetalleTablaBE> lista = _IMaestroRepository.ConsultarDetalleTablaDeTablas(consultaAduanaPorIdBE.EmpresaId, String.Empty).ToList(); string[] certificacionesIds = consultaAduanaPorIdBE.TipoCertificacionId.Split('|'); string certificacionLabel = string.Empty; if (certificacionesIds.Length > 0) { List <ConsultaDetalleTablaBE> certificaciones = lista.Where(a => a.CodigoTabla.Trim().Equals("TipoCertificacion")).ToList(); foreach (string certificacionId in certificacionesIds) { ConsultaDetalleTablaBE certificacion = certificaciones.Where(a => a.Codigo == certificacionId).FirstOrDefault(); if (certificacion != null) { certificacionLabel = certificacionLabel + certificacion.Label + " "; } } } consultaAduanaPorIdBE.TipoCertificacion = certificacionLabel; consultaAduanaPorIdBE.Certificaciones = _IAduanaRepository.ConsultarAduanaCertificacionPorId(request.AduanaId).ToList(); consultaAduanaPorIdBE.Cargamentos = _IAduanaRepository.ConsultarAduanaCargamentoPorId(request.AduanaId).ToList(); return(consultaAduanaPorIdBE); }