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